Hospital price transparency

CMS Hospital-Acquired Condition Reduction Program (HACRP)

medicare_silver.fact_hacrp·live·silver

Rows

3,055

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The CMS HAC Reduction Program hospital file.
2It carries PSI-90, CLABSI, CAUTI, SSI, CDI, and MRSA values and standardized scores, the Total HAC Score, and whether the hospital receives the one-percent Medicare payment reduction.

Grain

Key	Grain
N/A	1One row per (fiscal_year, hospital CCN) with PSI-90, five HAI measures, Total HAC Score, and payment-reduction status.

Columns (51)

Column	Type	Meaning
`fiscal_year`	int
`ccn`	string
`facility_name`	string
`state`	string
`psi_90_composite_value_footnote`	string
`psi_90_w_z_footnote`	string
`psi_90_start_date`	string
`psi_90_end_date`	string
`clabsi_sir_footnote`	string
`clabsi_w_z_footnote`	string
`cauti_sir_footnote`	string
`cauti_w_z_footnote`	string
`ssi_sir_footnote`	string
`ssi_w_z_footnote`	string
`cdi_sir_footnote`	string
`cdi_w_z_footnote`	string
`mrsa_sir_footnote`	string
`mrsa_w_z_footnote`	string
`hai_measures_start_date`	string
`hai_measures_end_date`	string
`total_hac_score_footnote`	string
`payment_reduction`	string
`payment_reduction_footnote`	string
`psi_90_composite_value`	double
`psi_90_w_z_score`	double
`clabsi_sir`	double
`clabsi_w_z_score`	double
`cauti_sir`	double
`cauti_w_z_score`	double
`ssi_sir`	double
`ssi_w_z_score`	double
`cdi_sir`	double
`cdi_w_z_score`	double
`mrsa_sir`	double
`mrsa_w_z_score`	double
`total_hac_score`	double
`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_hacrp")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_hacrp WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`fiscal_year,ccn`
Join	`how_to_join(source_fqn="medicare_silver.fact_hacrp")`
Raw door	Athena (read-only): medicare_silver.fact_hacrp
Note	FY2026 is live at 3055 rows and 3055 unique CCNs with zero duplicate FY+CCN keys or required-lineage nulls. Exact replay returned IDEMPOTENT_SKIP. Current rows overlap 3045 hospital-quality CCNs and 3050 hospital-price-spine CCNs.

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