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...

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

PATSTAT Online is a read-only database. You cannot create your own database views (CREATE VIEW ...). To create views, you have to set up your own local database and import PATSTAT data from its CSV files. But in almost all cases you can just work around database views: Here is a query which returns ...

I suppose you are using PATSTAT Online. PATSTAT Online is powered by MS SQL Server, which is using the T-SQL dialect of SQL. There are some more wildcards than just the %-character. Please see the full Microsoft documentation here: https://docs.microsoft.com/en-us/sql/t-sql/language-elements/like-tr...

Dear Carmen, There probably is a misconception about the meaning of "designated states". Article 79 of the European Patent Convention (http://www.epo.org/law-practice/legal-texts/html/epc/2016/e/ar79.html) specifies since late 2000 that "All the Contracting States party to this Convention at the tim...

Dear subscriber of PATSTAT Biblio, In case you have downloaded the files of the 2017 Autumn Edition before the noon of Nov 2nd, 2017: File tls201_part05.txt contains a bad character (marked red in the middle line below) in one of its lines, which may cause issues when you import the data into your d...

Please note that in the current 2017 Autumn Edition values in attribute NPL_BIBLIO of table TLS214_NPL_PUBLN can be up to 3 800 characters long. If your DB schema is not prepared to hold such longs strings, then you might experience problems when loading the data into your database. To avoid similar...

Dear Björn,

Bad timing! The document you are looking for is right now being replaced by an updated version.

Please try again a little later (today).

Sorry for the inconvenience,
Martin
EPO / PATSTAT