Search found 2 matches

by Anisa V
Tue Jun 30, 2020 11:24 am
Forum: PATSTAT Product Line
Topic: Firm/Nr of Patents/ Forward Citations
Replies: 1
Views: 609

Firm/Nr of Patents/ Forward Citations

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. S...
by Anisa V
Tue Jun 30, 2020 9:52 am
Forum: PATSTAT Product Line
Topic: Search Database with ISIN code
Replies: 1
Views: 643

Search Database with ISIN code

Hello,

I am interested in a query which presents firms with ISIN code, the nr of patents per year (2010-2018) and the nr of legal case for patents issues opened.
Is it possible to construct it?
Thank you!