Nursing Homes Including Rehab Services - Citation Code Lookup
Reference table mapping deficiency tag numbers to descriptions and regulatory categories.
Part of the CMS Data Feeds Dataset › Medicare
Dataplex delivers this CMS feed as the analysis-ready table DWV.NURSING_HOMES_CITATION_CODE_LOOKUP on Snowflake and Databricks: 78 snapshot releases spanning 2020–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.NURSING_HOMES_CITATION_CODE_LOOKUP
Databricks
cms_dwv.nursing_homes_citation_code_lookup
Cadence
Monthly
Update pattern
Full-refresh; each file replaces the prior snapshot
CMS published
2026-10-01
Loaded
2026-10-28
Columns
6 data + 6 lineage
File versions
78
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.
Sample queries
About this feed
Reference table mapping deficiency tag numbers to descriptions and regulatory categories.
Source: CMS feed metadata
Keywords: nursing homes, citation codes, deficiency tags, reference Theme: Medicare
Coverage timeline
2020–2026 🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)
7 of 7 years with snapshot releases, no gaps.
Release history
Snapshot as of 2026-10-01
2026-10-01
2026-10-28
✓
Snapshot as of 2026-09-01
2026-09-01
2026-10-24
Snapshot as of 2026-09-01
2026-09-01
2026-10-23
Snapshot as of 2026-09-01
2026-09-01
2026-10-22
Snapshot as of 2026-09-01
2026-09-01
2026-10-08
Snapshot as of 2026-08-01
2026-08-01
2026-09-28
Snapshot as of 2026-07-01
2026-07-01
2026-08-25
Snapshot as of 2026-07-01
2026-07-01
2026-08-24
Snapshot as of 2026-06-01
2026-06-01
2026-07-27
Snapshot as of 2026-06-01
2026-06-01
2026-07-15
Data dictionary
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:
Source & provenance
Published by the Centers for Medicare & Medicaid Services (bureau 009:38).
Frequently asked questions
How often is Nursing Homes Including Rehab Services - Citation Code Lookup updated?
Monthly. CMS last published this feed on 2026-10-01, and Dataplex loaded it to the warehouse on 2026-10-28. New releases are added automatically when CMS publishes them.
What years does Nursing Homes Including Rehab Services - Citation Code Lookup cover?
2020 through 2026.
How many records are in Nursing Homes Including Rehab Services - Citation Code Lookup?
Count the current snapshot yourself once the share is mounted:
How do I get Nursing Homes Including Rehab Services - Citation Code Lookup 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.NURSING_HOMES_CITATION_CODE_LOOKUP directly; no pipeline setup required.
Related feeds
Skilled Nursing Facility Quality Reporting Program - National DataNursing Homes Including Rehab Services - MDS Quality MeasuresNursing Homes Including Rehab Services - Medicare Claims Quality MeasuresNursing Homes Including Rehab Services - State US AveragesSkilled Nursing Facility Quality Reporting Program - Provider DataGet this feed
Start a free trial on Snowflake Marketplace or purchase via Databricks
Mount the share; the database and
DWVschema appear in your account immediatelyRun the sample query above; no ETL, no pipeline maintenance
Questions about this feed? Contact us at notifications@dataplex-consulting.com.
Part of the CMS Data Feeds Dataset; 300+ feeds · 34B+ records · updated daily. Back to the full catalog →
Last updated

