Skip to content
Iron Horse Analytics— home

Six federal sources · one provider record

You shouldn’t have to rebuild the crosswalk every time.

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.

Explore the data portalTalk to us about a project

No HIPAA-covered data. Every source is a public federal file.

SourcesFY2010 – FY2025
  • HCRIS cost reportsCCN530,904
  • NPPES registryNPI9,606,683
  • Medicare Part BNPI29,197,747
  • Open PaymentsProfile ID43,555,074
  • CMS CompareCCN499,160
  • IRS Form 990EIN1,630,677

One provider record

62,464 providers88,366 facility-years24 derived metrics

Reconciled through provider_npi_xwalk and provider_ein_xwalk.

What’s loaded

The linkage layer, in numbers.

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

SourceKeyed onRecords
HCRIS cost reportsCCN530,904
HCRIS numeric valuesCCN + WKST/LINE/COL496,000,000
NPPES registryNPI9,606,683
Medicare Part BNPI29,197,747
Open PaymentsProfile ID43,555,074
CMS CompareCCN499,160
PECOS affiliationsNPI ↔ CCN2,260,146
IRS Form 990EIN1,630,677

Derived metric layer covers FY2010 – FY2025

The product

Healthcare Data

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.

Create your accountSee what’s inside
Report142 facility-years
State: ORType: Short-term acuteFY 2023 – 2024Margin < 0
FacilityFYNet revenueOp. marginMedicare days
Valley General Hospital2024412,908,116−2.4%38.1%
St. Anselm Medical Center2024288,441,027−0.9%44.6%
Riverbend Community Hospital202396,225,480−5.7%51.2%
Cascade Regional Medical2024654,113,902−1.2%35.8%
Portal preview · sample rows

  • Build a report from filters, not SQL

    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.

  • Search by radius, county, or state

    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.

  • Facility profiles with multi-year trends

    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.

  • CSV export on every result set

    Whatever you can see, you can take. Identity columns plus all 24 metrics, in the same shape your model already reads.

Subscription

One price, the whole record.

Every subscription gets the full linked dataset — no metering by dataset, no per-seat surcharge on the data itself.

See plansConsulting instead

Monthly

$1,000/mo

Full access, cancel anytime

Best value

Annual

$11,000/yr

Save $1,000 against monthly

Engagements

When the portal can’t express the question.

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.

A team of analysts working through a problem around a boardroom table

Custom data extracts & analysis

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.

  • Cohort construction across the full source layer, not just the published views
  • Entity matching against your own provider, client, or prospect lists
  • Peer-group and market benchmarking with a defined comparison set
  • Delivery as CSV, Parquet, or a table loaded into your warehouse
How this works

Reimbursement & cost report advisory

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.

  • Worksheet-level interpretation of filed reports, by fiscal year and form version
  • IME, GME, and DSH computation, review, and reconciliation
  • Medicare reimbursement modelling across multi-year fiscal periods
  • Checks against filed values, amendment history, and settlement status
How this works

How we work

Built to be checked, not taken on faith.

  • Every number traces to a file

    Each metric carries where it came from — source, worksheet, line, column, fiscal year. You can check our work, and the good clients do.

  • No black boxes

    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.

  • Public data only

    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

Two ways in.

Subscribe to the portal

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 account

Bring us the problem

Tell 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