medicaid_expansion_spending
Pack: medicaid-spending · Connect: https://pipeworx.io/mcp (see Connect below for a single-pack URL)
No MCP client? Call it directly: GET https://gateway.pipeworx.io/v1/tools/medicaid_expansion_spending for the schema, then POST the same URL with its arguments for the data.
Quarterly Medicaid spending on the ACA expansion (“new adult” / VIII) group by state, with total computable and federal share, newly eligible versus not newly eligible, next to the state’s all-medical-assistance total. Source: CMS, Medicaid CMS-64 New Adult Group Expenditures. Newest quarter first. “N/A” in the source (state had not expanded) is returned as null.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
state | string | no | State name or code. Omit with a quarter to list every state for that quarter. |
quarter_end | string | no | Quarter end date YYYY-MM-DD (e.g. 2025-06-30). Omit for recent quarters. |
limit | integer | no | Maximum rows (default 12, max 200). |
Example call
Arguments
{
"state": "California",
"limit": 4
}
curl
curl -X POST https://gateway.pipeworx.io/medicaid-spending/mcp \
-H 'Content-Type: application/json' \
-d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"medicaid_expansion_spending","arguments":{"state":"California","limit":4}}}'
TypeScript (@pipeworx/sdk)
import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();
const result = await pipeworx.call('medicaid_expansion_spending', {
"state": "California",
"limit": 4
});
Response shape
| Field | Type | Description |
|---|---|---|
state | string | |
quarter_end | null | |
count | number | |
rows | array | |
notes | string | |
source | string | |
data_as_of | string |
Full JSON Schema
{
"type": "object",
"properties": {
"state": {
"type": "string"
},
"quarter_end": {
"type": "null"
},
"count": {
"type": "number"
},
"rows": {
"type": "array",
"items": {
"type": "object",
"properties": {
"state": {
"type": "string"
},
"total_computable_all_medical_assistance_expenditures": {
"type": "number"
},
"total_federal_share_all_medical_assistance_expenditures": {
"type": "number"
},
"total_computable_viii_group_expenditures": {
"type": "number"
},
"total_federal_share_viii_group_expenditures": {
"type": "number"
},
"total_computable_viii_group_newly_eligible_expenditures": {
"type": "number"
},
"total_federal_share_viii_group_newly_eligible_expenditures": {
"type": "number"
},
"total_computable_viii_group_not_newly_eligible_expenditures": {
"type": "number"
},
"total_federal_share_viii_group_not_newly_eligible_expenditures": {
"type": "number"
},
"quarter_end_date": {
"type": "string"
},
"updated_year": {
"type": "string"
},
"updated_month": {
"type": "string"
},
"notes": {
"type": "null"
}
},
"additionalProperties": true
}
},
"notes": {
"type": "string"
},
"source": {
"type": "string"
},
"data_as_of": {
"type": "string"
}
},
"additionalProperties": true
}
Connect
Add this to your MCP client config — every tool in the catalog, including this one — or use one-click install buttons:
{
"mcpServers": {
"pipeworx": {
"url": "https://pipeworx.io/mcp"
}
}
}
Connect to just the medicaid-spending pack
{
"mcpServers": {
"medicaid-spending": {
"url": "https://gateway.pipeworx.io/medicaid-spending/mcp"
}
}
}
See Getting Started for client-specific install steps.