Only 30% person_address available?
Posted: 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,
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,