Search found 3 matches

by nicole.crichton
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...
by nicole.crichton
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...
by nicole.crichton
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...