Inpatient Psychiatric Facility Quality Measure Data - by State

This dataset includes state-level data for quality measures included under the IPFQR program, including HBIPS, SUB, TOB, Transition Record (TR), Screening for…

Part of the CMS Data Feeds Dataset › Medicare

Dataplex delivers this CMS feed as the analysis-ready table DWV.INPATIENT_PSYCHIATRIC_FACILITY_QUALITY_MEASURE_DATA__BY_STATE on Snowflake and Databricks — six snapshot releases spanning 2024–2026, aligned to a single schema, refreshed automatically whenever CMS publishes a new file. Every row carries lineage back to the exact CMS source file that produced it.

Key facts

Snowflake	DWV.INPATIENT_PSYCHIATRIC_FACILITY_QUALITY_MEASURE_DATA__BY_STATE
Databricks	cms_dwv.inpatient_psychiatric_facility_quality_measure_data__by_state
Update pattern	Full-refresh — each file replaces the prior snapshot
CMS published	2026-04-21
Loaded	2026-05-15
Columns	53 data + 6 lineage
File versions	6
License	CMS public data — U.S. Government work
Platforms	Snowflake Marketplace · Databricks Delta Sharing

Included in the CMS Data Feeds Dataset — start a free trial on Snowflake Marketplace.

Current — CMS last published this feed on 2026-04-21. Coverage runs through 2026-04-21. Next CMS release expected ~Jul 2026.

Full-refresh feed — each file version is a complete snapshot and newer files supersede older ones. Filter to the latest file (see the sample query) to avoid double-counting across versions.

Sample queries

Snowflake

-- Latest snapshot only (avoids double-counting across file versions)
SELECT *
FROM DWV.INPATIENT_PSYCHIATRIC_FACILITY_QUALITY_MEASURE_DATA__BY_STATE
WHERE FILE_ID IN (
  SELECT ID FROM DWV.FEEDS_FILES WHERE IS_LATEST = 1
)
LIMIT 100;

Databricks

About this feed

This dataset includes state-level data for quality measures included under the IPFQR program, including HBIPS, SUB, TOB, Transition Record (TR), Screening for Metabolic Disorders (SMD), FAPH, IMM, Readmissions (READM), and Medication Continuation (MedCont, formerly known as MedCoPsy). Psychiatric facilities that are eligible for the Inpatient Psychiatric Facility Quality Reporting (IPFQR) program are required to meet all program requirements, otherwise their Medicare payments may be reduced.

— Source: CMS feed metadata

Keywords: Medicare, Inpatient Psychiatric Facility Quality Measure Data - by State Theme: Medicare

Coverage timeline

2024 🟩 · 2025 🟩 · 2026 🟩

3 of 3 years with snapshot releases — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
Snapshot as of 2026-04-21	2026-04-21	2026-05-15	✓
Snapshot as of 2026-01-26	2026-01-26	2026-02-28
Snapshot as of 2025-10-14	2025-10-14	2025-11-28
Snapshot as of 2025-07-16	2025-07-16	2025-08-06
Snapshot as of 2025-01-08	2025-01-08	2025-02-27
Snapshot as of 2024-10-10	2024-10-10	2024-12-14

Data dictionary

📋 53 data columns + 6 lineage columns

Data columns

