Numer of patents and patent applications per company

Here you can post your opinions, ask questions and share information regarding Patent Translate.
Post Reply

SinaSteffen26
Posts: 4
Joined: Fri Mar 31, 2023 9:45 am

Numer of patents and patent applications per company

Post by SinaSteffen26 » Fri Mar 31, 2023 9:54 am

Dear PATSTAT community,

I am currently writing my master thesis about the relationship of innovation and ESG. For this I need the number of granted patents and patents applications per company (European companies). Additionally, it would be helpful also to have the number of granted patents and patents applications per company the field of environmental-related technologies. If I am informed correctly the EPO developed the "Y02/Y04S tagging scheme" for those kinds of patents.
Since I am new to both PATSTAT and SQL, is it possible to write a query, which would provide me with a list of all European companies which had at least one granted patent and the number of their patent applications and in the field of environmental-related technologies?
Thanks in advance.

Best regards
Sina


Post Reply