Skip to content
← All datasets

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

Years of potential life lost before 75 and their rate per 100,000 residents under 75, by Georgia rankable cause (DPH's list: drug poisoning, crashes, suicide, cancer sites and more), 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
96e521cfd729

Detail levels available

StateCounty · default

Overview

Years of potential life lost before age 75 (YPLL 75) by Georgia residents, by underlying cause grouped into OASIS's Georgia rankable causes: Georgia DPH's own list of 55 mutually exclusive categories, finer than the national NCHS list for injuries and cancers, 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 specific causes take people young. Accidental poisoning (mostly drug overdoses) is its own cause here, where the NCHS list folds it into unintentional injuries: it was the largest single cause of Georgia's years lost in 2024 (58,118.5), ahead of ischemic heart and vascular disease, suicide and motor vehicle crashes; it was also the largest in 2020, 2022 and 2023 (ischemic heart and vascular disease is the largest in most other years, 2025 included). Motor vehicle crashes, falls, firearm accidents, drowning, fires and suffocation are each their own cause too. There is no heart disease or all-cancer total: use premature_death_ypll_nchs_rankable for those and for comparisons with other states. The NCHS and Georgia Rankable YPLL topics count the same years lost: never add across them. The same deaths' counts and death rates are in deaths_by_cause_georgia_rankable; 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——noGeorgia rankable cause of death
Full description
Underlying cause of death, the Georgia rankable categories (Georgia DPH's own list, finer than NCHS's for injuries and cancers) as OASIS lists them: septicemia, hiv_disease (HIV disease), tuberculosis, meningococcal_infection, covid_19 (virus identified; 0 before 2020), cancer_lip_oral_cavity_pharynx_esophagus, cancer_stomach, cancer_colon_rectum_anus, cancer_liver_and_bile_ducts, cancer_pancreas, cancer_trachea_bronchus_lung (lung cancer), melanoma_of_skin, cancer_breast, cancer_cervix_uterus_ovary, cancer_prostate_testis, cancer_bladder_kidney_renal_pelvis, cancer_brain_and_central_nervous_system, hodgkins_disease, leukemia, anemias, diabetes_mellitus, other_endocrine_nutritional_metabolic_diseases (OASIS's 'All Other' endocrine, nutritional and metabolic diseases: the chapter except diabetes), substance_use_disorders (mental and behavioral disorders due to psychoactive substance use, mostly alcohol use; not overdoses), other_mental_behavioral_disorders (the chapter's other disorders, mostly unspecified and vascular dementia), alzheimers_disease, parkinsons_disease, other_nervous_system_diseases (the nervous system chapter except Alzheimer's and Parkinson's), hypertension_and_hypertensive_heart_and_renal_disease (essential hypertension and hypertensive heart and renal disease; NCHS counts hypertensive heart disease in heart disease), rheumatic_fever_and_rheumatic_heart_diseases, ischemic_heart_and_vascular_disease (coronary heart disease, including heart attacks, plus atherosclerosis, aortic aneurysm and other arterial disease), cerebrovascular_disease (stroke), influenza, pneumonia, asthma, copd_except_asthma (COPD, chronic bronchitis and emphysema), alcoholic_liver_disease, other_chronic_liver_disease_and_cirrhosis (liver disease and cirrhosis not classed as alcoholic), nephritis_nephrotic_syndrome_and_nephrosis, infections_of_kidney, other_genitourinary_diseases (the genitourinary chapter except kidney disease and kidney infections), musculoskeletal_and_connective_tissue_diseases, perinatal_conditions (certain conditions originating in the perinatal period), congenital_malformations (congenital malformations, deformations and chromosomal abnormalities), sids (sudden infant death syndrome), motor_vehicle_crashes, falls, accidental_firearm_discharge, accidental_drowning, accidental_smoke_fire_and_flames, accidental_poisoning (accidental poisoning and exposure to noxious substances, mostly unintentional drug overdoses (DPH: 94% drugs, 4% alcohol)), suffocation, other_unintentional_injury (every other unintentional injury; with the seven before it, OASIS's unintentional injuries (slightly off the NCHS list's total in a few years; see limitations)), suicide (intentional self-harm, including drug suicides), homicide (assault), legal_intervention (injuries by law enforcement and legal executions). Plus all (every death: OASIS's 'All', shown as All Causes) and all_other_causes (years lost to causes in none of the 55 categories; our calculation, all minus the 55). The categories never overlap, and with all_other_causes they add up to all. There is no heart disease or all-cancer category. Breast, cervix/uterus/ovary and prostate/testis cancer rates divide by both sexes except on the male and female rows. ICD-10 codes of each: https://oasis.state.ga.us/dtt/content/DefMort.html.
57 allowed values
  • all — total / aggregate
  • septicemia
  • hiv_disease
  • tuberculosis
  • meningococcal_infection
  • covid_19
  • cancer_lip_oral_cavity_pharynx_esophagus
  • cancer_stomach
  • cancer_colon_rectum_anus
  • cancer_liver_and_bile_ducts
  • cancer_pancreas
  • cancer_trachea_bronchus_lung
  • melanoma_of_skin
  • cancer_breast
  • cancer_cervix_uterus_ovary
  • cancer_prostate_testis
  • cancer_bladder_kidney_renal_pelvis
  • cancer_brain_and_central_nervous_system
  • hodgkins_disease
  • leukemia
  • anemias
  • diabetes_mellitus
  • other_endocrine_nutritional_metabolic_diseases
  • substance_use_disorders
  • other_mental_behavioral_disorders
  • alzheimers_disease
  • parkinsons_disease
  • other_nervous_system_diseases
  • hypertension_and_hypertensive_heart_and_renal_disease
  • rheumatic_fever_and_rheumatic_heart_diseases
  • ischemic_heart_and_vascular_disease
  • cerebrovascular_disease
  • influenza
  • pneumonia
  • asthma
  • copd_except_asthma
  • alcoholic_liver_disease
  • other_chronic_liver_disease_and_cirrhosis
  • nephritis_nephrotic_syndrome_and_nephrosis
  • infections_of_kidney
  • other_genitourinary_diseases
  • musculoskeletal_and_connective_tissue_diseases
  • perinatal_conditions
  • congenital_malformations
  • sids
  • motor_vehicle_crashes
  • falls
  • accidental_firearm_discharge
  • accidental_drowning
  • accidental_smoke_fire_and_flames
  • accidental_poisoning
  • suffocation
  • other_unintentional_injury
  • 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. The sex-specific cancers' rates on the all and race rows divide by both sexes. 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
57 allowed values
  • all
  • septicemia
  • hiv_disease
  • tuberculosis
  • meningococcal_infection
  • covid_19
  • cancer_lip_oral_cavity_pharynx_esophagus
  • cancer_stomach
  • cancer_colon_rectum_anus
  • cancer_liver_and_bile_ducts
  • cancer_pancreas
  • cancer_trachea_bronchus_lung
  • melanoma_of_skin
  • cancer_breast
  • cancer_cervix_uterus_ovary
  • cancer_prostate_testis
  • cancer_bladder_kidney_renal_pelvis
  • cancer_brain_and_central_nervous_system
  • hodgkins_disease
  • leukemia
  • anemias
  • diabetes_mellitus
  • other_endocrine_nutritional_metabolic_diseases
  • substance_use_disorders
  • other_mental_behavioral_disorders
  • alzheimers_disease
  • parkinsons_disease
  • other_nervous_system_diseases
  • hypertension_and_hypertensive_heart_and_renal_disease
  • rheumatic_fever_and_rheumatic_heart_diseases
  • ischemic_heart_and_vascular_disease
  • cerebrovascular_disease
  • influenza
  • pneumonia
  • asthma
  • copd_except_asthma
  • alcoholic_liver_disease
  • other_chronic_liver_disease_and_cirrhosis
  • nephritis_nephrotic_syndrome_and_nephrosis
  • infections_of_kidney
  • other_genitourinary_diseases
  • musculoskeletal_and_connective_tissue_diseases
  • perinatal_conditions
  • congenital_malformations
  • sids
  • motor_vehicle_crashes
  • falls
  • accidental_firearm_discharge
  • accidental_drowning
  • accidental_smoke_fire_and_flames
  • accidental_poisoning
  • suffocation
  • other_unintentional_injury
  • 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_georgia_rankable"

counties data for 2025

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

Filtered to cause = septicemia for 2025

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

One county (FIPS 13121), 2025

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

Download 2025 as CSV

curl "https://georgiacivicdata.org/api/v1/health/premature_death_ypll_georgia_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 Georgia rankable cause and home county; the NCHS Rankable YPLL topic counts the same years: never add across them. The rate is per 100,000 residents under 75, not age-adjusted. OASIS withholds rates on 1-4 deaths. race_unknown and all_other_causes have no rate. Sex-specific cancer rates on all and race rows divide by both sexes. Race groups are NULL in 52 county-years (2000-2006) with over 20% unknown race; small groups break before 2015, not trends. Breast, cervix/uterus/ovary and prostate/testis cancer YPLL rates on the all and race rows are per 100,000 residents under 75 of both sexes (OASIS's rule for these causes, which its YPLL rate follows: every published rate is the row's years lost over the row's own population under 75), so they run well below the per-woman or per-man rates, about half in Georgia (2024: breast 125.1 on the all row against 241.5 on the female row; prostate and testis 35.2 against 72.2 on the male row): use the female or male row for those. 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). 58% 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: accidental_poisoning (58,118.5 years), ischemic_heart_and_vascular_disease (52,027.5 years), suicide (49,163 years), motor_vehicle_crashes (45,928.5 years); all_other_causes held 149,575, more than any category, but it is not one cause. Georgia's largest category of years lost is ischemic_heart_and_vascular_disease in every year, 2025 included, except: motor_vehicle_crashes in 2006-2007; accidental_poisoning in 2020 and 2022-2024; covid_19 in 2021. all_other_causes is all minus the 55 categories: 16% to 21% of Georgia's years lost a year, 2000-2025. It holds what the list leaves out: heart failure and other heart disease (beyond ischemic, hypertensive and rheumatic), ill-defined causes, most digestive and skin disease, cancer sites not listed, in situ and benign neoplasms, injuries of undetermined intent (including drug overdoses of undetermined intent), complications of medical care and pregnancy. Georgia's all_other_causes years lost jump for one year in 2008 (149,382.5), 2012 (140,515.5) and 2015 (153,956.5), about 8,300 to 15,100 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). For all heart disease or all cancers use the NCHS list's diseases_of_heart and malignant_neoplasms (premature_death_ypll_nchs_rankable); never sum this list's categories for them. The eight unintentional-injury categories (motor_vehicle_crashes through other_unintentional_injury) together cover unintentional injuries by OASIS's definitions; their Georgia years lost match the NCHS list's unintentional_injuries except in 2006, 2008, 2009 and 2013 (2009: 90,255 against 90,842 years), so OASIS's own figures differ slightly between the lists. accidental_poisoning excludes drug suicides (in suicide) and homicides (in homicide). hypertension_and_hypertensive_heart_and_renal_disease includes hypertensive heart disease, which NCHS counts in heart disease, and ischemic_heart_and_vascular_disease includes atherosclerosis and aortic aneurysm. 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 other_mental_behavioral_disorders, which holds unspecified dementia, fell from 3,663.5 to 2,354.5 years (its deaths: 4,626 to 2,716, deaths_by_cause_georgia_rankable): don't read either series across 2014-2016 as a trend. From 2014 on, dementia deaths also moved into senile degeneration of the brain (G31.1, in other_nervous_system_diseases 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 other_nervous_system_diseases 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.