I am interested in analysing the importance of national innovation systems for a particular technology field. For this, I would like to see the number of forward citations a country received over time. Ultimately, I am interested in seeing whether the respective inventions from a given country build a foundation for the specific technology and how this changed over time.
I’ve started out by using the following code:
Code: Select all
SELECT distinct psn_name, person_ctry_code, appln_auth+appln_nr,
appln_filing_date ,nb_citing_docdb_fam
FROM tls201_appln
join tls203_appln_abstr on tls201_appln.appln_id = tls203_appln_abstr.appln_id
join tls207_pers_appln on tls201_appln.appln_id = tls207_pers_appln.appln_id
join tls206_person on tls207_pers_appln.person_id = tls206_person.person_id
join tls801_country on tls206_person.person_ctry_code = tls801_country.ctry_code
WHERE appln_filing_year between 1980 and 2021
and docdb_family_id in (select docdb_family_id from tls201_appln where appln_auth = 'EP' and granted = 'Y')
and docdb_family_id in (select docdb_family_id from tls201_appln where appln_auth = 'US' and granted = 'Y')
and docdb_family_id in (select docdb_family_id from tls201_appln where appln_auth = 'JP' and granted = 'Y')
and appln_auth in ('EP','US', 'JP')
and granted = 'Y'
and applt_seq_nr > 0 and invt_seq_nr = 0
and (tls201_appln.appln_id in (select distinct appln_id from tls224_appln_cpc WHERE cpc_class_symbol like ('Y02E 10/728%')))
order by psn_name
The CPC code is iterative for an industry, in this case onshore wind.
My idea is to now take the data and aggregate the nb_citing_docbd_fam by person_ctry_code and appln_filling_date to see how the number of citations has changed for different countries over time.
My first question is if this would make sense or if my approach is completely wrong?
I assume there will be a slight bias towards older patents although a rough examination of the data seems to suggest that if at all this would only be marginal.
Now to my second question: If the above approach makes sense, it should measure the number of forward citations each patent of the onshore wind class receives per country and year.
Would there be a way to do this kind of analysis for any cpc classification but limit citations to the onshore wind classification? This might not necessarily be that different but I would expect there might be technologies outside of wind energy that are being cited for wind patents?