Search found 113 matches
- Tue Nov 24, 2020 7:43 am
- Forum: PATSTAT Product Line
- Topic: Counting patents by IPC subclass
- Replies: 2
- Views: 138
Re: Counting patents by IPC subclass
Dear PATSTAT user, Thanks you for your precise question. However, I doubt that your query ever worked. The error "Invalid column name 'ipc_subclass' " is in the GROUP BY clause. The attribute "ipc-subclass" does not exist in the database. It is just defined in the SELECT clause as an alias for "LEFT...
- Thu Nov 12, 2020 12:06 pm
- Forum: PATSTAT Product Line
- Topic: Concordance table between IPC and NACE2
- Replies: 0
- Views: 124
Concordance table between IPC and NACE2
NACE2 is the Statistical Classification of Economic Activities in the European Community, Rev. 2 (2008) ( N omenclature statistique des a ctivités économiques dans la C ommunauté e uropéenne). It serves a similar purpose as the SIC (Standard Industrial Classification) and the NAICS (North American I...
- Thu Oct 08, 2020 2:22 pm
- Forum: Linked open EP data/open EP bulk data
- Topic: Update for "EP full-text data for text analytics"
- Replies: 1
- Views: 8658
Re: Update for "EP full-text data for text analytics"
There has been another update this week. The new release contains all EP publications from 1978 (publication number 1) to week 37 of 2020.
- Thu Sep 17, 2020 10:31 am
- Forum: PATSTAT Product Line
- Topic: proper character set for tls203 and tls206 of patstat 2020 Spring version
- Replies: 1
- Views: 440
Re: proper character set for tls203 and tls206 of patstat 2020 Spring version
Hi Hanyang, The general recommendation we give in the relevant documentation "How to load PATSTAT data" (see bottom of page https://www.epo.org/searching-for-patents/business/patstat.html ) is this: When using MySQL: You must select character set utf8mb4 , because MySQL's character set utf8 is restr...
- Fri Jul 31, 2020 12:52 pm
- Forum: PATSTAT Product Line
- Topic: Question: how to merge PATSTAT with Orbis
- Replies: 1
- Views: 944
Re: Question: how to merge PATSTAT with Orbis
The HAN (Harmonized Applicant Name) attributes in PATSTAT are dervied from a public data set (see attachment for details) of the OECD - so all credits for HAN go to them. If the PATSTSTAT attribute HAN_HARMONIZED = 2, then the HAN_NAME should match with a name in ORBIS. But I do not have access to O...
- Thu Jul 30, 2020 9:59 am
- Forum: PATSTAT Product Line
- Topic: Download all retrieved applications in xml format!
- Replies: 3
- Views: 550
Re: Download all retrieved applications in xml format!
Dear HZ, I do not see why you should not be able to download the abstracts selected by your query with the "Result table" download feature. Also, for retrieving only certain section of your result ("paging"), have a look at the option the ORDER BY clause of T-SQL provides: https://docs.microsoft.com...
- Mon Jul 27, 2020 7:49 am
- Forum: PATSTAT Product Line
- Topic: Download all retrieved applications in xml format!
- Replies: 3
- Views: 550
Re: Download all retrieved applications in xml format!
Dear HZ, Thanks you for reporting this bug in the "Download Application" feature. We will fix it in a new version. In case another download format (CSV, Excel .xlsx, MS Access .accdb) would also work for you, then please note that there are several other download options available ("Download result ...
- Thu Jul 23, 2020 8:31 am
- Forum: PATSTAT Product Line
- Topic: PATSTAT Global
- Replies: 1
- Views: 867
Re: PATSTAT Global
Hi , You are right. Not all legal events in the Category "R" ('PARTY DATA CHANGE') have the fields about old and new party populated. Currently - 2/3 of the attribute PARTY_OLD and - 3/4 of the attribute PARTY_NEW are populated. We provide the data as we receive them from the corresponding patent of...
- Mon Jul 20, 2020 7:14 am
- Forum: PATSTAT Product Line
- Topic: Question: How to effeciently retrieve in a same table with different timescale and different CPC number?
- Replies: 3
- Views: 791
Re: Question: How to effeciently retrieve in a same table with different timescale and different CPC number?
Dear HZ, The data on which PATSTAT Online is based is also available as bulk data for download and import into your own data base management system. It is a subscription product. If you just need a single edition, PATSTAT Global (worldwide patents) currently costs 975 EUR and PATSTAT EP Register (on...
- Wed Jul 01, 2020 10:25 am
- Forum: PATSTAT Product Line
- Topic: Question: How to effeciently retrieve in a same table with different timescale and different CPC number?
- Replies: 3
- Views: 791
Re: Question: How to effeciently retrieve in a same table with different timescale and different CPC number?
Dear HZ, PATSTAT Online and its 3rd party components unfortunately is not free of bugs. In certain complex queries (e.g. nested queries with aliases) it detects syntax errors where there are none. Often there is a workaround by slightly re-writing the query, like - what I did below - to replace "SEL...