I´m having difficulties figuring out a suitable SQL query to find out numerical (the amount of applications) monthly data about EP & PCT -patent applications originating from Estonia and Finland (country of the applicant). The timeframe should be from 1.1.2000 to 31.12.2015. The data set should be separate between Finland and Estonia.
Is this even possible to do with the PATSTAT database? Any and all help would be much appreciated.
Help needed to find numerical data about patent applications
Re: Help needed to find numerical data about patent applicat
Yes, this is doable with PATSTAT. A query would look like this:
In case you want to count inventions instead of applications, you might want count DOCDB families instead.
Code: Select all
select DISTINCT a.*
-- DISTINCT to remove duplicates if applications have
-- more applicants from the requested country
from tls201_appln a
join tls207_pers_appln pa on a.appln_id = pa.appln_id
join tls206_person p on pa.person_id = p.person_id
where (appln_auth = 'EP' -- European applications
or appln_kind = 'W') -- PCT applications
and appln_filing_year between 2000 and 2015
and pa.applt_seq_nr > 0
-- limit to applicants; ignore persons who are inventors only
and p.person_ctry_code = 'FI' -- can be replaced by Estonia 'EE'
order by a.appln_filing_date
-------------------------------------------
Martin Kracker / EPO
Martin Kracker / EPO