Dear community,
I am conducting an empirical research on innovation and I would like the following data:
Company (I am using ISIN code)
Nr of Patents per year
Forward Citations per year
for the time horizon 2010-2018
Currently I am facing difficulties in retrieving the query, as a beginner in sql.
Some suggestions/help would be extremely appreciated.
Thank you!
Firm/Nr of Patents/ Forward Citations
-
- Posts: 440
- Joined: Thu Feb 22, 2007 5:33 pm
- Contact:
Re: Firm/Nr of Patents/ Forward Citations
Hello Anuisa,
Firm numbers are not available in PATSTAT.
On the topic of "forward citations", there are plenty of forum posts with example queries that cover that topic.
I also would recommend you to have a look at self learning material on the PATSTAT webpages: https://www.epo.org/searching-for-paten ... tstat.html and the attached publication.
Firm numbers are not available in PATSTAT.
On the topic of "forward citations", there are plenty of forum posts with example queries that cover that topic.
I also would recommend you to have a look at self learning material on the PATSTAT webpages: https://www.epo.org/searching-for-paten ... tstat.html and the attached publication.
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org
EPO - Vienna
patstat @ epo.org