Documentation Index
Fetch the complete documentation index at: /llms.txt
Use this file to discover all available pages before exploring further.
Columns and fill rates of the 10M+ and 50M+ U.S. datasets.
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.
| 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 |
| 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 |