scorecard_county
One row per US county. 13 of 18 education spec metrics live. Sources: ACS B15003 attainment, Stanford SEDA v6 test scores, College Scorecard outcomes, NCES F-33 district aggregates. Stubs: grad_rate (EDFacts pending), composite index.
tier bcomposite_index
overview
overview
All 3,222 US counties. SEDA-derived metrics cover ~98% of counties; small-county SEDA values can be missing.
current vintage — SEDA 2018; CCD SY2024-25; ACS 2020-2024; Opportunity Insights cohorts to 1991
history — Snapshot only; rebuilt per vintage
provenance
source & licensing
authority
Multiple - see education_ tables
dataset
NCES CCD + SEDA + Opportunity Insights + ACS
license
Mixed: NCES public domain; SEDA Creative Commons; Opportunity Insights research-use
citation
NCES CCD + Stanford Education Data Archive (SEDA) + Opportunity Insights College Mobility + ACS 5-Year 2020-2024.
schema
fields
| name | type | definition |
|---|---|---|
| acs_data_year | int64 | Reference year of the American Community Survey (ACS) data used for adult educational attainment columns in this row. |
| college_enrollment_rate_18_24 | float64 · percent (0–100) | Share of residents aged 18–24 enrolled in college, from ACS. Higher values indicate greater youth post-secondary participation in the county. |
| college_enrollment_rate_18_24_national_pctile | float64 · percentile (0–100) | National percentile rank of the county's college enrollment rate for 18–24 year olds among all US counties. Higher values indicate greater youth college participation relative to counties nationwide. |
| college_enrollment_rate_18_24_state_pctile | float64 · percentile (0–100) | Within-state percentile rank of the county's college enrollment rate for 18–24 year olds among counties in the same state. Higher values indicate greater youth college participation relative to in-state peers. |
| 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. |
| enrollment_per_1k_pop | float64 · count | Number of K–12 public school students enrolled per 1,000 county residents. Higher values reflect a larger school-age population relative to total county population. |
| grad_rate | float64 · percent (0–100) | Four-year adjusted cohort graduation rate for all students in county public high schools. Higher values indicate a greater share of students completing high school on time. |
| grad_rate_econ_disadvantaged | float64 · percent (0–100) | Four-year adjusted cohort graduation rate for economically disadvantaged students in county public high schools. Higher values indicate stronger on-time graduation outcomes for this subgroup. |
| mean_test_score | float64 · standard deviations | Average K–12 student academic achievement score for the county expressed in standard deviation units relative to the national grade-level mean, from SEDA. Higher values indicate above-average student proficiency. |
| mean_test_score_national_pctile | float64 · percentile (0–100) | National percentile rank of the county's mean_test_score among all US counties. Higher values indicate above-average K–12 student achievement relative to counties nationwide. |
| mean_test_score_state_pctile | float64 · percentile (0–100) | Within-state percentile rank of the county's mean_test_score among counties in the same state. Higher values indicate above-average K–12 student achievement relative to peers in the same state. |
| median_earnings_10yr_post_entry | float64 · dollars (nominal) | Median annual earnings of workers 10 years after first enrolling in a college or university, aggregated to the county level from the College Scorecard. Higher values indicate stronger post-college labor market outcomes for county residents. |
| median_earnings_10yr_post_entry_national_pctile | float64 · percentile (0–100) | National percentile rank of the county's median_earnings_10yr_post_entry value among all US counties. Higher values indicate stronger post-college earnings outcomes relative to counties nationwide. |
| median_earnings_10yr_post_entry_state_pctile | float64 · percentile (0–100) | Within-state percentile rank of the county's median_earnings_10yr_post_entry value among counties in the same state. Higher values indicate stronger post-college earnings outcomes relative to in-state peers. |
| n_districts | int64 · count | Number of K–12 school districts operating within the county. Higher values reflect more fragmented or larger local education governance structures. |
| pct_adults_hs_or_higher | float64 · percent (0–100) | Share of adults aged 25 and older who have completed at least a high school diploma or equivalent, from ACS. Higher values reflect greater baseline educational attainment. |
| pct_adults_some_college_or_higher | float64 · percent (0–100) | Share of adults aged 25 and older who have completed at least some college coursework, from ACS. Higher values indicate greater access to or participation in post-secondary education. |
| pct_bachelors_plus | float64 · percent (0–100) | Share of adults aged 25 and older who hold at least a bachelor's degree, from ACS. Higher values indicate a more highly educated adult population. |
| pct_bachelors_plus_national_pctile | float64 · percentile (0–100) | National percentile rank of the county's pct_bachelors_plus value among all US counties. A value of 90 means the county's bachelor's attainment rate exceeds 90% of all counties nationally. |
| pct_bachelors_plus_state_pctile | float64 · percentile (0–100) | Within-state percentile rank of the county's pct_bachelors_plus value among counties in the same state. A value of 90 means the county's bachelor's attainment rate exceeds 90% of counties in its state. |
| pct_charter_schools | float64 · percent (0–100) | Share of public schools in the county that are charter schools. Higher values indicate greater prevalence of charter school alternatives within the local public school system. |
| pct_graduate_plus | float64 · percent (0–100) | Share of adults aged 25 and older who hold a graduate or professional degree, from ACS. Higher values indicate a county with greater concentrations of advanced degree holders. |
| pct_graduate_plus_national_pctile | float64 · percentile (0–100) | National percentile rank of the county's pct_graduate_plus value among all US counties. Higher values indicate the county ranks near the top nationally for graduate degree attainment. |
| pct_graduate_plus_state_pctile | float64 · percentile (0–100) | Within-state percentile rank of the county's pct_graduate_plus value among counties in the same state. Higher values indicate the county ranks near the top within its state for graduate degree attainment. |
| pct_high_pell_grant_students | float64 · percent (0–100) | Share of undergraduates at institutions in the county who receive federal Pell grants, from the College Scorecard. Higher values indicate that local institutions serve a greater proportion of low-income students. |
| seda_data_year | int64 | Reference year of the Stanford Education Data Archive (SEDA) data used for K–12 test score columns in this row. |
| state_id | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| test_score_gap_non_ecd_ecd | float64 · standard deviations | Difference in mean test scores between non-economically disadvantaged and economically disadvantaged students in the county, from SEDA, in grade-level standard deviation units. Larger positive values indicate greater socioeconomic achievement disparities. |
| test_score_gap_non_ecd_ecd_national_pctile | float64 · percentile (0–100) | National percentile rank of the county's non-ECD vs. ECD test score gap among all US counties. Higher values indicate a larger socioeconomic achievement gap relative to other counties nationally. |
| test_score_gap_non_ecd_ecd_state_pctile | float64 · percentile (0–100) | Within-state percentile rank of the county's non-ECD vs. ECD test score gap among counties in the same state. Higher values indicate a larger socioeconomic achievement gap relative to in-state peers. |
| test_score_gap_white_black | float64 · standard deviations | Difference in mean test scores between white and Black students in the county, from SEDA, in grade-level standard deviation units. Larger positive values indicate greater racial achievement disparities. |
| test_score_gap_white_black_national_pctile | float64 · percentile (0–100) | National percentile rank of the county's white–Black test score gap among all US counties. Higher values indicate a larger racial achievement gap relative to other counties nationally. |
| test_score_gap_white_black_state_pctile | float64 · percentile (0–100) | Within-state percentile rank of the county's white–Black test score gap among counties in the same state. Higher values indicate a larger racial achievement gap relative to in-state peers. |
relationships
joins
primary key
county_id
common joins
dim.geographies on county_id
demographics_scorecard_county on county_id
economy_scorecard_county on county_id
usage
how to use this table
method
Materialized join of district-level metrics rolled to county weighted by enrollment, plus county-level ACS attainment and Opportunity Insights mobility.
do not use for
Time series analysis (snapshot); within-district equity (LEA grain); current-year college mobility (Opportunity Insights cohorts dated).
known issues
SEDA latest is 2018 (year 8 of release schedule). Mixed vintages in scorecard.
last updated · May 5, 2026