Since 2021, U.S. hospitals must publish their full price lists — but they bury them in unreadable 600 MB files. Phanera parses those federal price-transparency files from 11 Richmond hospitals and turns them into a simple tool: pick a procedure, see what every hospital charges, ranked cheapest to most expensive. Same procedure, same city, prices that differ by thousands.
VCU's price file is 648 MB; reading it whole would exhaust the heap. A token-by-token Jackson streaming parser walks to the charge array and reads one item at a time, filtering to the ~22 shoppable procedures — bounded memory regardless of file size.
HCA and VCU publish the identical CMS v3.0.0 JSON shape, so one JSON parser plus one CSV parser (Bon Secours) cover every system. The tedious per-hospital normalization is the moat — funded players stay shallow nationally; Phanera goes deep on one metro.
Raw files hold tens of thousands of rows (every screw, drug, supply). Keeping only rows whose CPT/HCPCS code is a shoppable procedure means the database holds a few thousand useful rows, not millions.