TABLE III: Weekly Mortality Data for 122 U.S. Cities by Age Group

122 U.S. cities voluntarily report weekly death certificate counts, including pneumonia and influenza (P&I) deaths, by age group. The data is reported by the place of occurrence and the week the certificate was filed, covering cities with populations typically over 100,000. The dataset was last updated on the Socrata platform on 2018-01-19.

Use Cases

• Analyze weekly mortality trends by city using `Reporting Area`, `MMWR WEEK`, and `MMWR YEAR`.
• Compare pneumonia and influenza (P&I) deaths to all-cause mortality using `P&I† Total` and `All causes, by age (years), All Ages**`.
• Model age-specific mortality patterns using columns like `All causes, by age (years), 25–44`, `45–64`, and `?65`.
• Assess data reporting completeness and flags using the various `flag` columns associated with counts.

Strengths

• Covers 122 U.S. cities, providing a broad geographic scope for analysis.
• Includes detailed age group breakdowns (e.g., `LT 1`, `1–24`, `25–44`, `45–64`, `?65`).
• Provides separate tracking for pneumonia and influenza (P&I) deaths via `P&I† Total`.

Limitations

• Last updated 2018-01-19 19:36:03; freshness should be verified.
• Row count is unknown, which may limit suitability assessment.
• Data is voluntarily reported, which may introduce geographic or temporal reporting bias.

Provenance

Source

data.cdc.gov via the 122 Cities Mortality Reporting System.

Collection Method

Voluntary weekly reports from vital statistics offices of 122 U.S. cities.

Time Range

Weekly data, specific years not stated in input.

Freshness

Last updated 2018-01-19 19:36:03.

Geography

122 cities across the United States, most with populations of 100,000 or more.