Saltar al contenido
← Todos los conjuntos de datos

School Zone Household Income

What households living in each Georgia public school's attendance zone earn: median and mean household income, all households.

Cobertura de años
2027–2027
Actualización
as zones change and each December (new ACS 5-year release)
Versión
1.0.0
Hash del esquema
ead1d3d8f3fc

Niveles de detalle disponibles

Escuela · predeterminado

Resumen

Household income of all households living in each Georgia public school's attendance zone: estimated households, median household income (the key metric) and mean household income, each with a 90 percent margin of error, from the American Community Survey 2020-2024 5-year estimates (2024 dollars). A zone that is its whole school district carries the Census's own figures for that district (tables B19001, B19013 and B19025), and one that is its whole county the county's (estimate_source). Every other zone is built from block-group estimates (tables B19001 and B19025), placed in the zone by the school_attendance_zone_block_groups crosswalk's 2020 household shares: the zone's income distribution is the weighted sum of its block groups' 16 income brackets, the median is interpolated in it, and the mean is aggregate income over households. One row per school and zone level. year is the school year the zones are in effect for (2027 = 2026-27).

Granularidad de fila: Una fila por year, district_code, school_code, zone_level.

Métrica clave

median_household_income — Median Household Income (currency)

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

Variables

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

ColumnaTipoUnidadRango¿Nulo?Descripción
yearYearinteger——noSchool year the zones are in effect for, as its ending calendar year (2027 = 2026-27). The income is the ACS 2020-2024 5-year estimate, in 2024 dollars.
Descripción completa
School year the zones are in effect for, as its ending calendar year (2027 = 2026-27). The income is the ACS 2020-2024 5-year estimate, in 2024 dollars.
district_codeDistrict Codestring——noGOSA district code (FK to the districts dimension).
Descripción completa
GOSA district code (FK to the districts dimension).

Se une a districts; agrega sus columnas de etiqueta.

school_codeSchool Codestring——no4-digit GOSA school code (composite FK to the schools dimension with district_code): the zone's school.
Descripción completa
4-digit GOSA school code (composite FK to the schools dimension with district_code): the zone's school.

Se une a schools; agrega sus columnas de etiqueta.

zone_levelZone Levelstring——noElementary, middle or high zone.
Descripción completa
The level of the school's zone: elementary, middle or high, as the crosswalk gives it. Most schools have one; a school with zones at two or three levels (a K-8, a 6-12, a K-12 school) has a row for each, and its zones can differ in area. A school drawing a single grade at two levels is counted at the lower one, as on the crosswalk.
3 valores permitidos
  • elementary
  • middle
  • high
