Count number of patents by Country

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

Posts: 1
Joined: Fri Feb 15, 2019 3:58 am

Count number of patents by Country

Post by vv_mm » 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 ( ... 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? :o

Posts: 227
Joined: Thu Feb 22, 2007 5:33 pm

Re: Count number of patents by Country

Post by EPO / PATSTAT Support » Fri Feb 15, 2019 10:55 am

as a far as I can see, your query is correct. I used the query below to also get an overview of the PCT filings in Chile and to mark the national filings which originate from an earlier PCT, but it doesn't change anything on the trend.

Code: Select all

SELECT appln_auth
     ,count(*) total
	 ,count( case when internat_appln_id <> 0 then internat_appln_id end) inter
FROM tls201_appln
where (appln_auth = 'CL' or receiving_office = 'CL') 
  and appln_filing_year > 2000
group by appln_auth, appln_kind, appln_filing_year
order by appln_auth, appln_kind, appln_filing_year, total asc
The dip for 2010 can maybe be partially attributed to the earth quick, but I don't see how this could effect already the filings of 2009 -unless patent applications did not get published- .

PATSTAT data is based on data provided by the respective patent offices to the EPO. WIPO might have other sources or maybe they get filing figures directly from Chile.
You can also see that for 2005, 2009, 2010 and 2011 there no applications that have an international application id. This is simply not possible, so I would say that data is missing. Maybe the easiest would be to contact the Chilean patent office and ask them for clarifications. (They have a link on their website to Espacenet which has the same source data as PATSTAT; it might be easier to refer to Espacenet to illustrate your request.)
PATSTAT Support Team
EPO - Vienna
patstat @

Post Reply