Help needed to find numerical data about patent applications

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: Thu Jun 30, 2016 10:59 am

Help needed to find numerical data about patent applications

Post by v.heinila » Thu Jun 30, 2016 11:13 am

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.

Posts: 114
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

Re: Help needed to find numerical data about patent applicat

Post by mkracker » Tue Jul 26, 2016 10:13 am

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.
Martin Kracker / EPO

Post Reply