Six federal datasets · one provider record
Iron Horse Analytics links HCRIS cost reports, NPPES, Medicare Part B, Open Payments, CMS Compare, and IRS Form 990 into one provider record — available as a subscription portal, or as an engagement with our analysts.
No HIPAA-covered data. Every source is a public federal file.
One provider record
62,464 providers88,366 facility-years24 derived metrics
Reconciled through provider_npi_xwalk and provider_ein_xwalk.
Advise hospitals? See how reimbursement consultants screen hospitals, research prospects, and benchmark clients with the portal, and where its figures need care.
What’s loaded
Not a roadmap. This is what is loaded, reconciled, and queryable today — every figure below is the row count from our own load ledger.
62,464
Medicare-certified providers
providers
88,366
Facility-years of derived metrics
provider_metrics
24
Derived financial metrics per facility-year
metrics_config
16
Federal source files reconciled
load_manifest
| Source | Keyed on | Records | |
|---|---|---|---|
| HCRIS cost reports | CCN | Filed report headers, fiscal periods, settlement status | 530,904 |
| HCRIS numeric values | CCN + WKST/LINE/COL | Every reported figure, addressed by worksheet coordinate | 496,000,000 |
| NPPES registry | NPI | Provider identity, taxonomy, practice locations | 9,606,683 |
| Medicare Part B | NPI | Service-line utilization and allowed amounts | 29,197,747 |
| Open Payments | Profile ID | Industry transfers of value, research, ownership | 43,555,074 |
| CMS Compare | CCN | Quality and star ratings across five care settings | 499,160 |
| PECOS affiliations | NPI ↔ CCN | The clinician-to-facility edge list | 2,260,146 |
| IRS Form 990 | EIN | Nonprofit financials, Schedule H community benefit | 1,630,677 |
Derived metric layer covers FY2010 – FY2025
The product
A subscription portal for analysts who would rather query than clean. Screen every Medicare-certified provider on identity and on derived financials in the same pass, then take the result set with you.
| Facility | FY | Net revenue | Op. margin | Medicare days |
|---|---|---|---|---|
| Valley General Hospital | 2024 | 412,908,116 | −2.4% | 38.1% |
| St. Anselm Medical Center | 2024 | 288,441,027 | −0.9% | 44.6% |
| Riverbend Community Hospital | 2023 | 96,225,480 | −5.7% | 51.2% |
| Cascade Regional Medical | 2024 | 654,113,902 | −1.2% | 35.8% |
Screen every Medicare-certified provider on identity and on derived financial metrics at once — ownership, facility type, fiscal year range, and thresholds on any of the 24 metrics.
Anchor on a facility and pull everything within a set distance, plotted on a map with the full result set behind it. Service-area work stops being a geocoding project.
Net revenue, operating margin, Medicare day share, and bad debts for a single provider across its filed years, with year-over-year movement and payer mix.
Whatever you can see, you can take. Identity columns plus all 24 metrics, in the same shape your model already reads.
Decision tools
The data is the foundation. On top of it sit guided tools for the reimbursement decisions that depend on it. The first two are included in every subscription; a third is on the way.
Should this hospital apply to move wage areas?
A four-step model for the Medicare Geographic Classification Review Board decision: enter a CCN, pick target areas, and see eligibility and the payment effect of each, net of cost.
How exposed is this hospital's DSH payment?
Trend each filed year against the 15% threshold, model a Medicaid-days scenario, and produce a report with the actions that follow from it.
Is this hospital's 340B status at risk?
An early-warning screen that tests a hospital's filed DSH adjustment percentage against the 340B thresholds, shows how much cushion it has, and flags when a new filing puts eligibility at risk.
Built on the DSH analysis. A screening aid, not an eligibility determination: HRSA decides eligibility.
Subscription
Every subscription gets the full linked dataset and both decision tools, MGCRB reclassification and DSH analysis — no metering by dataset, no per-seat surcharge on the data itself.
Monthly
$1,000/mo
Full access, cancel anytime
Annual
$11,000/yr
Save $1,000 against monthly
Engagements
Most of our clients are consultants and analysts who already know this data exists. They come to us for the part that takes years to learn — which file actually answers the question, and what the answer means once you have it.
The cohorts the filters can't build and the joins the schema doesn't ship.
The portal answers the questions we anticipated. When yours falls outside them, we work against the full warehouse — all 40 tables, including the cold layers the portal never surfaces — and hand back a dataset built to your specification.
HCRIS is 496 million numeric values addressed by worksheet, line, and column. We read it for a living.
Cost report work goes wrong in specific, repeatable ways: the wrong worksheet version for the fiscal year, an amended report silently superseding a settled one, a line that moved between form revisions. We know where those are.
The portal models the decision. We help you make the filing.
MGCRB applications and DSH appeals turn on judgement the model can't supply: which target area is defensible, which filed figures will be challenged, and what to do when the number is close to a threshold. We work from the same model you can run yourself, so you see our reasoning.
How we work
Each metric carries where it came from — source, worksheet, line, column, fiscal year. You can check our work, and the good clients do.
We hand over the method alongside the result. If we built a crosswalk or a cohort definition for you, it's yours to keep and re-run.
Every source is a public federal file. Nothing we touch is HIPAA-covered, so nothing here has to wait on your privacy review.
Where to start
Run your own reports against the linked provider record, as often as you like. Best when you know the question and want the data yourself.
Create your accountTell us what you’re trying to answer and we’ll tell you whether the data supports it, what it would take, and what it costs — before you commit.
Start a conversation
