Search found 440 matches
- Thu Sep 01, 2022 10:21 pm
- Forum: PATSTAT Product Line
- Topic: Grouping NACE2 Codes
- Replies: 3
- Views: 2391
Re: Grouping NACE2 Codes
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...
- Thu Sep 01, 2022 8:43 pm
- Forum: PATSTAT Product Line
- Topic: How to retrieve patents with at least one author to a certain country
- Replies: 3
- Views: 1311
Re: How to retrieve patents with at least one author to a certain country
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...
- Wed Aug 31, 2022 1:26 pm
- Forum: General
- Topic: Disappearing CPC classifications
- Replies: 2
- Views: 2045
Re: Disappearing CPC classifications
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-...
- Wed Aug 31, 2022 10:40 am
- Forum: PATSTAT Product Line
- Topic: Citations by industry and country filed at the EPO
- Replies: 1
- Views: 946
Re: Citations by industry and country filed at the EPO
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...
- Tue Aug 30, 2022 7:18 am
- Forum: PATSTAT Product Line
- Topic: triadic patents -query help
- Replies: 7
- Views: 6521
Re: triadic patents -query help
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 ...
- Wed Aug 17, 2022 10:50 am
- Forum: PATSTAT Product Line
- Topic: Grouping NACE2 Codes
- Replies: 3
- Views: 2391
Re: Grouping NACE2 Codes
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 ...
- Wed Aug 10, 2022 11:59 am
- Forum: PATSTAT Product Line
- Topic: NACE2 codes weights calculation
- Replies: 4
- Views: 2105
Re: NACE2 codes weights calculation
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...
- Wed Aug 10, 2022 10:50 am
- Forum: PATSTAT Product Line
- Topic: Aggregated patents by country and unassigned country codes
- Replies: 1
- Views: 895
Re: Aggregated patents by country and unassigned country codes
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...
- Thu Aug 04, 2022 1:15 pm
- Forum: PATSTAT Product Line
- Topic: Select patents according to a IPC class symbol
- Replies: 4
- Views: 4584
Re: Select patents according to a IPC class symbol
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...
- Thu Aug 04, 2022 11:44 am
- Forum: PATSTAT Product Line
- Topic: NACE2 codes weights calculation
- Replies: 4
- Views: 2105
Re: NACE2 codes weights calculation
Hello Aris,
you find more information here:
concordance-table-between-ipc-and-nace2-9756
And in the PATSTAT Data Catalog.
Geert Boedt
you find more information here:
concordance-table-between-ipc-and-nace2-9756
And in the PATSTAT Data Catalog.
Geert Boedt