Dear PATSTAT users, we have learned that some of you are using the Google BigQuery data platform to store PATSTAT data. ( https://cloud.google.com/bigquery/ ) The PATSTAT team is always interested to explore new media and platforms to make patent data better and easier accessible to a wider audience...

Hello José, your query is correct; but a couple of small remarks. Generally spoken, if you really want to limit to applicants, you should force the applt_seq_nr to be > 0 . In your query it does not make any difference because of the conditions on the person_name. Also, as you are looking for public...

Hello Fabian, just a small syntax error: the % wildcard should be used with the LIKE operator. Or you could use LEFT function. SELECT DISTINCT a.*, person_ctry_code appln_filing_year 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.pe...

Hello Renée, The short answer would be: the large majority of the applications filed in 2014 are available in Spring 2017 across most of the major patent authorities. (A delay of data delivery by a national patent office will result in delayed availability via PATSTAT and any other patent informatio...

Hello Student, Here you are: SELECT appln_auth, count (appln_id) '#patents' FROM tls201_appln where appln_auth = 'DE' and appln_filing_year = 2010 and granted = 1 group by appln_auth Just keep in mind that the granting procedure can take a number of years, so you will not find many patents filed in ...

Your question is less straightforward then it looks because the official filing figures are calculated on internal EPO data. Due to the 18 month publication delay, data for 2016 is not yet available for external users. For 2010, the data should be available, but the methodology used can not be 100% ...

Exactly;
that is the nice thing about PATSTAT;
you can tweak the data as much as you need/want ...
Geert

Hello Andy, I had some problems with the re-naming and aliases in your query, so I therefore decided to make a query from scratch which I think will serve your quest. You can adapt it and add some "counts" if you need numbers. I assume that you will want to look at family/family citations,...

Hello Torben, you could use something like this: I joined with an extra table created in a sub query, that selects only applications that have at least 3 "company applicants"; identified through the combinations of the applicant and inventor numbers and further restricted via the psn_secto...

Helo Maly, Using the earliest_filing_year will give you a unique "first date" which is also valid at the docdb_family_id level. (at least in most cases, there are families with 100's of members, where there are deviations) But keep in mind that using the earliest_filing_year instead of app...