Column	Type	Description
STATE	TEXT
HBIPS_2_MEASURE_DESCRIPTION	TEXT	HBIPS-2 MEASURE DESCRIPTION
S_HBIPS_2_OVERALL_RATE_PER_1000	NUMBER	S HBIPS-2 OVERALL RATE PER 1000
S_HBIPS_2_OVERALL_NUM	NUMBER	S HBIPS-2 OVERALL NUM
S_HBIPS_2_OVERALL_DEN	NUMBER	S HBIPS-2 OVERALL DEN
HBIPS_3_MEASURE_DESCRIPTION	TEXT	HBIPS-3 MEASURE DESCRIPTION
S_HBIPS_3_OVERALL_RATE_PER_1000	NUMBER	S HBIPS-3 OVERALL RATE PER 1000
S_HBIPS_3_OVERALL_NUM	NUMBER	S HBIPS-3 OVERALL NUM
S_HBIPS_3_OVERALL_DEN	NUMBER	S HBIPS-3 OVERALL DEN
SMD_MEASURE_DESCRIPTION	TEXT
S_SMD_	NUMBER	S SMD %
SUB_2_2A_MEASURE_DESCRIPTION	TEXT	SUB-2/-2A MEASURE DESCRIPTION
S_SUB_2_	NUMBER	S SUB-2 %
S_SUB_2A_	NUMBER	S SUB-2A %
SUB_3_3A_MEASURE_DESCRIPTION	TEXT	SUB-3/-3A MEASURE DESCRIPTION
S_SUB_3_	NUMBER	S SUB-3 %
S_SUB_3A_	NUMBER	S SUB-3A %
TOB_3_3A_MEASURE_DESCRIPTION	TEXT	TOB-3/-3A MEASURE DESCRIPTION
S_TOB_3_	NUMBER	S TOB-3 %
S_TOB_3A_	NUMBER	S TOB-3A %
TR_1_MEASURE_DESCRIPTION	TEXT	TR-1 MEASURE DESCRIPTION
S_TR_1_	NUMBER	S TR-1 %
START_DATE	DATE
END_DATE	DATE
FAPH_MEASURE_DESCRIPTION	TEXT
S_FAPH_30_	TEXT	S FAPH-30 %
S_FAPH_7_	TEXT	S FAPH-7 %
FAPH_MEASURE_START_DATE	DATE
FAPH_MEASURE_END_DATE	DATE
MEDCONT_MEASURE_DESCRIPTION	TEXT
S_MEDCONT_	TEXT	S MEDCONT %
MEDCONT_MEASURE_START_DATE	DATE
MEDCONT_MEASURE_END_DATE	DATE
READM_30_IPF_MEASURE_DESC	TEXT	READM-30-IPF MEASURE DESC
S_READM_30_IPF__IPFS_WORSE	TEXT	S READM-30-IPF # IPFS WORSE
S_READM_30_IPF__IPFS_SAME	TEXT	S READM-30-IPF # IPFS SAME
S_READM_30_IPF__IPFS_BETTER	TEXT	S READM-30-IPF # IPFS BETTER
S_READM_30_IPF__IPFS_TOO_FEW	TEXT	S READM-30-IPF # IPFS TOO FEW
READM_30_IPF_START_DATE	DATE	READM-30-IPF START DATE
READM_30_IPF_END_DATE	DATE	READM-30-IPF END DATE
IMM_2_MEASURE_DESCRIPTION	TEXT	IMM-2 MEASURE DESCRIPTION
S_IMM_2_	NUMBER	S IMM-2 %
FLU_SEASON_START_DATE	DATE
FLU_SEASON_END_DATE	DATE
HBIPS_5_MEASURE_DESCRIPTION	TEXT	HBIPS-5 MEASURE DESCRIPTION
S_HBIPS_5_	NUMBER	S HBIPS-5 %
TOB_2_2A_MEASURE_DESC	TEXT	TOB-2/-2A MEASURE DESC
S_TOB_2_	NUMBER	S TOB-2 %
S_TOB_2A_	NUMBER	S TOB-2A %
IPFQR_HCP_COVID_19_MEASURE_DESCRIPTION	TEXT	IPFQR-HCP COVID-19 MEASURE DESCRIPTION
IPFQR_HCP_COVID_19_	NUMBER	IPFQR-HCP COVID-19 %
IPFQR_HCP_COVID_19_START_DATE	DATE	IPFQR-HCP COVID-19 START DATE
IPFQR_HCP_COVID_19_END_DATE	DATE	IPFQR-HCP COVID-19 END DATE

Lineage columns (present on every feed table)

Column	Type	Description
ROW_ID	TEXT	Unique row ID for this table (PK)
FILE_ID	TEXT	Source file — joins to FEEDS_FILES.ID (FK)
FILE_FEED_ID	TEXT	Parent feed — joins to FEEDS.ID (FK)
FILE_NAME	TEXT	Source file name as published by CMS
ROWNUM	NUMBER	Row number within the source file
CREATED_AT	TIMESTAMP_NTZ	Timestamp when the record was loaded

Row-level lineage

Every row in this table traces to the exact CMS source file that produced it. The FILE_ID column joins to the FEEDS_FILES catalog table, and FILE_FEED_ID joins to the FEEDS master table:

Trace any row back to its source file and reporting period:

SELECT d.STATE, d.HBIPS_2_MEASURE_DESCRIPTION, d.S_HBIPS_2_OVERALL_RATE_PER_1000,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.INPATIENT_PSYCHIATRIC_FACILITY_QUALITY_MEASURE_DATA__BY_STATE d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Source & provenance

Published by the Centers for Medicare & Medicaid Services.

• Official CMS documentation

Frequently asked questions

How often is Inpatient Psychiatric Facility Quality Measure Data - by State updated?

CMS last published this feed on 2026-04-21. New releases are added automatically when CMS publishes them.

What years does Inpatient Psychiatric Facility Quality Measure Data - by State cover?

2024 through 2026.

How many records are in Inpatient Psychiatric Facility Quality Measure Data - by State?

Count the current snapshot yourself once the share is mounted:

SELECT COUNT(*)
FROM DWV.INPATIENT_PSYCHIATRIC_FACILITY_QUALITY_MEASURE_DATA__BY_STATE d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID
WHERE ff.IS_LATEST = 1;

How do I get Inpatient Psychiatric Facility Quality Measure Data - by State data?

It's included in the CMS Data Feeds Dataset on the Snowflake Marketplace (free trial available) and via Databricks Delta Sharing. Once mounted, query DWV.INPATIENT_PSYCHIATRIC_FACILITY_QUALITY_MEASURE_DATA__BY_STATE directly — no pipeline setup required.

Related feeds

Innovation Center Model ParticipantsPhysician/Supplier Procedure SummaryMedicare Monthly EnrollmentFacility-Level Minimum Data Set FrequencyQuarterly Prescription Drug Plan Formulary, Pharmacy Network, and Pricing Information - geographic_locator

Get this feed

1. Start a free trial on Snowflake Marketplace or purchase via Databricks

2. Mount the share — the database and DWV schema appear in your account immediately

3. Run the sample query above — no ETL, no pipeline maintenance

Questions about this feed? Contact us at [e-mail].

---

Part of the CMS Data Feeds Dataset — 280+ feeds · 245B+ records · updated daily. Back to the full catalog →