information on first filings by one country's inventor

[Mthibaut]

hello,
I'm looking for SQL lines on PATSTAT online, spring 2016 that would give me a list of firsts filings by swiss inventor's and/or applicants in 2014.

Thanks.

[Geert Boedt]

Hello Thibaut,
If we accept the simplified given that first filings are filings where no priority is claimed by the applicant, then the following query would give you those applications. (so we do not take into account divisional, continuations and the so called "technical relations")

Code: Select all

select distinct  tls201_appln.appln_auth, tls201_appln.appln_nr, tls201_appln.appln_kind, tls201_appln.appln_filing_date, tls201_appln.appln_nr_epodoc
from tls201_appln
join tls207_pers_appln on tls201_appln.appln_id = tls207_pers_appln.appln_id
join tls206_person on tls207_pers_appln.person_id = tls206_person.person_id
where
person_ctry_code = 'CH'
and tls201_appln.appln_id not in (select appln_id from tls204_appln_prior)
and appln_filing_year =  2014
order by appln_filing_date desc

Observation: applications filed at the end of 2014 will normally only be published around July 2016 (18 months later), and will therefore not yet be available in PATSTAT. So to have the complete data set you will need to use the upcoming 2016b release to see those latest applications. Also keep in mind that some offices do not provide us the data day on day, so the series for some filing authorities might not be complete for applications filed in 2014. EP data will be complete, as well as the other major patent offices.