Dataset fields

Columns and fill rates of the 10M+ and 50M+ U.S. datasets.

Dataset fields

Both U.S. datasets have two tables, companies and people, as Parquet files inside a zip. The 10M+ dataset (free in GET /files/) is us_smb_mid_market_companies.parquet and us_smb_mid_market_persons.parquet; the 50M+ dataset (large) is company_us.parquet and person_us.parquet. Join people to companies on CURRENT_JOB_COMPANY_LINKEDIN_ID = LINKEDIN_ID.

Fill rates below are the 10M+ dataset’s, measured on the September 2026 build.

---

Company fields

1,752,762 companies in the 10M+ dataset (6,828,825 in the 50M+ dataset).

Field	Type	Nullable	Fill rate	Description
LINKEDIN_ID	String	No	100%	Unique LinkedIn numeric ID for the company
LINKEDIN_URL	String	No	100%	Full LinkedIn company page URL (https://www.linkedin.com/company/...)
NAME	String	No	100%	Company name (acronyms normalized: LLC, PLLC, LLP, DBA, HVAC, USA)
HEADLINE	String	Yes	43.09%	Company tagline/headline from LinkedIn
ABOUT	String	Yes	63.95%	Company description/about section
FOUNDED	UInt16	Yes	46.26%	Year the company was founded (validated: 1800–current year)
LOGO_URL	String	No	100%	URL to company logo image
LINKEDIN_FOLLOWERS	UInt32	No	100%	Number of LinkedIn followers
IS_CLAIMED_PAGE	Bool	No	100%	Whether the LinkedIn page is claimed (always true - unclaimed pages are filtered out)
EMPLOYEE_COUNT_RANGE	String	No	100%	Employee count bucket. 10M+ dataset values: 11-50, 51-200, 201-500
HQ_CITY	String	Yes	74.61%	Headquarters city
HQ_STATE_CODE	String	Yes	73.03%	Headquarters US state code (e.g. CA, NY)
HQ_STATE_NAME	String	No	72.83%	Headquarters US state name (e.g. California, New York). Empty string when unknown.
HQ_POSTCODE	String	Yes	57.86%	Headquarters postal/zip code
HQ_STREET	String	Yes	53.54%	Headquarters street address
LINKEDIN_INDUSTRY	String	Yes	91.33%	LinkedIn industry classification
TYPE	String	Yes	64.39%	Entity type: Privately Held, Public Company, Partnership, Self-Owned
URL	String	Yes	79.32%	Company website URL
UPDATED_AT	DateTime	No	100%	When the record was last refreshed

---

Person fields

11,139,026 people in the 10M+ dataset (50,529,855 in the 50M+ dataset).

Field	Type	Nullable	Fill rate	Description
FIRST_NAME	String	No	100%	First name (validated: no digits, 1–50 chars)
LAST_NAME	String	No	100%	Last name (1–50 chars)
FULL_NAME	String	No	100%	Full name
ABOUT	String	Yes	31.00%	LinkedIn about/summary section
PROFILE_PIC_URL	String	No	100%	URL to profile picture
LINKEDIN_URL	String	No	100%	Full LinkedIn profile URL (https://www.linkedin.com/in/...)
LINKEDIN_ID	String	No	100%	Unique LinkedIn numeric ID (all digits, 1–15 chars)
HEADLINE	String	No	100%	LinkedIn headline
CONNECTIONS_COUNT	UInt32	No	100%	Number of LinkedIn connections (capped at 500)
MOBILE_PHONE	String	Yes	43.35%	Mobile phone number (US format: starts with +1, 10+ digits)
CITY	String	No	100%	City of residence
STATE_CODE	String	No	100%	US state code (e.g. CA)
STATE_NAME	String	No	100%	US state name (e.g. California)
CURRENT_JOB_TITLE	String	No	100%	Current job title (1–200 chars, acronyms normalized: VP, SVP, EVP, RN, LPN, CNA, HVAC)
CURRENT_JOB_DESCRIPTION	String	Yes	14.21%	Current job description
CURRENT_JOB_START_DATE	Date32	Yes	61.66%	When the current job started (validated: 1950–today)
CURRENT_JOB_CITY	String	Yes	30.37%	City of current job
CURRENT_JOB_STATE	String	Yes	31.88%	State name of current job
CURRENT_JOB_STATE_CODE	String	Yes	31.88%	State code of current job
CURRENT_JOB_COMPANY_LINKEDIN_ID	String	No	100%	LinkedIn ID of current employer (foreign key to company table)
EMAIL	String	Yes	30.39%	Email address (validated format, lowercase, domain has dot)
EMAIL_VALIDATED_AT	DateTime	Yes	30.39%	When the email was last validated
UPDATED_AT	DateTime	No	100%	When the record was last refreshed