Firm/Nr of Patents/ Forward Citations

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

Anisa V
Posts: 2
Joined: Tue Jun 30, 2020 9:49 am

Firm/Nr of Patents/ Forward Citations

Post by Anisa V » Tue Jun 30, 2020 11:24 am

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!

Posts: 231
Joined: Thu Feb 22, 2007 5:33 pm

Re: Firm/Nr of Patents/ Forward Citations

Post by EPO / PATSTAT Support » Wed Jul 01, 2020 2:44 pm

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.
PATSTAT Support Team
EPO - Vienna
patstat @

Post Reply