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
SQL request for the number of patent applications
-
- Posts: 176
- Joined: Tue Oct 19, 2004 10:36 am
- Location: Vienna
Re: SQL request for the number of patent applications
Hello Student,
Here you are:
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
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
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
Geert Boedt
PATSTAT support
Business Use of Patent Information
EPO Vienna