Page 1 of 1

SQL request for the number of patent applications

Posted: Thu Jun 08, 2017 9:30 pm
by Student
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

Re: SQL request for the number of patent applications

Posted: Tue Jun 13, 2017 5:23 pm
by Geert Boedt
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