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.
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
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. |
| edu_bachelors | int64 · persons | Count of persons aged 25+ whose highest educational attainment is a bachelor's degree. |
| edu_doctorate | int64 · persons | Count of persons aged 25+ whose highest educational attainment is a doctorate degree. |
| edu_masters | int64 · persons | Count of persons aged 25+ whose highest educational attainment is a master's degree. |
| edu_professional | int64 · persons | Count of persons aged 25+ whose highest educational attainment is a professional school degree (e.g., MD, JD, DDS). |
| pct_advanced_professional | float64 · percent (0–100) | Share of the population aged 25+ holding an advanced professional or doctorate degree, computed as (edu_professional + edu_doctorate) / total_pop × 100. Higher values indicate greater attainment of advanced credentials. |
| pct_bachelors_plus | float64 · percent (0–100) | Share of the population aged 25+ holding a bachelor's degree or higher, computed as (edu_bachelors + edu_masters + edu_professional + edu_doctorate) / total_pop × 100. Higher values indicate greater educational attainment. |
| pct_graduate_degree | float64 · percent (0–100) | Share of the population aged 25+ holding a graduate or professional degree, computed as (edu_masters + edu_professional + edu_doctorate) / total_pop × 100. Higher values indicate greater educational attainment. |
| state_idkey | string | 2-character FIPS code identifying the state.Part of primary key. Joins dim.states on state_id. |
| total_pop | int64 · persons | Population aged 25 and over, the universe for ACS educational attainment estimates (5-year, 2019–2024). |
| yearkey | int64 | Reference year of the observation.Part of primary key. |
joins
how to use this table
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.
Sub-county tract-level analysis; single-year change in counties <65k (5-year windows are smoothed); precise comparison across overlapping vintages.
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.