Years of Life Lost Before 75 by Census Tract

Years of potential life lost before age 75 in each Georgia census tract, all causes, 5-year totals from 2001-2005 to 2021-2025 (not rates).

Fuente: Georgia Department of Public Health, Office of Health Indicators for Planning (OHIP): OASIS (Online Analytical Statistical Information System) Mapping Tool, mortality map, Years of Potential Life Lost (YPLL) 75 (Deaths read only for the small-cell mask) by census tract of residence, 5-Year Aggregates, Save Data export (all causes, races, ethnicities, sexes and ages), retrieved 2026-10-24. Definitions: https://oasis.state.ga.us/gis/TrendableMaps/content/DefTrendMapMort.html
Cobertura de años: 2005–2025
Actualización: every 5 years (one new window)
Versión: 1.0.0
Hash del esquema: 103478682b04

Niveles de detalle disponibles

Resumen

Years of potential life lost before age 75 (YPLL 75) by Georgia residents, all causes, for each of Georgia's 2,796 census tracts (2020 boundaries) of residence, in 5-year windows from 2001-2005 to 2021-2025, from the Georgia Department of Public Health's OASIS Mapping Tool: each death before 75 adds 75 minus the age at death. Totals, not rates; NULL where a tract had fewer than 5 deaths in a window, and in one more tract (5 or more deaths) of some counties to shield the masked tracts from county totals.

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

Métrica clave

num_ypll_75 — Years of Potential Life Lost Before 75 (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	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`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). Se une a counties; agrega sus columnas de etiqueta.
`tract_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. Se une a tracts; agrega sus columnas de etiqueta.
`num_ypll_75`Years of Potential Life Lost Before 75	number	count	—	yes	Years of life lost to deaths before age 75 in the tract over the 5-year window (a total, not a rate). Descripción completa▾ Years of potential life lost before age 75 (YPLL 75), as OASIS publishes it: for each death of a tract resident before 75 in the window, 75 minus the age at death counted at the middle of the year of age (74.5 for an infant death), summed over the window's deaths from all causes. Half-year values; a total, not a rate. NULL where the tract had fewer than 5 deaths in the window (our small-cell mask), and in one more tract (5 or more deaths) of some counties, our complementary suppression to shield the masked tracts from county totals.

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/premature_death_ypll_tract"

tracts data for 2025

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

Download 2025 as CSV

curl "https://georgiacivicdata.org/api/v1/health/premature_death_ypll_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

Years of potential life lost before age 75 (YPLL 75), summed over a 5-year window for each census tract's residents: a total, not a rate, so tracts with more people show more years lost. YPLL is NULL wherever the tract had fewer than 5 deaths in the window and in one more tract (5 or more deaths) of some counties, to shield them from county totals (our masks, 24-36 tracts per window); tracts no longer add up to Georgia. For YPLL rates, use the county topic premature_death_ypll_nchs_rankable. Each death before 75 adds 75 minus the age at death, counted at the middle of the year of age (74.5 years for an infant death), so values end in .0 or .5; deaths at 75 or older add nothing. Each row covers a fixed 5-year window (2001-2005 to 2021-2025; year is its end year), summed over the five years, not one year. The windows share no years, but a tract's total can change between windows because its population grew, shrank or aged, not only because early deaths became more or less common. Tract rows only: no county or Georgia rows. The mask is the platform's: OASIS publishes YPLL for tracts with 1-4 deaths, where it can reveal one person's age at death. Before the mask the tracts add up exactly to OASIS's Georgia YPLL 75; no state figure or residual that would reveal the masked tracts is stored. 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. Deaths are placed by the tract of residence as OASIS geocodes it, not where the death happened. 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). The 12 tracts with no 2020 residents (water and special-use areas) still hold the deaths OASIS placed in them; YPLL is shown where they had 5 or more deaths (1 tract in 2001-2005, 2 tracts in 2006-2010, 1 tract in 2011-2015). OASIS publishes no tract rates (no tract population either), so a raw count is not comparable across tracts of different sizes. All causes, all ages, races and sexes: the tract export is served at the Mapping Tool's defaults, with no breakdown. Not comparable head to head with the county YPLL topics, which are single years by cause, with rates. 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.