Hospital price transparency

CMS Care Compare Hospital Quality Measures (mortality / readmissions / timely / infections / imaging / maternal)

medicare_silver.fact_hospital_quality_measure·live·silver

Rows

510,084

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Long-format hospital quality measures from the CMS Provider Data Catalog (Care Compare), unioned across SIX source datasets into one fact, partitioned by measure_source: "Complications and Deaths" (mortality + complication rates), "Unplanned Hospital Visits" (readmission / ED-return rates), "Timely and Effective Care" (timeliness), "Healthcare Associated Infections" (HAI / SIR), "Outpatient Imaging Efficiency" (appropriate-imaging measures), and "Maternal Health" (maternal-care measures).
2Each row carries the raw score string + a parsed score_numeric, plus compared-to-national, denominator/sample, lower/higher estimate, footnote, and the measurement start/end dates.
3The QUALITY axis joinable by CCN to the hospital chargemaster spine — i.e. expensive-and-low-quality detection.

Grain

Key	Grain
N/A	1One row per (measure_source, hospital CCN, measure_id) — the measure score + bounds.

Columns (33)

Column	Type	Meaning
`measure_source`	string
`ccn`	string
`facility_name`	string
`state`	string
`county_parish`	string
`measure_id`	string
`measure_name`	string
`condition`	string
`score`	string
`score_numeric`	double
`compared_to_national`	string
`denominator`	string
`sample`	string
`lower_estimate`	double
`higher_estimate`	double
`footnote`	string
`start_date`	string
`end_date`	string
`observed_period`	date
`asserted_at`	date
`effective_period_start`	date
`effective_period_end`	date
`cms_vintage_sequence`	int
`parse_revision`	int
`parser_artifact_hash`	string
`source_url`	string
`sha256_content_hash`	string
`source_id`	string
`is_current`	boolean
`bronze_object_key`	string
`s3_version_id`	string
`vintage_tag`	string
`drug_source_version_id`	string

Query it

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

Item	Value
Typed tools that read it	get_hospital_quality
Identity key	`ccn`
Join	`how_to_join(source_fqn="medicare_silver.fact_hospital_quality_measure")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_hospital_quality_measure
Note	Iceberg table medicare_silver.fact_hospital_quality_measure, partitioned by measure_source; one source dataset fully restates its partition (replace, idempotent by SHA-256). One runner downloads all six by title.

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