Hospital price transparency

Hospital price rollup by code x state x line of business

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

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Negotiated-rate min / median / max, the Medicare multiple, gross and cash medians, hospital and rate counts, and the count of rows excluded as percent-of-charges or other non-comparable classes, per code, state and program.

Grain

Key	Grain
N/A	1One row per (billing_code, code_system_resolved, hospital_state, line_of_business).

Columns (17)

Column	Type	Meaning
`billing_code`	string
`code_system_resolved`	string
`hospital_state`	string
`line_of_business`	string
`n_hospitals`	bigint
`n_rates`	bigint
`neg_min`	double
`neg_med`	double
`neg_max`	double
`x_med`	double
`gross_med`	double
`cash_med`	double
`cell_vintage`	string
`rollup_vintage`	string
`n_real_negotiated`	bigint
`n_excluded_pct_of_charges`	bigint
`n_excluded_other`	bigint

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`billing_code`
Join	`how_to_join(source_fqn="vlada_curated.mart_code_state_rollup")`
Raw door	Athena (read-only via query_substrate): vlada_curated.mart_code_state_rollup

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