Newer snapshots store phone number in full_phone_number.
Older snapshots store it in area_cd + phone_num, though some have only 1 of those fields (sigh).
But AFAICT, there are no other records which would store a phone number.
ncvoter_production=> select data from voter_ncvoter where not data ? 'area_cd' and not data ? 'full_phone_number' and not data ? 'phone_num' and data::text like '%phone%' limit 1;
data
------
(0 rows)
The other problem is that only about 4.4 million of the records have either of the above, so a majority of records don't have any phone.
full_phone_number.area_cd+phone_num, though some have only 1 of those fields (sigh).The other problem is that only about 4.4 million of the records have either of the above, so a majority of records don't have any phone.