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

Your group by should use the same ALIAS as in the select: GROUP BY a.docdb_family_id .
And if you want to do a typical "family-family" count then you should use the family_id in your count. (But maybe you want to effectively count applications, depends on your analysis.)

Hello Rahul, I had a look at the application you specified, but could not see any legal status referring to a filed opposition on that application. select reg101_appln.appln_id ,[appln_auth] ,[appln_nr] ,[appln_filing_date] ,[status] ,[internat_appln_id] ,[internat_appln_nr] ,[event_seq_nr] ,[event_...

Dear David, Actually, I do not see an inconsistency. In easy terms: If a (set of) claims of a patent application has an citation of category X, then this citation destroys this (set of) claims. The patent application will not be granted unless these claims are removed. In contrast, the citation cate...

Dear Rahul, I understand from your question that you are aware that there are no real oppositions in the US patent system, but re-examinations / post grant reviews. Also, a company may be involved on 2 sides: it may be either the appellant or the respondent / patent owner in post-grant review procee...

Hi Musso, You asked 2 questions: 1) As you mentioned, the same invention can be filed as patent (and probably later granted) in several jurisdictions. Such a group of patent is called “patent family”. There are multiple definitions of what precisely makes a patent family. The EPO uses two family typ...

I am not sure what you actually want to achieve. What I noted is that your last join has the join condition ‘company.person_id = cited.pat_publn_id’. You are comparing a person ID with a patent publication ID, which will get you random results. It’s a complex query. I recommend you re-do it incremen...

The Espacenet field identifier PD stand for “publication date”, and its PATSTAT equivalent is the attribute PUBLN_DATE in table TLS211_PAT_PUBLN. So your query is almost perfect. It just needs a join with the publication table as well: select * from tls201_appln a left outer join tls202_appln_title ...

Hi Musso, I think this is what you want: select a1.appln_id, a1.appln_auth, a4.ipc_class_symbol, a3.person_name, a3.person_ctry_code from tls201_appln a1 left outer join tls207_pers_appln a2 on a2.appln_id = a1.appln_id left outer join tls206_person a3 on a3.person_id = a2.person_id left outer join ...

Dear Pradeep, There are several reasons why your query has problems: - Last week we had a full disk issue which caused the error message you reported. This is fixed. Sorry for the inconvenience this has caused. - The other reason is that your query is – as you assumed – much too heavy, because it co...