Universal Person

Specifications

Release: December 5, 2024

Version: 2.12.0

Size: 91.3 G (.csv), 117.3 G (parquet)

Update Freq: Monthly

Data Schema, Counts, and Fill Rates

FeatureDescriptionCountFill Rate
up_idUniversal Person ID. This is a unique identifier assigned to a person, linking all business and consumer information to a single individual. The up_id, along with the company_id, are primary keys throughout the co-op data files.307,427,492100%
first_nameFirst name of the person in this record.307,383,431100%
last_nameLast name of the person in this record.307,385,406100%
business_emailThe primary business email associated with this person.84,800,52028%
programmatic_business_emailsThis feature is an array of all common business email formats, built from the first_name, last_name, and company_domain fields in the B2B and UP files.139,442,04645%
mobile_phoneMobile number uniquely associated with this person, regardless of business or personal association.162,054,60353%
direct_numberThe business phone number for this person.131,669,04443%
personal_phoneThe non-mobile, non business related telephone number for this person.131,669,04443%
linkedin_urlThe LinkedIn URL for this person.89,486,57329%
personal_addressWhere this person lives.216,301,02570%
personal_address_2Where this person lives.34,106,40411%
personal_cityThe city in which this person resides.272,965,46289%
personal_stateThe upper-case standard abbreviation for the person's home state. This field will contain 50 US states + Washington D.C. Please see professional_state and company_state for other state data.274,872,92489%
personal_zipThe 5-digit US zip code for the person's home address.224,633,18873%
personal_zip4The 4-digit extension the person's home zip code.209,266,32768%
personal_emailsThe primary personal email observed for this person record.208,397,14868%
additional_personal_emailsAny additional personal emails associated with this person, excluding any emails previously reported as invalid. Stored as a comma-separated array.35,804,34012%
genderGender of the person (M/F/U).257,418,84184%
age_rangeThe age range this contact fits within. The ranges are industry standard demographic ordinal values, and can be found here. Null values indicate unknown.191,754,96062%
marriedIf the person is married, the value will be 'Y'. Blank values represent unknown.139,462,29445%
childrenIndicates if the person associated with this record has children. Values are 'Y', 'N', or NULL. Null values indicate unknown.99,717,10432%
income_rangeThe income of this person, mapped to industry standard demographic ranges. Link is to the mapping ranges. Null values indicate unknown.114,800,79937%
net_worthEstimate of a households total financial assets minus liabilities, reported within industry standard demographic ranges. Link is the range table. Null values indicate unknown.137,248,67145%
homeownerReports if the person in this record is a homeowner. Y and N are observed values, P represents that they are likely a homeowner, based on probabilistic modeling, and null values represent 'unknown'.144,772,03447%
job_titleThe current job title of the person in this record.140,239,55746%
seniority_levelSeniority derived from the job title using the Seniority Clustering / Department mapping model136,593,37344%
departmentDepartment of the job_title in this person's record.112,457,12237%
professional_addressWhere this person shows up to work - could be the same as personal, company or different depending on company structure.41,618,31914%
professional_address2Where this person shows up to work - could be the same as personal, company or different depending on company structure.13,154,5324%
professional_cityWhere this person shows up to work - could be the same as personal, company or different depending on company structure.46,194,46515%
professional_stateThe state occurring within the professional address - the state where this person works from. This field will contain all 50 US states, Washington DC, and the five populated US territories - American Samoa, Guam, the Northern Mariana Islands, Puerto Rico, and the U.S. Virgin Islands. Please see company_state and personal_state for other state data.46,321,59315%
professional_zipThe 5-digit Zip Code occuring within the professional address.41,536,69714%
professional_zip4The 4-digit extension of the professional address zip code.27,045,5349%
company_nameCompany name associated with the person's job title.148,384,91248%
company_domainThe primary domain associated with this company.139,511,80945%
company_phoneGeneral phone number for the company.131,811,87443%
company_sicThe 4 digit Standard Industrial Classification (SIC) code(s) associated with the company. Link is to SIC classification taxonomy.127,641,14442%
company_addressThe physical address of the company headquarters.123,156,95340%
company_cityThe city of the company headquarters.148,362,22548%
company_stateState code of company headquarters. This field will include 50 states, Washington DC, the five US territories (American Samoa, Guam, the Northern Mariana Islands, Puerto Rico, and the U.S. Virgin Islands), and a variety of non-US user-reported data. Please see professional_address and personal_address for additional state data.142,905,57646%
company_zipZip of company headquarters.127,922,23942%
company_linkedin_urlThe URL for the company's LinkedIn profile.127,545,10641%
company_revenueRevenue range associated with the company. This is derived from the employee count and mapped in accordance with the mapping linked here.151,188,13049%
company_employee_countThe number of observed US enterprise employees of this company, fit within standard firmographic ranges, which are listed in this link.151,188,13049%
primary_industryThe primary industry for a company, as observed in multiple firmographic data sets.103,763,63734%
business_email_validation_statusThe validation status of the associated business email. The following values are allowed: 'valid' = the host email server does not return and 'invalid' response to an email sent to this email address. ; 'Valid-ESP' = the email validation flag was provided by an Email Service Provider (ESP); 'Valid-Digital'= the validation flag originated from cookie signal or digital tag.62,138,14120%
business_email_last_seenThe date (unix) by when an email was last seen as contributed via validation or other verifiable data. Null values mean that no data is available62,138,14120%
personal_emails_validation_statusThe validation status of the associated personal email, 'Valid' indicates the email has been validated, a null value represents unknown.162,200,81253%
personal_emails_last_seenThe UNIX timestamp of the last validation observation of this personal email. via validation or other verifiable data. Null values indicate that no data is available.162,200,81253%
company_last_updatedThis is the Unix timestamp of the last update for the company_name field in the B2B and Universal Person files. This field records when the contact record was last confirmed at the company. Note: companies may have multiple 'company_last_updated' values, reflecting the last updates across different employees.71,067,39323%
job_title_last_updatedThe Unix timestamp of the last update for the job title.63,434,05421%
last_updatedThe date (unix) by when a value within the record was last updated.245,377,65780%
work_historyThis field is a JSON formatted work history, which when available, include data for: company name, position, duration, start_time, end_time, job_description, location, and social_url.72,057,67123%
education_historyThis field is a JSON formatted education history, which when available, include data for: degree, description, start_time, end_time, institution_name, and social_url.43,323,53914%
cc_idA persistent, unique ID, assigned to each company in the Co-Op Firmographic dataset. The cc_id, along with the up_id, are used as key linkage across the co-op data sets.139,511,80945%
company_descriptionThis is a varchar(2000) field with the company description from online profiles.112,396,60237%
related_domainsThese are sub-domains and top-level domains that roll to up or redirect to the company_domain field in this record.27,092,4939%
social_connectionsThe number of social media connections observed for this person, given in ranges of 1-9, 10-49, 50-99, 100-249, 250-499, 500+.60,319,05420%
dpv_codeThe Delivery Point Confirmation Code is the primary method used by the USPS to indicate whether an address was considered deliverable or undeliverable. Y=confirmed for primary and secondary numbers, D=confirmed for primary number only, secondary number missing, S=confirmed for primary number only, secondary number present but unconfirmed, N=both primary and secondary numbers failed to confirm, Blank=no data.147,771,21648%
company_naicsNorth American Industry Classification System, denoting the primary industry(s) the company is listed in. This field is a comma-separated array with up to 5 NAICS codes.130,737,81043%
company_countryThe ISO Alpha-2 country code of the company address.86,071,29728%
contact_countryThe ISO Alpha-2 country code of the personal address.75,952,16525%
job_title_normalizedThis is the cleaned up version of the job_title, incorporating spelling corrections, standardized title elements, and normalized to reduce the number of variations. E.g. - "CEO", "C.E.O.", "Chief Exec Ofc", etc, all become: "Chief Executive Officer".22,960,4377%
seniority_level_2The updated model for seniority levels, modeled off the job_title and primary_industry. See this page for additional detail: https://docs.5x5coop.com/docs/seniority-and-department-20131,204,63743%
department_2The updated model for departments, modeled off the job_title and primary_industry. See this page for additional detail: https://docs.5x5coop.com/docs/seniority-and-department-20104,902,38234%

What’s Next

For additional information, please see the release notes linked below.