# Hospital price rollup by code x state x payer parent x line of business

`vlada_curated.mart_code_state_payer_rollup` · Hospital price transparency · status live

Negotiated-rate min / median / max, the Medicare multiple, and hospital, plan and rate counts per code, state, payer parent and program, with the counts of rows excluded as non-comparable.

**Grain.** One row per (billing_code, code_system_resolved, hospital_state, payer_parent_name, line_of_business).

| column | type | meaning |
|---|---|---|
| billing_code | string |  |
| code_system_resolved | string |  |
| hospital_state | string |  |
| payer_parent_name | string |  |
| line_of_business | string |  |
| n_hospitals | bigint |  |
| n_plans | bigint |  |
| n_rates | bigint |  |
| neg_min | double |  |
| neg_med | double |  |
| neg_max | double |  |
| x_med | double |  |
| cell_vintage | string |  |
| rollup_vintage | string |  |
| n_real_negotiated | bigint |  |
| n_excluded_pct_of_charges | bigint |  |
| n_excluded_other | bigint |  |

Query it: `query_substrate` with `SELECT ... FROM vlada_curated.mart_code_state_payer_rollup WHERE ... LIMIT 100`; read `describe_data_source("vlada_curated.mart_code_state_payer_rollup")` first.