cdc_query
Query CDC public health datasets including mortality, life expectancy, COVID, and birth indicators. Use SODA syntax to filter, select, and sort data for custom analysis.
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 |
|---|---|---|---|
| dataset_id | Yes | Dataset ID, e.g. 'bi63-dtpu' | |
| where | No | SODA $where clause: "year = '2021' AND state = 'New York'" | |
| select | No | SODA $select: 'year, state, deaths' | |
| order | No | SODA $order: 'year DESC' | |
| group | No | SODA $group: 'year' | |
| limit | No | Max rows (default 1000) |