Benefits Data - Premiums & Deductibles
Medicare Advantage and Part D premium amounts, deductibles, out-of-pocket maximums, and cost-sharing structures by plan
Part of the CMS Data Research Dataset › Plan Benefits
Dataplex delivers this CMS research table as the analysis-ready table DWV.BENEFITS_DATA__PREMIUMS_DEDUCTIBLES on Snowflake and Databricks: coverage from 2019 to 2027 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.BENEFITS_DATA__PREMIUMS_DEDUCTIBLES
Databricks
cms_research_dwv.benefits_data__premiums_deductibles
Coverage
Jan 2019 – Jan 2027
Rows
1,246,420 (total across all reporting periods)
Update pattern
Time-partitioned; each file adds one reporting period
Latest report period
2027-01-01
Loaded
2026-10-02
Columns
840 data + 5 lineage
Identifiers
Contract ID (H-number) · Plan ID
File versions
120 (20 report periods)
License
CMS public data (U.S. Government work)
Platforms
Snowflake Marketplace · Databricks Delta Sharing
Included in the CMS Data Research Dataset, start a free trial on Snowflake Marketplace.
Sample queries
About this feed
Medicare Advantage and Part D premium amounts, deductibles, out-of-pocket maximums, and cost-sharing structures by plan
Source: CMS feed metadata
Theme: Plan Benefits
Coverage timeline
2019–2027 🟩🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)
9 of 9 years covered, no gaps.
Release history
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.
Frequently asked questions
How often is Benefits Data - Premiums & Deductibles updated?
CMS last published this feed on 2027-01-01. New releases are added automatically when CMS publishes them.
What years does Benefits Data - Premiums & Deductibles cover?
2019 through 2027.
How many records are in Benefits Data - Premiums & Deductibles?
1,246,420 rows across all 20 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 Benefits Data - Premiums & Deductibles data?
It's included in the CMS Data Research Dataset on the Snowflake Marketplace (free trial available). Once mounted, query DWV.BENEFITS_DATA__PREMIUMS_DEDUCTIBLES directly; no pipeline setup required.
Related feeds
Benefits Data - B19B SSBCI ServicesBenefits Data - B19B SSBCI Other ServicesBenefits Data - B19A Skilled Nursing Facility (VBID/UF)Benefits Data - B19B Skilled Nursing Facility (VBID/UF)Benefits Data - B19B Other Services (VBID/UF)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; 48 research tables · 25 years of Medicare Advantage & Part D history · updated daily. Back to the full catalog →
Last updated

