demographics_education_county_year
ACS 5-year 2019-2024 educational attainment: bachelors+ shares (A3). Tier B. Less-than-bachelors detail and MOE columns blocked on ACS re-pull.
tier —sample_estimate
overview
overview
All 3,222 counties x 6 ACS 5-year vintages (2015-2019 through 2020-2024). 19,303 rows ~= 3,222 x 6.
current vintage — 2020-2024 ACS 5-Year
history — ACS B15003 from 2009-2013 vintage to present; pipeline ingests 2015-2019 forward
provenance
source & licensing
authority
U.S. Census Bureau
dataset
American Community Survey 5-Year Estimates
source url
license
—
citation
U.S. Census Bureau. ACS 5-Year Estimates, Table B15003 (educational attainment for population 25+), 2015-2019 through 2020-2024.
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. |
| edu_associate | int64 · count | Number of adults aged 25+ whose highest educational attainment is an associate's degree (occupational or academic). Higher values indicate more residents with two-year post-secondary credentials. |
| edu_bachelors | int64 · count | Number of adults aged 25+ whose highest educational attainment is a bachelor's degree. Higher values indicate more residents with undergraduate credentials. |
| edu_doctorate | int64 · count | Number of adults aged 25+ whose highest educational attainment is a doctoral degree (e.g., Ph.D., Ed.D.). Higher values indicate more residents with the highest level of academic attainment. |
| edu_hs_diploma | int64 · count | Number of adults aged 25+ whose highest educational attainment is a high school diploma or GED equivalent. Higher values indicate more residents whose education ended at secondary school completion. |
| edu_less_than_hs | int64 · count | Number of adults aged 25+ who did not complete a high school diploma or equivalency credential. Higher values indicate more residents with limited formal schooling. |
| edu_masters | int64 · count | Number of adults aged 25+ whose highest educational attainment is a master's degree. Higher values indicate more residents with graduate-level education. |
| edu_professional | int64 · count | Number of adults aged 25+ whose highest educational attainment is a professional degree (e.g., J.D., M.D., D.D.S.). Higher values indicate more residents with professional credentials. |
| edu_some_college | int64 · count | Number of adults aged 25+ who attended college but did not earn a degree, including those with some college credit but no credential. Higher values indicate more residents with partial post-secondary education. |
| pct_advanced_professional | float64 · percent (0–100) | Share of adults aged 25+ who hold a professional or doctoral degree, calculated as (edu_professional + edu_doctorate) / total_pop × 100. Higher values indicate greater concentration of the most advanced credentialed workers. |
| pct_bachelors_plus | float64 · percent (0–100) | Share of adults aged 25+ who hold a bachelor's degree or higher, calculated as (edu_bachelors + edu_masters + edu_professional + edu_doctorate) / total_pop × 100. Higher values indicate a more highly educated population. |
| pct_bachelors_plus_moe | float64 · percent (0–100) | Margin of error for pct_bachelors_plus at the 90% confidence level, as published by the American Community Survey. Larger values indicate less statistical precision for that county-year estimate. |
| pct_graduate_degree | float64 · percent (0–100) | Share of adults aged 25+ who hold a graduate or professional degree (master's, professional, or doctorate), calculated as (edu_masters + edu_professional + edu_doctorate) / total_pop × 100. Higher values indicate greater prevalence of advanced degree attainment. |
| pct_graduate_degree_moe | float64 · percent (0–100) | Margin of error for pct_graduate_degree at the 90% confidence level, as published by the American Community Survey. Larger values indicate less statistical precision for that county-year estimate. |
| state_id | string | 2-character FIPS code identifying the state.Joins dim.states on state_id. |
| total_pop | int64 · count | Total civilian population aged 25 and older used as the denominator for educational attainment estimates. Higher values indicate a larger adult population base. |
| yearkey | int64 | Reference year of the observation. |
relationships
joins
primary key
county_id, year
common joins
dim.geographies on county_id
demographics_population_county_year on (county_id, year)
economy_household_income_distribution_county_year on (county_id, year)
usage
how to use this table
method
ACS B15003 'population 25 years and over' classified by highest level of school completed. pct_bachelors_plus = (bachelor's + master's + professional + doctorate) / total 25+. MOE columns stubbed pending re-pull.
do not use for
Sub-county tract-level analysis; single-year change in counties <65k (5-year windows are smoothed); precise comparison across overlapping vintages.
known issues
Less-than-bachelors detail and MOE columns blocked on ACS re-pull. Overlapping 5-year windows mean year-over-year deltas are not independent observations.
← previousus_demographics.demographics_decennial_baseline_countynext →us_demographics.demographics_nativity_language_county_year
last updated · May 5, 2026