Search found 3 matches
- Mon Aug 29, 2022 5:11 pm
- Forum: PATSTAT Product Line
- Topic: Citations by industry and country filed at the EPO
- Replies: 1
- Views: 896
Citations by industry and country filed at the EPO
Hi, I would like to extract data on the number of patent citations by industry (industries 10 to 33) and country filed at the EPO from 2007-2018. I have formed the following code and would like to know if this is correct for the data I would like to collect: SELECT DISTINCT tls201_appln.earliest_pub...
- Wed Aug 17, 2022 12:35 pm
- Forum: PATSTAT Product Line
- Topic: Grouping NACE2 Codes
- Replies: 3
- Views: 1694
Re: Grouping NACE2 Codes
So this is my query: SELECT person_ctry_code, tls201_appln.earliest_filing_year, tls229_appln_nace2.nace2_code, COUNT(DISTINCT tls201_appln.inpadoc_family_id) TotalPatentFamilies FROM tls201_appln JOIN tls207_pers_appln ON tls201_appln.appln_id = tls207_pers_appln.appln_id JOIN tls206_person ON tls2...
- Tue Aug 16, 2022 4:56 pm
- Forum: PATSTAT Product Line
- Topic: Grouping NACE2 Codes
- Replies: 3
- Views: 1694
Grouping NACE2 Codes
Hi, I am working on my masters dissertation and I am trying to extract patent data from PATSTAT by NACE2 codes. I have managed to do this successfully, but I would like to group patents with certain NACE2 codes together to reduce the number of rows in my results table. For example, I would like to g...