@pipeworx/fqhc-cost-reports

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

Connect to just the @pipeworx/fqhc-cost-reports pack

https://gateway.pipeworx.io/fqhc-cost-reports/mcp — only @pipeworx/fqhc-cost-reports’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: 3

Per-center, per-fiscal-year Medicare cost report figures for federally qualified health centers (FQHCs): visits, total allowable cost, cost per visit, Medicare visits and cost, and visits by payer (Medicare, Medicaid, other), from CMS cost report form CMS-224-14, fiscal years 2015 onward.

Tools

  • fqhc_cost_report_search(name?, state?, city?, fiscal_year?, sort?, limit?) — find centers and compare cost per visit; sort by name, cost per visit or visits. Unmatched filters return near-name centers or the valid states and years.
  • fqhc_cost_report_center(provider_number | name + state) — one center across every fiscal year, with the year-over-year change in cost per visit and Medicare/Medicaid visit shares.
  • fqhc_cost_report_state_summary(state, fiscal_year?) — centers reporting, total visits, total allowable cost, aggregate and median cost per visit, lowest and highest cost centers, Medicare and Medicaid shares.

Auth

Keyless.

Data sources

  • Centers for Medicare & Medicaid Services (CMS), Healthcare Cost Report Information System, Federally Qualified Health Center cost reports (form CMS-224-14). US federal data, public domain. A stored, derived copy: one row per center per fiscal year (about 20,000 rows, 3.5 MB), refreshed by re-running scripts/bake-index.mjs on CMS’s current release. Every answer carries data_as_of (the latest CMS processing date in the release).

Where each figure comes from on the form (also recorded in scripts/bake-index.mjs):

FieldWorksheet, line, column
total_allowable_costWorksheet B Part I, line 11, column 5 (total costs by practitioner)
cost_per_visitWorksheet B Part I, line 13, column 6
medical / mental health / IOP visitsWorksheet B Part I, line 11, columns 7 / 8 / 8.01
medicare_visits, medicare_costWorksheet B Part I, line 11, columns 9+10+10.01 and 11+12+12.01 (Title XVIII)
visits by payerWorksheet S-3 Part I, lines 20 + 21 + 25, columns 1 Title V, 2 Title XVIII (Medicare), 3 Title XIX (Medicaid), 4 other, 5 all patients
total_expenses_all_cost_centersWorksheet A, line 100, column 7
name, city, state, zipWorksheet S-1 Part I, lines 1 and 3

Things worth knowing:

  • Fiscal year means the year the cost reporting period ends. Periods can be shorter than 12 months (a center’s first or last period), so compare visits and cost, not just totals, across years.
  • Cost per visit is the form’s average cost per visit, not a payment rate. A few centers report implausible values (for example a center filing only mental health visits against its whole cost); the figures are as filed.
  • A report filed for several sites together appears once, under the filing provider number. Sites covered by another entity’s consolidated report carry no figures and are not listed (about 11,700 such records were left out of the 31,700 in the release).
  • If a center filed more than once for the same period, the most recently processed report is kept.
  • Provider numbers (CCN) are 6-character strings; keep leading zeros. HRSA site data (hrsa-health-centers) uses different identifiers, so there is no crosswalk here.

Tools

  • fqhc_cost_report_search — Find federally qualified health centers (FQHCs) in Medicare cost report data and compare their cost per visit. Filter by center name words, state, city and fiscal year; returns each match’s visits, to
  • fqhc_cost_report_center — Get one federally qualified health center’s Medicare cost report figures across every fiscal year: visits (medical, mental health, IOP), total allowable cost, cost per visit, Medicare visits and cost,
  • fqhc_cost_report_state_summary — Summarize FQHC Medicare cost report figures for a state and fiscal year: number of reporting centers, total visits, total allowable cost, aggregate and median cost per visit, the lowest- and highest-c

Tools

  • fqhc_cost_report_center — Get one federally qualified health center's Medicare cost report figures across every fiscal year: visits (medical, mental health, IOP), total allowable cost, cost per visit, Medicare visits and cost,
  • fqhc_cost_report_search — Find federally qualified health centers (FQHCs) in Medicare cost report data and compare their cost per visit. Filter by center name words, state, city and fiscal year; returns each match's visits, to
  • fqhc_cost_report_state_summary — Summarize FQHC Medicare cost report figures for a state and fiscal year: number of reporting centers, total visits, total allowable cost, aggregate and median cost per visit, the lowest- and highest-c

Regenerated from source · build November 16, 2026