Hospital price transparency

Hospital chargemaster — canonical view

vlada_curated.vw_fact_hospital_chargemaster_canonical·live·semantic_view

Rows

N/A

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Canonical hospital-chargemaster view: resolved code system, payer/plan, rate type, billing class, rate, gross charge.
2The canonicalized rate surface (broader than _comparable; before the comparability filter).

Grain

Key	Grain
N/A	1One row per canonical hospital rate (CCN, billing_code, payer, plan).

Columns (43)

Column	Type	Meaning
`hospital_ccn`	string
`hospital_name`	string
`hospital_state`	string
`billing_code`	string
`code_system`	string
`code_system_resolved`	string
`code_system_precision`	varchar(14)
`payer_name`	string
`plan_name`	string
`rate_type`	string
`billing_class`	string
`rate`	double
`gross_charge`	double
`cash_price`	double
`methodology`	string
`methodology_norm`	varchar(17)
`payment_grain`	string
`grain_confidence`	string
`negotiated_pct`	double
`negotiated_algo`	string
`estimated_amount`	double
`median_amount`	double
`allowed_count`	bigint
`billing_code_comparable`	string
`billing_code_precision`	varchar(14)
`billing_class_norm`	varchar(13)
`billing_class_resolved`	varchar(13)
`billing_class_source`	varchar(21)
`billing_class_learned_inst_frac`	double
`payer_canonical_id`	string
`payer_parent_name`	string
`payer_entity_class`	string
`payer_match_method`	string
`line_of_business`	string
`plan_product_structure`	string
`plan_classify_method`	string
`plan_classify_confidence`	double
`plan_label_scope`	varchar(16)
`build_vintage`	string
`fact_builder_version`	string
`on_fixed_build`	boolean
`state_certification`	varchar(15)
`state_certified`	boolean

Query it

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

Item	Value
Typed tools that read it	compare_hospital_rates, coverage_status
Identity key	`hospital_ccn`
Join	`how_to_join(source_fqn="vlada_curated.vw_fact_hospital_chargemaster_canonical")`
Raw door	Athena (read-only via query_substrate): vlada_curated.vw_fact_hospital_chargemaster_canonical
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_vw_fact_hospital_chargemaster_canonical.md · every page in one file: /llms-full.txt