Benefits Data - Part D Drug Coverage

Medicare Part D prescription drug coverage details including formulary tiers, cost sharing, deductibles, coverage phases, and pharmacy networks

Part of the CMS Data Research Dataset › Plan Benefits

Dataplex delivers this CMS research table as the analysis-ready table DWV.BENEFITS_DATA__PART_D on Snowflake — coverage from 2019 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.BENEFITS_DATA__PART_D
Coverage	Jan 2019 – Jan 2026
Rows	1,953,186 (total across all reporting periods)
Update pattern	Time-partitioned — each file adds one reporting period
Latest report period	2026-01-01
Loaded	2025-11-20
Columns	624 data + 5 lineage
Identifiers	Contract ID (H-number) · Plan ID
File versions	131 (19 report periods)
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.

Latest report period Jan 2026 — awaiting the next release. New periods load automatically when CMS publishes.

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

-- Latest report period only (drop the WHERE clause for the full history)
SELECT *
FROM DWV.BENEFITS_DATA__PART_D
WHERE FILE_ID IN (
  SELECT ID FROM DWV.FEEDS_FILES WHERE IS_LATEST = 1
)
LIMIT 100;

About this feed

Medicare Part D prescription drug coverage details including formulary tiers, cost sharing, deductibles, coverage phases, and pharmacy networks

— Source: CMS feed metadata

Theme: Plan Benefits

Coverage timeline

2019–2026 🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)

8 of 8 years covered — no gaps.

Release history

Report period	Files	Loaded	Latest	CMS source
2026-01-01	3	2025-11-20	✓	source ↗
2025-01-01	5	2025-09-18		source ↗
2024-10-01	9	2025-09-18		source ↗
2024-07-01	9	2025-09-18		source ↗
2024-01-01	9	2025-09-18		source ↗
2023-10-01	9	2025-09-18		source ↗
2023-07-01	9	2025-09-18		source ↗
2023-04-01	9	2025-09-18		source ↗
2023-01-01	4	2025-09-18		source ↗
2022-04-01	9	2025-09-18		source ↗

Show 9 earlier report periods

Report period	Files	Loaded	Latest	CMS source
2022-01-01	9	2025-09-18		source ↗
2021-10-01	4	2025-09-18		source ↗
2021-04-01	7	2025-09-18		source ↗
2021-02-01	7	2025-09-18		source ↗
2021-01-01	7	2025-09-18		source ↗
2020-10-01	7	2025-09-18		source ↗
2020-04-01	7	2025-09-18		source ↗
2020-01-01	4	2025-09-18		source ↗
2019-01-01	4	2025-09-18		source ↗

Data dictionary

📋 624 data columns + 5 lineage columns

Data columns

