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.
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
source url
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
| name | type | definition |
|---|---|---|
| age_bandkey | string | 10-year age band: 0-4, 5-14, 15-24, ..., 75-84, 85+.Part of primary key. |
| age_lower_bound | int64 · years | Lower bound of the age band (0,5,15,...,85) for ordering. |
| country_idkey | string | ISO alpha-2 country code (always US). |
| county_idkey | string | 5-character county FIPS code.Joins dim.geographies on county_fips. |
| coverage_flag | string | ok; suppressed_lt10 (1-9 deaths, deaths/rate null); or no_population. |
| death_rate_per_100k | float64 · rate per 100k | All-cause death rate per 100,000 = deaths/population. Null when suppressed. This is m(a). |
| deaths | int64 · count | All-cause death count for the cell (CDC WONDER). Null when suppressed (1-9 deaths). |
| population | int64 · count | Census PEP population denominator for the county-year-age cell. |
| state_idkey | string | 2-character state FIPS code. |
| yearkey | int64 | Calendar 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).
← previousus_health.health_mental_health_county_yearnext →us_health.health_mortality_despair_county_year
last updated · Jul 7, 2026