demographics_age_sex_race_county_year
ACS 5-year 2024 age structure (B01001) plus Decennial 2020 DHC race shares (A2). Tier A-. pct_age_65_plus, median_age, pop_65_plus, and all race/ethnicity shares are populated. Race shares joined from demographics_decennial_baseline_county.
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_idkey | string | ISO alpha-2 country code (always 'US' for domestic tables).Part of primary key. |
| county_idkey | string | 5-character FIPS code identifying the county.Part of primary key. 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 population. Higher values indicate an older population. |
| pct_age_65_plus | float64 · percent (0–100) | Share of total population aged 65 and older, computed as pop_65_plus / total_population × 100. Higher values indicate an older age structure. |
| pct_aian_nh | float64 · percent (0–100) | Share of total population identifying as American Indian and Alaska Native alone, non-Hispanic. Higher values indicate a larger non-Hispanic AIAN share. |
| pct_asian_nh | float64 · percent (0–100) | Share of total population identifying as Asian alone, non-Hispanic. Higher values indicate a larger non-Hispanic Asian share. |
| pct_black_nh | float64 · percent (0–100) | Share of total population identifying as Black or African American alone, non-Hispanic. Higher values indicate a larger non-Hispanic Black share. |
| pct_hispanic | float64 · percent (0–100) | Share of total population identifying as Hispanic or Latino of any race. Higher values indicate a larger Hispanic share. |
| pct_multiracial_nh | float64 · percent (0–100) | Share of total population identifying as two or more races, non-Hispanic. Higher values indicate a larger multiracial share. |
| pct_nhpi_nh | float64 · percent (0–100) | Share of total population identifying as Native Hawaiian and Other Pacific Islander alone, non-Hispanic. Higher values indicate a larger non-Hispanic NHPI share. |
| pct_white_nh | float64 · percent (0–100) | Share of total population identifying as White alone, non-Hispanic (ACS race iteration A2). Higher values indicate a larger non-Hispanic White share. |
| pop_65_plus | float64 · count | Number of residents aged 65 and older. Higher values indicate a larger senior population. |
| racial_diversity_index | float64 · index (0–1) | Diversity index giving the probability that two randomly chosen residents belong to different race/ethnicity groups, computed as 1 − Σ(group share²) across the non-Hispanic race groups and Hispanic. Higher values indicate greater racial/ethnic diversity. |
| state_idkey | string | 2-character FIPS code identifying the state.Part of primary key. Joins dim.states on state_id. |
| total_population | float64 · count | Total resident population of the county from the ACS 5-year 2024 estimate (table B01001). Higher values indicate a larger population. |
| yearkey | int64 | Reference year of the observation.Part of primary key. |
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 shares (pct_white_nh, pct_black_nh, pct_hispanic, etc.) and racial_diversity_index from Decennial 2020 DHC and PEP.
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 shares carry Decennial 2020 DHC differential-privacy noise in small counties; 5-year ACS windows make year-over-year deltas non-independent.