Only 30% person_address available?

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

Fr3dY
Posts: 26
Joined: Mon Oct 17, 2016 8:57 am

Only 30% person_address available?

Post by Fr3dY » Fri May 18, 2018 9:42 am

Hi,

Just wanted to verify if only about 30% of person addresses are available (for RAW data):

select count(*) from patstat2018a.tls206_person where psn_sector='INDIVIDUAL' and person_address is not null;
3.653.560

select count(*) from patstat2018a.tls206_person where psn_sector='INDIVIDUAL' and person_address is null;
8.042.117



Regards,


gianluca.tarasconi
Posts: 63
Joined: Mon Nov 09, 2009 8:48 pm
Location: Italy
Contact:

Re: Only 30% person_address available?

Post by gianluca.tarasconi » Fri Jun 08, 2018 11:32 am

HI,

yes; if you need a coverage by patent office I made some stats here

http://rawpatentdata.blogspot.com/2017/ ... ks-in.html


Fr3dY
Posts: 26
Joined: Mon Oct 17, 2016 8:57 am

Re: Only 30% person_address available?

Post by Fr3dY » Fri Jun 08, 2018 2:47 pm

OK, thanks!!


Post Reply