Population by Age Group (ACS)

How many people live in each Georgia community, broken down into six age groups - 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: 44031e6060a3

Niveles de detalle disponibles

EstadoCondado · predeterminadoDistrito

Resumen

Population counts by age group from the American Community Survey 5-year estimates (detailed table B01001, Sex by Age), for Georgia at state, county, school district, and census tract geography, vintages 2020-2024. The 46 sex-by-age cells are collapsed into six school-age-aware brackets (summed over sex - no sex split is served) that are mutually exclusive and sum exactly to the total.

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

Métrica clave

population_count — Population Count (count)

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.
`age_bracket`Age Bracket	string	—	—	no	Age group, collapsed from the B01001 sex-by-age cells (summed over sex): under_5, 5_17 (school age), 18_24, 25_44, 45_64, 65_plus; 'all' is the total population. The six brackets are mutually exclusive and sum exactly to 'all'. Descripción completa▾ Age group, collapsed from the B01001 sex-by-age cells (summed over sex): under_5, 5_17 (school age), 18_24, 25_44, 45_64, 65_plus; 'all' is the total population. The six brackets are mutually exclusive and sum exactly to 'all'. 7 valores permitidos▾ `18_24` `25_44` `45_64` `5_17` `65_plus` `all — total / agregado` `under_5`
`population_count`Population Count	integer	count	—	yes	Estimated residents in the age group. Descripción completa▾ ACS 5-year estimate of the number of residents in the age bracket: the sum of the bracket's male + female B01001 cells ('all' is the published total). Survey estimate, not a full count - see population_count_moe.
`population_count_moe`Population Count Moe	number	count	—	yes	90 percent margin of error for population_count. For collapsed brackets this is the Census sqrt-sum-of-squares approximation over member-cell MOEs (non-integer float, not rounded); the 'all' row carries the published MOE directly. Never the headline metric. Descripción completa▾ 90 percent margin of error for population_count. For collapsed brackets this is the Census sqrt-sum-of-squares approximation over member-cell MOEs (non-integer float, not rounded); the 'all' row carries the published MOE directly. 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
`age_bracket`	categorical	7 valores permitidos▾ `18_24` `25_44` `45_64` `5_17` `65_plus` `all` `under_5`	valores múltiples, enum validado
`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/population_by_age"

counties data for 2024

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

Filtered to age_bracket = 18_24 for 2024

curl "https://georgiacivicdata.org/api/v1/census/population_by_age?year=2024&age_bracket=18_24"

One district (code 660), 2024

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

One county (FIPS 13121), 2024

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

Download 2024 as CSV

curl "https://georgiacivicdata.org/api/v1/census/population_by_age?year=2024&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

Age brackets are collapsed from the B01001 sex-by-age cells summed over sex - no sex split is served. The six non-'all' brackets are mutually exclusive and sum exactly to the 'all' row. Bracket margins of error are the Census sqrt-sum-of-squares approximation over member-cell MOEs (non-integer, served as a float; the 'all' row carries the published MOE directly). A NULL population_count_moe next to a present estimate means a controlled estimate (fixed to official population totals, no sampling error published; annotation -555555555 in the source) - either the 'all' row's own MOE or a bracket with at least one controlled member cell. 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.