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

NameTypeRequiredDescription
fiscal_yearintegernoFederal fiscal year. Default: latest.
sort_bystringnoDefault total_computable.
categorystringnoService-category name to rank on. Default “Total Net Expenditures”.
programstringnoDefault medical_assistance.
limitintegernoRows 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

FieldTypeDescription
fiscal_yearnumber
programstring
categorystring
sorted_bystring
nationalobject
rowsarray
jurisdictions_reportingnumber
notesstring
sourcestring
data_as_ofstring
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.

Regenerated from source · build November 16, 2026