cms_query_dataset
Query CMS healthcare datasets with filters, sorting, and pagination to return up to 5000 rows. For larger data, use the CSV link to load into Athena.
Instructions
Query a CMS dataset with filters, sorting, and pagination. Returns up to 5000 rows per request. For larger datasets, use csv_link and load into Athena.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| size | No | Number of rows to return (max 5000, default 100) | |
| sort | No | Column name to sort by (prefix with - for descending) | |
| filter | No | Filter expression (e.g., '[field]=value' or '[field]=value1,value2') | |
| offset | No | Number of rows to skip (for pagination) | |
| columns | No | Comma-separated list of columns to return | |
| dataset_id | Yes | The unique identifier (UUID) of the dataset |