EPO patents designated in single European countries
Posted: Mon Dec 25, 2017 11:11 pm
Hi all,
I am using the query below to count the number of EPO patents designated in the Netherlands with filing year between 2000 and 2015.
If I change the query to count the patents designated in any other country such as Germany, Denmark or Switzerland, I get the same number of patents from 2011 to 2015 in each of the countries: 42,188 in 2011 (in each country); 34,145 in 2012; 21,015 in 2013; 8,178 in 2014; 1,729 in 2015.
I wonder how it can be that each of these countries have the same number of designated patents. Is there anything wrong in my query? Are the results that I obtain reliable?
I would appreciate any insight that you might provide on this issue.
Thank you so much in advance! and have a happy New Year!
Best regards,
Carmen
I am using the query below to count the number of EPO patents designated in the Netherlands with filing year between 2000 and 2015.
Code: Select all
SELECT COUNT(distinct(a.appln_id)), a.appln_filing_year
FROM tls201_appln a join tls231_inpadoc_legal_event le on le.appln_id=a.appln_id
WHERE
a.appln_kind = 'A' -- Patent (exclude the PCT applications that have not yet entered reg. phase.)
AND a.appln_id < 900000000 -- exclude artificial applications
AND a.granted =1
AND a.ipr_type = 'PI'
AND a.appln_filing_year between 2000 and 2015
AND le.designated_states LIKE '%NL%'
AND a.appln_auth = 'EP'
GROUP BY a.appln_filing_year
ORDER BY a.appln_filing_year
I wonder how it can be that each of these countries have the same number of designated patents. Is there anything wrong in my query? Are the results that I obtain reliable?
I would appreciate any insight that you might provide on this issue.
Thank you so much in advance! and have a happy New Year!
Best regards,
Carmen