Public Data
Everything on the app's Public Data page from your assistant - hospital prices, Medicare and Medicaid volumes, insurers' published rates - one tool per table, and every CSV download.
The app's Public Data page has six tabs: Price Transparency, Medicare by State, Medicare by Metro, Medicare by Hospital, Dental, and Payer Rates. Each table, picker and download on it is a tool here, and the data is the same. Nothing needs setting up. Ask a question and your assistant picks the tool. public_sections lists them all.
Say something like:
What do Atlanta hospitals charge for a colonoscopy, and how many does Medicare pay for in the Atlanta metro? Send me the full list as a CSV.
What each part returns
| Tab | Component | Tool | What it returns |
|---|---|---|---|
| All tabs | About this data | describe_coverage | The states, years and source links of every dataset |
| All tabs | Search box | search_codes | A description turned into codes, most-used first |
| Price Transparency | Hospital picker | find_hospitals | Hospitals with a price file, by name, state, metro, ZIP, beds or distance |
| Price Transparency | Charges table | search_price_transparency | Each hospital's gross, cash and negotiated prices per code |
| Price Transparency | Source-file icon | public_hospital_source_file | A link to our copy of the hospital's price file |
| Price Transparency | Download all (CSV) | public_export_charges | Every matching charge line |
| Medicare by State | Procedures and inpatient table | browse_utilization (hcpcs, drg) | Medicare volumes and payments by state |
| Medicare by Metro | Metro picker | find_metro | Metro areas by name, ZIP or state |
| Medicare by Metro | Metro table | browse_utilization (hcpcs_msa) | Medicare procedures by metro, with the per-hospital estimate |
| Medicare by Hospital | Inpatient table | browse_utilization (drg_provider) | Each hospital's own DRG discharges |
| Dental | Year and category filters | public_utilization_facets | The years and CDT categories a dataset has |
| Dental | CDT table, under-19 rate series | browse_utilization (cdt, dental_category) | Medicaid dental volumes and paid amounts |
| Medicare and Dental | Download all (CSV) | public_export_utilization | Every matching utilization row |
| Payer Rates | What we have | payer_rates_overview | Which states and insurers we hold published rates for |
| Payer Rates | Hospitals explorer | search_payer_rates | Each insurer's published rates for hospitals and codes |
| Payer Rates | A hospital's own rates, every plan | get_hospital_payer_rates | Every payer and plan rate in the hospital's own file |
| Payer Rates | Providers picker | find_providers | Practices, groups and doctors by name, NPI or TIN |
| Payer Rates | Providers, Rows | search_provider_rates | Insurers' rates for named providers and codes |
| Payer Rates | Providers, Compare | compare_provider_rates | Code by provider, one column per payer family |
| Payer Rates | Download all (CSV) | public_export_payer_rates, public_export_provider_rates | The explorer's rows, or the compare table |
Medicare and Medicaid figures come from different payers. Every row says which, and the tools never add them together.
Free and paid
| Free | Public Data | Insurer-rates add-on | |
|---|---|---|---|
| Index, coverage, codes, pickers, filters, payer overview | Yes | Yes | Yes |
| Price and utilization tables | First 8 rows (hospital prices: gross and cash only) | Every row | |
| Downloads and the price file | No | Yes | |
A hospital's own rates, every plan (get_hospital_payer_rates) | First 8 rows, no dollar figures | Every row | |
| Insurers' published rates | First 8 rows, no dollar figures | First 8 rows, no dollar figures | Every row and the downloads |
A metro or hospital grant opens the price tables for that metro or hospital only. A locked result carries a subscribe link to the upgrade page. See Plans & access.
Your data (Data Sources)
The team's own data from a conversation - providers and health systems, rate tables and CDMs, volume and cost datasets, payers, fee-schedule import audits, contracts and files, one tool per component.
Plans & access
What a free account sees, what the full data adds for client work, and how to turn it on.