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)
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"dataset_id": "<dataset_id>"
},
"name": "cdc_query"
}
}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' |