Help with SQL query_caunt applications per Country
Posted: Wed Jan 04, 2017 4:30 pm
Dear community,
I'm working on a PATSTAT Online (Autumn 2016) patent query. My first aim is to replicate the patent statistics for Germany that are available here https://www.epo.org/about-us/annual-rep ... stics.html for my master thesis.
Here my query that i use for search for all patent applications from Germany in 2015 :
Here i get 72 435 results = applications but in the annual statistics for Germany there is only 24.820
Why do i get such a difference
Another example is number of Applications from Siemens
Here my query :
Here as a result i get 2054 applications but in the annual statistics for Germany there is only 1894
What am i doing wrong?
Thank you a lot in advance.
I'm working on a PATSTAT Online (Autumn 2016) patent query. My first aim is to replicate the patent statistics for Germany that are available here https://www.epo.org/about-us/annual-rep ... stics.html for my master thesis.
Here my query that i use for search for all patent applications from Germany in 2015 :
Code: Select all
select *
from tls201_appln
JOIN tls207_pers_appln on tls201_appln.appln_id= tls207_pers_appln.appln_id
where appln_auth = 'DE'
and appln_filing_year = 2015
Why do i get such a difference
Another example is number of Applications from Siemens
Here my query :
Code: Select all
select *
from tls201_appln
join tls207_pers_appln on tls201_appln.appln_id= tls207_pers_appln.appln_id
join tls206_person on tls207_pers_appln.person_id= tls206_person.person_id
where tls206_person.doc_std_name like 'siemens %'
and appln_filing_year = 2015
and person_ctry_code = 'De'
What am i doing wrong?
Thank you a lot in advance.