Monthly Enrollment by CPSC (contract)
Provides monthly enrollment at the contract/plan/state/county level for all organization types.
Part of the CMS Data Research Dataset › Enrollment
Dataplex delivers this CMS research table as the analysis-ready table DWV.MONTHLY_ENROLLMENT_BY_CONTRACT_PLAN_STATE_COUNTY 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.MONTHLY_ENROLLMENT_BY_CONTRACT_PLAN_STATE_COUNTY
Coverage
Jul 2006 – Jul 2026
Rows
1,517,642 (total across all reporting periods)
Cadence
Monthly
Update pattern
Time-partitioned — each file adds one reporting period
Latest report period
2026-07-01
Loaded
2026-07-12
Columns
12 data + 5 lineage
Identifiers
Contract ID (H-number) · Plan ID
File versions
240
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 Jul 2026 report period. Next CMS release expected ~Aug 2026.
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 monthly enrollment at the contract/plan/state/county level for all organization types.
— Source: CMS feed metadata
Theme: Enrollment
Coverage timeline
2006–2026 🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)
21 of 21 years covered — no gaps.
Release history
Data dictionary
📋 12 data columns + 5 lineage columns
Data columns
CONTRACT_ID
TEXT
PLAN_ID
NUMBER
ORGANIZATION_TYPE
TEXT
PLAN_TYPE
TEXT
OFFERS_PART_D
BOOLEAN
SNP_PLAN
BOOLEAN
EGHP
BOOLEAN
ORGANIZATION_NAME
TEXT
ORGANIZATION_MARKETING_NAME
TEXT
PLAN_NAME
TEXT
PARENT_ORGANIZATION
TEXT
CONTRACT_EFFECTIVE_DATE
TIMESTAMP_NTZ
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 Monthly Enrollment by CPSC (contract) updated?
Monthly. CMS last published this feed on 2026-07-01, and Dataplex loaded it to the warehouse on 2026-07-12. New releases are added automatically when CMS publishes them.
What years does Monthly Enrollment by CPSC (contract) cover?
2006 through 2026.
How many records are in Monthly Enrollment by CPSC (contract)?
1,517,642 rows across all 240 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 Monthly Enrollment by CPSC (contract) data?
It's included in the CMS Data Research Dataset on the Snowflake Marketplace (free trial available). Once mounted, query DWV.MONTHLY_ENROLLMENT_BY_CONTRACT_PLAN_STATE_COUNTY directly — no pipeline setup required.
Related feeds
Monthly Enrollment by CPSC (enrollment)Monthly Enrollment by StateMonthly Enrollment by PlanEnrollment by ContractGet 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