Hospital price transparency

Hospital chargemaster + payer-specific rates (HPT)

vlada_curated.fact_hospital_chargemaster·live·curated·Hospital Standard Charges (Price Transparency)

Rows

4,350,000,000

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Cleaned hospital prices extracted from CMS Hospital Price Transparency machine-readable files.
2Gross / cash / min / max / payer_specific + v3.0 allowed-amount percentile charge types.

Grain

Key	Grain
N/A	1One row per (CCN, payer_name, plan, code, code_type, methodology, charge_type) at the file snapshot.

Columns (98)

Column	Type	Meaning
`rate_id`	string
`hospital_ccn`	string
`hospital_name`	string
`hospital_state`	string
`billing_code`	string
`code_system`	string
`alt_codes_hash`	string
`code_1`	string
`code_1_type`	string
`code_2`	string
`code_2_type`	string
`code_3`	string
`code_3_type`	string
`code_4`	string
`code_4_type`	string
`code_5`	string
`code_5_type`	string
`description`	string
`payer_name`	string
`plan_name`	string
`rate_type`	string
`rate`	double
`min_rate`	double
`max_rate`	double
`billing_class`	string
`setting`	string
`modifiers`	string
`additional_info`	string
`collected_at`	string
`code_valid`	boolean
`gross_charge`	double
`cash_price`	double
`methodology`	string
`negotiated_pct`	double
`negotiated_algo`	string
`estimated_amount`	double
`drug_unit`	string
`drug_type`	string
`median_amount`	double
`tenth_percentile`	double
`ninetieth_percentile`	double
`allowed_count`	bigint
`version_id`	string
`source_files`	array<string>
`loaded_at`	timestamp
`methodology_statement`	string
`lookback_window_start`	date
`lookback_window_end`	date
`attestation_statement`	string
`confirm_attestation`	boolean
`attester_name`	string
`attester_title`	string
`npi_type2`	array<string>
`cms_hpt_txt_probed`	boolean
`cms_hpt_txt_url`	string
`homepage_footer_link_present`	boolean
`content_sha256`	string
`parser_version`	string
`mrf_schema_version`	string
`fetched_at`	timestamp
`raw_s3_key`	string
`pbd_npi`	string
`is_off_campus_pbd`	boolean
`parent_ccn`	string
`mrf_version_id`	string
`rate_outlier_flag`	string
`observed_period`	date
`asserted_at`	date
`effective_period_start`	date
`effective_period_end`	date
`asserted_at_source`	string
`calculation_epoch`	date
`vintage`	string
`cms_vintage_sequence`	int
`parse_revision`	int
`restatement_of`	string
`is_current`	boolean
`snapshot_set`	string
`s3_version_id`	string
`bronze_object_key`	string
`sha256_content_hash`	string
`source_lineage`	string
`parent_vintage_fingerprint`	string
`source_id`	string
`source_url`	string
`parser_artifact_hash`	string
`ingested_at`	timestamp
`count_of_compared_rates`	bigint
`additional_payer_notes`	string
`footnote`	string
`cbsa_code`	string
`chain_parent_id`	string
`payer_canonical_id`	string
`percentage_source`	string
`fact_builder_version`	string
`payment_grain`	string
`grain_confidence`	string
`allowed_count_band`	string	CMS per-payer allowed-count enum: 0 \| 1 through 10 \| count >=11 as digits. NULL = absent, invalid, or row built before migration 034.

Query it

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

Item	Value
Typed tools that read it	plan_hospital_price, prove_hospital_price, replay_hospital_price, state_expert
Identity key	`hospital_ccn`
Join	`how_to_join(source_fqn="vlada_curated.fact_hospital_chargemaster")`
Raw door	query_substrate (read-only SQL, the as-filed layer): vlada_curated.vw_fact_hospital_chargemaster_current (or this fact with is_current); hospital_state is required. Typed recipe: compare_hospital_rates.
Company names	`payer_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	5,224 hospitals served 2026-09-25 (4.56B current rows); 2,389 on the fixed build (fact_builder_version hospital_fact_v4c). v3.0 enforced 2026-04-01.

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