Search found 440 matches
- Thu Apr 04, 2024 9:53 am
- Forum: PATSTAT Product Line
- Topic: Changing column from country of origin to city of origin
- Replies: 5
- Views: 1701
Re: Changing column from country of origin to city of origin
You can obtain a bit more data changing the SELECT line to: SELECT DISTINCT a.appln_filing_year, a.appln_id, a.appln_auth, a.appln_nr, p.psn_name, p.person_ctry_code, p1.address_1, p1.address_2,p1.address_3,p1.address_4,p1.address_5, p1.street, p1.city, p1.zip_code But most of the ZIP codes and city...
- Thu Apr 04, 2024 9:37 am
- Forum: PATSTAT Product Line
- Topic: Comparison Triadic Patent Count and JPO/EPO/USTPO Patent Applications
- Replies: 3
- Views: 1462
Re: Comparison Triadic Patent Count and JPO/EPO/USTPO Patent Applications
Hello Keno, you have to keep in mind that "triadic patents" means in fact "patents belonging to a triadic patent family". Your question: I've noticed that the triadic patent count is much higher than applications (--> think you meant triadic patent families !) to the JPO. How can...
- Wed Apr 03, 2024 8:56 am
- Forum: PATSTAT Product Line
- Topic: Backward citations for set of documents from Espacenet
- Replies: 1
- Views: 751
Re: Backward citations for set of documents from Espacenet
Hello Minotaur, there are plenty of posts on backward and forward citations that provide working SQL queries. You have to keep in mind that citations ultimately is a reference from a patent publication (or application) to another publication. So bringing this to a "family level" might mean...
- Tue Apr 02, 2024 12:49 pm
- Forum: PATSTAT Product Line
- Topic: Counting countries where the same patent has been registered
- Replies: 3
- Views: 1158
Re: Counting countries where the same patent has been registered
Have a look at the the patent family concepts and the docdb_family_size attribute. A couple of things one need to keep in mind: A PCT (WO) application and an EP (or any other regional office) is not really a "country". WO and EP filings are initially rather a proxy for "an intention a...
- Fri Mar 29, 2024 9:31 am
- Forum: PATSTAT Product Line
- Topic: NUTS_Level is appearing as 0 in all cells
- Replies: 1
- Views: 696
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: 1357
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: 5
- Views: 1701
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: 2752
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: 528
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: 4
- Views: 1168
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...