legion_id | string | Stable company identifier | No | 100% | 71,442,615 |
name | object | Company name object ({display, cleaned, raw[]}) | No | 100% | 71,442,615 |
name.display | string | Best raw company name (display-ready) | No | 100% | 71,442,615 |
name.cleaned | string | Company name cleaned value | No | 100% | 71,442,615 |
name.raw[] | array | Company name raw snippets | No | 100% | 71,442,615 |
headline | object | Company headline object ({cleaned, raw[]}) | Yes | 22% | 15,988,190 |
headline.cleaned | string | Headline text | Yes | 22% | 15,988,190 |
headline.raw[] | array | Headline raw snippets | Yes | 23% | 16,088,600 |
description | object | Company description object ({cleaned, raw[]}) | Yes | 34% | 24,045,768 |
description.cleaned | string | Description text | Yes | 34% | 24,045,768 |
description.raw[] | array | Description raw snippets | Yes | 34% | 24,203,439 |
domain | string | Primary website domain | Yes | 52% | 36,809,922 |
tickers | array | Stock tickers (array of {symbol, exchange}) | Yes | 0% | 24,422 |
tickers[].symbol | string | Ticker symbol | No | 100% | 24,422 |
tickers[].exchange | string | Ticker exchange | Yes | 100% | 24,422 |
linkedin_url | string | Company LinkedIn profile URL | Yes | 100% | 71,442,615 |
linkedin_id | string | Company LinkedIn numeric ID | Yes | 100% | 71,442,615 |
linkedin_followers | integer | LinkedIn follower count | Yes | 47% | 33,419,022 |
linkedin_employee_count | integer | LinkedIn employee count | Yes | 48% | 34,430,108 |
legion_employee_count | integer | Current employee count | Yes | 8% | 5,686,927 |
industry | string | Company industry | Yes | 74% | 53,055,673 |
type | string | Company type (e.g. public, private, nonprofit) | Yes | 100% | 71,398,195 |
size | string | Company size range (see enums/company_size.csv) | Yes | 100% | 71,352,862 |
founded | integer | Company founding year | Yes | 23% | 16,618,678 |
socials | array | Social profiles (array of {network, url, username, id}) | Yes | 100% | 71,442,615 |
socials[].network | enum | Social network name (see enums/social_networks.csv) | No | 100% | 79,749,239 |
socials[].url | string | Profile URL | No | 100% | 79,749,239 |
socials[].username | string | Profile username | Yes | 95% | 75,853,400 |
socials[].id | string | Profile ID | Yes | 91% | 72,964,027 |
domains | array | All unique website domains (array of {domain}) | Yes | 52% | 36,809,923 |
domains[].domain | string | Website domain | No | 100% | 37,457,719 |
locations | array | Company addresses, primary first (array of {street_address, address_line_2, city, state, state_code, country, country_code, continent, continent_code, postal_code, geo, raw[], current, primary, num_sources, last_seen}) | Yes | 90% | 64,487,480 |
locations[].street_address | string | Street address | Yes | 71% | 61,783,189 |
locations[].address_line_2 | string | Suite / floor / unit | Yes | 6% | 5,253,915 |
locations[].city | string | City | Yes | 95% | 83,383,642 |
locations[].state | string | State or region name | Yes | 88% | 77,258,738 |
locations[].state_code | string | ISO 3166-2 subdivision code | Yes | 79% | 69,467,726 |
locations[].country | string | Country name | Yes | 100% | 87,521,739 |
locations[].country_code | string | ISO 3166-1 alpha-2 code | Yes | 100% | 87,521,739 |
locations[].continent | string | Continent name | Yes | 100% | 87,521,739 |
locations[].continent_code | string | Continent code | Yes | 100% | 87,521,739 |
locations[].postal_code | string | Postal code | Yes | 78% | 68,325,021 |
locations[].geo | string | Latitude,longitude | Yes | 75% | 65,997,469 |
locations[].raw[] | array | Vendor address text | No | 100% | 87,528,687 |
locations[].current | boolean | Office still operating | No | 100% | 87,529,599 |
locations[].primary | boolean | Company’s primary location | No | 100% | 87,529,599 |
locations[].num_sources | integer | Sources reporting this address | No | 100% | 87,529,599 |
locations[].last_seen | date | Most recent observation | Yes | 99% | 86,901,738 |
legion_employee_count_by_month | array | Monthly headcount, hires and departures (up to 60 months), ending at the as-of month | Yes | 8% | 5,643,093 |
legion_new_hire_count | struct | New hires in the 1, 3, 6 and 12 months ending at the as-of month | Yes | 8% | 5,686,927 |
legion_employee_growth_rate | struct | Headcount growth over the 1, 3, 6 and 12 months ending at the as-of month | Yes | 8% | 5,643,093 |
legion_attrition_count | struct | Departures in the 1, 3, 6 and 12 months ending at the as-of month | Yes | 8% | 5,686,927 |
legion_turnover_rate | struct | Departures / starting headcount over the 1, 3, 6 and 12 months ending at the as-of month | Yes | 8% | 5,643,093 |
legion_average_tenure | double | Average employee tenure in months | Yes | 8% | 5,686,927 |
legion_tenure_distribution | map | Employee tenure breakdown ({bucket: count}) | Yes | 8% | 5,686,927 |
legion_seniority_distribution | map | Current employee seniority breakdown ({level: count}) | Yes | 6% | 4,257,300 |
legion_job_function_distribution | map | Current employee job function breakdown ({function: count}) | Yes | 8% | 5,682,347 |
legion_expense_category_distribution | map | Current employee expense category breakdown ({category: count}) | Yes | 8% | 5,682,347 |
legion_education_distribution | map | Highest degree level breakdown ({degree: count}) | Yes | 6% | 4,373,187 |
legion_seniority_growth_rate | map | Growth rate per seniority level ({level: {1m, 3m, 6m, 12m}}) | Yes | 6% | 4,298,531 |
legion_job_function_growth_rate | map | Growth rate per job function ({function: {1m, 3m, 6m, 12m}}) | Yes | 8% | 5,627,453 |
legion_expense_category_growth_rate | map | Growth rate per expense category ({category: {1m, 3m, 6m, 12m}}) | Yes | 8% | 5,627,453 |
num_sources | integer | Number of data sources for this company | No | 100% | 71,442,615 |
last_seen | string | Date when this record was last seen | Yes | 100% | 71,442,615 |
build_version | string | Build version identifier | No | 100% | 71,442,615 |
