Count number of patents by Country
Posted: Fri Feb 15, 2019 4:31 am
I am a new PATSTAT user and I wanted to check the data. Therefore I counted the patent applications for Chile (CL) in the year 2008. I used the 2018 Autumn Edition, PATSTAT online. With the following Query I obtained 1218 patents applications (and changing the year - 94 patents applications in 2009 & 101 in 2010 - this big fall is rather strange):
select count(distinct a.appln_id)
from tls201_appln a
where a.appln_auth = 'CL'
and a.appln_filing_year = 2008
and a.appln_kind='A'
If we check WIPO statistics ( https://www.wipo.int/ipstats/en/statist ... sp?code=CL ) the numbers are completely different (I guess we should look at Resident + Non-Resident):
Patent Applications [for Chile]
Year Resident Non-Resident
2008 531 3,421
2009 343 1,374
2010 328 748
What did I do wrong?
select count(distinct a.appln_id)
from tls201_appln a
where a.appln_auth = 'CL'
and a.appln_filing_year = 2008
and a.appln_kind='A'
If we check WIPO statistics ( https://www.wipo.int/ipstats/en/statist ... sp?code=CL ) the numbers are completely different (I guess we should look at Resident + Non-Resident):
Patent Applications [for Chile]
Year Resident Non-Resident
2008 531 3,421
2009 343 1,374
2010 328 748
What did I do wrong?