Search found 235 matches

by EPO / PATSTAT Support
Mon Sep 24, 2018 3:52 pm
Forum: PATSTAT Product Line
Topic: Counting international patent applications
Replies: 1
Views: 1395

Re: Counting international patent applications

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...
by EPO / PATSTAT Support
Fri Sep 14, 2018 4:58 pm
Forum: PATSTAT Product Line
Topic: retrieve results of a custom sql query from a database connection
Replies: 4
Views: 3989

Re: retrieve results of a custom sql query from a database connection

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...
by EPO / PATSTAT Support
Thu Sep 13, 2018 5:36 pm
Forum: PATSTAT Product Line
Topic: patent citation (backward citation)
Replies: 5
Views: 2311

Re: patent citation (backward citation)

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

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: 3181

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: 2421

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: 1938

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: 2421

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: 1879

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: 1375

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