
Rare Agent Work · Open Data Edition
Rev 1.1 · Updated September 21, 2026
What 10.1M hospital price rows reveal about American healthcare pricing
US hospitals are legally required to publish every price they charge — and bury it in files too large to open. This report reads them, and shows you how to check your own hospital in an afternoon.
What this report gives you
The finding that changes your next decision
“The $17,058 sticker price for a CT scan with contrast sits 77x above the best negotiated rate at the same hospital — and until this data was mandated public, no patient could see either number. Transparency without tooling was functionally secrecy.”
Why this report exists
Since 2021, every US hospital must publish a machine-readable file listing its sticker price, cash price, and every insurer-negotiated rate. Compliance is now broad — but the files are deliberately, or at least functionally, unreadable: gigabyte-scale JSON that crashes spreadsheets and browsers. The result is a transparency law that publishes everything and, without tooling, informs no one. We built a streaming parser that turns any hospital's file into a queryable database, and ran it across five hospitals in four states. The verified spreads are far larger than the 2-3x folklore: within one hospital, sticker prices run up to 77x the best per-code negotiated rate for the same procedure, same setting. Across hospitals, identical procedures differ 7-14x in negotiated rates. The entire US hospital price dataset — every hospital in the country — fits on a laptop. The problem is not data availability — Turquoise Health, Serif Health, DoltHub and PatientRightsAdvocate.org all read it at scale. The unsolved problem is maintenance: everything comprehensive is proprietary, and every open dataset we could find is stale.
Honest disqualification. If none of the above matches you, this report was written for you.
Five hospitals' complete price files, normalized and queryable
discover / ingest / query / stats — MIT, runs on a laptop
Every figure reproducible via report_stats.py
How to pull your hospital's real rates before a scheduled procedure
All 4 sections — scroll down to read.
The CMS Hospital Price Transparency rule, in force since 2021 and strengthened for 2026, is one of the most complete disclosure regimes in American healthcare: every hospital must publish, in a machine-readable file, its gross charge, discounted cash price, and every payer-specific negotiated rate for every service. Compliance, after early resistance, is now broad. And it almost doesn't matter, because the median file is hundreds of megabytes of JSON — one we measured is 843 MB, which is larger than the entire text of Wikipedia when it was published. No spreadsheet opens it. No browser renders it. The law delivered the data and the delivery format destroyed the information.
Take a brain MRI with contrast (CPT 70553). At Cedars-Sinai, the sticker price is $15,417 while the per-code negotiated rates insurers actually pay, in the same outpatient setting, run from $445 to $8,675 — a 19.5x spread on the same code, same setting, same building, before any cross-hospital comparison. CT abdomen with contrast at the same hospital: $17,058 sticker against a best negotiated rate of $222 — 77x. A wrist X-ray (CPT 73630) negotiates at $17.30 at UCLA and $469.94 at Providence Washington — 27x across town. Correction in this revision: our first pass reported spreads up to 101.8x, but those maxima traced to flat case rates published identically across hundreds of unrelated codes; Rev 1.1 excludes them, and every number in this section survives that filter. The chargemaster figure that dominates billing disputes is still routinely an order of magnitude above what the system actually transacts at.
2 more sections in this report
What unlocks with purchase:
Same knee, 7.7x price difference
The entire country fits on your laptop
One-time purchase · Instant access · No subscription
Total knee replacement, CPT 27447, outpatient, negotiated rates: $6,121 at Hoag Memorial Hospital Presbyterian in Newport Beach, CA. $47,391 at Ronald Reagan UCLA Medical Center in Los Angeles — 15 miles away. Both are real contracted rates from the hospitals' own files, published as flat case rates covering the full surgical episode — the form in which hospitals typically contract major surgery — rather than per-line negotiated prices. A patient with a high-deductible plan at the second hospital could owe more than six times the entire cash-package price of the first. Cross-hospital variation of this magnitude is the norm in our sample, not the exception: brain MRI negotiated rates span $311 (UCLA) to $4,402 (Providence Washington) across the five institutions.
The five files we parsed total 1.5 GB and 10.1 million rows. There are roughly 6,000 hospitals in the United States. Extrapolating the observed file sizes, the complete national price dataset is on the order of a few hundred gigabytes raw — and compresses to a queryable database well within a single consumer machine. This is the central finding of this report, beyond any specific spread: the engineering excuse for not knowing American hospital prices is over. Any journalist, benefits team, researcher — or patient — can hold the whole market in one database. The parser that proves it is open source, handles both required formats, and ingested the largest file in 34 seconds.
Every claim in this report traces to a verifiable source.
Last reviewed September 21, 2026
Who wrote this, what evidence shaped it, and how the recommendations are framed.
Author: Rare Agent Work · Written and maintained by the Rare Agent Work research team. All prices sourced from hospitals' own CMS-mandated filings.
Proof 1
10.1 million price rows parsed from 5 hospitals' own CMS filings, including both required file formats.
Proof 2
Within-hospital spread: at one hospital a brain MRI with a $15,417 sticker price carries per-code negotiated rates from $445 to $8,675 — a 19.5x gap. Across the five hospitals the span runs $311 to $8,675.
Proof 3
Cross-hospital spread: the same knee replacement (CPT 27447, outpatient) is contracted at $6,121 at one hospital and $47,391 at another — 7.7x. Both are flat case rates covering the full surgical episode, not per-line negotiated prices.
Proof 4
Cash-price honesty varies wildly: one hospital's cash price is 3% of sticker; another's is 100% of sticker.
Powered by Claude — trained on this report's content. Your first question is free.
Ask anything about implementation, setup, or how to apply the concepts in this report. Your first question is free — then we'll ask you to sign in.
Powered by Claude · First question free
When the report isn't enough
Architecture review, implementation rescue, and strategy calls for teams with real blockers. Every intake is read by a human before any next step.