Hello, the change was not so unexpected :) It happened for the 2021 Spring release. The [cited_npl_publn_id] attribute should indeed be 32 characters long, NOT integer. The data catalog indicates this also in the Modification History for the [cited_npl_publn_id] but also in the "(7) History of ...

You could use something like this: SELECT DISTINCT a.appln_filing_year, a.appln_id, a.appln_auth, a.appln_nr, a.appln_kind, a.appln_filing_date, STRING_AGG (CPC.cpc_class_symbol, '; ') CPC_GROUP FROM tls201_appln a JOIN tls225_docdb_fam_cpc CPC ON a.docdb_family_id = CPC.docdb_family_id WHERE left(c...

The service fee (150 euro) for PATSTAT Global (or any of the data sets on the download platform) is abolished for 2024 subscriptions. But you still need to register to get access to the platform. (user_id, password, etc...) PATSTAT is produced 2 times per year. We are currently working on the Spring...

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