Search found 98 matches

by EPO / PATSTAT Support
Fri Feb 22, 2019 12:02 pm
Forum: Linked open EP data
Topic: SPARQL query for Agent and Applicant
Replies: 4
Views: 3566

Re: SPARQL query for Agent and Applicant

Hi Yulyia, Let me sum up what I understand: First, you used the "API" menu item of https://data.epo.org/linked-data/ to navigate from one application https://data.epo.org/linked-data/doc/application/EP/99203729 to its A1 publication, then to the agent and the agent's address. This is very fine. That...
by EPO / PATSTAT Support
Thu Feb 21, 2019 11:07 am
Forum: Linked open EP data
Topic: SPARQL query for Agent and Applicant
Replies: 4
Views: 3566

Re: SPARQL query for Agent and Applicant

Hi Yuliya, You may try a SPARQL query like this which retrieves up to 100 publications of the applicant "HUAWEI...": SELECT * { ?publn rdf:type patent:Publication; patent:applicantVC ?applicant; patent:publicationAuthority/skos:notation ?auth; patent:publicationNumber ?nr; patent:publicationKind/sko...
by EPO / PATSTAT Support
Fri Feb 15, 2019 10:55 am
Forum: PATSTAT Product Line
Topic: Count number of patents by Country
Replies: 1
Views: 182

Re: Count number of patents by Country

Hello, as a far as I can see, your query is correct. I used the query below to also get an overview of the PCT filings in Chile and to mark the national filings which originate from an earlier PCT, but it doesn't change anything on the trend. SELECT appln_auth ,appln_kind ,appln_filing_year ,count(*...
by EPO / PATSTAT Support
Wed Feb 06, 2019 11:57 am
Forum: PATSTAT Product Line
Topic: How to find lapse country/date beyond EP Authority
Replies: 2
Views: 213

How to find lapse country/date beyond EP Authority

Hello Walter, we are happy that you found the PATSTAT seminar useful. The lapse_country and year(lapse_date) attributes are specifically linked to (granted) EP applications and are not used for any other patents filed at other patent offices. If you want to get a list of patens that have lapsed cove...
by EPO / PATSTAT Support
Mon Feb 04, 2019 6:31 pm
Forum: PATSTAT Product Line
Topic: missing prior_appln_id
Replies: 5
Views: 538

Re: missing prior_appln_id

Hello Clem, your observation is correct in as such that a lot of applications are removed when you furhter join your initial query with the tls204_appln_prior table. This means that all applications that do not have a priority will be removed from your result list. In fact, your final result of "DIS...
by EPO / PATSTAT Support
Mon Feb 04, 2019 5:09 pm
Forum: PATSTAT Product Line
Topic: What does it mean when DOCDB is 0 (zero)?
Replies: 3
Views: 111

Re: What does it mean when DOCDB is 0 (zero)?

Hello Brian, Up to the 2016 Spring "vintage", we did not assign family identifications to replenished applications. They all had the default value 0 and you can also observe that they all have an appln_id > 900000000 (+ 0) . The result was that this created a very big family which always ended up on...
by EPO / PATSTAT Support
Mon Feb 04, 2019 5:01 pm
Forum: PATSTAT Product Line
Topic: What does it mean when DOCDB is 0 (zero)?
Replies: 3
Views: 111

Re: What does it mean when DOCDB is 0 (zero)?

Hi Brian, For the vintage :-) 2016 Spring Edition the Data Catalog explains the attribute DOCDB_FAMILY_ID like this: Domain: Number 0 … 999 999 999; A value 0 indicates that the application does not belong to any DOCDB family. This is only the case for the dummy application (APPLN_ID = 0) and for ar...
by EPO / PATSTAT Support
Mon Feb 04, 2019 4:50 pm
Forum: PATSTAT Product Line
Topic: International application ID as link to earlier PCT filing
Replies: 0
Views: 120

International application ID as link to earlier PCT filing

Users have to be careful when using the internat_appln_id attribute as sole indicator for an earlier PCT application. For most patent authorities this works fine but for some countries the internat_appln_id is not available or data is incomplete. An example is Columbia, PATSTAT (2018b) contains 12.6...
by EPO / PATSTAT Support
Thu Jan 31, 2019 9:41 am
Forum: PATSTAT Product Line
Topic: R script for loading PATSTAT global (Autumn Edition 2018) into PostgreSQL
Replies: 1
Views: 195

Re: R script for loading PATSTAT global (Autumn Edition 2018) into PostgreSQL

Hello Daniel,
many thanks for sharing your work with the community.
Geert BOEDT
by EPO / PATSTAT Support
Tue Jan 29, 2019 5:18 pm
Forum: PATSTAT Product Line
Topic: missing prior_appln_id
Replies: 5
Views: 538

Re: missing prior_appln_id

Hi,
Can you please provide some specific examples, so I can have a look?
And with which version of PATSTAT are you working?

Best regards,
Martin / EPO PATSTAT