Search found 232 matches

by EPO / PATSTAT Support
Wed Aug 22, 2018 8:10 am
Forum: Linked open EP data/open EP bulk data
Topic: Linked open EP data at the SEMANTiCs 2018 conference
Replies: 0
Views: 2994

Linked open EP data at the SEMANTiCs 2018 conference

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...
by EPO / PATSTAT Support
Tue Aug 21, 2018 10:02 am
Forum: PATSTAT Product Line
Topic: Forward citation.
Replies: 2
Views: 3153

Re: Forward citation.

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.)
by EPO / PATSTAT Support
Mon Aug 13, 2018 5:09 pm
Forum: PATSTAT Product Line
Topic: Estimating US patent "oppositions"
Replies: 3
Views: 2399

Re: Estimating US patent "oppositions"

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_...
by EPO / PATSTAT Support
Thu Jul 26, 2018 3:03 pm
Forum: PATSTAT Product Line
Topic: TLS_215 documentation inconsistency
Replies: 1
Views: 1921

Re: TLS_215 documentation inconsistency

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...
by EPO / PATSTAT Support
Wed Jul 25, 2018 12:56 pm
Forum: PATSTAT Product Line
Topic: Estimating US patent "oppositions"
Replies: 3
Views: 2399

Re: Estimating US patent "oppositions"

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...
by EPO / PATSTAT Support
Wed Jul 25, 2018 9:34 am
Forum: PATSTAT Product Line
Topic: Need Help with International Patents
Replies: 2
Views: 1845

Re: Need Help with International Patents

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...
by EPO / PATSTAT Support
Tue Jul 24, 2018 4:13 pm
Forum: PATSTAT Product Line
Topic: Published patents by company
Replies: 1
Views: 1349

Re: Published patents by company

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...
by EPO / PATSTAT Support
Tue Jul 24, 2018 3:50 pm
Forum: PATSTAT Product Line
Topic: PATSTAT and Espacenet consistency
Replies: 1
Views: 1367

Re: PATSTAT and Espacenet consistency

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 ...
by EPO / PATSTAT Support
Tue Jul 24, 2018 11:12 am
Forum: PATSTAT Product Line
Topic: IPC Classification
Replies: 1
Views: 2104

Re: IPC Classification

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 ...
by EPO / PATSTAT Support
Tue Jul 24, 2018 10:09 am
Forum: PATSTAT Product Line
Topic: Error: insufficient disk space
Replies: 1
Views: 1646

Re: Error: insufficient disk space

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