Hospital price transparency

CMS Care Compare Hospital General Information (overall star rating per CCN)

medicare_silver.dim_hospital_quality·live·dim

Rows

5,432

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The compact hospital quality summary from CMS Care Compare "Hospital General Information": one row per CCN with the headline overall star rating (1-5), hospital type, ownership, emergency-services flag, and birthing-friendly designation.
2The quality spine; per-measure detail lives in fact_hospital_quality_measure.

Grain

Key	Grain
N/A	1One row per Medicare-certified hospital (by CCN) — overall star rating + type + ownership.

Columns (29)

Column	Type	Meaning
`ccn`	string
`facility_name`	string
`city`	string
`state_cd`	string
`zip_cd`	string
`county_parish`	string
`hospital_type`	string
`hospital_ownership`	string
`emergency_services`	boolean
`birthing_friendly`	string
`overall_rating`	int
`overall_rating_footnote`	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
`latitude`	double
`longitude`	double

Query it

describe_data_source(source_fqn="medicare_silver.dim_hospital_quality")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.dim_hospital_quality 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.dim_hospital_quality")`
Raw door	Athena (read-only via query_substrate): medicare_silver.dim_hospital_quality
Note	Iceberg table medicare_silver.dim_hospital_quality, partitioned by state_cd; replace supersession (idempotent by SHA-256). Ingested by the same build-hospital-quality runner as the measure fact.

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