demographics_age_sex_race_county_year
ACS 5-year 2024 age structure (B01001) with race stubs (A2). Tier A-. pct_age_65_plus, median_age, pop_65_plus loaded. Full race/sex breakdown blocked on PEP charagegroups and Decennial 2020 DHC.
overview
All 3,222 US counties + DC + PR municipios. ACS 5-year covers ~99% of counties; suppression in counties with population <65,000 widens MOEs.
current vintage — 2020-2024 ACS 5-Year (released December 2025)
history — ACS 5-year releases from 2009-2013 vintage to present (rolling 5-year windows)
source & licensing
fields
| name | type | definition |
|---|---|---|
| country_id | string | ISO alpha-2 country code (always 'US' for domestic tables). |
| county_idkey | string | 5-character FIPS code identifying the county.Joins dim.counties on county_id. |
| county_name | string | Human-readable county name corresponding to county_id. |
| median_age | float64 · years | Median age of the county's resident population, where half of residents are older and half are younger. Higher values indicate an older population distribution. |
| pct_18_to_64 | float64 · percent (0–100) | Share of the total county population aged 18 to 64, representing the primary working-age cohort. Higher values indicate a larger labor-force-age population. |
| pct_age_65_plus | float64 · percent (0–100) | Share of the total county population aged 65 and older. Higher values indicate a greater concentration of older adults. |
| pct_aian_nh | float64 · percent (0–100) | Share of the total county population identifying as American Indian or Alaska Native alone, non-Hispanic. |
| pct_asian_nh | float64 · percent (0–100) | Share of the total county population identifying as Asian alone, non-Hispanic. |
| pct_black_nh | float64 · percent (0–100) | Share of the total county population identifying as Black or African American alone, non-Hispanic. |
| pct_hispanic | float64 · percent (0–100) | Share of the total county population identifying as Hispanic or Latino of any race. |
| pct_multiracial_nh | float64 · percent (0–100) | Share of the total county population identifying as two or more races, non-Hispanic. |
| pct_nhpi_nh | float64 · percent (0–100) | Share of the total county population identifying as Native Hawaiian or Other Pacific Islander alone, non-Hispanic. |
| pct_under_18 | float64 · percent (0–100) | Share of the total county population under 18 years of age. Higher values indicate a younger, more child-heavy population. |
| pct_white_nh | float64 · percent (0–100) | Share of the total county population identifying as White alone, non-Hispanic. Higher values indicate less racial and ethnic diversity among residents. |
| pop_18_to_64 | int64 · count | Number of residents aged 18 to 64. Higher values indicate a larger working-age population. |
| pop_65_plus | float64 · count | Number of residents aged 65 and older. Higher values indicate a larger older adult population. |
| pop_female | int64 · count | Number of female residents in the county. |
| pop_male | int64 · count | Number of male residents in the county. |
| pop_under_18 | int64 · count | Number of residents under 18 years of age. Higher values indicate a larger youth population. |
| racial_diversity_index | float64 · index (base year=100) | A summary measure of racial and ethnic diversity, typically computed as the probability that two randomly selected residents belong to different racial or ethnic groups (e.g., a Herfindahl-based index). Higher values indicate greater racial and ethnic diversity. |
| state_id | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| total_population | float64 · count | Total resident population of the county for the reference year. Higher values indicate more populous counties. |
| yearkey | int64 | Reference year of the observation. |
joins
how to use this table
ACS sample-based survey; Census weights and aggregates 5 years of monthly responses to county totals. Pipeline extracts pop_65_plus, median_age, pct_age_65_plus from B01001. Race/sex breakdowns are stubs pending Decennial 2020 DHC and PEP charagegroups load.
Year-over-year change at small-county grain (5-year overlapping windows); single-year point estimates (use ACS 1-year for counties >65k); race-specific population for counties <20k (high MOE).
Race/sex columns are stubs (NULL). Full breakdown blocked on Decennial 2020 DHC and PEP charagegroups load.