INDIVIDUAL MCP TOOL

hospital_payers

Every payer’s negotiated dollar amounts for the code at the hospitals within the radius, grouped by canonical payer_id (the stable id behind the many ways hospitals write a payer’s name), plan type and methodology (a per diem and a case rate are never pooled): how many hospitals and rates, and nearest-rank statistics.

spencermcw.comnone authenticationAvailability not checked

LIVE ENDPOINT

https://data.spencermcw.com/mcp

No auth detected

Connect to this endpoint to inspect the live schema for hospital_payers and invoke it with your own arguments.

Indexed input schema

{}

Risk classification

Potential side effects detected · medium confidence · heuristic, not a guarantee.

A tool name or description contains a write-action term.

Parent server

spencermcw.com

CONNECT WITH APPROVAL

Client installation

Review this server and its permissions before adding it. Secret placeholders must be set locally.

Codex

~/.codex/config.toml

[mcp_servers.distill]
url = "https://data.spencermcw.com/mcp"
enabled = true

Claude Code

.mcp.json

{
  "mcpServers": {
    "distill": {
      "type": "http",
      "url": "https://data.spencermcw.com/mcp"
    }
  }
}

Claude Desktop

Settings → Connectors → Add custom connector

Name: distill
Remote MCP URL: https://data.spencermcw.com/mcp

Add this remote URL as a custom connector in Claude Desktop. Availability depends on the user plan and workspace policy.

Cursor

.cursor/mcp.json

{
  "mcpServers": {
    "distill": {
      "url": "https://data.spencermcw.com/mcp"
    }
  }
}

Visual Studio Code

.vscode/mcp.json

Add to Visual Studio Code

{
  "servers": {
    "distill": {
      "type": "http",
      "url": "https://data.spencermcw.com/mcp"
    }
  }
}

Generic MCP

Client-specific MCP configuration

{
  "name": "distill",
  "transport": "streamable-http",
  "url": "https://data.spencermcw.com/mcp"
}

MCP Inspector

Run the official MCP Inspector locally and enter the indexed Streamable HTTP endpoint.

Related tools

tax_sales_rate — From the state’s own Streamlined Sales Tax rate and boundary files (24 states: AR, GA, IA, IN, KS, KY, MI, MN, NC, ND, NE, NJ, NV, OH, OK, RI, SD, TN, UT, VT, WA, WI, WV, WY).
tax_sales_rate_batch — The same answer as tax.
tax_changes — Change records read from the states’ rate and boundary files: rates that change, begin or end; ZIP+4 and 5-digit ZIP ranges whose jurisdictions change; new files posted.
hospital_prices — From the machine-readable standard-charge files hospitals must publish (45 CFR 180), parsed and normalized: for each hospital within the radius that posts the code, nearest first, the gross charge, the discounted cash price, the de-identified minimum and maximum, and every payer and plan’s negotiated dollar amount or percentage (with the v3.
hospital_compare — For each named hospital: whether it posts the code, and over its items for the code (only those without modifiers when it posts any, so a professional -26 or bilateral -50 line does not skew the row) nearest-rank statistics of its gross charges, discounted cash prices and negotiated dollar amounts across payers and plans, the range of negotiated percentages, the de-identified minimum and maximum, and the number of payers.
hospital_changes — Change records from diffing consecutive weekly builds: a hospital republishing its file (source raw_sha256), items and payer rates that appear, disappear or change price, a hospital’s status or file date changing, and the canonical payer of a payer/plan name changing.