# Hospital price-cell mart

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

The hospital price-cell serving mart — one materialized cell per (hospital, code, payer, plan, line_of_business, methodology, rate_type) with the rate. The precomputed serving grain for hospital price answers.

**Grain.** One row per (CCN, billing_code, payer, plan, LOB, methodology, rate_type) price cell.

| column | type | meaning |
|---|---|---|
| hospital_ccn | string |  |
| hospital_name | string |  |
| billing_code | string |  |
| code_system_resolved | string |  |
| code_system_precision | string |  |
| billing_class_resolved | string |  |
| payer_parent_name | string |  |
| payer_name | string |  |
| plan_name | string |  |
| line_of_business | string |  |
| methodology_norm | string |  |
| rate_type | string |  |
| payment_grain | string |  |
| grain_confidence | string |  |
| rate | double |  |
| gross_charge | double |  |
| cash_price | double |  |
| x_medicare | double |  |
| negotiated_pct | double |  |
| negotiated_algo | string |  |
| derived_amount | double |  |
| derived_amount_basis | string |  |
| code_gross | double |  |
| n_payers | bigint |  |
| n_rates | bigint |  |
| comparability_class | string |  |
| comparability_reason | string |  |
| cell_vintage | string |  |
| hospital_state | string |  |

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