Explore lab test prices from the Transparency in Coverage Act

We're working on making all the data from the Transparency in Coverage Act open source to whatever extent possible.

I wrote here about our efforts to make this work and what we found: https://news.ycombinator.com/item?id=34445914

The following query will return all the prices for the billing code 85032 (manual red blood cell count) that are greater than $10:

> select npi, reporting_entity_name, reporting_entity_type, negotiated_rate from npi_rate join (select id, insurer_id, negotiated_rate from rate where ( (code_id in (select id from code where billing_code = 85032)) and (negotiated_rate)) y on y.id = npi_rate.rate_id inner join insurer on insurer.id = insurer_id order by negotiated_rate;

This is being built as we speak and will slowly grow over the next few weeks. You can join the effort in building it or you can explore and tell me what you find. alec@dolthub.com