Column	Type
PBP_A_HNUMBER	TEXT
PBP_A_PLAN_IDENTIFIER	NUMBER
SEGMENT_ID	NUMBER
PBP_A_BEN_COV	NUMBER
PBP_A_PLAN_TYPE	NUMBER
ORGTYPE	NUMBER
BID_ID	TEXT
VERSION	NUMBER
PART_D_MODEL_DEMO	TEXT
PART_D_ENHNCD_CVRG_DEMO	TEXT
MRX_FORM_MODEL_TYPE	TEXT
MRX_DRUG_BEN_YN	NUMBER
MRX_BENEFIT_TYPE	NUMBER
MRX_PARTD_NETWORK_LOC	NUMBER
MRX_LTC_ATTEST_FLAG	NUMBER
MRX_FIRST_FILL	NUMBER
MRX_OTC_MEDS_PAY_UMP_YN	NUMBER
MRX_OTC_MEDS_ATTEST_FLAG	NUMBER
MRX_FORMULARY_TIERS_NUM	NUMBER
MRX_TIER_FORM_EX	NUMBER
MRX_TIER_FORM_EX_2_YN	NUMBER
MRX_TIER_FORM_EX_2	NUMBER
MRX_AE_OON_CSTSHR_STRUCT	NUMBER
MRX_AE_CSTSHR_APPLY	NUMBER
MRX_FORM_MODEL_DESC	TEXT
MRX_AE_OOPTCS_APPLY	NUMBER
MRX_ALT_DED_CHARGE	NUMBER
MRX_ALT_DED_AMOUNT	NUMBER
MRX_ALT_DED_TYPE_YN	NUMBER
MRX_ALT_NO_DED_TIER	NUMBER
MRX_ALT_DED_TIER_CSTSHR_YN	NUMBER
MRX_ALT_GEN_CSTSHR_STRUCT	NUMBER
MRX_ALT_GEN_COINS_PCT	TEXT
MRX_ALT_GEN_COPAY_AMT	NUMBER
MRX_ALT_OON_CSTSHR_STRUCT	NUMBER
MRX_ALT_RED_COST_SHARING	NUMBER
MRX_ALT_RED_COST_SHARING_ITEMS	NUMBER
MRX_ALT_FULFILL_DESC	TEXT
MRX_ALT_EXCL_DRUGS_YN	NUMBER
MRX_ALT_PRE_ICL_COST_SHARE	NUMBER
MRX_ALT_PRE_ICL_EXCLUD_ONLY_YN	NUMBER
MRX_ALT_IRA_COVG_TIER	TEXT
MRX_ALT_CSTSHR_POST_OOPT	NUMBER
MRX_GEN_LOC_RSTD	NUMBER
MRX_GEN_RSTD_1M	NUMBER
MRX_GEN_RSTD_2M	NUMBER
MRX_GEN_RSTD_3M	NUMBER
MRX_GEN_LOC_OON	NUMBER
MRX_GEN_OON_1M	NUMBER
MRX_GEN_OON_OS	NUMBER
MRX_GEN_LOC_MOSTD	NUMBER
MRX_GEN_MOSTD_1M	NUMBER
MRX_GEN_MOSTD_2M	NUMBER
MRX_GEN_MOSTD_3M	NUMBER
MRX_GEN_LOC_LTC	NUMBER
MRX_GEN_LTC_1M	NUMBER
MRX_TIER_EXTD_DAYS_GEN_YN	NUMBER
MRX_GEN_EXTD_FIRST_FILL	NUMBER
MRX_GEN_IRA_RSTD_COPAY_1M	TEXT
MRX_GEN_IRA_RSTD_COPAY_2M	TEXT
MRX_GEN_IRA_RSTD_COPAY_3M	TEXT
MRX_GEN_IRA_MOSTD_COPAY_1M	TEXT
MRX_GEN_IRA_MOSTD_COPAY_2M	TEXT
MRX_GEN_IRA_MOSTD_COPAY_3M	TEXT
MRX_GEN_IRA_OONP_COPAY_1M	TEXT
MRX_GEN_IRA_OONP_COPAY_OTHNUM	TEXT
MRX_GEN_IRA_LTCP_COPAY_1M	TEXT
MRX_GEN_IRA_RSTD_COINS_1M	TEXT
MRX_GEN_IRA_RSTD_COINS_2M	TEXT
MRX_GEN_IRA_RSTD_COINS_3M	TEXT
MRX_GEN_IRA_MOSTD_COINS_1M	TEXT
MRX_GEN_IRA_MOSTD_COINS_2M	TEXT
MRX_GEN_IRA_MOSTD_COINS_3M	TEXT
MRX_GEN_IRA_OONP_COINS_1M	TEXT
MRX_GEN_IRA_OONP_COINS_OTHNUM	TEXT
MRX_GEN_IRA_LTCP_COINS_1M	TEXT
MRX_AVG_EXP_COST_SHARE_ATTEST	NUMBER
MRX_SNP_ZEROCOST_ATTEST	NUMBER
MRX_VACCINE_ATTEST	TEXT
MRX_INSULIN_ATTEST	TEXT
MRX_TIER_LABEL_LIST	TEXT
MRX_TIER_POST_LABEL_LIST	TEXT
MRX_TIER_BENEFIT_TYPE	TEXT
MRX_TIER_DRUG_TYPE	TEXT
MRX_TIER_GROUP_ID	TEXT
MRX_TIER_POST_BENEFIT_TYPE	TEXT
MRX_D_PMM_YN	TEXT
MRX_SSM_CORRIDOR_YN	TEXT
MRX_SSM_RAI_YN	TEXT
MRX_TIER_GRP_EHC	TEXT
MRX_TIER_ID	TEXT
MRX_TIER_POST_FORM_MODEL_DESC	TEXT
MRX_TIER_POST_ID	TEXT
MRX_D_PMM_FLEX_CHK	TEXT
MRX_SSM_REWARDS_CNT_RDO	TEXT
MRX_TIER_GAP_COST_SHARE	TEXT
MRX_TIER_GRP_NAME	TEXT
MRX_TIER_INCLUDES	TEXT
MRX_TIER_PHASE	TEXT
MRX_TIER_POST_CST_SHR_TYPE	TEXT
MRX_TIER_POST_TYPE_ID	TEXT
MRX_TIER_TM	TEXT
MRX_TIER_TYPE_ID	TEXT
MRX_D_PMM_OTHER_DESC	TEXT
MRX_GROUP_TIERS_ICL	TEXT
MRX_GROUP_TIERS_OOP	TEXT
MRX_SSM_RI_TYPE_1_CHK	TEXT
MRX_TIER_CSTSHR_STRUCT_TYPE	TEXT
MRX_TIER_INCENT_YN	TEXT
MRX_D_RED_CS_LISB_DETAIL	TEXT
MRX_FLOOR_PRICE_YN	TEXT
MRX_SSM_RI_TYPE_1_OTHER	TEXT
MRX_TIER_CSTSHR_STRUCT_TYPE_VB	TEXT
MRX_TIER_HIVAL_YN	TEXT
MRX_TIER_POST_COST_STRUCT_VB	TEXT
MRX_TIER_POST_DRUG_TYPE	TEXT
MRX_CEILING_PRICE_YN	TEXT
MRX_D_RI_TYPE_CHK	TEXT
MRX_SSM_RI_1_AMT	TEXT
MRX_TIER_COST_SHARE_VB	TEXT
MRX_TIER_GRP_EHC_D	TEXT
MRX_TIER_MOD_DED_YN	TEXT
MRX_TIER_POST_COST_SHARE_VB	TEXT
MRX_TIER_POST_INCLUDES	TEXT
MRX_D_RI_TYPE_OTHER	TEXT
MRX_SSM_RI_ELIG_1_RDO	TEXT
MRX_TIER_LOCAT_RSTD	TEXT
MRX_TIER_MOD_DED_AMT	TEXT
MRX_TIER_PART_DRUGS_VB	TEXT
MRX_TIER_POST_COST_STRUCT	TEXT
MRX_TIER_POST_PART_DRUGS_VB	TEXT
MRX_D_RI_AMT	TEXT
MRX_QUANTITY_LIMITS	TEXT
MRX_SSM_ELIG_FREQ_1_OTHER	TEXT
MRX_TIER_LOCAT_RSPLT	TEXT
MRX_TIER_PART_INCLUDES_VB	TEXT
MRX_TIER_POST_COPAY_AMT	TEXT
MRX_TIER_POST_PART_INCLUDES_VB	TEXT
MRX_AUTH_YNBA	TEXT
MRX_D_RI_ELIG_RDO	TEXT
MRX_GROUP_TIERS_GAP	TEXT
MRX_SSM_RI_MAX_1_AMT	TEXT
MRX_TIER_CS_LIS_ELIG_YN	TEXT
MRX_TIER_LOCAT_OON	TEXT
MRX_TIER_LOCAT_RSTD_VB	TEXT
MRX_TIER_POST_COINS_PCT	TEXT
MRX_TIER_POST_COPAY_MIN	TEXT
MRX_D_ELIG_FREQ_OTHER	TEXT
MRX_LIMIT_OFC_YN	TEXT
MRX_SSM_ELIGCRIT_1_CHK	TEXT
MRX_STEP_THER_DRUGS_YN	TEXT
MRX_TIER_CS_LIS_CHK	TEXT
MRX_TIER_LOCAT_MOSTD	TEXT
MRX_TIER_LOCAT_RSPLT_VB	TEXT
MRX_TIER_POST_COPAY_MAX	TEXT
MRX_TIER_POST_INCLUDES_MMP	TEXT
MRX_D_RI_MAX_AMT	TEXT
MRX_SSM_ELIGCRIT_1_OTHER	TEXT
MRX_TIER_CS_LIS_WAIVE_YN	TEXT
MRX_TIER_ENR_TAR_VBID	TEXT
MRX_TIER_LOCAT_MOSPLT	TEXT
MRX_TIER_LOCAT_OON_VB	TEXT
MRX_TIER_POST_COINS_MIN	TEXT
MRX_TIER_POST_COPAY_AMT_MMPMIN	TEXT
MRX_D_ELIGCRIT_CHK	TEXT
MRX_OTC_STEP_THERAPY_YN	TEXT
MRX_SSM_ADHER_1_GOAL	TEXT
MRX_TIER_CS_LIS_REDUCE	TEXT
MRX_TIER_ENR_ENG_VBID	TEXT
MRX_TIER_LOCAT_LTC	TEXT
MRX_TIER_LOCAT_MOSTD_VB	TEXT
MRX_TIER_POST_COINS_MAX	TEXT
MRX_TIER_POST_COPAY_AMT_MMPMAX	TEXT
MRX_D_ELIGCRIT_OTHER	TEXT
MRX_SSM_ADHER_GOAL_1_DESC	TEXT
MRX_TIER_LOCAT_MOSPLT_VB	TEXT
MRX_TIER_RSTD_1M_NUM	TEXT
MRX_D_ADHER_GOAL	TEXT
MRX_SSM_RI_TYPE_2_CHK	TEXT
MRX_TIER_LOCAT_LTC_VB	TEXT
MRX_TIER_RSTD_2M_NUM	TEXT
MRX_D_ADHER_GOAL_DESC	TEXT
MRX_SSM_RI_TYPE_2_OTHER	TEXT
MRX_TIER_RSTD_3M_NUM	TEXT
MRX_TIER_RSTD_COPAY_1M_MIN	TEXT
MRX_SSM_RI_2_AMT	TEXT
MRX_TIER_RSPLT_1M_NUM	TEXT
MRX_TIER_RSTD_COPAY_1M_MAX	TEXT
MRX_SSM_RI_ELIG_2_RDO	TEXT
MRX_TIER_RSPLT_2M_NUM	TEXT
MRX_TIER_RSTD_COPAY_2M_MIN	TEXT
MRX_SSM_ELIG_FREQ_2_OTHER	TEXT
MRX_TIER_RSPLT_3M_NUM	TEXT
MRX_TIER_RSTD_COPAY_2M_MAX	TEXT
MRX_SSM_RI_MAX_2_AMT	TEXT
MRX_TIER_EXTD_DAYS_YN	TEXT
MRX_TIER_RSTD_COPAY_3M_MIN	TEXT
MRX_SSM_ELIGCRIT_2_CHK	TEXT
MRX_TIER_EXTD_FIRST_FILL	TEXT
MRX_TIER_RSTD_COPAY_3M_MAX	TEXT
MRX_SSM_ELIGCRIT_2_OTHER	TEXT
MRX_TIER_MOSTD_1M_NUM	TEXT
MRX_TIER_RSSTD_COPAY_1M_MIN	TEXT
MRX_SSM_ADHER_2_GOAL	TEXT
MRX_TIER_MOSTD_2M_NUM	TEXT
MRX_TIER_RSSTD_COPAY_1M_MAX	TEXT
MRX_SSM_ADHER_GOAL_2_DESC	TEXT
MRX_TIER_MOSTD_3M_NUM	TEXT
MRX_TIER_RSSTD_COPAY_2M_MIN	TEXT
MRX_SSM_INSULIN_YN	TEXT
MRX_TIER_MOSPLT_1M_NUM	TEXT
MRX_TIER_RSSTD_COPAY_2M_MAX	TEXT
MRX_SSM_COHORTS_CNT_RDO	TEXT
MRX_TIER_MOSPLT_2M_NUM	TEXT
MRX_TIER_RSSTD_COPAY_3M_MIN	TEXT
MRX_SSM_CUI_TIERS_1_CHK	TEXT
MRX_TIER_MOSPLT_3M_NUM	TEXT
MRX_TIER_RSSTD_COPAY_3M_MAX	TEXT
MRX_SSM_SRCS_1_CHK	TEXT
MRX_SSM_SRCS_CHK	TEXT
MRX_TIER_OONP_1M_NUM	TEXT
MRX_TIER_RSPFD_COPAY_1M_MIN	TEXT
MRX_ALT_GAP_COVG_YN	NUMBER
MRX_SSM_PRCS_1_CHK	TEXT
MRX_SSM_PRCS_CHK	TEXT
MRX_TIER_OONP_OTHNUMN	TEXT
MRX_TIER_RSPFD_COPAY_1M_MAX	TEXT
MRX_SSM_OONP_1_CHK	TEXT
MRX_SSM_OONP_CHK	TEXT
MRX_TIER_LTCP_1M	TEXT
MRX_TIER_RSPFD_COPAY_2M_MIN	TEXT
MRX_SSM_SMOCS_1_CHK	TEXT
MRX_SSM_SMOCS_CHK	TEXT
MRX_TIER_RSPFD_COPAY_2M_MAX	TEXT
MRX_TIER_RSTD_COPAY_1M	TEXT
MRX_ALT_PRE_ICL_COST_SHARE_MMP	NUMBER
MRX_SSM_PMOCS_1_CHK	TEXT
MRX_SSM_PMOCS_CHK	TEXT
MRX_TIER_RSPFD_COPAY_3M_MIN	TEXT
MRX_TIER_RSTD_COPAY_2M	TEXT
MRX_ALT_PRE_ICL_LIS_MMP_YN	NUMBER
MRX_SSM_LTCP_1_CHK	TEXT
MRX_SSM_LTCP_CHK	TEXT
MRX_TIER_RSPFD_COPAY_3M_MAX	TEXT
MRX_TIER_RSTD_COPAY_3M	TEXT
MRX_ALT_PRE_ICL_LIS_MMP_TIERS	NUMBER
MRX_SSM_SRCS_COPAY_1M_1_NUM	TEXT
MRX_TIER_RSTD_COINS_1M_MIN	TEXT
MRX_TIER_RSTD_COINS_AVG_1M	TEXT
MRX_ALT_COV_LMT_YN	NUMBER
MRX_SSM_SRCS_COINS_1M_1_NUM	TEXT
MRX_TIER_RSTD_COINS_1M	TEXT
MRX_TIER_RSTD_COINS_1M_MAX	TEXT
MRX_ALT_COV_LMT_AMT	NUMBER
MRX_SSM_SRCS_COPAY_2M_1_NUM	TEXT
MRX_TIER_RSTD_COINS_2M	TEXT
MRX_TIER_RSTD_COINS_2M_MIN	TEXT
MRX_ALT_GAP_COVG_TIER	NUMBER
MRX_SSM_SRCS_COINS_2M_1_NUM	TEXT
MRX_TIER_RSTD_COINS_2M_MAX	TEXT
MRX_TIER_RSTD_COINS_3M	TEXT
MRX_SSM_SRCS_COPAY_3M_1_NUM	TEXT
MRX_TIER_RSSTD_COPAY_1M	TEXT
MRX_TIER_RSTD_COINS_3M_MIN	TEXT
MRX_POST_EXCLUD_ONLY_YN	NUMBER
MRX_SSM_SRCS_COINS_3M_1_NUM	TEXT
MRX_TIER_RSSTD_COPAY_2M	TEXT
MRX_TIER_RSTD_COINS_3M_MAX	TEXT
MRX_ALT_CSTSHR_POST_OOPT_MMP	NUMBER
MRX_SSM_PRCS_COPAY_1M_1_NUM	TEXT
MRX_TIER_RSSTD_COINS_1M_MIN	TEXT
MRX_TIER_RSSTD_COPAY_3M	TEXT
MRX_SSM_PRCS_COINS_1M_1_NUM	TEXT
MRX_TIER_RSSTD_COINS_1M_MAX	TEXT
MRX_TIER_RSSTD_COINS_AVG_1M	TEXT
MRX_SSM_PRCS_COPAY_2M_1_NUM	TEXT
MRX_TIER_RSSTD_COINS_1M	TEXT
MRX_TIER_RSSTD_COINS_2M_MIN	TEXT
MRX_SSM_PRCS_COINS_2M_1_NUM	TEXT
MRX_TIER_RSSTD_COINS_2M	TEXT
MRX_TIER_RSSTD_COINS_2M_MAX	TEXT
MRX_SSM_PRCS_COPAY_3M_1_NUM	TEXT
MRX_TIER_RSSTD_COINS_3M	TEXT
MRX_TIER_RSSTD_COINS_3M_MIN	TEXT
MRX_SSM_PRCS_COINS_3M_1_NUM	TEXT
MRX_TIER_RSPFD_COPAY_1M	TEXT
MRX_TIER_RSSTD_COINS_3M_MAX	TEXT
MRX_SSM_OONP_COPAY_1M_1_NUM	TEXT
MRX_TIER_RSPFD_COINS_1M_MIN	TEXT
MRX_TIER_RSPFD_COPAY_2M	TEXT
MRX_SSM_OONP_COINS_1M_1_NUM	TEXT
MRX_TIER_RSPFD_COINS_1M_MAX	TEXT
MRX_TIER_RSPFD_COPAY_3M	TEXT
MRX_SSM_OONP_COPAY_OTH_1_NUM	TEXT
MRX_TIER_RSPFD_COINS_2M_MIN	TEXT
MRX_TIER_RSPFD_COINS_AVG_1M	TEXT
MRX_SSM_OONP_COINS_OTH_1_NUM	TEXT
MRX_TIER_RSPFD_COINS_1M	TEXT
MRX_TIER_RSPFD_COINS_2M_MAX	TEXT
MRX_SSM_SMOCS_COPAY_1M_1_NUM	TEXT
MRX_TIER_RSPFD_COINS_2M	TEXT
MRX_TIER_RSPFD_COINS_3M_MIN	TEXT
MRX_SSM_SMOCS_COINS_1M_1_NUM	TEXT
MRX_TIER_RSPFD_COINS_3M	TEXT
MRX_TIER_RSPFD_COINS_3M_MAX	TEXT
MRX_SSM_SMOCS_COPAY_2M_1_NUM	TEXT
MRX_TIER_MOSTD_COPAY_1M	TEXT
MRX_TIER_MOSTD_COPAY_1M_MIN	TEXT
MRX_SSM_SMOCS_COINS_2M_1_NUM	TEXT
MRX_TIER_MOSTD_COPAY_1M_MAX	TEXT
MRX_TIER_MOSTD_COPAY_2M	TEXT
MRX_SSM_SMOCS_COPAY_3M_1_NUM	TEXT
MRX_TIER_MOSTD_COPAY_2M_MIN	TEXT
MRX_TIER_MOSTD_COPAY_3M	TEXT
MRX_SSM_SMOCS_COINS_3M_1_NUM	TEXT
MRX_TIER_MOSTD_COINS_1M	TEXT
MRX_TIER_MOSTD_COPAY_2M_MAX	TEXT
MRX_SSM_PMOCS_COPAY_1M_1_NUM	TEXT
MRX_TIER_MOSTD_COINS_2M	TEXT
MRX_TIER_MOSTD_COPAY_3M_MIN	TEXT
MRX_SSM_PMOCS_COINS_1M_1_NUM	TEXT
MRX_TIER_MOSTD_COINS_3M	TEXT
MRX_TIER_MOSTD_COPAY_3M_MAX	TEXT
MRX_SSM_PMOCS_COPAY_2M_1_NUM	TEXT
MRX_TIER_MOSSTD_COPAY_1M	TEXT
MRX_TIER_MOSSTD_COPAY_1M_MIN	TEXT
MRX_SSM_PMOCS_COINS_2M_1_NUM	TEXT
MRX_TIER_MOSSTD_COPAY_1M_MAX	TEXT
MRX_TIER_MOSSTD_COPAY_2M	TEXT
MRX_SSM_PMOCS_COPAY_3M_1_NUM	TEXT
MRX_TIER_MOSSTD_COPAY_2M_MIN	TEXT
MRX_TIER_MOSSTD_COPAY_3M	TEXT
MRX_SSM_PMOCS_COINS_3M_1_NUM	TEXT
MRX_TIER_MOSSTD_COINS_1M	TEXT
MRX_TIER_MOSSTD_COPAY_2M_MAX	TEXT
MRX_SSM_LTCP_COPAY_1M_1_NUM	TEXT
MRX_TIER_MOSSTD_COINS_2M	TEXT
MRX_TIER_MOSSTD_COPAY_3M_MIN	TEXT
MRX_SSM_LTCP_COINS_1M_1_NUM	TEXT
MRX_TIER_MOSSTD_COINS_3M	TEXT
MRX_TIER_MOSSTD_COPAY_3M_MAX	TEXT
MRX_REDUCT_COST_YN	TEXT
MRX_SSM_CUI_TIERS_2_CHK	TEXT
MRX_TIER_MOSPFD_COPAY_1M	TEXT
MRX_TIER_MOSPFD_COPAY_1M_MIN	TEXT
MRX_SSM_SRCS_2_CHK	TEXT
MRX_TIER_GROUP_NUM	TEXT
MRX_TIER_MOSPFD_COPAY_1M_MAX	TEXT
MRX_TIER_MOSPFD_COPAY_2M	TEXT
MRX_SSM_PRCS_2_CHK	TEXT
MRX_SSM_SRCS_COPAY_1M_2_NUM	TEXT
MRX_TIER_MOSPFD_COPAY_2M_MIN	TEXT
MRX_TIER_MOSPFD_COPAY_3M	TEXT
MRX_V_BID_ATTESTATION	TEXT
MRX_RAI_OFF_REW_INCENT_YN	TEXT
MRX_SSM_OONP_2_CHK	TEXT
MRX_SSM_SRCS_COINS_1M_2_NUM	TEXT
MRX_TIER_MOSPFD_COINS_1M	TEXT
MRX_TIER_MOSPFD_COPAY_2M_MAX	TEXT
MRX_RAI_NUM_PARTD_OFFRD	TEXT
MRX_SSM_SMOCS_2_CHK	TEXT
MRX_SSM_SRCS_COPAY_2M_2_NUM	TEXT
MRX_TIER_MOSPFD_COINS_2M	TEXT
MRX_TIER_MOSPFD_COPAY_3M_MIN	TEXT
MRX_RAI_TYPE_PARTD_REW_1RX	TEXT
MRX_SSM_PMOCS_2_CHK	TEXT
MRX_SSM_SRCS_COINS_2M_2_NUM	TEXT
MRX_TIER_MOSPFD_COINS_3M	TEXT
MRX_TIER_MOSPFD_COPAY_3M_MAX	TEXT
MAX_RAI_PARTD_REW_INC_AMT_1RX	TEXT
MRX_SSM_LTCP_2_CHK	TEXT
MRX_SSM_SRCS_COPAY_3M_2_NUM	TEXT
MRX_TIER_MOSTD_COINS_1M_MIN	TEXT
MRX_TIER_OONP_COPAY_1M	TEXT
MAX_RAI_FRQ_REW_INCENT_1RX	TEXT
MRX_SSM_SRCS_COINS_3M_2_NUM	TEXT
MRX_TIER_MOSTD_COINS_1M_MAX	TEXT
MRX_TIER_OONP_COPAY_OTHNUM	TEXT
MRX_RAI_FRQ_RI_DESC_1RX	TEXT
MRX_SSM_PRCS_COPAY_1M_2_NUM	TEXT
MRX_TIER_MOSTD_COINS_2M_MIN	TEXT
MRX_TIER_OONP_COINS_1M	TEXT
MRX_RAI_ELIG_CRIT_1RX	TEXT
MRX_SSM_PRCS_COINS_1M_2_NUM	TEXT
MRX_TIER_MOSTD_COINS_2M_MAX	TEXT
MRX_TIER_OONP_COINS_OTHNUM	TEXT
MRX_RAI_MEET_ADH_GOAL_YN_1RX	TEXT
MRX_SSM_PRCS_COPAY_2M_2_NUM	TEXT
MRX_TIER_LTCP_COPAY_1M	TEXT
MRX_TIER_MOSTD_COINS_3M_MIN	TEXT
MAX_RAI_ANN_PARTD_REW_AMT_1RX	TEXT
MRX_SSM_PRCS_COINS_2M_2_NUM	TEXT
MRX_TIER_LTCP_COINS_1M	TEXT
MRX_TIER_MOSTD_COINS_3M_MAX	TEXT
MRX_RAI_TYPE_PARTD_REW_2RX	TEXT
MRX_SSM_PRCS_COPAY_3M_2_NUM	TEXT
MRX_TIER_MOSSTD_COINS_1M_MIN	TEXT
MRX_TIER_RSTD_COPAY_DAILY	TEXT
MAX_RAI_PARTD_REW_INC_AMT_2RX	TEXT
MRX_SSM_PRCS_COINS_3M_2_NUM	TEXT
MRX_TIER_MOSSTD_COINS_1M_MAX	TEXT
MRX_TIER_RSSTD_COPAY_DAILY	TEXT
MAX_RAI_FRQ_REW_INCENT_2RX	TEXT
MRX_SSM_OONP_COPAY_1M_2_NUM	TEXT
MRX_TIER_MOSSTD_COINS_2M_MIN	TEXT
MRX_TIER_RSPFD_COPAY_DAILY	TEXT
MRX_RAI_FRQ_RI_DESC_2RX	TEXT
MRX_SSM_OONP_COINS_1M_2_NUM	TEXT
MRX_TIER_MOSSTD_COINS_2M_MAX	TEXT
MRX_TIER_MOSTD_COPAY_DAILY	TEXT
MRX_RAI_ELIG_CRIT_2RX	TEXT
MRX_SSM_OONP_COPAY_OTH_2_NUM	TEXT
MRX_TIER_MOSSTD_COINS_3M_MIN	TEXT
MRX_TIER_MOSSTD_COPAY_DAILY	TEXT
MRX_RAI_MEET_ADH_GOAL_YN_2RX	TEXT
MRX_SSM_OONP_COINS_OTH_2_NUM	TEXT
MRX_TIER_MOSPFD_COPAY_DAILY	TEXT
MRX_TIER_MOSSTD_COINS_3M_MAX	TEXT
MAX_RAI_ANN_PARTD_REW_AMT_2RX	TEXT
MRX_SSM_SMOCS_COPAY_1M_2_NUM	TEXT
MRX_TIER_LTCP_COPAY_DAILY	TEXT
MRX_TIER_MOSPFD_COINS_1M_MIN	TEXT
MRX_RAI_TYPE_PARTD_REW_3RX	TEXT
MRX_SSM_SMOCS_COINS_1M_2_NUM	TEXT
MRX_TIER_FORM_MODEL_DESC	TEXT
MRX_TIER_MOSPFD_COINS_1M_MAX	TEXT
MAX_RAI_PARTD_REW_INC_AMT_3RX	TEXT
MRX_SSM_SMOCS_COPAY_2M_2_NUM	TEXT
MRX_TIER_INCLUDES_MMP	TEXT
MRX_TIER_MOSPFD_COINS_2M_MIN	TEXT
MAX_RAI_FRQ_REW_INCENT_3RX	TEXT
MRX_SSM_SMOCS_COINS_2M_2_NUM	TEXT
MRX_TIER_COPAY_AMT_RSTD_MMPMIN	TEXT
MRX_TIER_MOSPFD_COINS_2M_MAX	TEXT
MRX_RAI_FRQ_RI_DESC_3RX	TEXT
MRX_SSM_SMOCS_COPAY_3M_2_NUM	TEXT
MRX_TIER_COPAY_AMT_RSTD_MMPMAX	TEXT
MRX_TIER_IRA_RSTD_COPAY_1M	TEXT
MRX_TIER_MOSPFD_COINS_3M_MIN	TEXT
MRX_RAI_ELIG_CRIT_3RX	TEXT
MRX_SSM_SMOCS_COINS_3M_2_NUM	TEXT
MRX_TIER_COPAY_AMT_OON_MMPMIN	TEXT
MRX_TIER_IRA_RSTD_COPAY_2M	TEXT
MRX_TIER_MOSPFD_COINS_3M_MAX	TEXT
MRX_RAI_MEET_ADH_GOAL_YN_3RX	TEXT
MRX_SSM_PMOCS_COPAY_1M_2_NUM	TEXT
MRX_TIER_COPAY_AMT_OON_MMPMAX	TEXT
MRX_TIER_IRA_RSTD_COPAY_3M	TEXT
MRX_TIER_OONP_COPAY_1M_MIN	TEXT
MAX_RAI_ANN_PARTD_REW_AMT_3RX	TEXT
MRX_SSM_PMOCS_COINS_1M_2_NUM	TEXT
MRX_TIER_COPAY_AMT_MSTD_MMPMIN	TEXT
MRX_TIER_IRA_RSPFD_COPAY_1M	TEXT
MRX_TIER_OONP_COPAY_1M_MAX	TEXT
MRX_SSM_PMOCS_COPAY_2M_2_NUM	TEXT
MRX_TIER_COPAY_AMT_MSTD_MMPMAX	TEXT
MRX_TIER_IRA_RSPFD_COPAY_2M	TEXT
MRX_TIER_OONP_COPAY_OTH_MIN	TEXT
MRX_SSM_PMOCS_COINS_2M_2_NUM	TEXT
MRX_TIER_COPAY_AMT_LTC_MMPMIN	TEXT
MRX_TIER_IRA_RSPFD_COPAY_3M	TEXT
MRX_TIER_OONP_COPAY_OTH_MAX	TEXT
MRX_SSM_PMOCS_COPAY_3M_2_NUM	TEXT
MRX_TIER_COPAY_AMT_LTC_MMPMAX	TEXT
MRX_TIER_IRA_MOSTD_COPAY_1M	TEXT
MRX_TIER_OONP_COINS_1M_MIN	TEXT
MRX_SSM_PMOCS_COINS_3M_2_NUM	TEXT
MRX_TIER_IRA_MOSTD_COPAY_2M	TEXT
MRX_TIER_OONP_COINS_1M_MAX	TEXT
MRX_SSM_LTCP_COPAY_1M_2_NUM	TEXT
MRX_TIER_GAP_PART_DRUGS	TEXT
MRX_TIER_IRA_MOSTD_COPAY_3M	TEXT
MRX_TIER_OONP_COINS_OTH_MIN	TEXT
MRX_SSM_LTCP_COINS_1M_2_NUM	TEXT
MRX_TIER_GAP_PART_INCLUDES	TEXT
MRX_TIER_IRA_MOPFD_COPAY_1M	TEXT
MRX_TIER_OONP_COINS_OTH_MAX	TEXT
MRX_SSM_CUI_TIERS_3_CHK	TEXT
MRX_TIER_IRA_MOPFD_COPAY_2M	TEXT
MRX_TIER_LTCP_COPAY_1M_MIN	TEXT
MRX_SSM_SRCS_COPAY_1M_3_NUM	TEXT
MRX_TIER_IRA_MOPFD_COPAY_3M	TEXT
MRX_TIER_LTCP_COPAY_1M_MAX	TEXT
MRX_SSM_SRCS_COINS_1M_3_NUM	TEXT
MRX_TIER_IRA_OONP_COPAY_1M	TEXT
MRX_TIER_LTCP_COINS_1M_MIN	TEXT
MRX_SSM_SRCS_COPAY_2M_3_NUM	TEXT
MRX_TIER_IRA_OONP_COPAY_OTHNUM	TEXT
MRX_TIER_LTCP_COINS_1M_MAX	TEXT
MRX_SSM_SRCS_COINS_2M_3_NUM	TEXT
MRX_TIER_IRA_LTCP_COPAY_1M	TEXT
MRX_TIER_RSTD_1M_NUM_VB	TEXT
MRX_SSM_SRCS_COPAY_3M_3_NUM	TEXT
MRX_TIER_IRA_RSTD_COINS_1M	TEXT
MRX_TIER_RSTD_COPAY_DAILY_VB	TEXT
MRX_SSM_SRCS_3_CHK	TEXT
MRX_SSM_SRCS_COINS_3M_3_NUM	TEXT
MRX_TIER_IRA_RSTD_COINS_2M	TEXT
MRX_TIER_MOSTD_1M_NUM_VB	TEXT
MRX_SSM_PRCS_3_CHK	TEXT

