What 482 hospitals charge vs. what insurers pay, from their own files

US hospitals must publish a machine-readable file of their prices, including the rate they've negotiated with each insurer. The files are huge (one is 36GB), in four formats and often messy, so almost nobody reads them.I built a crawler that finds each hospital's official file and pulls out 29 common services. Across 482 hospitals: a moderate ER visit is listed at a median $1,285 while insurers pay $288; a metabolic panel is listed at $207 while insurers pay $11.46.To keep it honest: only per-service fee-schedule dollar rates count (no case rates or percentages, which cover a whole visit), each figure needs at least 3 insurers, and every value is checked against Medicare reference rates. Surgery is excluded because insurer surgery rates cover the whole operation while the list price is one line item. Each hospital page links its source file. Feedback on the methodology is very welcome.

Hacker NewsToolAISource
0Sign in to voteCopy link

FL score

78

out of 100

Verdict

VALIDATE

high confidence

Competition

No competitor data yet

Trend

No signal yet

A tool that extracts and compares hospital list prices versus insurer payments from official files to reveal pricing disparities.

The pain

Hospital pricing is opaque and confusing, making it hard for patients, researchers, and policymakers to understand true costs and negotiate better deals.

The gap

Although hospitals publish price files, their size, format, and complexity prevent meaningful analysis, leaving a transparency gap.

Build angle

Automate crawling and parsing of large, messy hospital price files to extract comparable service-level pricing data and present it clearly with source links.

Strengths

  • Addresses a well-documented, significant transparency problem in healthcare pricing.
  • Uses publicly mandated data sources, ensuring legitimacy and defensibility.
  • Technical solution is feasible with existing tools and can be built by a small team or individual.
  • Provides clear, comparable metrics that highlight large discrepancies between list prices and insurer payments.

Risks

  • Unclear who the paying customers are and how to monetize the tool effectively.
  • Data complexity and variability may limit scalability or accuracy over time.
  • Excludes surgery and other complex billing, which may limit perceived completeness.
  • Potential legal or compliance challenges in republishing or interpreting hospital data.

Questions about this idea?

FlyBot reads the scoring and gives you a second opinion on “What 482 hospitals charge vs. what insurers pay, from their own files”.

Open FlyBot