Page 1 of 1

Firm/Nr of Patents/ Forward Citations

Posted: Tue Jun 30, 2020 11:24 am
by Anisa V
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!

Re: Firm/Nr of Patents/ Forward Citations

Posted: Wed Jul 01, 2020 2:44 pm
by EPO / PATSTAT Support
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: ... tstat.html and the attached publication.