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...

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...

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...

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...

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...

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 ...

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...

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...

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...

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...