docs/us_health/health_mortality_by_age_county_year

health_mortality_by_age_county_year

All-cause mortality by age band - the age-of-death distribution m(a), (see yaml).

tier aTier A - CDC WONDER actual death counts by age band (not modeled), over the complete PEP population grid.
grain
county-year-age
years
1990 – 2024
cadence
Annual (CDC WONDER final mortality, ~1.5-year lag)
overview

overview

3,142 counties x 35 years x 10 age bands = 1,099,768 rows (plus legacy CT/AK FIPS). WONDER all-cause deaths cover 1999-2024; earlier years carry PEP denominators. Suppressed (1-9-death) cells carry null deaths/rate.

current vintage — 2024

provenance

source & licensing

authority
U.S. Centers for Disease Control and Prevention
dataset
CDC WONDER Multiple Cause of Death (all-cause, by age) + Census PEP
license
Public domain (U.S. Federal Government work)
citation
Centers for Disease Control and Prevention, National Center for Health Statistics, CDC WONDER Multiple Cause of Death 1999-2024; Census Bureau Population Estimates Program.
schema

fields

nametypedefinition
age_bandkeystring10-year age band: 0-4, 5-14, 15-24, ..., 75-84, 85+.Part of primary key.
age_lower_boundint64 · yearsLower bound of the age band (0,5,15,...,85) for ordering.
country_idkeystringISO alpha-2 country code (always US).
county_idkeystring5-character county FIPS code.Joins dim.geographies on county_fips.
coverage_flagstringok; suppressed_lt10 (1-9 deaths, deaths/rate null); or no_population.
death_rate_per_100kfloat64 · rate per 100kAll-cause death rate per 100,000 = deaths/population. Null when suppressed. This is m(a).
deathsint64 · countAll-cause death count for the cell (CDC WONDER). Null when suppressed (1-9 deaths).
populationint64 · countCensus PEP population denominator for the county-year-age cell.
state_idkeystring2-character state FIPS code.
yearkeyint64Calendar year (1990-2024).Part of primary key.
relationships

joins

primary key
county_id, state_id, country_id, year, age_band
common joins
not provided
usage

how to use this table

method

int_mortality_wonder filtered to cause_code all_cause; death_rate_per_100k = deaths/population x 100k; suppressed cells null; missing WONDER cells are true zeros.

do not use for

Cause-specific mortality (all-cause only); sub-county geography; ages as exact (10-year bands).

last updated · Jul 7, 2026