PATSTAT Autumn 2021 - Increase in number of English abstracts

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

danwas
Posts: 2
Joined: Thu Dec 23, 2021 1:02 pm

PATSTAT Autumn 2021 - Increase in number of English abstracts

Post by danwas » Thu Dec 23, 2021 1:20 pm

Dear colleagues!

We used the PATSTAT Spring 2020 edition in order to query English EP abstracts from table `tls203_appln_abstr`. In detail, we searched for specific combination of words in order to identify certain topics. We did the exact same analysis (same query, same DB, same SQL client) and the number of application IDs increased (depending on the topic) by factor 2-4.

We then had a look at the number of abstracts included in the two PATSTAT versions and it seems that the number of EP abstracts in the autumn 2021 version is nearly twice as high as the number of EP abstracts in the spring 2020 version.

Could this be the case and if yes, what is the reason behind this?

Thank you very much for some support!


EPO / PATSTAT Support
Posts: 425
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: PATSTAT Autumn 2021 - Increase in number of English abstracts

Post by EPO / PATSTAT Support » Wed Dec 29, 2021 1:19 pm

Can you post your SQL query that illustrates what you observed ?

A count can show differences depending on the keywords you used.
The condition below will give more hits today then in 2020.

Code: Select all

WHERE tls203_appln_abstr.appln_abstract like '%corona%virus%'
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Vesna Hassler
Posts: 4
Joined: Wed Jun 02, 2021 10:24 am

Re: PATSTAT Autumn 2021 - Increase in number of English abstracts

Post by Vesna Hassler » Tue Jan 04, 2022 4:59 pm

Dear PATSTAT user,

Some additional info to what my colleague wrote before: In our Data catalog ("7 History of major changes to tables and attributes") you can find this for 2020 Autumn:
"Euro-PCTs are replenished with abstracts from PCTs".

In other words, since that edition abstracts missing from EPs are replenished from the corresponding PCT applications.

So that is the reason why since 2020 Autumn there are, in general, many more EP applications with an English abstract.

Kind regards,
The PATSTAT team


danwas
Posts: 2
Joined: Thu Dec 23, 2021 1:02 pm

Re: PATSTAT Autumn 2021 - Increase in number of English abstracts

Post by danwas » Mon Jan 10, 2022 8:04 am

Dear PATSTAT-Team,
thank you very much for your quick response. That fully answered our question. A follow-up on this: is this process of replenishing abstracts for previous patent applications complete or still ongoing?

Kind regards,
Daniel


EPO / PATSTAT Support
Posts: 425
Joined: Thu Feb 22, 2007 5:33 pm
Contact:

Re: PATSTAT Autumn 2021 - Increase in number of English abstracts

Post by EPO / PATSTAT Support » Fri Jan 28, 2022 12:46 pm

The replenishing is done for each new PATSTAT release.
The process is very simple: linking the EP application with the PCT via the internat_appln_id, and then duplicating the abstract data, making and extra link via the appln_id.
There are however a limited number of linked PCT applications that do not have an abstract neither. (Exactly 2064 in the patstat2021b edition.)

Code: Select all

SELECT *
FROM tls201_appln
where tls201_appln.appln_auth = 'EP' and internat_appln_id <> 0
  and appln_id not in (select appln_id from tls203_appln_abstr)
order by appln_filing_date desc
PATSTAT Support Team
EPO - Vienna
patstat @ epo.org


Post Reply