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

NameTypeRequiredDescription
statestringnoState name or code. Omit with a quarter to list every state for that quarter.
quarter_endstringnoQuarter end date YYYY-MM-DD (e.g. 2025-06-30). Omit for recent quarters.
limitintegernoMaximum 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

FieldTypeDescription
statestring
quarter_endnull
countnumber
rowsarray
notesstring
sourcestring
data_as_ofstring
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.

Regenerated from source · build November 16, 2026