EPO - Discussion forums

Posted: **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?

Posted: **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
Geert BOEDT

EPO - Discussion forums

PATSTAT Globa--tls207_pers_appln

PATSTAT Globa--tls207_pers_appln

Re: PATSTAT Global--tls207_pers_appln