B2B Person
SpecificationsRelease: December 5, 2024
Version: 5.17.0
Size: 71.1 G (.csv), 96.3 G (parquet)
Update Freq: Monthly
Key Feature Trends
Data Schema, Counts, and Fill Rates
Feature | Description | Counts | Fill Rate |
---|---|---|---|
up_id | Universal 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. | 114,157,062 | 100% |
first_name | First name of the person in this record. | 114,157,062 | 100% |
last_name | Last name of the person in this record. | 114,157,062 | 100% |
business_email | The primary business email associated with this person. | 66,328,500 | 58% |
programmatic_business_emails | This 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. | 88,675,034 | 78% |
job_title | The current job title of the person in this record. | 104,596,225 | 92% |
seniority_level | Seniority derived from the job title using the Seniority Clustering / Department mapping model | 102,976,378 | 90% |
department | Department of the job_title in this person's record. | 84,381,892 | 74% |
mobile_phone | Mobile number uniquely associated with this person, regardless of business or personal association. | 37,462,860 | 33% |
direct_number | This is a non-mobile business or personal number for the contact. | 30,629,406 | 27% |
linkedin_url | The LinkedIn URL for this person. | 75,225,822 | 66% |
personal_address | Where this person lives. | 36,147,271 | 32% |
personal_address_2 | Where this person lives. | 4,750,309 | 4% |
personal_city | The city in which this person resides. | 86,552,893 | 76% |
personal_state | The 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. | 88,652,934 | 78% |
personal_zip | The 5-digit US zip code for the person's home address. | 36,058,512 | 32% |
personal_zip4 | The 4-digit extension the person's home zip code. | 29,866,828 | 26% |
professional_address | Where this person shows up to work - could be the same as personal, company or different depending on company structure. | 39,837,344 | 35% |
professional_address2 | Where this person shows up to work - could be the same as personal, company or different depending on company structure. | 12,601,819 | 11% |
professional_city | Where this person shows up to work - could be the same as personal, company or different depending on company structure. | 44,456,605 | 39% |
professional_state | The 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. | 44,635,234 | 39% |
professional_zip | The 5-digit Zip Code occuring within the professional address. | 39,759,606 | 35% |
professional_zip4 | The 4-digit extension of the professional address zip code. | 25,643,892 | 22% |
company_name | Company name associated with the person's job title. | 101,435,247 | 89% |
company_domain | The primary domain associated with this company. | 88,675,034 | 78% |
company_phone | General phone number for the company. | 85,302,168 | 75% |
primary_industry | The primary industry for a company, as observed in multiple firmographic data sets. | 75,189,684 | 66% |
company_sic | The 4 digit Standard Industrial Classification (SIC) code(s) associated with the company. Link is to SIC classification taxonomy. | 84,303,082 | 74% |
company_naics | North 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. | 85,949,890 | 75% |
company_address | The physical address of the company headquarters. | 83,258,280 | 73% |
company_address_2 | The physical address of the company headquarters. | 2,483,892 | 2% |
company_city | The city of the company headquarters. | 100,982,816 | 88% |
company_state | State 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. | 99,879,542 | 87% |
company_zip | Zip of company headquarters. | 84,867,624 | 74% |
company_zip4 | Plus 4 of company ZIP. | 1,887,628 | 2% |
company_linkedin_url | The URL for the company's LinkedIn profile. | 85,938,662 | 75% |
company_revenue | Revenue range associated with the company. This is derived from the employee count and mapped in accordance with the mapping linked here. | 102,186,309 | 90% |
company_employee_count | The number of observed US enterprise employees of this company, fit within standard firmographic ranges, which are listed in this link. | 102,180,814 | 90% |
business_email_validation_status | The 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. | 57,274,198 | 50% |
business_email_last_seen | The date (unix) by when an email was last seen as contributed via validation or other verifiable data. Null values mean that no data is available | 57,274,198 | 50% |
company_last_updated | This 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. | 72,410,523 | 63% |
job_title_last_updated | The Unix timestamp of the last update for the job title. | 65,413,811 | 57% |
last_updated | The date (unix) by when a value within the record was last updated. | 107,199,872 | 94% |
work_history | This 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. | 69,394,681 | 61% |
education_history | This field is a JSON formatted education history, which when available, include data for: degree, description, start_time, end_time, institution_name, and social_url. | 42,112,065 | 37% |
cc_id | A 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. | 88,675,034 | 78% |
company_description | This is a varchar(2000) field with the company description from online profiles. | 79,599,048 | 70% |
related_domains | These are sub-domains and top-level domains that roll to up or redirect to the company_domain field in this record. | 19,441,944 | 17% |
social_connections | The 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,152,372 | 53% |
company_country | The ISO Alpha-2 country code of the company address. | 59,915,062 | 52% |
contact_country | The ISO Alpha-2 country code of the personal address. | 73,683,305 | 65% |
job_title_normalized | This 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". | 15,708,392 | 14% |
seniority_level_2 | The 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-20 | 95,331,442 | 84% |
department_2 | The 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-20 | 75,829,407 | 66% |
Updated 9 days ago
What’s Next
For additional information, please see the release notes linked below.