@pipeworx/medicaid-spending

Connect: https://pipeworx.io/mcp — every tool in the catalog, including @pipeworx/medicaid-spending’s. Install: one-click buttons

Connect to just the @pipeworx/medicaid-spending pack

https://gateway.pipeworx.io/medicaid-spending/mcp — only @pipeworx/medicaid-spending’s own tools, nothing else in the catalog.

No MCP client? Skip the connection: POST https://gateway.pipeworx.io/v1/tools/search_packs {"query":"..."} to find a tool below, GET /v1/tools/<name> for its schema, POST the same URL with arguments for the data — see For AI agents.

Tools: 6

What each state spends on Medicaid, by service category and federal fiscal year, split into federal and state share (CMS CMS-64 net expenditures, fiscal years 2014-2024), the federal matching rate (FMAP and enhanced FMAP) by state and fiscal year 2014-2027, and the quarterly expansion-group and temporary increased-FMAP expenditure reports.

Tools

  • medicaid_spending_by_state(state, fiscal_year?, program?, category?, include_chip?, limit?) — one state’s (or the nation’s) headline total net expenditures and its service-category rows (managed care, prescribed drugs, nursing facility, home and community-based services, and so on), each with total computable, federal share, state share and the federal share percentage.
  • medicaid_spending_trend(state, category?, program?) — the same figures for every fiscal year 2014-2024, with year-over-year growth. Defaults to the headline total; pass a category to trend one service line.
  • medicaid_spending_ranking(fiscal_year?, sort_by?, category?, program?, limit?) — all 56 jurisdictions ranked by total, federal share, state share or federal share percentage, beside the national row.
  • medicaid_fmap(state?, fiscal_year?) — the Federal Medical Assistance Percentage and enhanced FMAP, for one state across years, or every jurisdiction in one year.
  • medicaid_expansion_spending(state?, quarter_end?, limit?) — quarterly spending on the ACA expansion (“new adult”) group: total computable and federal share, newly eligible versus not, beside all-medical-assistance.
  • medicaid_increased_fmap_spending(program?, state?, quarter_end?, limit?) — quarterly expenditure under the temporary increased match periods (the 2020 pandemic increase, and the phase-down under the 2023 appropriations act).

A state, fiscal year, quarter or category that matches nothing returns the valid values and near matches, never a bare empty result.

Auth

Keyless.

Data sources

  • CMS, Medicaid Financial Management Report (CMS-64 net expenditures): one workbook per federal fiscal year, per state and national totals, for the Medical Assistance Program (benefit spending) and Administration. Fiscal years 2014 to 2024 are served. States report these figures to CMS on the CMS-64; the report is net of collections and rebates.
  • HHS, annual Federal Medical Assistance Percentages notice in the Federal Register: one notice per fiscal year (2014 to 2027 served).
  • CMS, Medicaid CMS-64 New Adult Group Expenditures, and CMS, Medicaid CMS-64 increased-FMAP expenditure reports.

The expenditure workbooks and the yearly FMAP notices are bulk publications with no per-state query, so those two tables are read once by scripts/bake-index.mjs and stored (about 2.5 MB: 64,756 non-zero rows and 784 FMAP rows). Every response carries data_as_of. The two quarterly datasets are read live per request. Refresh is yearly (budget in scripts/baked-index-freshness.json): add the new fiscal year to FMR_YEARS in the script and re-run it.

Checks the bake performs: for every fiscal year the state and territory sheets sum exactly to the national-totals sheet (0.000 percent difference), the national total is in the hundreds of billions, and every FMAP is between 50 and 83 percent with the enhanced rate at or above it. The script refuses to write if any of them fails.

Notes

  • Figures are whole dollars, net of offsets. Service rows include negative offsets (drug rebates), so they do not all add up positively; the “Total Net Expenditures” row is the headline. Subtotal rows (“Total …”, “Balance”) are listed only when a category filter names them.
  • “C-” rows are CHIP-allotment-funded Medicaid expansion expenditures and “T-” rows are the CHIP-allotment portion of qualifying-state expenditures; both sit outside the headline and are hidden unless include_chip is set. The separate CHIP (title XXI) publication is not included.
  • The newest fiscal year can still be revised as states file adjustments. The FY2024 Texas total, for example, reads 17 percent below FY2023; check data_as_of before reading a one-year change as a trend.
  • FMAP rows are the standard rates only. The temporary pandemic increase, the 90 percent expansion-adult rate and disaster-recovery adjustments are not in the table. Federal Register correction notices are skipped; the original notice’s table is used.
  • Annual Disproportionate Share Hospital allotments are not served: CMS publishes them in Federal Register notices as page images, with no structured source. State DSH payments inside the expenditure series appear as the “Inpatient Hospital - DSH” and “Mental Health Facility - DSH” categories.
  • Territories (American Samoa, Guam, the Northern Mariana Islands, Puerto Rico, the Virgin Islands) report on the same basis; their FMAPs are statutory rates.

Tools

  • medicaid_spending_by_state — 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 expend
  • medicaid_spending_trend — One state’s Medicaid spending across federal fiscal years 2014 onward: total computable, federal share, state share and the effective federal share percentage per year, plus year-over-year growth. Def
  • medicaid_spending_ranking — 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 Managemen
  • medicaid_fmap — Federal Medical Assistance Percentage (the federal share of a state’s Medicaid costs) and the enhanced FMAP for CHIP, by state and federal fiscal year 2014 through 2027. Source: HHS, annual Federal Me
  • medicaid_expansion_spending — 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
  • medicaid_increased_fmap_spending — Quarterly Medicaid expenditure under the temporary increased federal match periods, by state: the 6.2 point pandemic increase (Families First Act, 2020 onward) or the phase-down under the Consolidated

Tools

  • medicaid_expansion_spending — 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-
  • medicaid_fmap — Federal Medical Assistance Percentage (the federal share of a state's Medicaid costs) and the enhanced FMAP for CHIP, by state and federal fiscal year 2014 through 2027. Source: HHS, annual Federal Me
  • medicaid_increased_fmap_spending — Quarterly Medicaid expenditure under the temporary increased federal match periods, by state: the 6.2 point pandemic increase (Families First Act, 2020 onward) or the phase-down under the Consolidated
  • medicaid_spending_by_state — 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 expend
  • medicaid_spending_ranking — 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 Managemen
  • medicaid_spending_trend — One state's Medicaid spending across federal fiscal years 2014 onward: total computable, federal share, state share and the effective federal share percentage per year, plus year-over-year growth. Def

Regenerated from source · build November 16, 2026