Search found 120 matches

by mkracker
Mon May 11, 2020 11:07 am
Forum: PATSTAT Product Line
Topic: Problem with concatenated fields
Replies: 1
Views: 734

Re: Problem with concatenated fields

Hi Stefana, Interesting question, so I had a look and tried it myself. You will find my code below. My thoughts: I assume you did not consider that the technical field table TLS901_TECHN_FIELD_IPC contains multiple entries for each technical field number. There is one record for each technical field...
by mkracker
Thu May 07, 2020 7:19 am
Forum: PATSTAT Product Line
Topic: Accessing Data from ER Register PATSTAT Online
Replies: 2
Views: 1136

Re: Accessing Data from ER Register PATSTAT Online

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 referred to unambiguously. ...
by mkracker
Mon May 04, 2020 11:18 am
Forum: PATSTAT Product Line
Topic: Non-patent-literature, encoding error?
Replies: 2
Views: 793

Re: Non-patent-literature, encoding error?

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
by mkracker
Wed Apr 01, 2020 7:12 am
Forum: PATSTAT Product Line
Topic: PSN_ID changed?
Replies: 3
Views: 1394

Re: PSN_ID changed?

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 Name) is no...
by mkracker
Fri Mar 13, 2020 10:09 am
Forum: Linked open EP data/open EP bulk data
Topic: Update for "EP full-text data for text analytics"
Replies: 2
Views: 11790

Update for "EP full-text data for text analytics"

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...
by mkracker
Wed Dec 11, 2019 4:06 pm
Forum: Linked open EP data/open EP bulk data
Topic: End of year publication dates
Replies: 0
Views: 4613

End of year publication dates

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 apologize fo...
by mkracker
Wed Jun 26, 2019 4:26 pm
Forum: PATSTAT Product Line
Topic: Now available: EP full-text data for analytics
Replies: 2
Views: 7084

Re: Now available: EP full-text data for analytics

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 6 describ...
by mkracker
Fri Aug 31, 2018 10:16 am
Forum: Linked open EP data/open EP bulk data
Topic: Kind of IPC and CPC for patents in LOD
Replies: 1
Views: 10858

Re: Kind of IPC and CPC for patents in LOD

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 (= updated in case the...
by mkracker
Wed Aug 29, 2018 10:57 am
Forum: Linked open EP data/open EP bulk data
Topic: Kind of citations in LOD
Replies: 2
Views: 5696

Re: Kind of citations in LOD

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...
by mkracker
Wed Mar 21, 2018 5:00 pm
Forum: PATSTAT Product Line
Topic: tls231_part01
Replies: 5
Views: 3491

Re: tls231_part01

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