Page 1 of 1

Help needed to find numerical data about patent applications

Posted: Thu Jun 30, 2016 11:13 am
by v.heinila
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.

Re: Help needed to find numerical data about patent applicat

Posted: Tue Jul 26, 2016 10:13 am
by mkracker
Yes, this is doable with PATSTAT. A query would look like this:

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
In case you want to count inventions instead of applications, you might want count DOCDB families instead.