Dear Fernando, using SQL in PATSTAT Register, there is indeed a risk for double counting when multiple tables are joined in a query. Each joined table might multiplicate the number of rows if no further restrictions are applied in the WHERE clause. Generally spoken on using PATSTAT for "replica...

I can not guarantee that you will not have to adapt the code to your platform.
The sql code is written for MySQL, so if you have a MySQL data base platform, it might very well run without any further modifications.

Hello paringyang, It is indeed impossible to run Professor Gaétan's code on PATSTAT Online, also because users can not store their own (user defined) data on the PATSTAT Online platform. My advice: extract the data which you need (maximum 100.000 applications), include the family members in the extr...

Hello AWFB, you probably just made a mistake in your query. (Maybe the JOINS if you do not find any persons at all) Try the query below and you will find exactly the same as in Espacenet. SELECT a.[appln_id] ,a.[appln_auth] ,a.[appln_nr] ,a.[appln_kind] ,a.[appln_filing_date] ,applt_seq_nr, invt_seq...

Hello AWFB, your PATSTAT search is searching the CPC classification scheme, not IPC. If you change it to CPC, you will the results. In ESPACENET you will find 4 results which are basically some kind of data errors. We will correct that because the correct result should indeed be zero results, like y...

Hello Diana, 2 observations: a) the AND and OR operators are executed according to standard order of precedence. Meaning: A OR B AND C is executed as (A OR (B AND C )). While what you want is ((A OR B) and C). When you have 1 attribute to be checked against a couple -or many- possible values, you ca...

(Newbie) PATSTAT users often struggle to understand the concept of patent families. Our colleagues at the patentdata team have produced this very explanatory video on patent families. Both Simple and INPADOC (extended) patent families are pre-created in the PATSTAT data base and are available via th...

During the previous editions, many PATSTAT users have benefited from the EPO Academic Research Programme. The new call for proposals is open until 15 October 2021. Proposals for research schemes may be submitted by individual research institutes or by groups of institutes. More information is availa...

Hello alexsunny, yes, it can be done in PATSTAT, but if you only need to do this for "half a dozen" of patent applications, it might be easier and quicker to do this via ESPACENET and the CCD (Common Citation Document) platform. https://www.fiveipoffices.org/activities/globaldossier/ccd/cc...

Hello Valentin, it will not be easy; and I would say that this is not possible to do in 1 query- 1 go. You will need to extract the data sets. In the case of patents that have (at least) 1 FR inventor, there are 8582 patent applications. They are grouped in 3359 docdb patent families. So for each on...