medicaid_spending_by_state
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_spending_by_state for the schema, then POST the same URL with its arguments for the data.
What one state (or the nation) spent on Medicaid in a federal fiscal year, by service category, split into federal and state share. Source: CMS, Medicaid Financial Management Report (CMS-64 net expenditures), fiscal years 2014 onward.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
state | string | yes | State, territory or DC: full name or two-letter code (“Texas”, “TX”). “national” for the all-states total. |
fiscal_year | integer | no | Federal fiscal year (October-September). Default: the latest in the series. |
program | string | no | medical_assistance = benefit spending (default); administration = administrative costs. |
category | string | no | Case-insensitive word or phrase to match in the service-category name, e.g. “drug”, “nursing facility”, “mco”. |
include_chip | boolean | no | Include the “C-” and “T-” CHIP-funded rows (default false). |
limit | integer | no | Maximum category rows (default 25, max 300). |
Example call
Arguments
{
"state": "California",
"fiscal_year": 2024,
"limit": 5
}
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_spending_by_state","arguments":{"state":"California","fiscal_year":2024,"limit":5}}}'
TypeScript (@pipeworx/sdk)
import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();
const result = await pipeworx.call('medicaid_spending_by_state', {
"state": "California",
"fiscal_year": 2024,
"limit": 5
});
Response shape
| Field | Type | Description |
|---|---|---|
state | string | |
fiscal_year | number | |
program | string | |
headline | object | |
category_filter | null | |
rows | array | |
rows_returned | number | |
rows_available | number | |
notes | string | |
source | string | |
data_as_of | string |
Full JSON Schema
{
"type": "object",
"properties": {
"state": {
"type": "string"
},
"fiscal_year": {
"type": "number"
},
"program": {
"type": "string"
},
"headline": {
"type": "object",
"properties": {
"category": {
"type": "string"
},
"kind": {
"type": "string"
},
"total_computable": {
"type": "number"
},
"federal_share": {
"type": "number"
},
"state_share": {
"type": "number"
},
"federal_share_pct": {
"type": "number"
},
"program": {
"type": "string"
}
},
"additionalProperties": true
},
"category_filter": {
"type": "null"
},
"rows": {
"type": "array",
"items": {
"type": "object",
"properties": {
"category": {
"type": "string"
},
"kind": {
"type": "string"
},
"total_computable": {
"type": "number"
},
"federal_share": {
"type": "number"
},
"state_share": {
"type": "number"
},
"federal_share_pct": {
"type": "number"
},
"program": {
"type": "string"
}
},
"additionalProperties": true
}
},
"rows_returned": {
"type": "number"
},
"rows_available": {
"type": "number"
},
"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.