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

NameTypeRequiredDescription
statestringyesState, territory or DC: full name or two-letter code (“Texas”, “TX”). “national” for the all-states total.
fiscal_yearintegernoFederal fiscal year (October-September). Default: the latest in the series.
programstringnomedical_assistance = benefit spending (default); administration = administrative costs.
categorystringnoCase-insensitive word or phrase to match in the service-category name, e.g. “drug”, “nursing facility”, “mco”.
include_chipbooleannoInclude the “C-” and “T-” CHIP-funded rows (default false).
limitintegernoMaximum 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

FieldTypeDescription
statestring
fiscal_yearnumber
programstring
headlineobject
category_filternull
rowsarray
rows_returnednumber
rows_availablenumber
notesstring
sourcestring
data_as_ofstring
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.

Regenerated from source · build November 16, 2026