PricePortal: an open multi-state corpus of hospital price transparency machine-readable files for California and Indiana

PricePortal is an open, reproducible corpus harmonizing federal Hospital Price Transparency (HPT) machine-readable files (MRFs) for 528 Medicare-certified hospitals in California and Indiana with Medicare OPPS/MPFS benchmarks and ZIP-level community-risk variables. This deposit contains 16 analysis-grade parquet files plus a data dictionary and SHA-256 manifest (6.42 GB total) covering: (1) gross + cash chargemaster prices (305M rows, 478 hospitals); (2) payer-specific negotiated rates (417M rows, 411 hospitals); (3) Medicare CPT/HCPCS benchmark (9,709 codes, OPPS preferred + MPFS fallback); (4) hospital×code price-to-Medicare ratio panel (1,528,609 rows, four price types per row); (5) state and per-payer summary tables; (6) Wang 2023 within-hospital correlation replication, with a schema-stratified disambiguation test (kaiser_2023, misc_csv, §180 v1.x/v2.x/v3.x) and a discounter-threshold sensitivity analysis (5%, 15%, 30%); (7) Chang & Psek 2024 ZIP-level socioeconomic gradient extension (257 hospital ZIPs; pooled cash-ratio βlog_inc=−0.96, p=0.063); (8) hospital identity crosswalk (CCN ↔ OSHPD ↔ NPI ↔ EIN, 528 hospitals; 95.6% NPI coverage); (9) Indiana ZIP-level ACS 2024 5-year demographics and CDC PLACES health outcomes.
Headline findings. Median chargemaster-to-Medicare ratio is 3.92× in California vs 2.19× in Indiana; cash 1.42× vs 0.90×; minimum-negotiated 0.95× vs 0.55×, consistent with Indiana HEA 1004's Medicare-repricing benchmark. Within hospital, the gross–cash log-correlation is ≈1.0 across every MRF schema bucket — including pre-§180 Kaiser legacy chargemasters and custom non-§180 formats — weighing decisively against a v3-template encoding-artifact explanation.
See DATA_DICTIONARY.md for full schema, provenance, and caveats per file. File integrity is verifiable via MANIFEST.sha256.
Source code: iupui-soic/mrf-pricing-research. Public portal: pricingapp.streamlit.app.