…and 124 more columns. Run DESCRIBE VIEW DWV.BENEFITS_DATA__PART_D once the share is mounted for the complete column list.

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

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.PBP_A_HNUMBER, d.PBP_A_PLAN_IDENTIFIER, d.SEGMENT_ID,
       ff.TEMPORAL_START, ff.TEMPORAL_END, ff.CMS_FEED_MODIFIED
FROM DWV.BENEFITS_DATA__PART_D d
JOIN DWV.FEEDS_FILES ff ON d.FILE_ID = ff.ID;

Source & provenance

Published by the Centers for Medicare & Medicaid Services.

• Official CMS documentation (MA/Part D contract and enrollment data)

• Latest source file from CMS (zip)

Frequently asked questions

How often is Benefits Data - Part D Drug Coverage updated?

CMS last published this feed on 2026-01-01. New releases are added automatically when CMS publishes them.

What years does Benefits Data - Part D Drug Coverage cover?

2019 through 2026.

How many records are in Benefits Data - Part D Drug Coverage?

1,953,186 rows across all 19 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 - Part D Drug Coverage data?

It's included in the CMS Data Research Dataset on the Snowflake Marketplace (free trial available). Once mounted, query DWV.BENEFITS_DATA__PART_D directly — no pipeline setup required.

Related feeds

Benefits Data - Inpatient Hospital (Acute)Benefits Data - Covered ServicesBenefits Data - Inpatient Hospital (Psychiatric)Benefits Data - Premiums & DeductiblesBenefits Data - Plan Information

Get this feed

1. Start a free trial on Snowflake Marketplace

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 Research Dataset — 22 research tables · 20 years of Medicare Advantage & Part D history · updated daily. Back to the full catalog →