Hospital Intelligence Brief
What Public Hospital Data Cannot Tell You About Profitability
Public hospital data reveal a lot about volume and mix. About profit, they are far less reliable. Knowing exactly why prevents expensive mistakes.
Short answer
Public hospital data cannot reliably show profitability because charges are not revenue, most discharge datasets contain no cost or payment information, cost reports are annual and allocated, and data lag and may be incomplete. They are best used to size demand and compare mix, then combined with a hospital’s own financial data to assess profit.[1][2][3]
Why do people try to infer profit from public data?
It is tempting. Public datasets describe discharges, diagnoses and charges for every hospital, and a planner assessing a new service line naturally wonders whether it is profitable. But the datasets were designed for planning, research and regulation, not for financial analysis, and treating them as profit statements leads to errors. Understanding the limits helps analysts decide what questions to bring to public data and what to answer elsewhere.
Why are charges not revenue?
Hospital charges are the prices on the hospital’s chargemaster. What the hospital actually receives depends on the payer. Medicare pays by diagnosis-related group using prospectively set rates adjusted for wages and other factors, regardless of the charge.[4] Commercial payers negotiate discounts. Medicaid pays set rates. Uninsured patients may receive financial assistance or generate bad debt. Revenue is therefore the amount collected after contractual adjustments, denials and write-offs.
SPARCS records are described as pre-adjudicated claim data, meaning they are submitted before payers have finished processing them.[1] The charges in the data therefore do not reflect final payment. Using charges as revenue can overstate income, and the overstatement differs by payer, so comparisons between hospitals with different payer mixes are distorted.
What about costs?
Most discharge datasets contain no cost data, or only limited estimated cost fields, whose derivation may not be documented. The New York public inpatient file, for example, includes total charges and total costs, but its notes do not explain how costs are derived from charges, which is a reason to read the data dictionary before relying on them.
Cost reports are a better source of cost. The Medicare hospital cost report includes costs and charges by cost center, utilization data and financial statement data.[2] But they are annual, filed after year-end, and cost center costs are the product of accounting allocation rules. Two hospitals with identical operations can report different departmental costs because of allocation choices. They are useful for hospital-level comparison and poor for precise service-line profit.
What else limits public data?
Timing: data are released months or years after the events. Completeness: the Department of Health states that at the time of an open dataset release some facilities are not in full compliance with reporting requirements.[3] Granularity: patient geography and age are coarsened for privacy. Scope: ambulatory, physician and post-acute revenue are often missing, though they may be a large part of the economics of a service line. And context: public data say nothing about contracts, local wage rates, equipment, staffing or the hospital’s cost structure.
How should public data be used instead?
Use public data for what it does well: demand, market share, patient flow, case mix, severity, length of stay and relative volume. Then bring in internal data for revenue per case by payer, direct cost per case, step-fixed costs and capacity. Combine them in a business case that states assumptions and shows scenarios. If a decision depends on profit, test it with the hospital’s own data and, where needed, with a costing study.
The next article in this series, on combining market data with financial and operational evidence, shows how. The interactive example below uses invented figures to show how a charge-based estimate can differ from a payment-based one.
Frequently asked questions
Can public hospital data show profitability?
Not reliably. Charges are not revenue, most datasets lack cost data, and cost reports are annual and allocated.
What is the difference between charges and revenue?
Charges are billed prices; revenue is what is collected after contractual adjustments, denials and bad debt.
What is pre-adjudicated claim data?
Claims data submitted before payers have finished processing them, as SPARCS records are.[1]
Do Medicare cost reports show service-line profit?
They show costs and charges by cost center but rely on allocation and are annual, so they are weak for precise service-line profit.[2]
What should public data be used for?
Demand, market share, patient flow, case mix and relative volume.
What to do next
- Use public data only for demand and mix questions.
- Gather internal revenue and cost data for any profit question.
- State the assumptions behind any financial estimate.
- Test decisions with scenarios, not point estimates.
Optional · interactive example
See it in an interactive example.
Hospital Market Explorer: a market dashboard comparing a five-hospital market by service category, an outmigration capture scenario, evidence-linked answers from APIS, and a sample brief, all on synthetic data.
The experience below uses a synthetic five-hospital market built to look like public discharge data. It is not New York data, or data for any real market, and every figure is illustrative. The counts are discharges, not dollars.
- Ask APIS “What can this data not tell us about profitability?” and read what it lists as missing.
- Ask it about revenue or margin directly. Notice that it declines rather than guesses.
- Open the brief and find where it states what the data cannot establish.
Explore Your Hospital’s Opportunities
Two Pillars can help hospital leadership investigate market, financial, operational and strategic questions using relevant organizational data, public information and a structured assessment process. A good first step is a market scan that uses public discharge data to show where your service area’s patients go and which gaps are worth a closer look.
Sources
- New York State Department of Health, SPARCS Data Submission. Accessed October 2026.
- Centers for Medicare & Medicaid Services, Cost Reports. Accessed October 2026.
- New York State Department of Health, Hospital Inpatient Discharges (SPARCS De-Identified): 2024. Accessed October 2026.
- Centers for Medicare & Medicaid Services, Acute Inpatient PPS. Accessed October 2026.
Sources checked October 2026. This guide is general information for healthcare leaders and is not legal, financial, clinical or compliance advice. Figures and rules are cited to the sources below and may have changed since they were accessed, so confirm anything you rely on against the current source. Two Pillars & Co is independent of the organizations cited. See our editorial policy.