num_householdsNumber Householdsintegercount—noEstimated households in the zone (ACS B19001): for a whole-district or whole-county zone, the Census's estimate for the district or county; otherwise each block group's households times the share of its 2020 households living in the zone, added over the zone's block groups, rounded to whole households. Income figures are shown only where this is at least 50.
Descripción completa
Estimated households in the zone (ACS B19001): for a whole-district or whole-county zone, the Census's estimate for the district or county; otherwise each block group's households times the share of its 2020 households living in the zone, added over the zone's block groups, rounded to whole households. Income figures are shown only where this is at least 50.
num_households_moeNumber Households Moeintegercount—no90 percent margin of error of num_households: the published margin for a whole district or county; otherwise the root sum of squares of the block groups' weighted margins (Census zero-cell rule). Never the headline metric.
Descripción completa
90 percent margin of error of num_households: the published margin for a whole district or county; otherwise the root sum of squares of the block groups' weighted margins (Census zero-cell rule). Never the headline metric.
median_household_incomeMedian Household Incomeintegercurrency—yesMedian household income of the zone's households, 2024 dollars.
Descripción completa
Median household income in the past 12 months, 2024 dollars. For a whole-district or whole-county zone, the Census's published median for it (B19013). Otherwise interpolated linearly in the zone's income distribution (the weighted sum of its block groups' 16 B19001 brackets, under $10,000 to $200,000 or more), where 200001 means $200,000 or more: not a Census median, applied to single block groups it lands within about 3% of the published median for half of them.
median_household_income_moeMedian Household Income Moeintegercurrency—yes90 percent margin of error of the median, dollars: the published B19013 margin for a whole district or county. For a block-group median, the Census confidence-interval method for a median from a distribution, with the 50th percentile's standard error derived from the brackets' published margins in place of the Census design factor, and the addition form used when the proportion form's radicand is under a quarter of it (this widens about 1% of margins). Applied to single block groups it runs about 1.06 times the published margin.
Descripción completa
90 percent margin of error of the median, dollars: the published B19013 margin for a whole district or county. For a block-group median, the Census confidence-interval method for a median from a distribution, with the 50th percentile's standard error derived from the brackets' published margins in place of the Census design factor, and the addition form used when the proportion form's radicand is under a quarter of it (this widens about 1% of margins). Applied to single block groups it runs about 1.06 times the published margin.
mean_household_incomeMean Household Incomeintegercurrency—yesMean household income, 2024 dollars: aggregate household income (B19025) over households. For a whole district or county, its published aggregate and households; otherwise both weighted sums over the zone's block groups with a published aggregate (those hold at least 99% of the zone's households wherever a mean is shown).
Descripción completa
Mean household income, 2024 dollars: aggregate household income (B19025) over households. For a whole district or county, its published aggregate and households; otherwise both weighted sums over the zone's block groups with a published aggregate (those hold at least 99% of the zone's households wherever a mean is shown).
mean_household_income_moeMean Household Income Moeintegercurrency—yes90 percent margin of error of the mean, dollars (Census ratio formula; conservative, as it omits the positive covariance of aggregate income and households).
Descripción completa
90 percent margin of error of the mean, dollars (Census ratio formula; conservative, as it omits the positive covariance of aggregate income and households).
estimate_sourceEstimate Sourcestring——noWhere the row's figures come from.
Descripción completa
school_district: the zone is its whole school district (the district's only zone at every grade the school serves at this level), so the row carries the Census's own figures for the district; county: the zone is its whole county but not a whole district (a zone adding an area outside the district's unified outline, as a military base's high school area), so the county's own figures; block_groups: built from the zone's block groups (every other zone).
3 valores permitidos
  • school_district
  • county
  • block_groups
zone_differs_by_gradeZone Differs by Gradeboolean——noTrue when the school's zone at this level is not the same area at every grade it serves (a phased-in rezoning, or a neighbouring school serving only some grades): the row then describes the zone averaged over those grades. False for most zones.
Descripción completa
True when the school's zone at this level is not the same area at every grade it serves (a phased-in rezoning, or a neighbouring school serving only some grades): the row then describes the zone averaged over those grades. False for most zones.

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ámetroTipoValores permitidosNotas
yearyear_exactcualquier valor—
year_minyear_rangecualquier valor—
year_maxyear_rangecualquier valor—
detaildetailschoolsenum validado, predeterminado: schools
district_codeforeign_keycualquier valorvalores múltiples
school_codeforeign_keycualquier valorvalores múltiples
zone_levelcategoricalelementarymiddlehighvalores múltiples, enum validado, elige uno
estimate_sourcecategoricalschool_districtcountyblock_groupsvalores múltiples, enum validado
zone_differs_by_gradecategoricalcualquier valorvalores múltiples
district_typedimension_attribute
7 valores permitidos
  • commission_charter
  • resa
  • standard
  • state_agency
  • state_charter
  • state_school
  • state_special
valores múltiples, enum validado
school_leveldimension_attributeelementarymiddlehighk12othervalores múltiples, enum validado
localedimension_attributecitysuburbtownruralvalores múltiples, enum validado

Ejemplos de solicitudes

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

All rows (first page), schools level

curl "https://georgiacivicdata.org/api/v1/education/school_zone_income"

schools data for 2027

curl "https://georgiacivicdata.org/api/v1/education/school_zone_income?year=2027"

Filtered to zone_level = elementary for 2027

curl "https://georgiacivicdata.org/api/v1/education/school_zone_income?year=2027&zone_level=elementary"

Download 2027 as CSV

curl "https://georgiacivicdata.org/api/v1/education/school_zone_income?year=2027&format=csv"

Notas y limitaciones

Manejo de NULL

  • Las celdas suprimidas (muy pocos estudiantes para reportar) son NULL, nunca cero.
  • El cero es un valor real y reportado.

Limitaciones

A zone that is its whole school district, or its whole county, carries the Census's own published figures for it (estimate_source); the district figures are for the district's boundary in the ACS release. Every other zone's estimates are built from census block groups (the smallest areas the American Community Survey publishes income for), not surveyed in the zone: each block group's households and their income distribution are placed in the zone in proportion to the share of its 2020 census households living there, so a zone that holds part of a block group gets that block group's income mix. All households only: no breakdown by race or other group (the Census publishes none by block group). Income is the ACS 2020-2024 5-year estimate in 2024 dollars, while the zones are those in effect for the 2026-27 school year and the household weights are the 2020 census; a later school year will pair its zones with the newest ACS release, and consecutive releases share most of their sample, so a difference between years is not annual change. A block-group median is interpolated from 16 income brackets (applied to block groups it lands within 3% of the Census's published median for half of them; applied to the whole-district and whole-county zones, within 1.0% of the published median for half of them and 4.1% for nine in ten); a median in the open-ended top bracket is top-coded 200001 ('$200,000 or more'). The mean is NULL where the Census withheld the aggregate income of block groups holding more than 1% of the zone's households. Margins of error (90%) of block-group estimates use the Census approximation formulas and do not include the error of placing block group households in zones. A median or mean whose margin of error exceeds the estimate is withheld (NULL: 1 median and no means). Others remain very uncertain (8 medians with a margin over half the median, 3 means over half the mean): read every figure with its margin. Coverage is the crosswalk's: districts whose zones were collected; a zone's gaps and stale boundaries carry through (see the school_attendance_zones topic). A row averages the zone over its grades where the zone differs by grade (zone_differs_by_grade). Zones are not enrollment: the households are the zone's residents, not the school's students' families.