Search found 425 matches

by EPO / PATSTAT Support
Mon Mar 25, 2024 10:44 am
Forum: PATSTAT Product Line
Topic: Patent query problem
Replies: 1
Views: 70

Re: Patent query problem

Hello Carl, there is no good method of assigning 1 IPC (or CPC) code to an application because every code assigned has it's meaning and purpose. Any method applied will lead to loss of granularity and might introduce noise in your analysis and conclusions. It is a similar issue when researchers use ...
by EPO / PATSTAT Support
Mon Mar 11, 2024 12:27 pm
Forum: PATSTAT Product Line
Topic: Changing column from country of origin to city of origin
Replies: 1
Views: 129

Re: Changing column from country of origin to city of origin

Hello Carlos, more detailed address information will -generally spoken- only be available for applicants that filed patents at the EPO. Addresses for inventors or natural persons have been removed from PATSTAT Online. For those applicants, where the address is available, the tls226_person_orig might...
by EPO / PATSTAT Support
Wed Mar 06, 2024 9:17 pm
Forum: PATSTAT Product Line
Topic: missing appln_id
Replies: 1
Views: 947

Re: missing appln_id

Hello Ugo, in the PATSTAT data catalog, it is written that appln_ids are stable and unique across the PATSTAT releases. But there are exceptions (also mentioned), and most of them are due to data corrections in the source data base. (docdb). If the data correction is minimal, the appln_id will not c...
by EPO / PATSTAT Support
Tue Mar 05, 2024 7:02 pm
Forum: PATSTAT Product Line
Topic: query problem about patent count
Replies: 1
Views: 82

Re: query problem about patent count

Hello Alice, small observation on your query, it should be count/distinct, which reduces even a bit more the figures. But it excludes the double counts. My thoughts: Kyoto protocol and awareness ... entered into force only in 2005. That generated more patents in the Y02 area after 2005. Also, I assu...
by EPO / PATSTAT Support
Mon Mar 04, 2024 7:23 pm
Forum: PATSTAT Product Line
Topic: Searching by keywords in abstract and title
Replies: 2
Views: 109

Re: Searching by keywords in abstract and title

There are a couple of different ways to do that. But keep in mind that the abstract (tls203) can not be extracted via a download extraction process. So if you need to also "see" the abstract and the title, you will need to LEFT join the tables and export the result list. (In Patstat Online...
by EPO / PATSTAT Support
Tue Feb 20, 2024 4:04 pm
Forum: PATSTAT Product Line
Topic: Elasticsearch with PATSTAT
Replies: 1
Views: 225

Re: Elasticsearch with PATSTAT

Hello William, EPO does use Elasticsearch with the free Espacenet service. https://worldwide.espacenet.com/ , and we appreciate your interest in utilising the PATSTAT database with Elasticsearch. However, PATSTAT is essentially a relational data base and not a search engine like Elasticsearch. It is...
by EPO / PATSTAT Support
Wed Jan 31, 2024 3:33 pm
Forum: PATSTAT Product Line
Topic: backward citations
Replies: 5
Views: 3605

Re: backward citations

Your query is correct, the best way to check results is to look at one single application (all publications), and see whether the result is the same as what you can see in ESPACENET or the EPO register. (small differences are possible, but it should be sufficient to confirm that all your JOINS in SQ...
by EPO / PATSTAT Support
Thu Jan 18, 2024 4:59 pm
Forum: PATSTAT Product Line
Topic: About PUBLN_CLAIM Contents
Replies: 1
Views: 1340

Re: About PUBLN_CLAIM Contents

No, PATSTAT does not contain the text of the claims; only titles and abstracts. If you want full text (claims, description, search data, etc...) of the patents published by the EPO, you will need to have a closer look at this: https://new.epo.org/en/searching-for-patents/data/bulk-data-sets/text-ana...
by EPO / PATSTAT Support
Wed Jan 10, 2024 12:47 pm
Forum: PATSTAT Product Line
Topic: Help with SQL query_caunt applications per Country
Replies: 5
Views: 5807

Re: Help with SQL query_caunt applications per Country

The data format (and data base model) has slightly changed between when the original topic was posted and now. This means that the "AND appln_kind = 'A' (to exclude PCT's) is not needed anymore because PCT applications now have "WO" as application authority. So adding that line will n...
by EPO / PATSTAT Support
Mon Jan 08, 2024 4:50 pm
Forum: PATSTAT Product Line
Topic: Loading data into SQL
Replies: 2
Views: 1558

Re: Loading data into SQL

Hello Chayenne, difficult to say how long it will take. That depends a lot on your server system and how you have your storage organised. But it can take indeed a bit of time. It is clear that an SSD will be a lot faster then normal "spinning" hard disks. DB systems have always a method of...