cdc_query
Query CDC public health datasets on mortality, COVID-19, life expectancy, and other indicators using SODA syntax to extract specific data for 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
TableJSON 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) |