Building National Hospital Price Benchmarks

The question

The company needed usable hospital price comparisons from large, inconsistent machine-readable files, together with documentation its engineering team could maintain.

The work

We built a pipeline from a 165-million-row source covering 42 states and approximately 2,450 hospitals. The methodology defined payer normalization, exclusions, comparison rules, and Medicare-based benchmarks. We packaged the pipeline with methodology and integration documentation for the client’s engineering team.

What the client gained

A national benchmarking pipeline and a documented basis for comparing prices. The scale describes the source and coverage of the work, not realized savings. Separate SOC 2 Type 1 readiness work included gap assessment, control design, policy development, and audit preparation.

The filtered pricing dataset contained approximately 11.6 million records. SOC 2 readiness work included development of 15 security policies alongside the control-design and preparation work.

Comparison rules

Payer normalization, facility exclusions, and handling of emergency and professional fees were defined explicitly. Source-file quality and the inclusion rules affect which prices can be compared.