Hospital price transparency

Hospital price-cell mart

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

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

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

Grain

Key	Grain
N/A	1One row per (CCN, billing_code, payer, plan, LOB, methodology, rate_type) price cell.

Columns (29)

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

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`hospital_ccn`
Join	`how_to_join(source_fqn="vlada_curated.mart_hospital_cell")`
Raw door	Athena (read-only via query_substrate): vlada_curated.mart_hospital_cell
Company names	`payer_name` `payer_parent_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

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