Saltar al contenido
← Todos los conjuntos de datos

Deaths and Average Age at Death by Census Tract

Deaths of residents and their average age at death for each Georgia census tract, all causes, in 5-year windows 2001-2005 to 2021-2025.

Cobertura de años
2005–2025
Actualización
annual
Versión
1.0.0
Hash del esquema
eb1659b231fe

Niveles de detalle disponibles

Resumen

Deaths of Georgia residents from all causes by 2020 census tract of residence, summed over OASIS's fixed 5-year windows 2001-2005 through 2021-2025, with the average age at death of those deaths, from the Georgia Department of Public Health's OASIS Mapping Tool. Tract rows only; fewer than 5 deaths show as '0-4' (NULL here), one more tract (5 or more deaths) is NULL in some counties to shield the '0-4' tracts from county totals, and no tract rates are published.

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

Métrica clave

avg_age_at_death — Average Age at Death (score, 0–120)

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——noEnd year of the 5-year window the row covers: 2005 = 2001-2005, 2010 = 2006-2010, 2015 = 2011-2015, 2020 = 2016-2020, 2025 = 2021-2025. Consecutive windows share no calendar year. See year_meaning.
Descripción completa
End year of the 5-year window the row covers: 2005 = 2001-2005, 2010 = 2006-2010, 2015 = 2011-2015, 2020 = 2016-2020, 2025 = 2021-2025. Consecutive windows share no calendar year. See year_meaning.
county_fipsCounty FIPSstring——yesAlways NULL: tract rows only. The tracts dimension gives each tract's county (also the first five digits of its GEOID).
Descripción completa
Always NULL: tract rows only. The tracts dimension gives each tract's county (also the first five digits of its GEOID).

Se une a counties; agrega sus columnas de etiqueta.

tract_geoidTract GEOIDstring——yes11-digit 2020 census tract GEOID of the residence of the people who died (FK to the tracts dimension): all 2,796 Georgia tracts in every window, 2001-2005 included.
Descripción completa
11-digit 2020 census tract GEOID of the residence of the people who died (FK to the tracts dimension): all 2,796 Georgia tracts in every window, 2001-2005 included.

Se une a tracts; agrega sus columnas de etiqueta.

num_deathsNumber Deathsintegercount—yesDeaths of residents, all causes, in the 5-year window
Descripción completa
Deaths of the tract's residents from all causes, summed over the 5-year window (OASIS's count; divide by 5 for a yearly average). NULL where OASIS shows '0-4' (fewer than 5, possibly none), and in one more tract (5 or more deaths) of some counties, our complementary suppression to shield the '0-4' tracts from county totals. The deaths avg_age_at_death averages over. No tract population is published, so counts are not comparable across tracts of different sizes.
avg_age_at_deathAverage Age at Deathnumberscore0–120yesAverage age at death of the tract's residents who died in the window; reflects the tract's age mix, not life expectancy
Descripción completa
Average age at death, in years to 0.1, of the tract's residents who died in the window, all causes (OASIS: the sum of the ages at death divided by the number of deaths). It mostly reflects the tract's age structure: a tract of young adults (a military post, a college) averages low, one around a nursing home high. Not life expectancy. NULL where OASIS shows '*' (fewer than 5 deaths), and on the complementary cells (5 or more deaths, our mask; see num_deaths). An average outside 0-120 years would stop the run.

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—
detaildetailtractsenum validado, predeterminado: tracts
county_fipsforeign_keycualquier valorvalores múltiples
tract_geoidforeign_keycualquier valorvalores múltiples

Ejemplos de solicitudes

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

All rows (first page), tracts level

curl "https://georgiacivicdata.org/api/v1/health/deaths_all_causes_tract"

tracts data for 2025

curl "https://georgiacivicdata.org/api/v1/health/deaths_all_causes_tract?year=2025"

Download 2025 as CSV

curl "https://georgiacivicdata.org/api/v1/health/deaths_all_causes_tract?year=2025&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

Deaths of a 2020 census tract's residents from all causes, summed over a fixed 5-year window (year 2025 = 2021-2025), not one year. Average age at death mostly reflects the tract's age mix (young adults, a nursing home), not only its mortality risk; it is not life expectancy. Tract rows only: no county or Georgia rows. Deaths and average age are NULL where OASIS shows '0-4' (under 5 deaths) and in one more tract (5+ deaths) in some counties, to shield '0-4' tracts from county totals. OASIS's own definition says the average age at death is not life expectancy and, for all causes, is heavily influenced by the age distribution of the area. Tract averages run from 12.0 years (7 deaths in a tract of Chattahoochee County, where much of the Fort Benning army post lies, 2021-2025) to 87.8 (308 deaths in a Fulton County tract, 2006-2010). Tracts never add up to a county or Georgia total: the '0-4' cells are left out, and the platform builds no total that would reveal them. '0-4' means 0 to 4, so a NULL does not mean at least one death: 12 of the 15 '0-4' tracts of 2021-2025 had no residents in the 2020 Census (water or special-use areas). OASIS's county deaths and YPLL (the county OASIS topics, summed over a window) equal the sum of the county's tracts, so in each of the 61 county-windows with a '0-4' tract one more tract, with 5 or more deaths, is NULL too (our complementary suppression, the same tract in both tract topics): a NULL can hold 5 or more deaths, and a county total minus the published tracts is never the '0-4' tracts' own total. OASIS shows tract counts under 5 as '0-4' and offers only separate 5-year windows, both for confidentiality. OASIS publishes no tract rates (no tract population either), so a raw count is not comparable across tracts of different sizes. A death rate would need a tract population, our own calculation. The windows share no year, so a tract's five rows are a trend at five-year steps, but tract populations change between windows (some tracts that are populous now had under 5 deaths in 2001-2005), so a change in deaths can reflect growth, a new facility such as a nursing home or prison, or how OASIS placed older records on 2020 tracts. Every window is on 2020 census tracts: OASIS's Mapping Tool has used 2020 tract boundaries since 2023-12-01, for its earlier windows too. OASIS does not say how it placed earlier deaths on 2020 tracts; every count is a whole number, so each death sits in one tract and none is split between tracts (our reading). Deaths are placed by the tract of residence as OASIS geocodes it, not where the death happened. 2025, the newest year of the 2021-2025 window, was added to OASIS on 2026-07-29; OASIS adds a year once its data are closed out and marks no year provisional. Not comparable head to head with the county OASIS topics, which are single years with rates: use health/oasis/deaths_by_cause_nchs_rankable for county and state death rates. county_fips is always NULL: the tracts dimension gives each tract's county.