Hospital price transparency

Hospital price comparison mart (answered layer)

vlada_curated.vw_hospital_comparison_mart·live·mart·Hospital Standard Charges (Price Transparency)

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The precomputed answers compare_hospital_rates reads first (p10 / median / p90, n rows, n hospitals, the Medicare multiple and the cheapest window) per code, state, program and methodology family, built from the comparable surface with the tool's own floors and quarantine list.
2Each row carries build_id and as_of.

Grain

Key	Grain
N/A	1One row per (grain_level, code_system, billing_code, hospital_state, line_of_business, billing_class, methodology family, payer parent) statistic, plus the stored cheapest window rows (grain_level = 'cheapest').

Columns (60)

Column	Type	Meaning
`grain_level`	varchar(11)
`code_system`	string
`billing_code`	string
`line_of_business`	string
`billing_class`	varchar(18)
`methodology_family`	varchar(12)
`methodology_norm`	varchar(17)
`payer_parent_name`	string
`n_rows`	bigint
`n_rows_all`	bigint
`n_hospitals`	bigint
`n_hospitals_all`	bigint
`n_payers`	bigint
`n_payers_all`	bigint
`n_below_floor`	bigint
`p10`	double
`median`	double
`p90`	double
`min_rate`	double
`max_rate`	double
`p10_all`	double
`median_all`	double
`p90_all`	double
`min_all`	double
`max_all`	double
`median_rate_over_gross`	double
`ccn_median`	double
`ccn_p10`	double
`ccn_p90`	double
`ccn_n_hospitals`	bigint
`ccn_n_hospitals_fully_excluded`	bigint
`max_parents_sharing_price`	bigint
`max_labels_sharing_price`	bigint
`floor_value`	double
`floor_multiple`	double
`medicare_allowed`	double
`medicare_source`	varchar(19)
`medicare_year`	int
`medicare_bases_json`	string
`median_x_medicare`	double
`quarantine_hash`	varchar(16)
`build_id`	varchar(17)
`as_of`	varchar(17)
`cheapest_rank`	int
`cheapest_bucket`	string
`cheapest_k`	int
`row_hospital_state`	string
`hospital_ccn`	string
`hospital_name`	string
`payer_name`	string
`plan_name`	string
`payer_entity_class`	string
`plan_product_structure`	string
`billing_class_norm`	string
`facility_type`	string
`comparability_reason`	string
`rate`	double
`gross_charge`	double
`cash_price`	double
`hospital_state`	string

Query it

describe_data_source(source_fqn="vlada_curated.vw_hospital_comparison_mart")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.vw_hospital_comparison_mart WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	compare_hospital_rates
Identity key	`billing_code`
Join	`how_to_join(source_fqn="vlada_curated.vw_hospital_comparison_mart")`
Raw door	Athena (read-only via query_substrate): vlada_curated.vw_hospital_comparison_mart
Company names	`payer_name` `payer_parent_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	The answered layer of the hospital price product (docs/architecture/2026-09-25-hospital-price-product.md).

This page as markdown: /docs-md/data/vlada_curated_vw_hospital_comparison_mart.md · every page in one file: /llms-full.txt