Hospital Intelligence Brief
How to Identify Potential Market Opportunities From Public Healthcare Data
Public data cannot tell a hospital what to do, but it can show where to look. Four signals, tested one at a time, turn a mass of numbers into a short list of opportunities.
Short answer
Public healthcare data can point to market opportunities through four signals: demand that exceeds local supply, large outmigration in services a hospital could offer, growth in service lines or age groups, and quality or access gaps among competitors. Each signal is a hypothesis to be tested with local knowledge and financial analysis before investing.[1][2][3]
What counts as a market opportunity?
A market opportunity is a service or patient group where the hospital can serve more patients, or serve them better, at acceptable cost. Public data can suggest where to look, but they cannot show whether the hospital can seize it. The discipline is to use data to create hypotheses and to test them with local knowledge, capacity and financial analysis before committing resources.
Which public data sources help?
Several sources combine well. The Healthcare Cost and Utilization Project provides all-payer, encounter-level hospital data from 1988 for national, state and local market analysis.[1] In New York, the SPARCS public use files cover discharges by facility, by county of residence and annual patient-level files with diagnosis groupings, severity and payer.[2] The AHRQ Quality Indicators measure hospital quality and area-level conditions using administrative data.[3] Medicare cost reports provide financial and utilization data for individual hospitals, and in New York hospitals file an Institutional Cost Report with the state.[4][5]
No single source answers the question, but together they show demand, supply, quality and finances.
What are the four signals?
The first signal is demand exceeding local supply: residents’ use rate for a service is higher than local discharges, or waits are long. The second is recapturable outmigration: a large share of area residents travel elsewhere for a service the hospital offers or could add. The third is growth: a service line or age group growing faster than the market, such as an aging population needing more orthopedic or cardiac care. The fourth is competitor gaps: a competitor with weaker quality indicators, long waits or limited capacity.
An invented example: in a three-county area, the over-65 population is growing 3 percent a year; residents have 900 cardiac discharges a year, of which 40 percent are treated in a city 50 miles away; and the nearest competing program reports longer-than-average lengths of stay in its public data. Three signals line up. They suggest the hypothesis that a local cardiac program could capture volume. They do not yet show that it would pay.
How do you test an opportunity?
Apply four tests. Size: how many cases and how much contribution could realistically be captured? Fit: does the opportunity match the hospital’s strengths, staff and strategy? Feasibility: can it recruit the clinicians, secure referrals and obtain approvals? Timing: how long to break even, and what is the risk if volumes fall short? Score each opportunity on these dimensions and rank them.
Test also what could go wrong. Public data can be incomplete: the Department of Health notes that some facilities are not in full compliance with reporting requirements at the time of release.[2] Data lag by a year or more. Patient ZIP codes are approximate. Validate with physicians and payers.
What should you avoid?
Avoid chasing the largest numbers without regard to fit. Avoid treating public charge data as revenue. Avoid assuming that leakage can be fully recaptured. Avoid acting on one year of data. And avoid launching without referral commitments. The interactive example below uses invented figures to show how a short list of opportunities might be ranked.
Frequently asked questions
How can public data identify hospital market opportunities?
By revealing unmet demand, outmigration, growth and competitor gaps, which are then tested with local knowledge and financial analysis.
What public data sources do hospitals use?
HCUP, state discharge data such as SPARCS, AHRQ Quality Indicators, and Medicare and state cost reports.[1][2][3][4]
Is leakage the same as opportunity?
No. Only the part that can be recaptured, given capacity, referrals and economics, is an opportunity.
How reliable is public hospital data?
It is useful but lagged, and the Department of Health notes some facilities may not be in full compliance at release.[2]
How should opportunities be ranked?
By size, fit, feasibility and timing, with explicit assumptions.
What to do next
- List candidate service lines and age groups.
- Check the four signals for each using public data.
- Score size, fit, feasibility and timing.
- Validate the top two or three with physicians and payers.
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.
- Select Oncology and Orthopedics in turn. How large are they relative to each other?
- Ask APIS “What can this data not tell us about profitability?” to see the limits of stage one.
- Use the Scenario tab to see how little a small capture adds, then decide what stage two would need to show.
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
- Agency for Healthcare Research and Quality, HCUP-US Overview (Healthcare Cost and Utilization Project). Accessed October 2026.
- New York State Department of Health, Hospital Inpatient Discharges (SPARCS De-Identified): 2024. Accessed October 2026.
- Agency for Healthcare Research and Quality, AHRQ Quality Indicator Tools for Data Analytics. Accessed October 2026.
- Centers for Medicare & Medicaid Services, Cost Reports. Accessed October 2026.
- New York State Department of Health, Institutional Cost Reports (ICRs). 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.