Skip to content
← All datasets

Years of Potential Life Lost by Cause (NCHS Rankable Causes)

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).

Year coverage
2000–2025
Updated
annual
Version
1.0.0
Schema hash
4c3d7f1253b3

Detail levels available

StateCounty · default

Overview

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.

Row grain: One row per year, county_fips, tract_geoid, demographic, cause.

Key metric

ypll_rate_per_100k — YPLL Rate per 100,000 Residents Under 75 (rate_per_population)

The single headline value most answers want.

Variables

Every column in the fact table. The code is the exact field name the API returns.

ColumnTypeUnitRangeNull?Description
yearYearinteger——noCalendar year of death, 2000-2025.
Full description
Calendar year of death, 2000-2025.
county_fipsCounty FIPSstring——yes5-digit FIPS of the decedent's county of residence (FK to the counties dimension); NULL on Georgia's statewide row.
Full description
5-digit FIPS of the decedent's county of residence (FK to the counties dimension); NULL on Georgia's statewide row.

Joins counties; adds its label columns.

tract_geoidTract GEOIDstring——yesAlways NULL: state and county rows only.
Full description
Always NULL: state and county rows only.

Joins tracts; adds its label columns.

demographicDemographicstring——noThe 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.
Full 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.
11 allowed values
  • all
  • asian
  • black
  • female
  • hispanic
  • male
  • multiracial
  • native_american
  • pacific_islander
  • race_unknown
  • white

Joins demographics; adds its label columns.

causeCausestring——noNCHS rankable cause of death
Full 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.
50 allowed values
  • all — total / aggregate
  • 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
ypll_rate_per_100kYPLL Rate per 100,000 Residents Under 75numberrate_per_population—yesYears of life lost before 75 per 100,000 under 75
Full 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.
num_ypll_75Years of Potential Life Lost Before 75numbercount—yesYears of potential life lost before 75
Full 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.
num_population_under_75Population Under 75integercount—yesOASIS'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.
Full 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.

Filters

Query parameters the fact endpoint accepts. Comma-separated values are OR within a parameter; multiple parameters AND together.

ParameterKindAllowed valuesNotes
yearyear_exactany value—
year_minyear_rangeany value—
year_maxyear_rangeany value—
detaildetailcountiesstatesenum-enforced, default: counties
county_fipsforeign_keyany valuemulti-value
tract_geoidforeign_keyany valuemulti-value
demographicforeign_key
11 allowed values
  • all
  • asian
  • black
  • female
  • hispanic
  • male
  • multiracial
  • native_american
  • pacific_islander
  • race_unknown
  • white
multi-value, enum-enforced
causecategorical
50 allowed 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
multi-value, enum-enforced
demographic_categorydimension_attribute
12 allowed values
  • aggregate
  • disability
  • economic_status
  • esol
  • foster_care
  • gender
  • grade
  • homeless_status
  • migrant_status
  • military
  • race
  • sped
multi-value, enum-enforced

Example requests

Run these against the base URL — they return live data.

All rows (first page), counties level

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

counties data for 2025

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

Filtered to cause = septicemia for 2025

curl "https://georgiacivicdata.org/api/v1/health/premature_death_ypll_nchs_rankable?year=2025&cause=septicemia"

One county (FIPS 13121), 2025

curl "https://georgiacivicdata.org/api/v1/health/premature_death_ypll_nchs_rankable?county_fips=13121&year=2025&detail=counties"

Download 2025 as CSV

curl "https://georgiacivicdata.org/api/v1/health/premature_death_ypll_nchs_rankable?year=2025&format=csv"

Notes & limitations

NULL handling

  • Suppressed cells (values the source withholds, usually for a group too small to report) are NULL, never zero.
  • Zero is a real, reported value.

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.