Hello Nicole, that can easily be done with a SQL CASE Expression. That allows users to create specific result columns based on the data of the withheld records created via your WHERE clause conditions and joined tables. Have a look at this; you can then expand the logics to your own groups of NACE c...

Hello Maria, your thinking is correct, the "Norwegian inventor or applicant" condition should be achieved via a subquery in your WHERE clause. Writing "t6.person_ctry_code = 'ΝO' " will limit your result list to only Norwegian persons. Which is correct as such, but not what you w...

Hello Bradford, kindly have a look at this forum post which provides some insights on the changes in the CPC scheme. The only way to further drill down into the regrouped CPC tags is to use the (non -y-tag) CPC codes and/or IPC codes in combination with keywords. https://forums.epo.org/revision-and-...

Hello Nicole, I think the logics in your query are flawed. (But I am not 100 % sure what you want to do neither.) The tls212_citation.cited_pat_publn_id has no connection to tls212_citation.cited_appln_id in the tls212_citation records, apart from the fact that both are cited by the same publication...

Have a look at the PATSTAT webpages and request the 1 month free subscription from PATSTAT Online. ( https://www.epo.org/searching-for-patents/business/patstat.html ) That might be sufficient for you to extract the data you need. It is rather difficult to know "what does not work" without ...

Can you post your SQL and give more details on how you want to "group". The NACE data is based on an IPC concordance table; as a result, 1 patent application can have multiple (weighed) NACE codes. You can of course sum the weights to see how a patent portfolio would look, or even compare ...

The computation of the WEIGHT value is more complicated than the simple ratio used for a technology field because each field get a weight according to a number of relations to the application: First, per application, its IPC symbols (TLS209_APPLN_IPC.IPC_CLASS_SYMBOL matching TLS902_IPC_NACE2.IPC) l...

Hello Keno, what you observe is simply due to the fact that many patent offices do not provide the country codes of the applicants (or inventors) to the EPO. Some researchers have developed methodologies to replenish methodologies to replenish missing country codes. ( https://forums.epo.org/data-rep...

An easy solution to find patents that have 2 specific classification codes is the following query. Assume you are looking for patents that combine paint (coatings) with solar cells. Assuming we take the following CPC codes (just as an example, in reality you would also consider IPC codes): C09D5: ht...

Hello Aris,
you find more information here:
concordance-table-between-ipc-and-nace2-9756
And in the PATSTAT Data Catalog.
Geert Boedt