Hospital price transparency

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

vlada_curated.mart_code_state_payer_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, and hospital, plan and rate counts per code, state, payer parent and program, with the counts of rows excluded as non-comparable.

Grain

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

Columns (17)

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

describe_data_source(source_fqn="vlada_curated.mart_code_state_payer_rollup")     # the card, live
query_substrate(sql="SELECT * FROM vlada_curated.mart_code_state_payer_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_payer_rollup")`
Raw door	Athena (read-only via query_substrate): vlada_curated.mart_code_state_payer_rollup
Company names	`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_code_state_payer_rollup.md · every page in one file: /llms-full.txt