SQL request for the number of patent applications

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

Student
Posts: 1
Joined: Thu Jun 08, 2017 9:04 pm

SQL request for the number of patent applications

Post by Student » Thu Jun 08, 2017 9:30 pm

Hello everybody,

concerning my recent research project I need the following data:

The number of patent applications
- in a specific year (e. g. 2015)
- in a specific country (e. g. Germany)
- the patent should be granted subsequently

Could you please give me the SQL code for this query?

Thank you in advance!

Kind regards


Geert Boedt
Posts: 176
Joined: Tue Oct 19, 2004 10:36 am
Location: Vienna

Re: SQL request for the number of patent applications

Post by Geert Boedt » Tue Jun 13, 2017 5:23 pm

Hello Student,
Here you are:

Code: Select all

SELECT appln_auth, count (appln_id) '#patents'
  FROM tls201_appln
  where appln_auth = 'DE' and appln_filing_year = 2010 and granted = 1
  group by appln_auth
Just keep in mind that the granting procedure can take a number of years, so you will not find many patents filed in 2015 that have already been granted. (and for which information is already included in PATSTAT).

Kindly also have a look at the self-learning modules on the PATSTAT webpage. There you will find a good selection of basic SQL queries that can help you to get going.
http://www.epo.org/searching-for-patent ... .html#tab1
Best regards,

Geert Boedt
PATSTAT support
Business Use of Patent Information
EPO Vienna


Post Reply