People Data Labs: Company Data License

Over 22 million companies to power your business

Description:

About PDL:

– People Data Labs is your engineering partner for all things b2b data. Our company has enabled thousands of engineering, data science, product, and other technical teams to build compliant, innovative, software solutions using b2b data.
– PDL provides company and person data via flat files and APIs

About this Dataset:

– This is a paid dataset that requires a signed order form with PDL to access
– Our company dataset contains over 22 million profiles of companies in our identity graph.
– This data covers global profiles with a linkedin url as the primary key.

Tables Included:

1. ROOT_COMPANY

id | The ID value is currently non-persistent and generated from the company’s primary LinkedIn username.
average_employee_tenure | Average employee tenure is the average number of years employees work for the company. It is represented by a floating number greater than zero and rounded to the nearest thousandth.
employee_count | employee_count is an integer greater than zero. We calculate it by finding the number of our profiles whose job_company_id matches the company.
facebook_url | The main Facebook profile URL for the company based on source agreement.
founded | The founding year of the company.
gics_sector | GICS standard sector classification for public companies.
headline | The company’s headline summary.
industry | The self-reported industry of the company.
linkedin_id | The main LinkedIn profile ID for the company based on source agreement.
linkedin_url | The main LinkedIn profile URL for the company based on source agreement.
location_address_line_2 | HQ location information.
location_continent | HQ location information.
location_country | HQ location information.
location_geo | City-center geo code of the company’s current HQ.
location_locality | HQ location information.
location_metro | US ONLY MSA of the company’s current HQ.
location_name | HQ location information in the format “locality, region, country”.
location_postal_code | HQ location information.
location_region | HQ location information.
location_street_address | HQ location information.
inferred_revenue | Company’s estimated annual revenue in US dollars.
mic_exchange | The MIC code for the stock exchange that the company’s ticker is listed on.
name | The company’s main common name.
size | A self-reported range representing the number of people working at the company.
summary | A description of the company.
ticker | The company ticker (only for public companies).
twitter_url | The main Twitter profile URL for the company based on source agreement.
type | type will be one of the Canonical Company Types in the PDL company data. If a company has a known ticker, then its type is public.
website | The primary company website.

2. TAG

company_id | PDL company ID.
tag | Tag associated with the company.

3. NAICS

company_id | PDL company ID.
naics_code | The NAICS code associated with a company’s industry classification.
sector | The industry classification according to the first two digits in the NAICS code.
sub_sector | The industry classification according to the first three digits in the NAICS code.
industry_group | The industry classification according to the first four digits in the NAICS code.
industry | The industry classification according to the first five digits in the NAICS code.
national_industry | The industry classification according to all six digits in the NAICS code.

4. SIC

company_id | PDL company ID.
sic_code | The SIC code associated with a company’s industry classification.
major_group | The industry classification according to the first two digits in the SIC code.
industry_group | The industry classification according to the first three digits in the SIC code.
industry_sector | The industry classification according to all four digits in the SIC code.

5. AFFILIATED_PROFILE

company_id | PDL company ID.
affiliated_profile | Company ID that is affiliated with the queried company.

6. ALTERNATIVE_DOMAIN

company_id | PDL company ID.
alternative_domain | An alternate domain associated with this company.

7. ALTERNATIVE_NAME

company_id | PDL company ID.
alternative_name | A name associated with this company.

8. PROFILE

company_id | PDL company ID.
profile | A known social profile URL for the company.

9. HEADCOUNT_CHANGE_BY_MONTH

company_id | PDL company ID.
month | Month of event.
gross_additions | The total number of people that joined the company in this month.
gross_departures | The total number of people that departed the company each month.

10. EMPLOYEE_CHANGE_RATES
Churn rates represent the rate of decrease in employee headcount from N months prior rounded to the nearest ten-thousandth.
Growth rates represent The percentage increase in total headcount from 3 months prior rounded to the nearest ten-thousandth.

company_id | PDL company ID.
churn_rate_3_month
churn_rate_6_month
churn_rate_12_month
churn_rate_24_month
growth_rate_3_month
growth_rate_6_month
growth_rate_12_month
growth_rate_24_month

11. HEADCOUNT_BY_MONTH

company_id | PDL company ID.
month | Month of event.
value | The number of employees at the end of each month.

12. HEADCOUNT_BY_COUNTRY

company_id | PDL company ID.
country | Canonical country in the PDL data.
value | The number of current employees in this country.

13. RECENT_EXEC_CHANGES

previous_company_id | PDL company ID.
event_date | Month of executive changing roles. Formatted as YYYY-MM-01.
person_id | PDL persistent person ID of the exec
previous_title | The executive’s previous job title at the old company.
previous_role | The executive’s previous job role at the old company. This will be one of the Canonical Title Roles.
previous_sub_role | The executive’s previous job sub-role at the old company. This will be one of the Canonical Title Sub-Roles.
previous_levels | The executive’s previous job level at the old company. This will be one of the Canonical Title Levels.
next_company_id | PDL company ID.
next_title | The executive’s job title at their next company.
next_role | The executive’s previous job title role at their next company. This will be one of the Canonical Title Roles.
next_sub_role | The executive’s previous job title sub-role at their next company. This will be one of the Canonical Title Sub-Roles.
next_levels | The executive’s previous job title level at their next company. This will be one of the Canonical Title Levels.

14. EMPLOYEE_MOVEMENT

previous_company_id | PDL company ID.
next_company_id | PDL company ID.
role | PDL canonical role generated from an employee’s title in their experience history. This value can also be “all” for a sum of all employees across the company.
value | Integer value representing the number of employees who moved from previous company to next company.

15. TOP_US_EMPLOYEE_METRO

company_id | PDL company ID.
metro | Each metro listed is one of our Canonical Metros.
current_headcount | The number of employees in the metro.
growth_rate_12_month | The growth rate in the metro over the last twelve months, rounded to the nearest ten-thousandth.

16. TENURE_BY_LEVEL

company_id | PDL company ID.
role | PDL canonical level generated from an employee’s title in their experience history.
value | Average tenure by role, rounded to the nearest thousandth.

17. TENURE_BY_ROLE

company_id | PDL company ID.
role | PDL canonical role generated from an employee’s title in their experience history.
value | Average tenure by role, rounded to the nearest thousandth.

About the Provider

“People Data Labs builds B2B data. At PDL we know that every company is rapidly transforming to solve problems in a more data-driven and people-driven manner. In order to succeed, companies are forming data departments, pivoting their focus into data acquisition, and doubling down on legal, security, and compliance to protect themselves. For these organizations, clean, rich, and compliant person data is critical and PDL is here to meet that demand.

Today, the PDL platform seeks to enable all companies to build compliant B2B data solutions. Our sole focus is on building the best data available by integrating thousands of compliantly-sourced datasets into a single, developer-friendly source of truth. Use our dataset of 3 billion person profiles and 20 million company profiles to build products, power predictive modeling/AI, and more. We work with technical teams as their engineering focused data partner.”

Get access to the People Data Labs: Company Data License Listing in Snowflake

SIGN UP FOR A SNOWFLAKE FREE TRIAL

Already a Snowflake customer?
Access this listing directly from your Snowflake account.

LOGIN