Page 1 of 1

PATSTAT Globa--tls207_pers_appln

Posted: Mon Aug 31, 2020 1:40 am
by yekai
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?

Re: PATSTAT Global--tls207_pers_appln

Posted: Mon Aug 31, 2020 8:39 am
by EPO / PATSTAT Support
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