cdc_query
Run custom SODA queries against CDC datasets covering mortality, life expectancy, COVID, and more. Filter, sort, and select specific fields to get the exact public health data you need.
Instructions
Custom query against any CDC dataset using SODA syntax. Datasets: bi63-dtpu (death 1999–2017), w9j2-ggv5 (life expectancy), 489q-934x (mortality rates), swc5-untb (PLACES county), dxpw-cm5u (PLACES city), pwn4-m3yp (COVID), r8kw-7aab (weekly deaths), s2qv-b27b (disability), xbxb-epbu (drug overdose), hn4x-zwk7 (nutrition/obesity), 6rkc-nb2q (historical death rates), 76vv-a7x8 (birth indicators)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| group | No | SODA $group: 'year' | |
| limit | No | Max rows (default 1000) | |
| order | No | SODA $order: 'year DESC' | |
| where | No | SODA $where clause: "year = '2021' AND state = 'New York'" | |
| select | No | SODA $select: 'year, state, deaths' | |
| dataset_id | Yes | Dataset ID, e.g. 'bi63-dtpu' |