Educational Attainment (ACS)

The share of each Georgia community's adults 25 and over at each education level, from less than high school to a graduate degree - American Community Survey 5-year estimates down to the census-tract level.

Fuente: U.S. Census Bureau, American Community Survey 5-Year Estimates
Cobertura de años: 2020–2024
Actualización: annual
Versión: 1.0.0
Hash del esquema: 62385068845d

Niveles de detalle disponibles

EstadoCondado · predeterminadoDistrito

Resumen

Educational attainment from the American Community Survey 5-year estimates (detailed table B15003, Educational Attainment for the Population 25 Years and Over), for Georgia at state, county, school district, and census tract geography, vintages 2020-2024. The 24 detailed attainment cells are collapsed into six levels (less than high school through graduate/professional degree); each row carries the level's share of adults 25 and over, the underlying counts, and 90 percent margins of error.

Granularidad de fila: Una fila por year, county_fips, district_code, tract_geoid, attainment_level.

Métrica clave

attainment_rate — Attainment Rate (proportion)

El valor principal que la mayoría de las consultas busca.

Esquema JSON →Contrato de datos (YAML) →

Variables

Todas las columnas de la tabla de hechos. El código es el nombre exacto del campo que devuelve la API.

Columna	Tipo	Unidad	Rango	¿Nulo?	Descripción
`year`Year	integer	—	—	no	ACS 5-year vintage END year: 2024 covers the pooled 2020-2024 survey period. Consecutive vintages overlap. Descripción completa▾ ACS 5-year vintage END year: 2024 covers the pooled 2020-2024 survey period. Consecutive vintages overlap.
`county_fips`County FIPS	string	—	—	yes	5-digit county FIPS code (state 13 + county). Populated only on county-level rows. Descripción completa▾ 5-digit county FIPS code (state 13 + county). Populated only on county-level rows. Se une a counties; agrega sus columnas de etiqueta.
`district_code`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. Descripción completa▾ 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. Se une a districts; agrega sus columnas de etiqueta.
`tract_geoid`Tract GEOID	string	—	—	yes	11-digit census tract GEOID (2020 boundaries). Populated only on tract-level rows. Descripción completa▾ 11-digit census tract GEOID (2020 boundaries). Populated only on tract-level rows. Se une a tracts; agrega sus columnas de etiqueta.
`attainment_level`Attainment Level	string	—	—	no	Highest education level attained, collapsed from the 24 B15003 cells: less_than_hs (no diploma), hs_grad (regular diploma or GED/alternative credential), some_college (no degree), associate, bachelors, graduate (master's, professional, or doctorate). The six levels are mutually exclusive and partition the 25+ universe exactly - there is no 'all' row. Descripción completa▾ Highest education level attained, collapsed from the 24 B15003 cells: less_than_hs (no diploma), hs_grad (regular diploma or GED/alternative credential), some_college (no degree), associate, bachelors, graduate (master's, professional, or doctorate). The six levels are mutually exclusive and partition the 25+ universe exactly - there is no 'all' row. 6 valores permitidos▾ `associate` `bachelors` `graduate` `hs_grad` `less_than_hs` `some_college`
`attainment_rate`Attainment Rate	number	proportion	—	yes	Share of adults 25+ at this education level. Descripción completa▾ Adults 25 and over whose highest attainment falls in this level, as a share of all adults 25 and over (0-1), derived as num_in_attainment_level / num_adults_25_plus. NULL when the geography's 25+ population estimate is 0 (no one sampled - not proof there are none). A geography's six shares sum to 1.
`attainment_rate_moe`Attainment Rate Moe	number	proportion	—	yes	90 percent margin of error for attainment_rate, derived from the component margins with the Census ratio formula. 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. Descripción completa▾ 90 percent margin of error for attainment_rate, derived from the component margins with the Census ratio formula. 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`Number in Attainment Level	integer	count	—	yes	Adults 25 and over whose highest attainment falls in this level (ACS estimate; sum of the level's B15003 member cells) - the rate's numerator. Descripción completa▾ Adults 25 and over whose highest attainment falls in this level (ACS estimate; sum of the level's B15003 member cells) - the rate's numerator.
`num_in_attainment_level_moe`Number in Attainment Level Moe	number	count	—	yes	90 percent margin of error for num_in_attainment_level: the Census sqrt-sum-of-squares approximation over the level's member-cell MOEs, counting only the largest margin among cells estimated at zero (stored as Float64 and never rounded; integral for the single-cell associate and bachelors levels, where it is the published margin). Never the headline metric. Descripción completa▾ 90 percent margin of error for num_in_attainment_level: the Census sqrt-sum-of-squares approximation over the level's member-cell MOEs, counting only the largest margin among cells estimated at zero (stored as Float64 and never rounded; integral for the single-cell associate and bachelors levels, where it is the published margin). Never the headline metric.
`num_adults_25_plus`Number Adults 25 Plus	integer	count	—	yes	Total population 25 years and over (ACS estimate, B15003_001) - the rate's denominator, repeated on each of the geography's six attainment rows. Descripción completa▾ Total population 25 years and over (ACS estimate, B15003_001) - the rate's denominator, repeated on each of the geography's six attainment rows.
`num_adults_25_plus_moe`Number Adults 25 Plus Moe	integer	count	—	yes	90 percent margin of error for num_adults_25_plus, as published. Never the headline metric. Descripción completa▾ 90 percent margin of error for num_adults_25_plus, as published. Never the headline metric.

Filtros

Parámetros de consulta que acepta el endpoint de hechos. Los valores separados por comas son OR dentro de un parámetro; varios parámetros se combinan con AND.

Parámetro	Tipo	Valores permitidos	Notas
`year`	year_exact	cualquier valor	—
`year_min`	year_range	cualquier valor	—
`year_max`	year_range	cualquier valor	—
`detail`	detail	`countiesdistrictsstatestracts`	enum validado, predeterminado: counties
`district_code`	foreign_key	cualquier valor	valores múltiples
`county_fips`	foreign_key	cualquier valor	valores múltiples
`tract_geoid`	foreign_key	cualquier valor	valores múltiples
`attainment_level`	categorical	`associatebachelorsgraduatehs_gradless_than_hssome_college`	valores múltiples, enum validado, elige uno
`district_type`	dimension_attribute	7 valores permitidos▾ `commission_charter` `resa` `standard` `state_agency` `state_charter` `state_school` `state_special`	valores múltiples, enum validado

Ejemplos de solicitudes

Ejecútalos contra la URL base: devuelven datos en vivo.

All rows (first page), counties level

curl "https://georgiacivicdata.org/api/v1/census/educational_attainment"

counties data for 2024

curl "https://georgiacivicdata.org/api/v1/census/educational_attainment?year=2024"

Filtered to attainment_level = associate for 2024

curl "https://georgiacivicdata.org/api/v1/census/educational_attainment?year=2024&attainment_level=associate"

One district (code 660), 2024

curl "https://georgiacivicdata.org/api/v1/census/educational_attainment?district_code=660&year=2024&detail=districts"

One county (FIPS 13121), 2024

curl "https://georgiacivicdata.org/api/v1/census/educational_attainment?county_fips=13121&year=2024&detail=counties"

Download 2024 as CSV

curl "https://georgiacivicdata.org/api/v1/census/educational_attainment?year=2024&format=csv"

Notas y limitaciones

Manejo de NULL

Las celdas suprimidas (valores que la fuente oculta, normalmente por un grupo demasiado pequeño para informarlo) son NULL, nunca cero.
El cero es un valor real y reportado.

Limitaciones

Universe: the population 25 years and over - attainment of younger adults is not covered, and each geography's six attainment shares describe adults only. There is no 'all' attainment row; the num_adults_25_plus denominator rides every row instead. hs_grad includes GED and other alternative credentials, not just regular diplomas. For the four multi-cell levels (less_than_hs, hs_grad, some_college, graduate) num_in_attainment_level_moe is the Census sqrt-sum-of-squares approximation over member-cell margins (counting, of the cells estimated at zero, only the largest margin, as the Census advises), not a published margin; for associate and bachelors the level is a single B15003 cell, so the Census's published margin is carried through unchanged. attainment_rate_moe uses the Census ratio formula on the derived share (a 0 or 100 percent share takes the Census's own model margin for such estimates); a degenerate derived margin above 1.0 is set to NULL. 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.