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...

Hello Murry, your query is correct; it illustrates that we have no country information for applicants and inventors on applications filed in Japan. As a comparison, here is an SQL query that gives an easy overview of as well JP as EP applications, counting the number person_id's that have (no) count...

Dear Carmen, as far as I can see, I think you are counting something different then what you want to count. In your query you count the internat_appn_id; that attribute links the PCT application to a later application referring to that PCT. But as you already are looking for PCT applications (receiv...

I have no experience with TALEND myself. And I am not sure that here you will get a prompt response here - but I hope somebody could prove me wrong. This forum is about PATSTAT data and not so much about ETL tools like TALEND. I think you might get a faster answer to your question at a specialized f...

Hello Devor, that is perfectly possible. Here is a query that does something similar; analyse it and it should be clear what it is doing. You can of course adapt the criteria to what you need for your research. To illustrate better what it does, adapt the query to only1 citing application, and then ...

We are pleased to announce that EPO’s linked open EP data will be presented at the SEMANTiCS 2018 in an industry talk as well on a poster & demo stand. SEMANTiCS conference ( https://semantics.cc/ ) is the leading European conference on Machine Learning, Data Science, Linked Data and Natural Languag...