Search found 128 matches

by EPO / PATSTAT Support
Wed Jun 05, 2019 10:13 am
Forum: PATSTAT Product Line
Topic: New PATSTAT release 2019 Spring edition is now available
Replies: 0
Views: 351

New PATSTAT release 2019 Spring edition is now available

We would like to inform you that the 2019 Spring edition is now ready for download and also PATSTAT Online has been updated. For a short overview on the changes, kindly have a look at this document: Readme.pdf Detailed information on the changes is available in the PATSTAT Data Catalog: DataCatalog_...
by EPO / PATSTAT Support
Wed Jun 05, 2019 9:40 am
Forum: PATSTAT Product Line
Topic: Now available: EP full-text data for analytics
Replies: 2
Views: 756

Now available: EP full-text data for analytics

Patent data analysts, researchers and PATSTAT users have been asking for it since long. A 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 and linkable to PATSTAT. O...
by EPO / PATSTAT Support
Thu May 23, 2019 9:30 am
Forum: PATSTAT Product Line
Topic: Retrieving tables of random sample
Replies: 2
Views: 707

Re: Retrieving tables of random sample

Hi Jon, TABLESAMPLE is not supported by the driver we are using in PATSTAT Online. Nevertheless, there are many other ways to get a random sample. The technical identifier APPLN_ID is a sequential number assigned to the applications as they are loaded into the database. [[So it can be regarded as ra...
by EPO / PATSTAT Support
Wed May 22, 2019 1:15 pm
Forum: PATSTAT Product Line
Topic: Patent specialization by technology class for Greece
Replies: 1
Views: 196

Re: Patent specialization by technology class for Greece

Hello Hannah, technology classes can be identified thought for example the patent classification scheme, be it IPC or CPC classess (at various levels of granularity). Another option would be to use the so called "technology fields and sectors" available via the TLS230 and TLS901 tables in PATSTAT. B...
by EPO / PATSTAT Support
Mon May 20, 2019 7:46 am
Forum: PATSTAT Product Line
Topic: Only download newly added data from new version
Replies: 2
Views: 337

Re: Only download newly added data from new version

Hi Tobias, your misconception seems that you assume that each new edition of PATSTAT is just the same as the previous plus some additional data. This is by far not the case. Let's see some examples: The EPO collects data from various offices and the timing of these deliveries are often not guarantee...
by EPO / PATSTAT Support
Fri May 17, 2019 6:44 pm
Forum: PATSTAT Product Line
Topic: PATSTAT - ORACLE loading scripts
Replies: 10
Views: 4762

Re: PATSTAT - ORACLE loading scripts

1 day after release !
Fantastic, that was quick :D
by EPO / PATSTAT Support
Thu May 16, 2019 1:11 pm
Forum: PATSTAT Product Line
Topic: Data completeness India
Replies: 2
Views: 747

Re: Data completeness India

Hello Tomas,
the only reason for this is the missing data from the Indian patent office.
We are in permanent negotiations in order to improve the data flows.
by EPO / PATSTAT Support
Thu May 16, 2019 10:27 am
Forum: PATSTAT Product Line
Topic: Best way to count DOCDB_FAMILY_ID
Replies: 1
Views: 420

Re: Best way to count DOCDB_FAMILY_ID

Hello Mike, there are a couple of flaws in the approach: the min(a2.appln_id) does not guarantee that you have the first application of the family, you are doing an aggregation using publications and if I understood correctly, you want to have a "family - level" final table. The main challenge is to...
by EPO / PATSTAT Support
Wed May 15, 2019 3:13 pm
Forum: PATSTAT Product Line
Topic: 2018b - 2019a person concordance table taking into account old person id's
Replies: 0
Views: 440

2018b - 2019a person concordance table taking into account old person id's

The new PATSTAT 2019 Spring edition is now published. In this release, we have added names in original language (in asian, cyrillic, arab characters) to the person records. There are many cases where persons with different names in original language were previously merged together because they have ...
by EPO / PATSTAT Support
Tue May 14, 2019 4:03 pm
Forum: PATSTAT Product Line
Topic: PATSTAT Online 2019 Spring Availability
Replies: 9
Views: 2203

Re: PATSTAT Online 2019 Spring Availability

Dear PATSTAT user, we would like to inform you that the new PATSTAT 2019 Spring is now uploaded on the EPO download platform. This also means that the Autumn 2018 files have now been taken off-line from the download platform and are not available anymore. Depending on your subscription for 2019 data...