{"main_topic":"health","sub_topic":"oasis","topic":"premature_death_ypll_nchs_rankable","key":"health/oasis/premature_death_ypll_nchs_rankable","version":"1.0.0","year_min":2000,"year_max":2025,"year_gaps":[],"update_frequency":"annual","detail_levels":["counties","states"],"default_detail":"counties","path_template":"health/premature_death_ypll_nchs_rankable/year={year}/{detail}.parquet","grain":["year","county_fips","tract_geoid","demographic","cause"],"title":"Years of Potential Life Lost by Cause (NCHS Rankable Causes)","summary":"Years of potential life lost before 75 and their rate per 100,000 residents under 75, by NCHS rankable cause, race and ethnicity, and sex, Georgia and its counties, 2000-2025 (DPH OASIS).","description":"Years of potential life lost before age 75 (YPLL 75) by Georgia residents, by underlying cause grouped into the NCHS rankable causes: the National Center for Health Statistics list used to rank the leading causes of death nationally (48 categories as Georgia DPH's OASIS publishes them), plus all_other_causes (years lost to causes in none of them; our calculation) and the all-causes total. Georgia and each of its 159 counties, 2000-2025, overall, by race and ethnicity and by sex: the YPLL rate per 100,000 residents under 75 (key metric), the years lost and the population under 75. Each death before 75 adds 75 minus the age at death, so early deaths weigh most: use it for which causes take people young. The same deaths' counts and death rates are in deaths_by_cause_nchs_rankable; premature_death_ypll_georgia_rankable splits injuries and cancers more finely (accidental poisoning, mostly drug overdoses, is its own cause there); premature_death_ypll_tract has all-cause years lost by census tract in 5-year windows.","explorer":true,"search_aliases":{"en":["years of life lost","YPLL","premature deaths","causes of early death","dying young","premature mortality","lifespan lost","heart disease years lost","suicide years lost","CDC cause list"],"es":["años de vida perdidos","YPLL","muertes prematuras","muerte prematura","defunciones prematuras","mortalidad prematura","morir joven","años perdidos corazón","años perdidos por suicidio","lista de causas CDC"]},"source":"Georgia Department of Public Health, Office of Health Indicators for Planning (OHIP), OASIS Data Table Tool, Mortality (NCHS Rankable Causes; YPLL 75 and YPLL Rate); population under 75: OASIS population module (Census Bureau estimates as OASIS publishes them)","source_url":"https://oasis.state.ga.us/dtt/mortality","endpoint":"/api/v1/health/premature_death_ypll_nchs_rankable","columns":[{"name":"year","type":"integer","role":"year","nullable":false,"label":"Year","short_description":"","description":"Calendar year of death, 2000-2025.","valid_values":null,"example":2024,"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":"5-digit FIPS of the decedent's county of residence (FK to the counties dimension); NULL on Georgia's statewide row.","valid_values":null,"example":"13121","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":"Always NULL: state and county rows only.","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":"demographic","type":"string","role":"fk_demographic","nullable":false,"label":"Demographic","short_description":"","description":"The group: all; race groups hispanic (any race) and non-Hispanic white, black, asian, native_american (American Indian or Alaska Native), pacific_islander (Native Hawaiian or Other Pacific Islander) and multiracial, plus race_unknown (our calculation: all minus those seven; unknown ethnicity, or non-Hispanic of unknown race); gender male and female. The race groups' years lost add up to all (except in the county-years the race mask NULLs), and so do male and female's.","valid_values":["all","asian","black","female","hispanic","male","multiracial","native_american","pacific_islander","race_unknown","white"],"example":"all","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"cause","type":"string","role":"categorical","nullable":false,"label":"Cause","short_description":"NCHS rankable cause of death","description":"Underlying cause of death, the NCHS rankable categories as OASIS lists them: septicemia, hiv_disease (HIV disease), tuberculosis, meningococcal_infection, salmonella_infections, shigellosis_and_amebiasis, whooping_cough, scarlet_fever_and_erysipelas, syphilis, acute_poliomyelitis, arthropod_borne_viral_encephalitis, measles, viral_hepatitis, malaria, covid_19, malignant_neoplasms (every cancer), in_situ_benign_and_uncertain_neoplasms (in situ, benign and uncertain or unknown behavior neoplasms), anemias, diabetes_mellitus, nutritional_deficiencies, alzheimers_disease, parkinsons_disease, meningitis, hypertension_and_hypertensive_renal_disease (essential hypertension and hypertensive renal disease), diseases_of_heart (heart disease), cerebrovascular_diseases (stroke), atherosclerosis, aortic_aneurysm_and_dissection, influenza_and_pneumonia, acute_bronchitis_and_bronchiolitis, chronic_lower_respiratory_diseases (CLRD), pneumoconioses_and_chemical_effects, pneumonitis_due_to_solids_and_liquids, chronic_liver_disease_and_cirrhosis, peptic_ulcer, diseases_of_appendix, hernia, cholelithiasis_and_gallbladder_disorders, nephritis_nephrotic_syndrome_and_nephrosis, infections_of_kidney, hyperplasia_of_prostate, inflammatory_diseases_of_female_pelvic_organs, perinatal_conditions (certain conditions originating in the perinatal period), congenital_malformations (congenital malformations, deformations and chromosomal abnormalities), unintentional_injuries (accidents, including unintentional drug overdoses, falls and motor vehicle crashes), suicide (intentional self-harm), homicide (assault), legal_intervention. Plus all (every death: OASIS's 'All NCHS Rankable Causes', shown as All Causes) and all_other_causes (years lost to causes in none of the 48 categories; our calculation, all minus the 48). The categories never overlap, and with all_other_causes they add up to all. ICD-10 codes of each: https://oasis.state.ga.us/dtt/content/DefMort.html.","valid_values":["all","septicemia","hiv_disease","tuberculosis","meningococcal_infection","salmonella_infections","shigellosis_and_amebiasis","whooping_cough","scarlet_fever_and_erysipelas","syphilis","acute_poliomyelitis","arthropod_borne_viral_encephalitis","measles","viral_hepatitis","malaria","covid_19","malignant_neoplasms","in_situ_benign_and_uncertain_neoplasms","anemias","diabetes_mellitus","nutritional_deficiencies","alzheimers_disease","parkinsons_disease","meningitis","hypertension_and_hypertensive_renal_disease","diseases_of_heart","cerebrovascular_diseases","atherosclerosis","aortic_aneurysm_and_dissection","influenza_and_pneumonia","acute_bronchitis_and_bronchiolitis","chronic_lower_respiratory_diseases","pneumoconioses_and_chemical_effects","pneumonitis_due_to_solids_and_liquids","chronic_liver_disease_and_cirrhosis","peptic_ulcer","diseases_of_appendix","hernia","cholelithiasis_and_gallbladder_disorders","nephritis_nephrotic_syndrome_and_nephrosis","infections_of_kidney","hyperplasia_of_prostate","inflammatory_diseases_of_female_pelvic_organs","perinatal_conditions","congenital_malformations","unintentional_injuries","suicide","homicide","legal_intervention","all_other_causes"],"example":"all","unit":null,"value_min":null,"value_max":null,"null_meaning":null,"key_metric_grain_contributor":true,"metric_component":null},{"name":"ypll_rate_per_100k","type":"number","role":"metric","nullable":true,"label":"YPLL Rate per 100,000 Residents Under 75","short_description":"Years of life lost before 75 per 100,000 under 75","description":"OASIS's YPLL rate: years of potential life lost before 75 per 100,000 residents under 75 of the place and group (num_ypll_75 / num_population_under_75 x 100,000). Not age-adjusted (OASIS publishes no age-adjusted YPLL rate). Never add or average it across rows; combine places or groups as SUM(num_ypll_75) * 100000 / SUM(num_population_under_75) over the rows with num_ypll_75 (race rows the race mask NULLs left out). 0 where the group lost no year: no deaths, or 5 or more deaths all at 75 and over. NULL where OASIS withholds it (1-4 deaths), the group has no residents under 75, or the race mask applies. Georgia 2024, all causes: 7,758.6. The highest, 80,841.1 (all, native_american, county 13135, 2004: 1,038 years), is preserved as published: a small group's rate.","valid_values":null,"example":null,"unit":"rate_per_population","value_min":null,"value_max":null,"null_meaning":"No rate: the population under 75 OASIS divides by is zero, though the group lost years (a death under 75 in a group OASIS's estimates place no one under 75 in) (code -2, 17 rows); the group's deaths in the cause exceed its population under 75, the rate's denominator (OASIS: numerator greater than denominator) (code -3, 2 rows); OASIS withholds the rate where the place and group had 1-4 deaths in the cause, whatever the years lost (shown as * on OASIS) (code -5, 229,634 rows, 67,369 of them with no year lost); no residents under 75 in the group (population under 75 of 0) and no year lost, where OASIS shows 0: a rate on no population is undefined (our mask, 31,882 rows) (row counts are totals over all years). race_unknown rows never have one (there is no population for unknown race or ethnicity), and all_other_causes rows are our residual of years lost only; OASIS publishes no rate for them. Never recompute a withheld rate from the years. Also NULL on the race groups' rows (hispanic and the six non-Hispanic groups) of 52 county-years where race or ethnicity is unknown for more than 20% of the county-year's deaths (race_unknown / all, all causes, OASIS's death counts): our mask, OASIS's own 20% threshold for missing items; the all, sex and race_unknown rows and the population under 75 are kept.","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 potential life lost before 75","description":"Years of potential life lost before 75 by residents of the place and group who died of the cause: each death before 75 adds 75 minus the age at death, counted at the middle of the year of age, so values end in .0 or .5 (an infant death adds 74.5; a death at 75 or over adds nothing). OASIS publishes every value, however small; NULL only by the race mask. race_unknown and all_other_causes are our subtractions from OASIS's figures. Years, not deaths, and not independent events. Georgia 2024, all causes: 811,127.","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":"NULL on the race groups' rows (hispanic and the six non-Hispanic groups) of 52 county-years where race or ethnicity is unknown for more than 20% of the county-year's deaths (race_unknown / all, all causes, OASIS's death counts): our mask, OASIS's own 20% threshold for missing items; the all, sex and race_unknown rows and the population under 75 are kept.","key_metric_grain_contributor":false,"metric_component":null},{"name":"num_population_under_75","type":"integer","role":"metric","nullable":true,"label":"Population Under 75","short_description":"","description":"OASIS's population under 75 of the place and group (its population module, the age groups under 75 summed), the YPLL rate's denominator. The same on every cause row of a place and group, so never sum it across causes. 0 for a group with no residents under 75 in the place, whose rate is then NULL. Georgia 2024: 10,454,609.","valid_values":null,"example":null,"unit":"count","value_min":null,"value_max":null,"null_meaning":"NULL only on race_unknown rows: OASIS has no population for unknown race or ethnicity.","key_metric_grain_contributor":false,"metric_component":null}],"key_metric":"ypll_rate_per_100k","numeric_filter_columns":["ypll_rate_per_100k","num_ypll_75","num_population_under_75"],"usage":"Compare counties, race groups or sexes, or follow a place over time, with ypll_rate_per_100k (years lost per 100,000 residents under 75); never add or average it across rows. To combine places or groups, add the parts of the rows that have them: SUM(num_ypll_75) * 100000 / SUM(num_population_under_75) over rows where num_ypll_75 is not NULL is their YPLL rate (pooled_rates), which equals ypll_rate_per_100k wherever OASIS publishes that rate. Never compute it for a single row: where OASIS withholds a rate (1-4 deaths), that would rebuild what OASIS withholds. Race rows the race mask NULLs (county-years with over 20% of deaths of unknown race or ethnicity) are left out of both sums, so a race group pooled over counties in those years is not Georgia's: use Georgia's own row. num_population_under_75 repeats on every cause row: never sum it across causes. Rank causes of years lost within one place and year over the 48 categories, leaving out cause = 'all' and 'all_other_causes' (not one cause). Pin demographic = 'all' and cause = 'all' for totals. For deaths and death rates by the same causes use deaths_by_cause_nchs_rankable; the Georgia Rankable YPLL topic counts the same years: never add figures across them. Read directly with DuckDB over Parquet.","limitations":"Years of potential life lost before 75 by NCHS rankable cause and county of residence; the Georgia Rankable YPLL topic counts the same deaths, so never add across them. The rate is years lost per 100,000 residents under 75, not age-adjusted. OASIS withholds rates on 1-4 deaths (NULL). race_unknown and all_other_causes are our calculations, with no rate. Race groups are NULL in 52 county-years (2000-2006) with over 20% unknown race or ethnicity; small groups' series break before 2015, not trends. 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. ypll_rate_per_100k is OASIS's YPLL rate: years lost per 100,000 residents under 75 of the place and group (num_ypll_75 / num_population_under_75 x 100,000 reproduces every published rate). OASIS publishes no age-adjusted YPLL rate, so part of a difference between places or groups can come from their age mix under 75. OASIS publishes every YPLL figure, however small, and withholds the rate wherever the place and group had 1-4 deaths in the cause (NULL here), even when none of them was before 75; the platform adds no small-cell suppression of its own and never recomputes a withheld rate. A group with no residents under 75 in a place (num_population_under_75 0) has no rate (NULL): OASIS shows 0 there, but a rate on no population is undefined and would rank as the lowest (our mask; the years lost stay 0 unless the race mask NULLs them). 48% of rows with years lost have no rate, mostly 1-4 deaths in small counties, small groups and rare causes. num_ypll_75 counts years, not deaths, and the years come in clumps (one infant death adds 74.5), so they are not independent events: don't test differences in them as if they were. Race groups follow the platform convention from OASIS's race x ethnicity cross: hispanic is Hispanic of any race; white, black, asian, native_american (American Indian or Alaska Native), pacific_islander (Native Hawaiian or Other Pacific Islander) and multiracial are non-Hispanic. race_unknown is our calculation, all minus those seven (unknown ethnicity, or non-Hispanic of unknown race), so the race groups' years lost add up to all wherever the race mask (below) leaves them; it has no population and so no rate. Hispanic ethnicity is under-reported on death certificates, so hispanic figures may be low. The smaller race groups' series break in ways that look like changes in how race was recorded, not in mortality (our reading; the deaths_by_cause topics show the same breaks in deaths): Georgia's multiracial years lost were 0-831 a year in 2000-2007, then 2,672 in 2008, 320 in 2009 and 5,563.5 in 2012; native_american's YPLL rate went from 11,764.3 (2005) to 1,097.7 (2008); asian years lost went 7,507.5, 2,767.5, 6,511 in 2005-2007; and 15,974-28,543 years a year in 2000-2006 are race_unknown (mostly unknown ethnicity), against at most 6,376 since, so the non-Hispanic groups are undercounted then. Since 2015 multiracial has had Georgia's lowest all-cause YPLL rate of any race group every year, at most 51% of the next lowest (2024: 1,255.4 against 7,758.6 for all races), probably because death certificates record more than one race far less often than population estimates do (our reading): don't compare them with other groups, and don't read the small groups' changes before 2015 as trends. Where race or ethnicity is unknown for more than 20% of a place-year's deaths (race_unknown / all, all causes: OASIS's death counts, as in the deaths_by_cause topics), the race groups' years lost and rates for that place and year are NULL (our mask, OASIS's own 20% threshold for missing items): each group would miss its share of the unknowns, so its figures run low and its trend follows the recording, not the group. The all, sex and race_unknown rows and the population under 75 are kept, so the unknown share stays visible. It applies to 52 county-years (10 counties, 2000-2006, never Georgia), the death topics' own, on every cause: in those years a race group's county years lost can add up to less than Georgia's race row, which counts every county. num_population_under_75 is OASIS's own population under 75 (its population module, the 17 age groups under 75 summed) for the place, year and group; the race groups' populations add to all, as do male and female. Georgia 2024's top causes of years lost: unintentional_injuries (130,136.5 years), diseases_of_heart (128,819 years), malignant_neoplasms (126,930.5 years); all_other_causes held 131,143.5, more than any category, but it is not one cause. all_other_causes is all minus the 48 categories: 13% to 17% of Georgia's years lost a year, 2000-2025. Georgia's all_other_causes years lost jump for one year in 2008 (117,831.5), 2012 (114,458) and 2015 (127,337), about 10,100 to 15,200 years above the average of the years before and after, as its deaths do (deaths_by_cause topics): in OASIS's Detailed list those extra deaths are in none of its 15 cause groups, mostly ill-defined or unknown causes (ICD-10 R codes), probably deaths whose cause was still pending (our reading; OASIS documents no reason). NCHS ranks 52 causes; OASIS's list lacks four (Clostridium difficile infection, pregnancy and childbirth, complications of medical and surgical care, operations of war), whose years are in all_other_causes, as are drug overdoses of undetermined intent (OASIS's list has no such category). unintentional_injuries includes unintentional drug overdoses, falls and motor vehicle crashes; suicide includes drug suicides; covid_19 is 0 before 2020. Dementia deaths moved between causes in 2014-2016 (our reading: a change in how they were coded, not in how many people died): Georgia's alzheimers_disease deaths nearly doubled, from 2,042 in 2013 to 4,017 in 2016 (deaths_by_cause topics). Most dementia deaths are at 75 and over and add no years, so the shift is small in years lost: alzheimers_disease went from 861.5 to 1,753.5 years (0.1% and 0.2% of Georgia's years lost), while all_other_causes, which holds unspecified dementia (the NCHS list does not rank it), shows no matching fall (110,729.5 to 111,579 years): don't read alzheimers_disease across 2014-2016 as a trend. From 2014 on, dementia deaths also moved into senile degeneration of the brain (G31.1, in all_other_causes here): 5 Georgia deaths in 2013, 3,947 in 2025 (dementia_deaths), while alzheimers_disease's age-adjusted death rate fell from 47.8 (2018) to 30.9 (2025) and unspecified dementia fell too; the three together held steady, so this is probably coding as well (our reading). Few of these deaths were before 75, so years lost barely show it (alzheimers_disease: 2,155.5 years in 2018, 2,302 in 2025), but don't read alzheimers_disease or all_other_causes as a trend after 2013. Deaths are placed by county of residence as OASIS geocodes it, so about 4% land in a different county than in the federal NCHS files. 2025, the newest year, was added to OASIS on 2026-07-29; OASIS marks no year provisional. Counties add up to Georgia, except a race group's years lost in a year the race mask NULLs some of its county rows. Not served: OASIS's SES-vulnerability rows (its SES rates divide by the whole place's population), age and education breakdowns, and the death counts and rates (the deaths_by_cause topics). tract_geoid is always NULL.","null_semantics":{"suppressed_to_null":true,"zero_is_real":true},"available_years":[2000,2001,2002,2003,2004,2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025],"schema_hash":"4c3d7f1253b3def3fcb4b061eb394ec567a357ba751ccc30ebee90555e27eac4","tags":["health","georgia department of public health, office of health indicators for planning","premature_death_ypll_nchs_rankable"],"granularity_description":"One row per year, county_fips, tract_geoid, demographic, cause (geography columns are NULL at higher aggregation levels).","example_queries":[{"description":"Latest year (2025), counties detail","query":"SELECT * FROM premature_death_ypll_nchs_rankable WHERE year = 2025 LIMIT 100"},{"description":"Filter by cause = all","query":"SELECT * FROM premature_death_ypll_nchs_rankable WHERE cause = 'all' AND 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"},{"column":"demographic","target_object":"demographics","target_columns":["demographic"],"attribute_columns_added":["demographic_label","demographic_category"],"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":["counties","states"],"default":"counties"},{"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},{"param":"demographic","kind":"foreign_key","column":"demographic","type":"string","multi_value":true,"enum_enforced":true,"values":["all","asian","black","female","hispanic","male","multiracial","native_american","pacific_islander","race_unknown","white"]},{"param":"cause","kind":"categorical","column":"cause","type":"string","multi_value":true,"enum_enforced":true,"values":["all","septicemia","hiv_disease","tuberculosis","meningococcal_infection","salmonella_infections","shigellosis_and_amebiasis","whooping_cough","scarlet_fever_and_erysipelas","syphilis","acute_poliomyelitis","arthropod_borne_viral_encephalitis","measles","viral_hepatitis","malaria","covid_19","malignant_neoplasms","in_situ_benign_and_uncertain_neoplasms","anemias","diabetes_mellitus","nutritional_deficiencies","alzheimers_disease","parkinsons_disease","meningitis","hypertension_and_hypertensive_renal_disease","diseases_of_heart","cerebrovascular_diseases","atherosclerosis","aortic_aneurysm_and_dissection","influenza_and_pneumonia","acute_bronchitis_and_bronchiolitis","chronic_lower_respiratory_diseases","pneumoconioses_and_chemical_effects","pneumonitis_due_to_solids_and_liquids","chronic_liver_disease_and_cirrhosis","peptic_ulcer","diseases_of_appendix","hernia","cholelithiasis_and_gallbladder_disorders","nephritis_nephrotic_syndrome_and_nephrosis","infections_of_kidney","hyperplasia_of_prostate","inflammatory_diseases_of_female_pelvic_organs","perinatal_conditions","congenital_malformations","unintentional_injuries","suicide","homicide","legal_intervention","all_other_causes"],"has_total":true,"total_value":"all","requires_single_value":false,"nullable":false,"null_filter_token":null},{"param":"demographic_category","kind":"dimension_attribute","dimension":"demographics","column":"demographic_category","type":"string","multi_value":true,"enum_enforced":true,"values":["aggregate","disability","economic_status","esol","foster_care","gender","grade","homeless_status","migrant_status","military","race","sped"]}],"filter_hints":[],"non_additive":[{"column":"cause","reason":"num_population_under_75 is the place and group's whole population under 75, repeated on every cause row as the denominator of that row's rate, so a sum across causes counts the same residents again.","metrics":["num_population_under_75"]}],"partitions":[],"value_implications":[],"year_meaning":null,"pooled_rates":[{"column":"ypll_rate_per_100k","numerator":"num_ypll_75","denominator":"num_population_under_75","scale":100000}],"series_breaks":[],"year_window":null,"pooled_min_count":null,"values_endpoint":"/api/v1/health/premature_death_ypll_nchs_rankable/values"}