Search found 426 matches
- Fri Mar 29, 2024 9:31 am
- Forum: PATSTAT Product Line
- Topic: NUTS_Level is appearing as 0 in all cells
- Replies: 1
- Views: 30
Re: NUTS_Level is appearing as 0 in all cells
Hello, there are 2 issues to keep in mind. NUTS codes can only be assigned to those applicants or inventors for which the EPO has an address available. The DE patent office does not provide the addresses to the EPO, so generally spoken no NUTS can be assigned to DE patents. Additional,the EPO data r...
- Mon Mar 25, 2024 10:44 am
- Forum: PATSTAT Product Line
- Topic: Patent query problem
- Replies: 1
- Views: 73
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 ...
- 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...
- Wed Mar 06, 2024 9:17 pm
- Forum: PATSTAT Product Line
- Topic: missing appln_id
- Replies: 1
- Views: 948
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...
- Tue Mar 05, 2024 7:02 pm
- Forum: PATSTAT Product Line
- Topic: query problem about patent count
- Replies: 1
- Views: 84
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...
- 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...
- 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...
- Wed Jan 31, 2024 3:33 pm
- Forum: PATSTAT Product Line
- Topic: backward citations
- Replies: 5
- Views: 3612
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...
- 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...
- Wed Jan 10, 2024 12:47 pm
- Forum: PATSTAT Product Line
- Topic: Help with SQL query_caunt applications per Country
- Replies: 5
- Views: 5810
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...