legion_id | string | Stable company identifier | No | 100% | 71,378,184 |
name | object | Company name object ({cleaned, display, raw[]}) | No | 100% | 71,378,184 |
name.cleaned | string | Company name cleaned value | No | 100% | 71,378,184 |
name.display | string | Best-quality name with original casing preserved | No | 100% | 71,378,184 |
name.raw[] | array | Company name raw snippets | No | 100% | 71,378,184 |
headline | object | Company headline object ({cleaned, raw[]}) | Yes | 22% | 15,683,082 |
headline.cleaned | string | Headline text | Yes | 22% | 15,683,082 |
headline.raw[] | array | Headline raw snippets | Yes | 22% | 15,782,154 |
description | object | Company description object ({cleaned, raw[]}) | Yes | 36% | 25,963,865 |
description.cleaned | string | Description text | Yes | 36% | 25,963,865 |
description.raw[] | array | Description raw snippets | Yes | 37% | 26,119,260 |
domain | string | Primary website domain | Yes | 51% | 36,530,177 |
tickers | array | Stock tickers (array of {symbol, exchange}) | Yes | 0% | 24,421 |
tickers[].symbol | string | Ticker symbol | No | 100% | 24,421 |
tickers[].exchange | enum | Ticker exchange (see enums/stock_exchange.csv) | Yes | 100% | 24,421 |
linkedin_url | string | Company LinkedIn profile URL | Yes | 100% | 71,377,651 |
linkedin_id | string | Company LinkedIn numeric ID | Yes | 100% | 71,378,184 |
linkedin_followers | integer | LinkedIn follower count | Yes | 46% | 33,036,845 |
linkedin_employee_count | integer | LinkedIn-reported employee count | Yes | 47% | 33,641,381 |
legion_employee_count | integer | Current employee count from person data | Yes | 7% | 5,278,821 |
industry | enum | Company industry (see enums/industry.csv) | Yes | 74% | 52,874,743 |
type | enum | Company type (see enums/company_type.csv) | Yes | 100% | 71,337,973 |
size | enum | Company size range (see enums/company_size.csv) | Yes | 100% | 71,336,959 |
founded | integer | Company founding year | Yes | 23% | 16,326,689 |
socials | array | Social profiles (array of {network, url, username, id}) | Yes | 100% | 71,377,654 |
socials[].network | enum | Social network name (see enums/social_networks.csv) | No | 100% | 80,850,422 |
socials[].url | string | Profile URL | No | 100% | 80,850,422 |
socials[].username | string | Profile username | Yes | 95% | 76,952,403 |
socials[].id | string | Profile ID | Yes | 92% | 74,063,310 |
domains | array | All unique website domains (array of {domain}) | Yes | 51% | 36,530,202 |
domains[].domain | string | Website domain | No | 100% | 37,049,031 |
legion_employee_count_by_month | array | Monthly headcount time series (up to 60 months) | Yes | 7% | 5,278,821 |
legion_new_hire_count | struct | New hires by time window ({1m, 3m, 6m, 12m}) | Yes | 7% | 5,278,821 |
legion_employee_growth_rate | struct | Growth rate by time window ({1m, 3m, 6m, 12m}) | Yes | 7% | 5,278,821 |
legion_attrition_count | struct | Employee departures by time window ({1m, 3m, 6m, 12m}) | Yes | 5% | 3,241,339 |
legion_turnover_rate | struct | Turnover rate by time window ({1m, 3m, 6m, 12m}) | Yes | 7% | 5,278,821 |
legion_average_tenure | number | Average employee tenure in months | Yes | 7% | 5,278,821 |
legion_tenure_distribution | map | Employee tenure breakdown ({bucket: count}) | Yes | 7% | 5,278,821 |
legion_seniority_distribution | map | Current employee seniority breakdown ({level: count}) | Yes | 5% | 3,888,784 |
legion_job_function_distribution | map | Current employee job function breakdown ({function: count}) | Yes | 7% | 5,276,787 |
legion_expense_category_distribution | map | Current employee expense category breakdown ({category: count}) | Yes | 7% | 5,276,787 |
legion_education_distribution | map | Highest degree level breakdown ({degree: count}) | Yes | 6% | 4,071,059 |
legion_seniority_growth_rate | map | Growth rate per seniority level ({level: {1m, 3m, 6m, 12m}}) | Yes | 5% | 3,888,784 |
legion_job_function_growth_rate | map | Growth rate per job function ({function: {1m, 3m, 6m, 12m}}) | Yes | 7% | 5,276,787 |
legion_expense_category_growth_rate | map | Growth rate per expense category ({category: {1m, 3m, 6m, 12m}}) | Yes | 7% | 5,276,787 |
num_sources | integer | Number of data sources for this company | No | 100% | 71,378,184 |
last_seen | string | Date when this record was last seen | Yes | 100% | 71,378,184 |
build_version | string | Build version identifier | No | 100% | 71,378,184 |
