Query CDC Dataset
cdc.health.queryRead-onlyIdempotent
Query CDC health datasets by state, year, age group, or condition using SoQL filters. Get structured results with column names.
Instructions
Query a specific CDC dataset using SoQL filters — filter by state, year, age group, condition. Returns structured rows with column names. Supports WHERE, SELECT, ORDER, GROUP BY. Use cdc.datasets to find dataset IDs first (US Gov, Socrata SODA API)
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dataset_id | Yes | CDC dataset ID in xxxx-xxxx format (e.g. "9bhg-hcku" for COVID deaths). Use cdc.datasets to find IDs. | |
| where | No | SoQL WHERE clause filter (e.g. "state='CA'", "year > 2020", "age_group='65+'") | |
| select | No | Columns to return, comma-separated (e.g. "state, year, deaths"). Default: all columns. | |
| order | No | Sort order (e.g. "year DESC", "deaths DESC"). Default: dataset default order. | |
| group | No | Group by columns for aggregation (e.g. "state" with select "state, SUM(deaths)") | |
| limit | No | Max rows to return (1-1000, default 100) |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | No | Tool response payload. Shape varies per tool — consult the tool description and inputSchema. May be an object, array, string, or number depending on the upstream provider response. | |
| error | No | Present only when the call failed. Includes error code, message, request_id, and any provider-specific extras. |