CMS Medicare dataset query

Queries a data.cms.gov dataset version by UUID with keyword search, up to two column filters, column selection and sorting. Needs dataset id.

Inputs

1 required

Dataset ID: Dataset version UUID, e.g. '9552739e-3d05-4c1b-8eff-ecabf391e2e5'Required · dataset_id
Keyword: Full-text keyword across columns, e.g. 'Ozempic'Optional · keyword
Filter column: Column for the first filter, e.g. 'Brnd_Name'Optional · filter_column
Filter operator: Operator for the first filter, e.g. '='Optional · filter_operator
Filter value: Value for the first filter (case-sensitive), e.g. 'Ozempic'Optional · filter_value
Filter2 column: Column for a second filter, e.g. 'Prscrbr_State_Abrvtn'Optional · filter2_column
Filter2 operator: Operator for the second filter, e.g. '='Optional · filter2_operator
Filter2 value: Value for the second filter, e.g. 'VT'Optional · filter2_value
Columns: Columns to return, e.g. 'Prscrbr_NPI,Prscrbr_Last_Org_Name,Tot_Clms'Optional · columns
Sort: Sort column, prefix '-' for descending (text sort), e.g. '-Tot_Clms'Optional · sort
Size: Rows to return, e.g. 10Optional · size
Offset: Rows to skip, e.g. 10Optional · offset

Price: Free, no charge per call
Billing: No charge per call. A workspace is still needed so your agent can call it.
License: US Government public data (public domain)
Attribution: Data from the Centers for Medicare & Medicaid Services (data.cms.gov)

Your agent reads the schema and the price with inspect_tool before it runs the tool.

Knowledge & research