`condition_hospital_costs`

Pack: hcup-inpatient-stats · 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/condition_hospital_costs for the schema, then POST the same URL with its arguments for the data.

National U.S. inpatient hospital discharges and aggregate costs by principal diagnosis (CCSR category) and year, from AHRQ HCUP’s published “Most Expensive Conditions by Payer” Statistical Brief series — e.g. heart failure, septicemia/sepsis, acute myocardial infarction, COVID-19, stroke (cerebral infarction). Returns the top-20 most expensive conditions nationally (or filtered to one condition) with discharge counts, aggregate cost, and mean cost per stay. Years available: 2022, 2017 (AHRQ has not published a 2021 edition of this cross-condition table as of 2026-10-21). Optionally filter by expected payer (Medicare, Medicaid, private insurance, self-pay) for 2022.

Parameters

Name	Type	Required	Description
`year`	number	no	Statistical Brief edition year. One of: 2022, 2017. Defaults to 2022 (the most recent AHRQ has published).
`payer`	string	no	Expected payer to filter by. Only 2022 has per-payer tables; other years return the all-payer table regardless of this argument.
`condition`	string	no	Condition name (e.g. “heart failure”, “sepsis”, “stroke”) or CCSR code (e.g. “CIR019”) to filter to. Omit to get the full top-20 table for that year/payer.

Example call

Arguments

{
  "year": 2022,
  "condition": "heart failure"
}

curl

curl -X POST https://gateway.pipeworx.io/hcup-inpatient-stats/mcp \
  -H 'Content-Type: application/json' \
  -d '{"jsonrpc":"2.0","id":1,"method":"tools/call","params":{"name":"condition_hospital_costs","arguments":{"year":2022,"condition":"heart failure"}}}'

TypeScript (@pipeworx/sdk)

import { Pipeworx } from '@pipeworx/sdk';
const pipeworx = new Pipeworx();

const result = await pipeworx.call('condition_hospital_costs', {
  "year": 2022,
  "condition": "heart failure"
});

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 hcup-inpatient-stats pack

{
  "mcpServers": {
    "hcup-inpatient-stats": {
      "url": "https://gateway.pipeworx.io/hcup-inpatient-stats/mcp"
    }
  }
}

See Getting Started for client-specific install steps.

condition_hospital_costs