> ## Documentation Index
> Fetch the complete documentation index at: https://idle.docs.datacircle.dev/llms.txt
> Use this file to discover all available pages before exploring further.

# 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/`](/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 |


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.