medicaid_spending_ranking
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_ranking for the schema, then POST the same URL with its arguments for the data.
States ranked by Medicaid spending in a federal fiscal year (total computable, federal share, state share, effective federal share percentage), largest first. Source: CMS, Medicaid Financial Management Report (CMS-64 net expenditures). Pass category to rank on one service line instead of the headline total.
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
fiscal_year | integer | no | Federal fiscal year. Default: latest. |
sort_by | string | no | Default total_computable. |
category | string | no | Service-category name to rank on. Default “Total Net Expenditures”. |
program | string | no | Default medical_assistance. |
limit | integer | no | Rows to return (default 60: every jurisdiction). |
Example call
Arguments
{
"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_ranking","arguments":{"fiscal_year":2024,"limit":5}}}'
TypeScript (@pipeworx/sdk)
import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();
const result = await pipeworx.call('medicaid_spending_ranking', {
"fiscal_year": 2024,
"limit": 5
});
Response shape
| Field | Type | Description |
|---|---|---|
fiscal_year | number | |
program | string | |
category | string | |
sorted_by | string | |
national | object | |
rows | array | |
jurisdictions_reporting | number | |
notes | string | |
source | string | |
data_as_of | string |
Full JSON Schema
{
"type": "object",
"properties": {
"fiscal_year": {
"type": "number"
},
"program": {
"type": "string"
},
"category": {
"type": "string"
},
"sorted_by": {
"type": "string"
},
"national": {
"type": "object",
"properties": {
"total_computable": {
"type": "number"
},
"federal_share": {
"type": "number"
},
"state_share": {
"type": "number"
},
"federal_share_pct": {
"type": "number"
}
},
"additionalProperties": true
},
"rows": {
"type": "array",
"items": {
"type": "object",
"properties": {
"rank": {
"type": "number"
},
"state": {
"type": "string"
},
"total_computable": {
"type": "number"
},
"federal_share": {
"type": "number"
},
"state_share": {
"type": "number"
},
"federal_share_pct": {
"type": "number"
}
},
"additionalProperties": true
}
},
"jurisdictions_reporting": {
"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.