School Zone Household Income
What households living in each Georgia public school's attendance zone earn: median and mean household income, all households.
- 2027–2027
- as zones change and each December (new ACS 5-year release)
- 1.0.0
- ead1d3d8f3fc
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.
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.
| Columna | Tipo | Unidad | Rango | ¿Nulo? | Descripción |
|---|---|---|---|---|---|
year | integer | — | — | no | 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.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_code | string | — | — | no | GOSA district code (FK to the districts dimension).Descripción completa▾GOSA district code (FK to the districts dimension). |
school_code | string | — | — | no | 4-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. |
zone_level | string | — | — | no | Elementary, 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▾
|
num_households | integer | — | no | 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.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_moe | integer | — | no | 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.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_income | integer | — | yes | Median 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_moe | integer | — | yes | 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.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_income | integer | — | yes | 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).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_moe | integer | — | yes | 90 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_source | string | — | — | no | Where 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▾
|
zone_differs_by_grade | boolean | — | — | no | 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.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ámetro | Tipo | Valores permitidos | Notas |
|---|---|---|---|
year | year_exact | cualquier valor | — |
year_min | year_range | cualquier valor | — |
year_max | year_range | cualquier valor | — |
detail | detail | schools | enum validado, predeterminado: schools |
district_code | foreign_key | cualquier valor | valores múltiples |
school_code | foreign_key | cualquier valor | valores múltiples |
zone_level | categorical | elementarymiddlehigh | valores múltiples, enum validado, elige uno |
estimate_source | categorical | school_districtcountyblock_groups | valores múltiples, enum validado |
zone_differs_by_grade | categorical | cualquier valor | valores múltiples |
district_type | dimension_attribute | 7 valores permitidos▾
| valores múltiples, enum validado |
school_level | dimension_attribute | elementarymiddlehighk12other | valores múltiples, enum validado |
locale | dimension_attribute | citysuburbtownrural | valores 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.