PATSTAT Globa--tls207_pers_appln

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

Posts: 3
Joined: Wed Jul 22, 2020 10:58 am

PATSTAT Globa--tls207_pers_appln

Post by yekai » Mon Aug 31, 2020 1:40 am

Hello,I find that the number of appln_id in table tls207_pers_appln is less than that in table tls201_appln. What is the reason?

Posts: 243
Joined: Thu Feb 22, 2007 5:33 pm

Re: PATSTAT Global--tls207_pers_appln

Post by EPO / PATSTAT Support » Mon Aug 31, 2020 8:39 am

Hello Yekai,
you can easily check the number of records for tls201 and tls207 with the following query:

Code: Select all

select count (appln_id) from tls207_pers_appln;
select count (appln_id) from tls201_appln;
They give respective 265 and 105 million records. It is however correct that not all applications have applicant and/or inventor information available. For all applications that have an appln_id > 900000000 (replenished applications) you will not have any applicant or inventor data at all. The same goes for older patent applications.
Additionally, it is possible that INVENTORS for EP applications have requested to NOT have their name published. (Applicants can of course not request that.)

For more detailed informatoin on coverage and completeness, also have a look at this post.
mapping-data-completeness-of-patstat-gl ... ls231-7984
PATSTAT Support Team
EPO - Vienna
patstat @

Post Reply