Hi Stefana, This line in your nested SELECT is causing the error: "SELECT distinct reg110_title. id , reg107_parties. id , reg107_parties.country " The result of this SELECT is a (virtual) table containing 2 columns named "id" which is never allowed because they cannot be referre...

Hi Elisa,

Make sure you imported the data as UTF-8. A Chinese character is typically encoded by 3 bytes.

The result of your query should look like in the attached screenshot.

Best regards,
Martin

Hi Tim, Only some of the Identifiers in PATSTAT data are "stable", meaning they identify the same records across editions of PATSTAT. For details please see the Data Catalog or PATSTAT Global, section 4.3.2. While PERSON_ID is such as stable identifier, PSN_NAME (the PATSTAT Standardised N...

This product is a free bulk data set consisting of XML-tagged titles, abstracts, descriptions, claims and search reports covering all EP publications, designed to facilitate natural language processing work. It can be used alone, but is best if combined with bibliographic patent data, like it is ava...

The update for the data set "Linked open EP data" will be delayed due to EPO's office closure during the holidays. The planned schedule is: The update for week 52/2019 will take place Friday, 2020-01-03 afternoon. The update for week 01/2020 will take place Monday, 2020-01-06 morning. I ap...

Hi, The data set is open (CC-BY) and free. You do not need to request it. Detailed information is on the product page https://www.epo.org/searching-for-patents/data/bulk-data-sets/text-analytics . The user manual (accessible from bottom of the product page of tab "Getting started") on page...

The LOD data set contains all IPC and CPC classifications of EP patents. "Inventive" and "Additional" (= non-inventive) classifications are distinguished. IPC and CPC classifications are in the newest version (so e.g. IPC is always the newest version of IPC8) and re-classified (=...

No, the origin of the citation (from search, from examination, opposition, third party observation etc.) is not in the data. However, citations provided by the applicant himself have been excluded from the data, because their value is typically very poor. Consequently, the citations which are left i...

Hi Leo,

So - in short - the file is corrupted on your USB Memory stick. I suggest you send your email address to the PATSTAT help desk (patstat@epo.org). I will then send you a link from where you can download the missing file.

Sorry for the inconvenience and best regards,
Martin

Hi Leo,

Which version of PATSTAT data are you using? 2017 Autumn Edition?
To check whether the downloading introduced some error:
- After downloading, have you compared the SHA values?
- Or have you tried to download that particular file again?

Best regards,
Martin