Public Data
The index of the Public Data page, the explorer filters, a hospital's price file, and every table's CSV download.
These tools sit beside the row tools (Prices, Utilization, Payer rates, Hospitals) and cover what those don't: the index of the app's Public Data page, the dental filters, our copy of a hospital's price file, and the "Download all (CSV)" of every table. Each download is a short link that works for one hour.
public_sections
Every component of the Public Data page and the tool that returns it. Free.
| Parameter | Type | Default | What it does |
|---|
public_utilization_facets
The years (newest first) and, for dental codes, the service categories a utilization dataset has. Free.
| Parameter | Type | Default | What it does |
|---|---|---|---|
dataset | hcpcs | drg | hcpcs_msa | drg_provider | cdt | dental_category | required | Which CMS or Medicaid utilization table to read. |
public_hospital_source_file
A link to our mirrored copy of a hospital's price file. It keeps working after the hospital's own link dies. Needs Public Data.
| Parameter | Type | Default | What it does |
|---|---|---|---|
hospital_id | string | required | One hospital id (UUID), as returned by find_hospitals. |
public_export_utilization
Every matching row of a Medicare or Medicaid utilization table as a CSV. Same filters as browse_utilization. Needs Public Data.
| Parameter | Type | Default | What it does |
|---|---|---|---|
category | string | none | Dental category. |
codes | list of string | none | CPT, HCPCS or MS-DRG codes to look up. |
dataset | hcpcs | drg | hcpcs_msa | drg_provider | cdt | dental_category | required | Which CMS or Medicaid utilization table to read. |
dir | asc | desc | none | Sort direction, asc or desc. |
hospital | string | none | A hospital CCN or name, or a metro or hospital id for the dataset you picked. |
metro | string | none | Metro area (CBSA) code, 5 digits, for example 12060 for Atlanta. Find it with find_metro. |
pos | F | O | none | Place of service. |
q | string | none | Search the service description, up to 200 characters. |
sort | string | none | Column to sort by. |
state | string | none | Two-letter US state, for example FL. A state on its own is not enough: add codes, apc, q or hospital_ids. |
year | string | none | Data year. |
public_export_charges
Every matching hospital charge line as a CSV, up to 250,000 rows. Same filters as search_price_transparency. Needs Public Data.
| Parameter | Type | Default | What it does |
|---|---|---|---|
apc | list of string | none | APC codes (Medicare outpatient payment groups). |
code_type | CPT | HCPCS | MS-DRG | APC | none | Only lines of this code type. |
codes | list of string | none | CPT, HCPCS or MS-DRG codes to look up. |
hospital_ids | list of string | none | Up to 25 hospital ids (UUIDs), as returned in the hospital_id field of earlier rows. |
priced_only | boolean | true | Hide lines that have no price. On by default. |
q | string | none | Search the service description, up to 200 characters. |
setting | inpatient | outpatient | none | Only inpatient or only outpatient lines. |
state | string | none | Two-letter US state, for example FL. A state on its own is not enough: add codes, apc, q or hospital_ids. |
public_export_payer_rates
Insurers' published rates for hospitals and codes as a CSV. Same filters as search_payer_rates. Needs the insurer-rates add-on.
| Parameter | Type | Default | What it does |
|---|---|---|---|
codes | list of string | none | CPT, HCPCS or MS-DRG codes to look up. |
hospital_ids | list of string | none | Up to 25 hospital ids (UUIDs), as returned in the hospital_id field of earlier rows. |
payer | string | none | Only this insurer, as named in the data. |
state | string | required | Two-letter US state, for example FL. A state on its own is not enough: add codes, apc, q or hospital_ids. |
public_export_provider_rates
Insurers' published rates for named providers as a CSV: the rows, or with compare=true the table with one column per payer family. Needs the insurer-rates add-on.
| Parameter | Type | Default | What it does |
|---|---|---|---|
billing_class | professional | institutional | professional | professional or institutional. |
codes | list of string | required | CPT, HCPCS or MS-DRG codes to look up. |
compare | boolean | false | |
family | string | none | Only this payer family. |
state | string | required | Two-letter US state, for example FL. A state on its own is not enough: add codes, apc, q or hospital_ids. |
tins | list of string | required | Up to 25 provider tax ids (TIN), as returned by find_providers. |
Your data
The data_* tools - the Data Sources index, owners, rate tables and CDMs, datasets, payers, fee-schedule imports, contracts, files, connectors and monitors.
Benchmark a fee schedule
Hand your assistant a client's fee schedule and get back a rate benchmarking study against similar nearby hospitals, with the workbook and PDF you would have built by hand.