Georgia Civic DataEducational Attainment by Place of Birth (ACS)
How education levels of adults 25 and over differ between residents born in Georgia, in other states, and abroad - ACS 5-year estimates down to the census tract.
- 2020–2024
- annual
- 1.0.0
- 43178600d573
Overview
Educational attainment by place of birth from the American Community Survey 5-year estimates (detailed table B06009, Place of Birth by Educational Attainment in the United States), for Georgia at state, county, school district, and census tract geography, vintages 2020-2024: the share of adults 25 and over at each of five education levels (less than high school through graduate/professional degree) among those born in Georgia, born in another state, native born abroad, and foreign born, with the underlying counts and 90 percent margins of error.
Row grain: One row per year, county_fips, district_code, tract_geoid, place_of_birth, attainment_level.
attainment_rate — Attainment Rate (proportion)
The single headline value most answers want.
Variables
Every column in the fact table. The code is the exact field name the API returns.
| Column | Type | Unit | Range | Null? | Description |
|---|---|---|---|---|---|
year | integer | — | — | no | ACS 5-year vintage END year: 2024 covers the pooled 2020-2024 survey period. Consecutive vintages overlap.Full description▾ACS 5-year vintage END year: 2024 covers the pooled 2020-2024 survey period. Consecutive vintages overlap. |
county_fips | string | — | — | yes | 5-digit county FIPS code (state 13 + county). Populated only on county-level rows.Full description▾5-digit county FIPS code (state 13 + county). Populated only on county-level rows. |
district_code | string | — | — | yes | GCD school district code (FK to the education districts dimension). Populated only on district-level rows - Census unified-school-district estimates mapped onto the ~180 standard districts via the dimension's district_census_id.Full description▾GCD school district code (FK to the education districts dimension). Populated only on district-level rows - Census unified-school-district estimates mapped onto the ~180 standard districts via the dimension's district_census_id. |
tract_geoid | string | — | — | yes | 11-digit census tract GEOID (2020 boundaries). Populated only on tract-level rows.Full description▾11-digit census tract GEOID (2020 boundaries). Populated only on tract-level rows. |
place_of_birth | string | — | — | no | Where adults 25+ were born: Georgia, another state, abroad as a citizen, or abroad as a foreign national.Full description▾Place of birth. A partition of the total: all = born_in_state + born_other_state + native_born_abroad + foreign_born (the first three together are the native population). 'all' is the total row. 'Born in state' means born in Georgia, the state of residence. In this topic the universe is the population 25 years and over (B06009), and every place_of_birth value is crossed with all five attainment levels; the partition holds on both counts at every level. 5 allowed values▾
|
attainment_level | string | — | — | no | Highest education level of adults 25+, in five bands.Full description▾Highest education level attained, in the five B06009 bands: less_than_hs (no high school diploma), hs_grad (high school graduate, including GED/equivalency), some_college_or_associate (some college with no degree, or an associate's degree), bachelors, graduate (master's, professional, or doctorate). The five levels are mutually exclusive and partition each place-of-birth group's adults 25+ exactly - there is no 'all' row (num_adults_25_plus carries the total). less_than_hs, hs_grad, bachelors, and graduate match the educational_attainment topic's levels; some_college_or_associate equals that topic's some_college + associate combined. 5 allowed values▾
|
attainment_rate | number | — | yes | Share of the place-of-birth group's adults 25+ at this education level.Full description▾Adults 25 and over in the place-of-birth group whose highest attainment falls in this level, as a share of all the group's adults 25 and over (0-1), derived as num_in_attainment_level / num_adults_25_plus. NULL when the group has no adults 25+ in the geography (a true absence, not suppression). A group's five shares sum to 1. | |
attainment_rate_moe | number | — | yes | 90 percent margin of error for attainment_rate, derived from the count margins with the Census ratio formula: the subtraction form, with the Census addition-form fallback whenever the radicand is not positive, so a served margin is always greater than zero; a result above 1.0 is set to NULL as known-bad. A rate of exactly 0 or 1 (0 or 100 percent) instead takes the Census's own model margin for such estimates, 1.645 * sqrt(R * (1 - R) * AW / N) with R = min(2.3 * AW / N, 0.5), N the denominator and AW Georgia's average survey weight for the vintage (18 in 2020, 19 in 2021-2024): the ratio formula would give a 0 percent rate only the zero count's margin over N, about half the width the Census publishes. Never the headline metric.Full description▾90 percent margin of error for attainment_rate, derived from the count margins with the Census ratio formula: the subtraction form, with the Census addition-form fallback whenever the radicand is not positive, so a served margin is always greater than zero; a result above 1.0 is set to NULL as known-bad. A rate of exactly 0 or 1 (0 or 100 percent) instead takes the Census's own model margin for such estimates, 1.645 * sqrt(R * (1 - R) * AW / N) with R = min(2.3 * AW / N, 0.5), N the denominator and AW Georgia's average survey weight for the vintage (18 in 2020, 19 in 2021-2024): the ratio formula would give a 0 percent rate only the zero count's margin over N, about half the width the Census publishes. Never the headline metric. | |
num_in_attainment_level | integer | — | yes | Adults 25 and over in the place-of-birth group whose highest attainment falls in this level (the published B06009 band cell) - the rate's numerator. Published zeros are real.Full description▾Adults 25 and over in the place-of-birth group whose highest attainment falls in this level (the published B06009 band cell) - the rate's numerator. Published zeros are real. | |
num_in_attainment_level_moe | integer | — | yes | 90 percent margin of error for num_in_attainment_level, as published (integer). Never the headline metric.Full description▾90 percent margin of error for num_in_attainment_level, as published (integer). Never the headline metric. | |
num_adults_25_plus | integer | — | yes | Total adults 25 and over in the place-of-birth group (the published B06009 subtotal: 001 for 'all', 007 born in Georgia, 013 born in another state, 019 native born abroad, 025 foreign born) - the rate's denominator, repeated on each of the group's five attainment rows.Full description▾Total adults 25 and over in the place-of-birth group (the published B06009 subtotal: 001 for 'all', 007 born in Georgia, 013 born in another state, 019 native born abroad, 025 foreign born) - the rate's denominator, repeated on each of the group's five attainment rows. | |
num_adults_25_plus_moe | integer | — | yes | 90 percent margin of error for num_adults_25_plus, as published (integer). Never the headline metric.Full description▾90 percent margin of error for num_adults_25_plus, as published (integer). Never the headline metric. |
Filters
Query parameters the fact endpoint accepts. Comma-separated values are OR within a parameter; multiple parameters AND together.
| Parameter | Kind | Allowed values | Notes |
|---|---|---|---|
year | year_exact | any value | — |
year_min | year_range | any value | — |
year_max | year_range | any value | — |
detail | detail | countiesdistrictsstatestracts | enum-enforced, default: counties |
district_code | foreign_key | any value | multi-value |
county_fips | foreign_key | any value | multi-value |
tract_geoid | foreign_key | any value | multi-value |
place_of_birth | categorical | allborn_in_stateborn_other_statenative_born_abroadforeign_born | multi-value, enum-enforced |
attainment_level | categorical | less_than_hshs_gradsome_college_or_associatebachelorsgraduate | multi-value, enum-enforced, pick one |
district_type | dimension_attribute | 7 allowed values▾
| multi-value, enum-enforced |
Example requests
Run these against the base URL — they return live data.
All rows (first page), counties level
curl "https://georgiacivicdata.org/api/v1/census/educational_attainment_by_nativity"counties data for 2024
curl "https://georgiacivicdata.org/api/v1/census/educational_attainment_by_nativity?year=2024"Filtered to place_of_birth = born_in_state for 2024
curl "https://georgiacivicdata.org/api/v1/census/educational_attainment_by_nativity?year=2024&place_of_birth=born_in_state"One district (code 667), 2024
curl "https://georgiacivicdata.org/api/v1/census/educational_attainment_by_nativity?district_code=667&year=2024&detail=districts"One county (FIPS 13135), 2024
curl "https://georgiacivicdata.org/api/v1/census/educational_attainment_by_nativity?county_fips=13135&year=2024&detail=counties"Download 2024 as CSV
curl "https://georgiacivicdata.org/api/v1/census/educational_attainment_by_nativity?year=2024&format=csv"Notes & limitations
NULL handling
- Zero is a real, reported value.
Limitations
Universe: the population 25 years and over - each place-of-birth group's five attainment shares describe its adults 25+ only. There is no 'all' attainment row; the group's 25+ total (num_adults_25_plus) rides every row instead. place_of_birth is a partition: all = born_in_state + born_other_state + native_born_abroad + foreign_born, and 'born in state' means born in Georgia (B06009's 'born in state of residence'). B06009 publishes five attainment bands, not the six of the educational_attainment topic: less_than_hs, hs_grad, bachelors, and graduate are the same bands there, but some_college_or_associate combines that topic's some_college and associate levels and has no single counterpart in it - add those two when comparing. hs_grad includes GED and other equivalency credentials. Published zeros are real estimates, not suppression: small native-born-abroad and foreign-born groups in rural counties and many tracts are 0 with a positive margin, and a NULL attainment_rate means the group has no adults 25+ in the geography (a true absence). Every count and count margin is a published B06009 cell; attainment_rate_moe is derived with the Census ratio formula (addition-form fallback whenever the subtraction form's radicand is not positive, so a served margin is never zero; a 0 or 100 percent rate takes the Census's own model margin for such estimates), and a degenerate small-sample margin above 1.0 is set to NULL. The grand total for Clarke County and Clarke County School District in 2022-2024 is a controlled estimate with no published margin, so num_adults_25_plus_moe and attainment_rate_moe are NULL on those place_of_birth 'all' rows. ACS 5-year period estimates: the year column is the vintage END year and each estimate pools five years of survey responses (2024 = 2020-2024). Consecutive vintages share about 80% of their sample, so the series is heavily smoothed - never difference overlapping vintages as if they were annual change. Estimates are survey-based and carry 90% margins of error (the *_moe columns); tract-level margins can be large relative to the estimate. All levels serve vintages 2020-2024 only, on 2020-vintage tract boundaries. State rows have NULL county_fips, district_code, and tract_geoid; county rows carry only county_fips, district rows only district_code, tract rows only tract_geoid. District rows cover the ~180 standard (city/county) districts only: the Census publishes school-district estimates at unified school district geography, which has no codes for charter schools, RESAs, or state agencies, and its few Census-only districts (e.g. the Fort Stewart military district) have no GCD district code and are dropped.