Hello Manual, the purpose of the limitation on a time frame for forward citations is to avoid bias. In simple words: patents that were published in 2010 will have had more opportunity to become cited then a patent application that was published in 2017. Therefore researchers look at the date of publ...

Hello Manual,
can you give some examples or share your code ?
And why it would be a problem.

Hallo Davor, I kindly refer to the PATSTAT webpage for detailed information. Small data sets (up to 100.000 applications from 1 query) can be downloaded via PATSTAT Online. You can obtain 1 month free access via the online registration form: https://www.epo.org/searching-for-patents/business/patstat...

Hello Lionpat, here is a query that links utility models filed in DE with their US priority filings. To look for DE utility models that served as priority for later US applications, simply switch the joins on the tls204 table. SELECT p.person_name, psn_name,pa.applt_seq_nr ,a.appln_nr_epodoc, a.ipr_...

Hello Thomas, this is due to the endless series of (US) divisional applications originating from 6 "parent" US applications. The process to assign DOCDB_FAMILY_IDs takes into account not only the so called Paris Convention priorities but also the data in TLS2016_APPLN_CONTN and TLS205_TECH_REL. Have...

Here is an addition to my previous post in this thread: I forgot to mention that the situation has changed in the newest PATSTAT edition: This 2018 Spring Edition is available as PATSTAT data since early October and will be available soon in PATSTAT Online. In the 2018 Autumn Edition of PATSTAT Glob...

The procedural step ISAT in the "PATSTAT EP Register" Database does only contain the office of the ISR (Internat. Search Report), not its citations etc. In general, citations cannot be found in the "PATSTAT EP Register" database but only in "PATSTAT Global". Both databases can easily been used toget...

Thank you so much, Gianluca, for supporting the PATSTAT community by providing these MySQL scripts.

Martin, EPO / PATSTAT

Dear Users, In addition to the existing "Expert" SQL query interface, a "Beginners" query interface has been added to support users not yet familiar with SQL. It is possible to answer a small set of frequent information needs by filling out a very simple query form, which automatically constructs th...

Hello Devor, your observation is correct, but if you do a family-family analysis, then you have to give your data preparation a serious thought on what attributes you will migrate to family level, and more important how you will do that for attributes that are "application" bound. Very specific: how...