Sometimes you cannot compare data from Espacenet and PATSTAT because they represent data from different points of time: Espacenet is incrementally updated daily, while PATSTAT is completely re-created 2x / year. If you are now using the latest PATSTAT 2016 Spring Edition, then in fact you see the da...

IMO your query is fine. Just the comma at the end must be removed. And you do not need to put the attribute values in quotes because TECHN_FIELD_NR is not a string attribute but a numerical attribute.

So why are you not happy with your result?

Short answer: Have a look at table TLS230_APPLN_TECHN_FIELD, which has the data about to which degree an application is related to a technical field. This table will already solve half of your problem. This table is based on the reference table TLS901_TECHN_FIELD_IPC. The Data Catalog gives you more...

Yes, this looks good. Nevertheless, here a slightly adapted version: SELECT tls201_appln.*, tls207_pers_appln.*, tls206_person.* FROM tls201_appln JOIN tls207_pers_appln ON tls207_pers_appln.appln_id = tls201_appln.appln_id JOIN tls206_person ON tls206_person.person_id = tls207_pers_appln.person_id ...

Yes, this is doable with PATSTAT. A query would look like this: select DISTINCT a.* -- DISTINCT to remove duplicates if applications have -- more applicants from the requested country from tls201_appln a join tls207_pers_appln pa on a.appln_id = pa.appln_id join tls206_person p on pa.person_id = p.p...

There are several online tools at the EPO where you can retrieve EP applications: - Espacenet - European Patent Register In PISE (Patent Information Services for Experts): - Global Patent Index - European Full text Search - European Patent Bulletin Online - PATSTAT Online (http://www.epo.org/searchi...

Hi Torben, I suppose by "main IPC class" you mean the "most representative" of the IPC symbols. Of all the IPCs assigned, there should always be a "first" IPC (IPC_POSITION = 'F'). However, its meaning depends on the office: I know that for German publications (and I th...

You mention several similar, but distinctive data items. Please let me explain each of them: EARLIEST_PAT_PUBLN_ID, EARLIEST_PUBLN_DATE, EARLIEST_PUBLN_YEAR in table TLS201_APPLN: An application can have multiple publication, like first A2, the A3, followed by B1 and finally B8. These attributes sim...

I assume that when you write "insert another row per assigned Patent-IPC " you mean that you want additional columns for each IPC symbol of an application. I can imagine that this is possible with SQL, but it would be quite tricky. Anyway,I would discourage you to do so, because that is no...

Hi Moos, Bad news: I cannot comprehend your query. In fact, I never saw a query with 7 nested(!) subqueries and I cannot imagine that this is ever necessary. Good news: Your information need is quite typical and you can solve it in a much easier way. Instead of analysing your query I propose one whi...