{"main_topic":"census","sub_topic":"acs","topic":"educational_attainment_by_nativity","key":"census/acs/educational_attainment_by_nativity","version":"1.0.0","year_min":2020,"year_max":2024,"year_gaps":[],"update_frequency":"annual","detail_levels":["counties","districts","states","tracts"],"default_detail":"counties","path_template":"census/educational_attainment_by_nativity/year={year}/{detail}.parquet","grain":["year","county_fips","district_code","tract_geoid","place_of_birth","attainment_level"],"title":"Educational Attainment by Place of Birth (ACS)","summary":"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.","description":"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.","source":"U.S. Census Bureau, American Community Survey 5-Year Estimates","source_url":"https://data.census.gov/table/ACSDT5Y2024.B06009?g=040XX00US13","endpoint":"/api/v1/census/educational_attainment_by_nativity","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"ACS 5-year vintage END year: 2024 covers the pooled 2020-2024 survey period. Consecutive vintages overlap.","valid_values":null,"example":2024,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"county_fips","type":"string","role":"fk_county","nullable":true,"label":"County FIPS","short_description":"","description":"5-digit county FIPS code (state 13 + county). Populated only on county-level rows.","valid_values":null,"example":"13135","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"district_code","type":"string","role":"fk_district","nullable":true,"label":"District Code","short_description":"","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.","valid_values":null,"example":"667","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"tract_geoid","type":"string","role":"fk_tract","nullable":true,"label":"Tract GEOID","short_description":"","description":"11-digit census tract GEOID (2020 boundaries). Populated only on tract-level rows.","valid_values":null,"example":"13135050440","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"place_of_birth","type":"string","role":"categorical","nullable":false,"label":"Place of Birth","short_description":"Where adults 25+ were born: Georgia, another state, abroad as a citizen, or abroad as a foreign national.","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.","valid_values":["all","born_in_state","born_other_state","native_born_abroad","foreign_born"],"example":"foreign_born","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"attainment_level","type":"string","role":"categorical","nullable":false,"label":"Attainment Level","short_description":"Highest education level of adults 25+, in five bands.","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.","valid_values":["less_than_hs","hs_grad","some_college_or_associate","bachelors","graduate"],"example":"bachelors","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"attainment_rate","type":"number","role":"metric","nullable":true,"label":"Attainment Rate","short_description":"Share of the place-of-birth group's adults 25+ at this education level.","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.","valid_values":null,"example":0.2144,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"attainment_rate_moe","type":"number","role":"metric","nullable":true,"label":"Attainment Rate Moe","short_description":"","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.","valid_values":null,"example":null,"unit":"proportion","value_min":null,"value_max":null,"null_meaning":"No margin derivable: the group has no adults 25+, a component margin was not published (the controlled grand total for Clarke County / Clarke County School District, 2022-2024, on place_of_birth 'all' rows), or the derived margin exceeded 1.0 (degenerate small-sample cell; a 0 or 100 percent rate's model margin exceeds 1.0 only on a group of 12 adults or fewer).","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_in_attainment_level","type":"integer","role":"metric","nullable":true,"label":"Number in Attainment Level","short_description":"","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.","valid_values":null,"example":227263,"unit":"count","value_min":null,"value_max":null,"null_meaning":"NULL means the Census published an annotation code instead of an estimate for this cell; no level count is masked in vintages 2020-2024.","key_metric_grain_contributor":false,"metric_component":"numerator"},{"name":"num_in_attainment_level_moe","type":"integer","role":"metric","nullable":true,"label":"Number in Attainment Level Moe","short_description":"","description":"90 percent margin of error for num_in_attainment_level, as published (integer). Never the headline metric.","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Controlled estimate or annotation code in the source; every level margin is published in vintages 2020-2024.","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_adults_25_plus","type":"integer","role":"metric","nullable":true,"label":"Number Adults 25 Plus","short_description":"","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.","valid_values":null,"example":1059942,"unit":"count","value_min":null,"value_max":null,"null_meaning":"NULL means the Census published an annotation code instead of an estimate for the group total; none is masked in vintages 2020-2024.","key_metric_grain_contributor":false,"metric_component":"denominator"},{"name":"num_adults_25_plus_moe","type":"integer","role":"metric","nullable":true,"label":"Number Adults 25 Plus Moe","short_description":"","description":"90 percent margin of error for num_adults_25_plus, as published (integer). Never the headline metric.","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":"Controlled estimate: the grand total (place_of_birth 'all') is fixed to official population estimates for Clarke County and Clarke County School District in 2022-2024, so the Census publishes no sampling error (annotation -555555555 in the source). Every place-of-birth subtotal margin is published.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"attainment_rate","usage":"Star-schema fact table. Join the districts dimension on district_code; the counties dimension on county_fips; the tracts dimension on tract_geoid. Read directly with DuckDB over Parquet.","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.","null_semantics":{"suppressed_to_null":false,"zero_is_real":true},"available_years":[2020,2021,2022,2023,2024],"schema_hash":"43178600d573756d964e222a815b38fcd4e00e879bc285d93a8f6bc1d317a8c5","tags":["census","u.s. census bureau, american community survey 5-year estimates","educational_attainment_by_nativity"],"granularity_description":"One row per year, county_fips, district_code, tract_geoid, place_of_birth, attainment_level (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2024), counties detail","query":"SELECT * FROM educational_attainment_by_nativity WHERE year = 2024 LIMIT 100"},{"description":"District 667 in 2024","query":"SELECT * FROM educational_attainment_by_nativity WHERE district_code = '667' AND year = 2024 LIMIT 100"},{"description":"Filter by place_of_birth = foreign_born","query":"SELECT * FROM educational_attainment_by_nativity WHERE place_of_birth = 'foreign_born' AND year = 2024 LIMIT 100"}],"foreign_keys":[{"column":"county_fips","target_object":"counties","target_columns":["county_fips"],"attribute_columns_added":["county_name"],"scope":"global"},{"column":"district_code","target_object":"districts","target_columns":["district_code"],"attribute_columns_added":["district_name","district_census_id","district_type"],"scope":"domain"},{"column":"tract_geoid","target_object":"tracts","target_columns":["tract_geoid"],"attribute_columns_added":["tract_name"],"scope":"global"}],"filters":[{"param":"year","kind":"year_exact","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_min","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_max","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"detail","kind":"detail","type":"string","multi_value":false,"enum_enforced":true,"values":["counties","districts","states","tracts"],"default":"counties"},{"param":"district_code","kind":"foreign_key","column":"district_code","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"county_fips","kind":"foreign_key","column":"county_fips","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"tract_geoid","kind":"foreign_key","column":"tract_geoid","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"place_of_birth","kind":"categorical","column":"place_of_birth","type":"string","multi_value":true,"enum_enforced":true,"values":["all","born_in_state","born_other_state","native_born_abroad","foreign_born"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"attainment_level","kind":"categorical","column":"attainment_level","type":"string","multi_value":true,"enum_enforced":true,"values":["less_than_hs","hs_grad","some_college_or_associate","bachelors","graduate"],"has_total":false,"total_value":null,"requires_single_value":true,"nullable":false,"null_filter_token":null},{"param":"district_type","kind":"dimension_attribute","dimension":"districts","column":"district_type","type":"string","multi_value":true,"enum_enforced":true,"values":["commission_charter","resa","standard","state_agency","state_charter","state_school","state_special"]}],"filter_hints":[],"values_endpoint":"/api/v1/census/educational_attainment_by_nativity/values"}