Part C&D Plan Crosswalk
Provides the list of annual plan crosswalks for all organization types.
Part of the CMS Data Research Dataset › Plan Crosswalk
Dataplex delivers this CMS research table as the analysis-ready table DWV.PLAN_CROSSWALKS on Snowflake — coverage from 2006 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.PLAN_CROSSWALKS
Coverage
Jan 2006 – Jan 2026
Rows
121,311 (total across all reporting periods)
Cadence
Annual
Update pattern
Time-partitioned — each file adds one reporting period
Latest report period
2026-01-01
Loaded
2025-11-20
Columns
14 data + 5 lineage
Identifiers
Contract ID (H-number) · Plan ID
File versions
17
License
CMS public data — U.S. Government work
Platforms
Snowflake Marketplace
Included in the CMS Data Research Dataset — start a free trial on Snowflake Marketplace.
Current — data runs through the Jan 2026 report period. Next CMS release expected ~Jan 2027.
Partitioned by report period — each file version covers one report period and history is additive. The sample query below returns the latest report period; drop the WHERE clause to query the full history.
Sample queries
About this feed
Provides the list of annual plan crosswalks for all organization types.
— Source: CMS feed metadata
Theme: Plan Crosswalk
Coverage timeline
2006–2026 🟩🟩🟩🟩🟩⬜⬜⬜🟩🟩⬜🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)
17 of 21 years covered — gaps: 2011, 2012, 2013, 2016.
Release history
Data dictionary
📋 14 data columns + 5 lineage columns
Data columns
PREVIOUS_CONTRACT_ID
TEXT
PREVIOUS_PLAN_ID
TEXT
PREVIOUS_PLAN_NAME
TEXT
PREVIOUS_SNP_TYPE
TEXT
PREVIOUS_SNP_INSTITUTIONAL
TEXT
CURRENT_CONTRACT_ID
TEXT
CURRENT_PLAN_ID
TEXT
CURRENT_PLAN_NAME
TEXT
CURRENT_SNP_TYPE
TEXT
CURRENT_SNP_INSTITUTIONAL
TEXT
STATUS
TEXT
DESCRIPTION
TEXT
PREVIOUS_SNP_POPULATION
TEXT
CURRENT_SNP_POPULATION
TEXT
Lineage columns (present on every feed table)
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
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.
Frequently asked questions
How often is Part C&D Plan Crosswalk updated?
Annually. CMS last published this feed on 2026-01-01, and Dataplex loaded it to the warehouse on 2025-11-20. New releases are added automatically when CMS publishes them.
What years does Part C&D Plan Crosswalk cover?
2006 through 2026. Coverage gaps: 2011, 2012, 2013, 2016.
How many records are in Part C&D Plan Crosswalk?
121,311 rows across all 17 report periods. Because this feed is partitioned by report period, the full table total is the meaningful count — no deduplication needed.
How do I get Part C&D Plan Crosswalk data?
It's included in the CMS Data Research Dataset on the Snowflake Marketplace (free trial available). Once mounted, query DWV.PLAN_CROSSWALKS directly — no pipeline setup required.
Get this feed
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 Research Dataset — 22 research tables · 20 years of Medicare Advantage & Part D history · updated daily. Back to the full catalog →
Last updated