{"main_topic":"health","sub_topic":"oasis","topic":"premature_death_ypll_tract","key":"health/oasis/premature_death_ypll_tract","version":"1.0.0","year_min":2005,"year_max":2025,"year_gaps":[],"update_frequency":"every 5 years (one new window)","detail_levels":["tracts"],"default_detail":"tracts","path_template":"health/premature_death_ypll_tract/year={year}/{detail}.parquet","grain":["year","county_fips","tract_geoid"],"title":"Years of Life Lost Before 75 by Census Tract","summary":"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).","description":"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.","explorer":false,"search_aliases":{"en":["years of life lost","YPLL","premature deaths","early deaths by neighborhood","dying young","premature mortality","lifespan lost","neighborhood death burden"],"es":["años de vida perdidos","YPLL","muertes prematuras","muertes por vecindario","defunciones prematuras","mortalidad prematura","muerte temprana","morir joven"]},"source":"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","source_url":"https://oasis.state.ga.us/gis/TrendableMaps/agsMortTrend.aspx","endpoint":"/api/v1/health/premature_death_ypll_tract","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"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.","valid_values":null,"example":2025,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"county_fips","type":"string","role":"fk_county","nullable":true,"label":"County FIPS","short_description":"","description":"Always NULL: tract rows only. The tracts dimension gives each tract's county (also the first five digits of its GEOID).","valid_values":null,"example":null,"unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"tract_geoid","type":"string","role":"fk_tract","nullable":true,"label":"Tract GEOID","short_description":"","description":"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.","valid_values":null,"example":"13245010207","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":false,"metric_component":null},{"name":"num_ypll_75","type":"number","role":"metric","nullable":true,"label":"Years of Potential Life Lost Before 75","short_description":"Years of life lost to deaths before age 75 in the tract over the 5-year window (a total, not a rate).","description":"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.","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":"The tract had fewer than 5 deaths in the window (OASIS shows them as '0-4'), so YPLL is withheld (our mask; 23, 14, 15, 15 and 15 tracts in the windows 2001-2005 to 2021-2025): OASIS publishes YPLL for some of these tracts, and on so few deaths it can reveal one person's age at death. Never filled in: a NULL can stand for 0 (no deaths before 75) or more, so never read it as 0 or as a positive value. Also NULL in 61 tracts with 5 or more deaths (our complementary suppression): in every county and window with a '0-4' tract, one more of the county's tracts is withheld, so that the county's total in the county OASIS topics minus the published tracts is never the '0-4' tracts' own total.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"num_ypll_75","numeric_filter_columns":["num_ypll_75"],"usage":"Filter by tract_geoid (join the tracts dimension for the tract's county and name) and compare windows with year. num_ypll_75 is a total, so a fair comparison between tracts needs a population you supply; for rates use the county YPLL topics. A sum over tracts leaves out the NULL (masked) tracts and so falls short of the true total; never compute the masked tracts as a residual.","limitations":"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.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2005,2010,2015,2020,2025],"schema_hash":"103478682b042b9a659f2cc3d699beed4f6c0e0a312ce2d249dcdbfe114c2909","tags":["health","georgia department of public health, office of health indicators for planning","premature_death_ypll_tract"],"granularity_description":"One row per year, county_fips, tract_geoid.","example_queries":[{"description":"Latest year (2025), tracts detail","query":"SELECT * FROM premature_death_ypll_tract WHERE year = 2025 LIMIT 100"}],"foreign_keys":[{"column":"county_fips","target_object":"counties","target_columns":["county_fips"],"attribute_columns_added":["county_name"],"scope":"global"},{"column":"tract_geoid","target_object":"tracts","target_columns":["tract_geoid"],"attribute_columns_added":["tract_name"],"scope":"global"}],"filters":[{"param":"year","kind":"year_exact","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_min","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"year_max","kind":"year_range","type":"integer","multi_value":false,"enum_enforced":false,"values":null},{"param":"detail","kind":"detail","type":"string","multi_value":false,"enum_enforced":true,"values":["tracts"],"default":"tracts"},{"param":"county_fips","kind":"foreign_key","column":"county_fips","type":"string","multi_value":true,"enum_enforced":false,"values":null},{"param":"tract_geoid","kind":"foreign_key","column":"tract_geoid","type":"string","multi_value":true,"enum_enforced":false,"values":null}],"filter_hints":[],"non_additive":[],"partitions":[],"value_implications":[],"year_meaning":"year is the last calendar year of a fixed 5-year window (2005 = 2001-2005, 2010 = 2006-2010, 2015 = 2011-2015, 2020 = 2016-2020, 2025 = 2021-2025): each row covers all five years together, never the single year named. The windows are OASIS's own, back to back, sharing no year.","pooled_rates":[],"series_breaks":[],"year_window":{"years":5,"overlapping":false},"pooled_min_count":null,"values_endpoint":"/api/v1/health/premature_death_ypll_tract/values"}