demographics_scorecard_county
Demographics scorecard: one row per US county, 11 primary metrics across 5 groups (population level, race/ethnicity, education, immigration/language, geographic classification) plus 10 ranking columns (5 metrics × national + state pctile). Live metrics (v1): total_population (PEP 2023), pct_bachelors_plus / pct_graduate_degree (ACS 2019-2024 latest vintage). Null stubs (see README Part 3): race, nativity/language, geographic classification. Will populate as Decennial 2020 DHC, ACS B05001/B16002, and OMB CBSA data loads.
tier —composite_index
overview
overview
All 3,222 US counties. Population from PEP 2023; education from ACS 2020-2024. Several stub columns are NULL pending downstream loads.
current vintage — PEP 2023 + ACS 2020-2024
history — Snapshot only; rebuilt per vintage
provenance
source & licensing
authority
U.S. Census Bureau
dataset
Population Estimates Program + ACS 5-Year Estimates
source url
license
—
citation
U.S. Census Bureau. ACS 5-Year Estimates 2020-2024 + Population Estimates Program Vintage 2023.
schema
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. |
| education_data_year | int64 | Reference year of the underlying education attainment data used to calculate pct_bachelors_plus and pct_graduate_degree, as ACS estimates may differ from the demographic reference year. |
| metro_status | string | Classification of the county by metropolitan or micropolitan statistical area designation (e.g., metro, micro, noncore). Derived from OMB or USDA rural-urban classification schemes. |
| pct_bachelors_plus | float64 · percent (0–100) | Share of the adult population (age 25 and older) with at least a bachelor's degree. Higher values indicate a more highly educated county population. |
| pct_bachelors_plus_national_pctile | float64 · percent (0–100) | Percentile rank of pct_bachelors_plus relative to all U.S. counties. Higher values indicate the county has a more educated population than most counties nationally. |
| pct_bachelors_plus_state_pctile | float64 · percent (0–100) | Percentile rank of pct_bachelors_plus relative to all counties within the same state. Higher values indicate the county has a more educated population than most in-state peers. |
| pct_black_nh | float64 · percent (0–100) | Share of the county population identifying as non-Hispanic Black or African American alone. Higher values indicate a greater proportion of non-Hispanic Black residents. |
| pct_foreign_born | float64 · percent (0–100) | Share of the county population born outside the United States. Higher values indicate a larger immigrant or foreign-born presence. |
| pct_foreign_born_national_pctile | float64 · percent (0–100) | Percentile rank of pct_foreign_born relative to all U.S. counties. Higher values indicate a larger foreign-born share than most counties nationally. |
| pct_foreign_born_state_pctile | float64 · percent (0–100) | Percentile rank of pct_foreign_born relative to all counties within the same state. Higher values indicate a larger foreign-born share than most in-state peers. |
| pct_graduate_degree | float64 · percent (0–100) | Share of the adult population (age 25 and older) with a graduate or professional degree. Higher values indicate a greater concentration of advanced-degree holders. |
| pct_hispanic | float64 · percent (0–100) | Share of the county population identifying as Hispanic or Latino of any race. Higher values indicate a greater proportion of Hispanic residents. |
| pct_hispanic_national_pctile | float64 · percent (0–100) | Percentile rank of pct_hispanic relative to all U.S. counties. Higher values indicate a greater Hispanic population share than most counties nationally. |
| pct_hispanic_state_pctile | float64 · percent (0–100) | Percentile rank of pct_hispanic relative to all counties within the same state. Higher values indicate a greater Hispanic population share than most in-state peers. |
| pct_lep_household | float64 · percent (0–100) | Share of households classified as linguistically isolated, where no member age 14 or older speaks English at least 'very well.' Higher values indicate greater limited English proficiency prevalence. |
| pct_white_nh | float64 · percent (0–100) | Share of the county population identifying as non-Hispanic White alone. Higher values indicate a greater proportion of non-Hispanic White residents. |
| pct_white_nh_national_pctile | float64 · percent (0–100) | Percentile rank of pct_white_nh relative to all U.S. counties. Higher values indicate a greater non-Hispanic White share than most counties nationally. |
| pct_white_nh_state_pctile | float64 · percent (0–100) | Percentile rank of pct_white_nh relative to all counties within the same state. Higher values indicate a greater non-Hispanic White share than most in-state peers. |
| population_change_5yr_pct | float64 · percent (0–100) | Percentage change in total population over the most recent 5-year period. Positive values indicate population growth; negative values indicate decline. |
| racial_diversity_index | float64 · index (0–1) | Probability that two randomly selected residents belong to different racial or ethnic groups, calculated from the shares of each group. Higher values indicate greater racial and ethnic diversity. |
| racial_diversity_index_national_pctile | float64 · percent (0–100) | Percentile rank of racial_diversity_index relative to all U.S. counties. Higher values indicate greater racial and ethnic diversity than most counties nationally. |
| racial_diversity_index_state_pctile | float64 · percent (0–100) | Percentile rank of racial_diversity_index relative to all counties within the same state. Higher values indicate greater racial and ethnic diversity than most in-state peers. |
| state_id | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| total_population | int64 · count | Total resident population of the county. Higher values indicate more populous counties. |
| total_population_national_pctile | float64 · percent (0–100) | Percentile rank of the county's total population relative to all U.S. counties. A value of 90 means the county has a larger population than 90% of all counties nationally. |
| total_population_state_pctile | float64 · percent (0–100) | Percentile rank of the county's total population relative to all counties within the same state. A value of 90 means the county is more populous than 90% of counties in its state. |
relationships
joins
primary key
county_id
common joins
dim.geographies on county_id
economy_scorecard_county on county_id
scorecard_health_county on county_id
usage
how to use this table
method
Materialized from demographics_population_county_year (population) + demographics_education_county_year (latest vintage education). Race, nativity/language, and geographic classification columns are NULL stubs pending Decennial DHC, ACS B05001/B16002, and OMB CBSA loads. Percentile columns computed via PERCENT_RANK() over national and within-state partitions.
do not use for
Time series analysis (snapshot only); racial composition (stub columns); precise tract or ZIP-level work.
known issues
~5 of 11 primary metrics are NULL stubs pending raw loads (race, immigration/language, geographic classification). Population and education are populated.
← previousus_demographics.demographics_population_county_yearnext →us_economy.cost_of_living_family_budget_county_family_type
last updated · May 5, 2026