Long-Term Care Hospital - Provider Data

Provider-level long-term care hospital quality measures from CMS Provider Data.

Part of the CMS Data Feeds Dataset › Long-term care hospitals

Dataplex delivers this CMS feed as the analysis-ready table DWV.LONG_TERM_CARE_HOSPITAL_PROVIDER_DATA on Snowflake and Databricks — coverage from 2026 to 2026 in a single aligned 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.LONG_TERM_CARE_HOSPITAL_PROVIDER_DATA
Databricks	cms_dwv.long_term_care_hospital_provider_data
Cadence	Quarterly
CMS published	2026-06-01
Loaded	2026-07-06
Columns	17 data + 6 lineage
Identifiers	CCN · ZIP codes
File versions	1
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-06-01. Coverage runs through 2026-06-01. Next CMS release expected ~Sep 2026.

Sample queries

Snowflake

SELECT *
FROM DWV.LONG_TERM_CARE_HOSPITAL_PROVIDER_DATA
LIMIT 100;

Databricks

About this feed

Provider-level long-term care hospital quality measures from CMS Provider Data. One row per provider per measure per reporting period.

— Source: CMS feed metadata

Keywords: long-term care hospitals, provider data, quality measures, quality reporting Theme: Long-term care hospitals

Coverage timeline

2026 🟩

1 of 1 years covered — no gaps.

Release history

Reporting period	CMS published	Loaded	Latest file
—	2026-06-01	2026-07-06	✓

Data dictionary

📋 17 data columns + 6 lineage columns

Data columns

Column	Type	Description
DATA_PERIOD	TEXT	Data snapshot period from BATCH_LOG (e.g., '2026-06')
CMS_CERTIFICATION_NUMBER_CCN	TEXT	CMS Certification Number — unique 6-character long-term care hospital identifier
PROVIDER_NAME	TEXT	Official name of the long-term care hospital
ADDRESS_LINE_1	TEXT	Primary street address for the hospital
ADDRESS_LINE_2	TEXT	Secondary address line for the hospital, if present
CITY_TOWN	TEXT	City or town where the hospital is located
STATE	TEXT	Two-letter state abbreviation
ZIP_CODE	TEXT	5-digit ZIP code
COUNTY_PARISH	TEXT	County or parish name
TELEPHONE_NUMBER	TEXT	Hospital telephone number
CMS_REGION	TEXT	CMS regional office number
MEASURE_CODE	TEXT	LTCH quality measure code identifier
SCORE	TEXT	Published measure value or categorical result from CMS
FOOTNOTE	TEXT	Footnote code explaining suppression or publication caveats
START_DATE	DATE	Start date of the measurement period
END_DATE	DATE	End date of the measurement period
MEASURE_DATE_RANGE	TEXT	Original measurement date range string from CMS, if present

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.DATA_PERIOD, d.CMS_CERTIFICATION_NUMBER_CCN, d.PROVIDER_NAME,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.LONG_TERM_CARE_HOSPITAL_PROVIDER_DATA d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Source & provenance

Published by the Centers for Medicare & Medicaid Services (bureau 009:38).

• Official CMS documentation

• Fp6g 2gsn

Frequently asked questions

How often is Long-Term Care Hospital - Provider Data updated?

Quarterly. CMS last published this feed on 2026-06-01, and Dataplex loaded it to the warehouse on 2026-07-06. New releases are added automatically when CMS publishes them.

What years does Long-Term Care Hospital - Provider Data cover?

2026 through 2026.

How many records are in Long-Term Care Hospital - Provider Data?

Count the current snapshot yourself once the share is mounted:

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

How do I get Long-Term Care Hospital - Provider Data 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.LONG_TERM_CARE_HOSPITAL_PROVIDER_DATA directly — no pipeline setup required.

Related feeds

Inpatient Rehabilitation Facility - Provider DataInpatient Rehabilitation Facility - National DataNursing Homes Including Rehab Services - MDS Quality MeasuresSkilled Nursing Facility Quality Reporting Program - National DataNursing Homes Including Rehab Services - State US Averages

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 →