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.
- 2005–2025
- annual
- 1.0.0
- eb1659b231fe
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.
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.
| Columna | Tipo | Unidad | Rango | ¿Nulo? | Descripción |
|---|---|---|---|---|---|
year | integer | — | — | no | 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.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_fips | string | — | — | yes | Always 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). |
tract_geoid | string | — | — | yes | 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.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. |
num_deaths | integer | — | yes | Deaths of residents, all causes, in the 5-year windowDescripció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_death | number | 0–120 | yes | Average age at death of the tract's residents who died in the window; reflects the tract's age mix, not life expectancyDescripció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ámetro | Tipo | Valores permitidos | Notas |
|---|---|---|---|
year | year_exact | cualquier valor | — |
year_min | year_range | cualquier valor | — |
year_max | year_range | cualquier valor | — |
detail | detail | tracts | enum validado, predeterminado: tracts |
county_fips | foreign_key | cualquier valor | valores múltiples |
tract_geoid | foreign_key | cualquier valor | valores 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.