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 — 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__PREMIUMS_DEDUCTIBLES
Coverage	Jan 2019 – Jan 2026
Rows	1,031,536 (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	818 data + 5 lineage
Identifiers	Contract ID (H-number) · Plan ID
File versions	114 (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__PREMIUMS_DEDUCTIBLES
WHERE FILE_ID IN (
  SELECT ID FROM DWV.FEEDS_FILES WHERE IS_LATEST = 1
)
LIMIT 100;

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–2026 🟩🟩🟩🟩🟩🟩🟩🟩 (🟩 covered · ⬜ no data)

8 of 8 years covered — no gaps.

Release history

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

Show 9 earlier report periods

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

Data dictionary

📋 818 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
PBP_D_ANN_DEDUCT_YN	TEXT
PBP_D_ANN_DEDUCT_AMT_TYPE	TEXT
PBP_D_ANN_DEDUCT_AMT	TEXT
PBP_D_ANN_DEDUCT_COMB_TYPE	TEXT
PBP_D_ANN_DEDUCT_14A_YN	TEXT
PBP_D_ANN_DEDUCT_BENS	TEXT
PBP_D_ANN_DEDUCT_INN_MC_YN	TEXT
PBP_D_ANN_DEDUCT_INN_MC_CATS	TEXT
PBP_D_ANN_DEDUCT_INN_NMC_YN	TEXT
PBP_D_ANN_DEDUCT_INN_NMC_CATS	TEXT
PBP_D_ANN_DEDUCT_OON_NMC_YN	TEXT
PBP_D_ANN_DEDUCT_OON_NMC_CATS	TEXT
PBP_D_DIFF_DEDUCT_YN	TEXT
PBP_D_DIFF_DEDUCT_CATS	TEXT
PBP_D_DIFF_DEDUCT_1A_T1_AMT	TEXT
PBP_D_DIFF_DEDUCT_1A_T2_AMT	TEXT
PBP_D_DIFF_DEDUCT_1A_T3_AMT	TEXT
PBP_D_DIFF_DEDUCT_1A_B_AMT	TEXT
PBP_D_DIFF_DEDUCT_1A1_AMT	TEXT
PBP_D_DIFF_DEDUCT_1A1_T2_AMT	TEXT
PBP_D_DIFF_DEDUCT_1A1_T3_AMT	TEXT
PBP_D_DIFF_DEDUCT_1A2_AMT	TEXT
PBP_D_DIFF_DEDUCT_1A3_AMT	TEXT
PBP_D_DIFF_DEDUCT_1B_T1_AMT	TEXT
PBP_D_DIFF_DEDUCT_1B_T2_AMT	TEXT
PBP_D_DIFF_DEDUCT_1B_T3_AMT	TEXT
PBP_D_DIFF_DEDUCT_1B_B_AMT	TEXT
PBP_D_DIFF_DEDUCT_1B1_AMT	TEXT
PBP_D_DIFF_DEDUCT_1B1_T2_AMT	TEXT
PBP_D_DIFF_DEDUCT_1B1_T3_AMT	TEXT
PBP_D_DIFF_DEDUCT_1B2_AMT	TEXT
PBP_D_DIFF_DEDUCT_2_T1_AMT	TEXT
PBP_D_DIFF_DEDUCT_2_T2_AMT	TEXT
PBP_D_DIFF_DEDUCT_2_T3_AMT	TEXT
PBP_D_DIFF_DEDUCT_2_B_AMT	TEXT
PBP_D_DIFF_DEDUCT_2_1_AMT	TEXT
PBP_D_DIFF_DEDUCT_2_1_T2_AMT	TEXT
PBP_D_DIFF_DEDUCT_2_1_T3_AMT	TEXT
PBP_D_DIFF_DEDUCT_3_1_AMT	TEXT
PBP_D_DIFF_DEDUCT_3_2_AMT	TEXT
PBP_D_DIFF_DEDUCT_3_3_AMT	TEXT
PBP_D_DIFF_DEDUCT_3_4_AMT	TEXT
PBP_D_DIFF_DEDUCT_3_1_NMC_AMT	TEXT
PBP_D_DIFF_DEDUCT_3_2_NMC_AMT	TEXT
PBP_D_DIFF_DEDUCT_3_3_NMC_AMT	TEXT
PBP_D_DIFF_DEDUCT_3_4_NMC_AMT	TEXT
PBP_D_DIFF_DEDUCT_4A_AMT	TEXT
PBP_D_DIFF_DEDUCT_4B_AMT	TEXT
PBP_D_DIFF_DEDUCT_4C1_AMT	TEXT
PBP_D_DIFF_DEDUCT_4C2_AMT	TEXT
PBP_D_DIFF_DEDUCT_4C3_AMT	TEXT
PBP_D_DIFF_DEDUCT_5_AMT	TEXT
PBP_D_DIFF_DEDUCT_5B_AMT	TEXT
PBP_D_DIFF_DEDUCT_6_AMT	TEXT
PBP_D_DIFF_DEDUCT_7A_AMT	TEXT
PBP_D_DIFF_DEDUCT_7B_AMT	TEXT
PBP_D_DIFF_DEDUCT_7B1_AMT	TEXT
PBP_D_DIFF_DEDUCT_7B2_AMT	TEXT
PBP_D_DIFF_DEDUCT_7C_AMT	TEXT
PBP_D_DIFF_DEDUCT_7D_AMT	TEXT
PBP_D_DIFF_DEDUCT_7E1_AMT	TEXT
PBP_D_DIFF_DEDUCT_7E2_AMT	TEXT
PBP_D_DIFF_DEDUCT_7F_AMT	TEXT
PBP_D_DIFF_DEDUCT_7F_NMC_AMT	TEXT
PBP_D_DIFF_DEDUCT_7G_AMT	TEXT
PBP_D_DIFF_DEDUCT_7H1_AMT	TEXT
PBP_D_DIFF_DEDUCT_7H2_AMT	TEXT
PBP_D_DIFF_DEDUCT_7I_AMT	TEXT
PBP_D_DIFF_DEDUCT_7J_AMT	TEXT
PBP_D_DIFF_DEDUCT_7K_AMT	TEXT
PBP_D_DIFF_DEDUCT_8A1_AMT	TEXT
PBP_D_DIFF_DEDUCT_8A2_AMT	TEXT
PBP_D_DIFF_DEDUCT_8B1_AMT	TEXT
PBP_D_DIFF_DEDUCT_8B2_AMT	TEXT
PBP_D_DIFF_DEDUCT_8B3_AMT	TEXT
PBP_D_DIFF_DEDUCT_9A1_AMT	TEXT
PBP_D_DIFF_DEDUCT_9A2_AMT	TEXT
PBP_D_DIFF_DEDUCT_9B_AMT	TEXT
PBP_D_DIFF_DEDUCT_9C1_AMT	TEXT
PBP_D_DIFF_DEDUCT_9C2_AMT	TEXT
PBP_D_DIFF_DEDUCT_9D_AMT	TEXT
PBP_D_DIFF_DEDUCT_10A1_AMT	TEXT
PBP_D_DIFF_DEDUCT_10A2_AMT	TEXT
PBP_D_DIFF_DEDUCT_10B1_AMT	TEXT
PBP_D_DIFF_DEDUCT_10B2_AMT	TEXT
PBP_D_DIFF_DEDUCT_11A_AMT	TEXT
PBP_D_DIFF_DEDUCT_11B1_AMT	TEXT
PBP_D_DIFF_DEDUCT_11B2_AMT	TEXT
PBP_D_DIFF_DEDUCT_11C1_AMT	TEXT
PBP_D_DIFF_DEDUCT_11C2_AMT	TEXT
PBP_D_DIFF_DEDUCT_12_AMT	TEXT
PBP_D_DIFF_DEDUCT_13A_AMT	TEXT
PBP_D_DIFF_DEDUCT_13B_AMT	TEXT
PBP_D_DIFF_DEDUCT_13C_AMT	TEXT
PBP_D_DIFF_DEDUCT_13D_AMT	TEXT
PBP_D_DIFF_DEDUCT_13E_AMT	TEXT
PBP_D_DIFF_DEDUCT_13F_AMT	TEXT
PBP_D_DIFF_DEDUCT_13G_AMT	TEXT
PBP_D_DIFF_DEDUCT_14A_AMT	TEXT
PBP_D_DIFF_DEDUCT_14B_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C1_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C2_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C3_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C4_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C5_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C6_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C7_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C8_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C9_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C10_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C11_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C12_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C13_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C14_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C15_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C16_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C17_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C18_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C19_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C20_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C21_AMT	TEXT
PBP_D_DIFF_DEDUCT_14C22_AMT	TEXT
PBP_D_DIFF_DEDUCT_14D_AMT	TEXT
PBP_D_DIFF_DEDUCT_14E1_AMT	TEXT
PBP_D_DIFF_DEDUCT_14E2_AMT	TEXT
PBP_D_DIFF_DEDUCT_14E4_AMT	TEXT
PBP_D_DIFF_DEDUCT_14E5_AMT	TEXT
PBP_D_DIFF_DEDUCT_15_1_AMT	TEXT
PBP_D_DIFF_DEDUCT_15_2_AMT	TEXT
PBP_D_DIFF_DEDUCT_15_3_AMT	TEXT
PBP_D_DIFF_DEDUCT_15_NMC_AMT	TEXT
PBP_D_DIFF_DEDUCT_16A_N_AMT	TEXT
PBP_D_DIFF_DEDUCT_16B1_N_AMT	TEXT
PBP_D_DIFF_DEDUCT_16B2_N_AMT	TEXT
PBP_D_DIFF_DEDUCT_16B3_N_AMT	TEXT
PBP_D_DIFF_DEDUCT_16B4_N_AMT	TEXT
PBP_D_DIFF_DEDUCT_16B5_N_AMT	TEXT
PBP_D_DIFF_DEDUCT_16B6_N_AMT	TEXT
PBP_D_DIFF_DEDUCT_16C1_N_AMT	TEXT
PBP_D_DIFF_DEDUCT_16C2_N_AMT	TEXT
PBP_D_DIFF_DEDUCT_16C3_N_AMT	TEXT
PBP_D_DIFF_DEDUCT_16C4_N_AMT	TEXT
PBP_D_DIFF_DEDUCT_16C5_N_AMT	TEXT
PBP_D_DIFF_DEDUCT_16C6_N_AMT	TEXT
PBP_D_DIFF_DEDUCT_16C7_N_AMT	TEXT
PBP_D_DIFF_DEDUCT_16C8_N_AMT	TEXT
PBP_D_DIFF_DEDUCT_16C9_N_AMT	TEXT
PBP_D_DIFF_DEDUCT_16C10_N_AMT	TEXT
PBP_D_DIFF_DEDUCT_17A_AMT	TEXT
PBP_D_DIFF_DEDUCT_17A1_AMT	TEXT
PBP_D_DIFF_DEDUCT_17A2_AMT	TEXT
PBP_D_DIFF_DEDUCT_17B_AMT	TEXT
PBP_D_DIFF_DEDUCT_17B1_AMT	TEXT
PBP_D_DIFF_DEDUCT_17B2_AMT	TEXT
PBP_D_DIFF_DEDUCT_17B3_AMT	TEXT
PBP_D_DIFF_DEDUCT_17B4_AMT	TEXT
PBP_D_DIFF_DEDUCT_17B5_AMT	TEXT
PBP_D_DIFF_DEDUCT_18A_AMT	TEXT
PBP_D_DIFF_DEDUCT_18A1_AMT	TEXT
PBP_D_DIFF_DEDUCT_18A2_AMT	TEXT
PBP_D_DIFF_DEDUCT_18B1_AMT	TEXT
PBP_D_DIFF_DEDUCT_18B2_AMT	TEXT
PBP_D_DIFF_DEDUCT_18B3_AMT	TEXT
PBP_D_DIFF_DEDUCT_18B4_AMT	TEXT
PBP_D_DIFF_DEDUCT_18C_AMT	TEXT
PBP_D_DIFF_DEDUCT_20_AMT	TEXT
PBP_D_NMC_DEDUCT_YN	TEXT
PBP_D_NMC_DEDUCT_CATS	TEXT
PBP_D_DEDUCT_IHA_AMT	TEXT
PBP_D_MAND_DEDUCT_1A1_AMT	TEXT
PBP_D_MAND_DEDUCT_1A2_AMT	TEXT
PBP_D_MAND_DEDUCT_1A3_AMT	TEXT
PBP_D_DEDUCT_IHP_AMT	TEXT
PBP_D_MAND_DEDUCT_1B1_AMT	TEXT
PBP_D_MAND_DEDUCT_1B2_AMT	TEXT
PBP_D_DEDUCT_SNF_AMT	TEXT
PBP_D_MAND_DEDUCT_2_1_AMT	TEXT
PBP_D_MAND_DEDUCT_3_1_AMT	TEXT
PBP_D_MAND_DEDUCT_3_2_AMT	TEXT
PBP_D_MAND_DEDUCT_3_3_AMT	TEXT
PBP_D_MAND_DEDUCT_3_4_AMT	TEXT
PBP_D_MAND_DEDUCT_4C1_AMT	TEXT
PBP_D_MAND_DEDUCT_4C2_AMT	TEXT
PBP_D_MAND_DEDUCT_4C3_AMT	TEXT
PBP_D_MAND_DEDUCT_7B1_AMT	TEXT
PBP_D_MAND_DEDUCT_7B2_AMT	TEXT
PBP_D_DEDUCT_POD_AMT	TEXT
PBP_D_MAND_DEDUCT_10B1_AMT	TEXT
PBP_D_MAND_DEDUCT_10B2_AMT	TEXT
PBP_D_DEDUCT_ACUPUNC_AMT	TEXT
PBP_D_DEDUCT_OTC_AMT	TEXT
PBP_D_DEDUCT_MEAL_AMT	TEXT
PBP_D_DEDUCT_OTHER1_AMT	TEXT
PBP_D_DEDUCT_OTHER2_AMT	TEXT
PBP_D_DEDUCT_OTHER3_AMT	TEXT
PBP_D_DEDUCT_DSNP_HIS_AMT	TEXT
PBP_D_DEDUCT_APE_AMT	TEXT
PBP_D_MAND_DEDUCT_14C1_AMT	TEXT
PBP_D_MAND_DEDUCT_14C2_AMT	TEXT
PBP_D_MAND_DEDUCT_14C3_AMT	TEXT
PBP_D_MAND_DEDUCT_14C4_AMT	TEXT
PBP_D_MAND_DEDUCT_14C5_AMT	TEXT
PBP_D_MAND_DEDUCT_14C6_AMT	TEXT
PBP_D_MAND_DEDUCT_14C7_AMT	TEXT
PBP_D_MAND_DEDUCT_14C8_AMT	TEXT
PBP_D_MAND_DEDUCT_14C9_AMT	TEXT
PBP_D_MAND_DEDUCT_14C10_AMT	TEXT
PBP_D_MAND_DEDUCT_14C11_AMT	TEXT
PBP_D_MAND_DEDUCT_14C12_AMT	TEXT
PBP_D_MAND_DEDUCT_14C13_AMT	TEXT
PBP_D_MAND_DEDUCT_14C14_AMT	TEXT
PBP_D_MAND_DEDUCT_14C15_AMT	TEXT
PBP_D_MAND_DEDUCT_14C16_AMT	TEXT
PBP_D_MAND_DEDUCT_14C17_AMT	TEXT
PBP_D_MAND_DEDUCT_14C18_AMT	TEXT
PBP_D_MAND_DEDUCT_14C19_AMT	TEXT
PBP_D_MAND_DEDUCT_14C20_AMT	TEXT
PBP_D_MAND_DEDUCT_14C21_AMT	TEXT
PBP_D_MAND_DEDUCT_14C22_AMT	TEXT
PBP_D_MAND_DEDUCT_15_1_AMT	TEXT
PBP_D_MAND_DEDUCT_16B1_N_AMT	TEXT
PBP_D_MAND_DEDUCT_16B2_N_AMT	TEXT
PBP_D_MAND_DEDUCT_16B3_N_AMT	TEXT
PBP_D_MAND_DEDUCT_16B4_N_AMT	TEXT
PBP_D_MAND_DEDUCT_16B5_N_AMT	TEXT
PBP_D_MAND_DEDUCT_16B6_N_AMT	TEXT
PBP_D_MAND_DEDUCT_16C1_N_AMT	TEXT
PBP_D_MAND_DEDUCT_16C2_N_AMT	TEXT
PBP_D_MAND_DEDUCT_16C3_N_AMT	TEXT
PBP_D_MAND_DEDUCT_16C4_N_AMT	TEXT
PBP_D_MAND_DEDUCT_16C5_N_AMT	TEXT
PBP_D_MAND_DEDUCT_16C6_N_AMT	TEXT
PBP_D_MAND_DEDUCT_16C7_N_AMT	TEXT
PBP_D_MAND_DEDUCT_16C8_N_AMT	TEXT
PBP_D_MAND_DEDUCT_16C9_N_AMT	TEXT
PBP_D_MAND_DEDUCT_16C10_N_AMT	TEXT
PBP_D_MAND_DEDUCT_17A1_AMT	TEXT
PBP_D_MAND_DEDUCT_17A2_AMT	TEXT
PBP_D_MAND_DEDUCT_17B1_AMT	TEXT
PBP_D_MAND_DEDUCT_17B2_AMT	TEXT
PBP_D_MAND_DEDUCT_17B3_AMT	TEXT
PBP_D_MAND_DEDUCT_17B4_AMT	TEXT
PBP_D_MAND_DEDUCT_17B5_AMT	TEXT
PBP_D_MAND_DEDUCT_18A1_AMT	TEXT
PBP_D_MAND_DEDUCT_18A2_AMT	TEXT
PBP_D_MAND_DEDUCT_18B1_AMT	TEXT
PBP_D_MAND_DEDUCT_18B2_AMT	TEXT
PBP_D_MAND_DEDUCT_18B3_AMT	TEXT
PBP_D_MAND_DEDUCT_18B4_AMT	TEXT
PBP_D_MAND_DEDUCT_18C_AMT	TEXT
PBP_D_INN_DEDUCT_YN	TEXT
PBP_D_INN_DEDUCT_PARTB_YN	TEXT
PBP_D_INN_DEDUCT_AMT	TEXT
PBP_D_INN_DEDUCT_BENS	TEXT
PBP_D_INN_DEDUCT_M_YN	TEXT
PBP_D_INN_DEDUCT_M_CATS	TEXT
PBP_D_INN_DEDUCT_NM_YN	TEXT
PBP_D_INN_DEDUCT_NM_CATS	TEXT
PBP_D_COMB_DEDUCT_YN	TEXT
PBP_D_COMB_DEDUCT_PARTB_YN	TEXT
PBP_D_COMB_DEDUCT_AMT	TEXT
PBP_D_COMB_DEDUCT_BENS	TEXT
PBP_D_COMB_DEDUCT_INN_M_YN	TEXT
PBP_D_COMB_DEDUCT_INN_M_CATS	TEXT
PBP_D_COMB_DEDUCT_INN_NM_YN	TEXT
PBP_D_COMB_DEDUCT_INN_NM_CATS	TEXT
PBP_D_COMB_DEDUCT_OON_M_YN	TEXT
PBP_D_COMB_DEDUCT_OON_M_CATS	TEXT
PBP_D_COMB_DEDUCT_OON_NM_YN	TEXT
PBP_D_COMB_DEDUCT_OON_NM_CATS	TEXT
PBP_D_OON_DEDUCT_YN	TEXT
PBP_D_OON_DEDUCT_PARTB_YN	TEXT
PBP_D_OON_DEDUCT_AMT	TEXT
PBP_D_OON_DEDUCT_BENS	TEXT
PBP_D_OON_DEDUCT_M_YN	TEXT
PBP_D_OON_DEDUCT_M_CATS	TEXT
PBP_D_OON_DEDUCT_NM_YN	TEXT
PBP_D_OON_DEDUCT_NM_CATS	TEXT
PBP_D_NON_DEDUCT_YN	TEXT
PBP_D_NON_DEDUCT_PARTB_YN	TEXT
PBP_D_NON_DEDUCT_AMT	TEXT
PBP_D_NON_DEDUCT_BENS	TEXT
PBP_D_NON_DEDUCT_M_YN	TEXT
PBP_D_NON_DEDUCT_M_CATS	TEXT
PBP_D_NON_DEDUCT_NM_YN	TEXT
PBP_D_NON_DEDUCT_NM_CATS	TEXT
PBP_D_OUT_POCKET_AMT_YN	TEXT
PBP_D_OUT_POCKET_AMT_TYPE	TEXT
PBP_D_OUT_POCKET_AMT	TEXT
PBP_D_INN_MAX_ENR_OOPC_BENS	TEXT
PBP_D_INN_MAX_ENR_M_YN	TEXT
PBP_D_INN_MAX_ENR_M_CAT_EX	TEXT
PBP_D_INN_MAX_ENR_NM_YN	TEXT
PBP_D_INN_MAX_ENR_NM_CAT_EX	TEXT
PBP_D_COMB_MAX_ENR_AMT_YN	TEXT
PBP_D_COMB_MAX_ENR_AMT_TYPE	TEXT
PBP_D_COMB_MAX_ENR_AMT	TEXT
PBP_D_COMB_MAX_ENR_OOPC_BENS	TEXT
PBP_D_COMB_MAX_ENR_INN_M_YN	TEXT
PBP_D_COMB_MAX_ENR_INN_MCAT_EX	TEXT
PBP_D_COMB_MAX_ENR_INN_NM_YN	TEXT
PBP_D_COMB_MAX_ENR_INN_NMCATEX	TEXT
PBP_D_COMB_MAX_ENR_OON_M_YN	TEXT
PBP_D_COMB_MAX_ENR_OON_MCAT_EX	TEXT
PBP_D_COMB_MAX_ENR_OON_NM_YN	TEXT
PBP_D_COMB_MAX_ENR_OON_NMCATEX	TEXT
PBP_D_OON_MAX_ENR_OOPC_YN	TEXT
PBP_D_OON_MAX_ENR_OOPC_AMT	TEXT
PBP_D_OON_MAX_ENR_OOPC_BENS	TEXT
PBP_D_OON_MAX_ENR_M_YN	TEXT
PBP_D_OON_MAX_ENR_M_CAT_EX	TEXT
PBP_D_OON_MAX_ENR_NM_YN	TEXT
PBP_D_OON_MAX_ENR_NM_CAT_EX	TEXT
PBP_D_MAXENR_OOPC_YN	TEXT
PBP_D_MAXENR_OOPC_TYPE	TEXT
PBP_D_MAXENR_OOPC_AMT	TEXT
PBP_D_MAXENR_OOPC_BENS	TEXT
PBP_D_MAXENR_OOPC_M_CATS_YN	TEXT
PBP_D_MAXENR_OOPC_M_CATS	TEXT
PBP_D_MAXENR_OOPC_NM_CATS_YN	TEXT
PBP_D_MAXENR_OOPC_NM_CATS	TEXT
PBP_D_MPLUSC_PREMIUM	TEXT
PBP_D_MPLUSC_BONLY_PREMIUM	TEXT
PBP_D_MCO_PAY_REDUCT_YN	TEXT
PBP_D_MCO_PAY_REDUCT_AMT	TEXT
PBP_D_BALBILL_YN	TEXT
PBP_D_BALBILL_PROV_CATS	TEXT
PBP_D_BALBILL_MIN_PCT	TEXT
PBP_D_BALBILL_MAX_PCT	TEXT
PBP_D_MSA_DED_AMT	TEXT
PBP_D_MSA_ANNUAL_AMT	TEXT
PBP_D_RICS_YN	TEXT
PBP_D_RICS_CNT	TEXT
PBP_D_RICS_GRP_NAME_1	TEXT
PBP_D_RICS_CATS_EHC_1	TEXT
PBP_D_RICS_MC_CATS_1	TEXT
PBP_D_RICS_NMC_CATS_1	TEXT
PBP_D_RICS_MAX_BENE_AMT_1	TEXT
PBP_D_RICS_PERIOD_1	TEXT
PBP_D_RICS_PERIOD_D_1	TEXT
PBP_D_RICS_COMB_SHR_YN_1	TEXT
PBP_D_RICS_COMB_PKG_NUM_1	TEXT
PBP_D_RICS_APP_DED_YN_1	TEXT
PBP_D_RICS_MOD_1	TEXT
PBP_D_RICS_MOD_1_D	TEXT
PBP_D_RICS_GRP_NAME_2	TEXT
PBP_D_RICS_CATS_EHC_2	TEXT
PBP_D_RICS_MC_CATS_2	TEXT
PBP_D_RICS_NMC_CATS_2	TEXT
PBP_D_RICS_MAX_BENE_AMT_2	TEXT
PBP_D_RICS_PERIOD_2	TEXT
PBP_D_RICS_PERIOD_D_2	TEXT
PBP_D_RICS_COMB_SHR_YN_2	TEXT
PBP_D_RICS_COMB_PKG_NUM_2	TEXT
PBP_D_RICS_APP_DED_YN_2	TEXT
PBP_D_RICS_MOD_2	TEXT
PBP_D_RICS_MOD_2_D	TEXT
PBP_D_RICS_GRP_NAME_3	TEXT
PBP_D_RICS_CATS_EHC_3	TEXT
PBP_D_RICS_MC_CATS_3	TEXT
PBP_D_RICS_NMC_CATS_3	TEXT
PBP_D_RICS_MAX_BENE_AMT_3	TEXT
PBP_D_RICS_PERIOD_3	TEXT
PBP_D_RICS_PERIOD_D_3	TEXT
PBP_D_RICS_COMB_SHR_YN_3	TEXT
PBP_D_RICS_COMB_PKG_NUM_3	TEXT
PBP_D_RICS_APP_DED_YN_3	TEXT
PBP_D_RICS_MOD_3	TEXT
PBP_D_RICS_MOD_3_D	TEXT
PBP_D_RICS_GRP_NAME_4	TEXT
PBP_D_RICS_CATS_EHC_4	TEXT
PBP_D_RICS_MC_CATS_4	TEXT
PBP_D_RICS_NMC_CATS_4	TEXT
PBP_D_RICS_MAX_BENE_AMT_4	TEXT
PBP_D_RICS_PERIOD_4	TEXT
PBP_D_RICS_PERIOD_D_4	TEXT
PBP_D_RICS_COMB_SHR_YN_4	TEXT
PBP_D_RICS_COMB_PKG_NUM_4	TEXT
PBP_D_RICS_APP_DED_YN_4	TEXT
PBP_D_RICS_MOD_4	TEXT
PBP_D_RICS_MOD_4_D	TEXT
PBP_D_RICS_GRP_NAME_5	TEXT
PBP_D_RICS_CATS_EHC_5	TEXT
PBP_D_RICS_MC_CATS_5	TEXT
PBP_D_RICS_NMC_CATS_5	TEXT
PBP_D_RICS_MAX_BENE_AMT_5	TEXT
PBP_D_RICS_PERIOD_5	TEXT
PBP_D_RICS_PERIOD_D_5	TEXT
PBP_D_RICS_COMB_SHR_YN_5	TEXT
PBP_D_RICS_COMB_PKG_NUM_5	TEXT
PBP_D_RICS_APP_DED_YN_5	TEXT
PBP_D_RICS_MOD_5	TEXT
PBP_D_RICS_MOD_5_D	TEXT
PBP_D_COMBO_SUPP_BEN_YN	TEXT
PBP_D_COMBO_NUM_GRPS	TEXT
PBP_D_COMBO_GRP_NAME_1	TEXT
PBP_D_COMBO_NMC_CATS_1	TEXT
PBP_D_COMBO_MODE_1	TEXT
PBP_D_COMBO_MODE_OTHER_1	TEXT
PBP_D_COMBO_ENROLLEE_LIM_YN_1	TEXT
PBP_D_COMBO_MAX_PLAN_BEN_YN_1	TEXT
PBP_D_COMBO_MAX_PLAN_BEN_AMT_1	TEXT
PBP_D_COMBO_MAX_PLAN_PERIOD_1	TEXT
PBP_D_COMBO_MAX_PLAN_PRD_D_1	TEXT
PBP_D_COMBO_SHARE_VISIT_YN_1	TEXT
PBP_D_COMBO_SHARE_VISIT_AMT_1	TEXT
PBP_D_COMBO_SHR_VST_PERIOD_1	TEXT
PBP_D_COMBO_GRP_NAME_2	TEXT
PBP_D_COMBO_NMC_CATS_2	TEXT
PBP_D_COMBO_MODE_2	TEXT
PBP_D_COMBO_MODE_OTHER_2	TEXT
PBP_D_COMBO_ENROLLEE_LIM_YN_2	TEXT
PBP_D_COMBO_MAX_PLAN_BEN_YN_2	TEXT
PBP_D_COMBO_MAX_PLAN_BEN_AMT_2	TEXT
PBP_D_COMBO_MAX_PLAN_PERIOD_2	TEXT
PBP_D_COMBO_MAX_PLAN_PRD_D_2	TEXT
PBP_D_COMBO_SHARE_VISIT_YN_2	TEXT
PBP_D_COMBO_SHARE_VISIT_AMT_2	TEXT
PBP_D_COMBO_SHR_VST_PERIOD_2	TEXT
PBP_D_COMBO_GRP_NAME_3	TEXT
PBP_D_COMBO_NMC_CATS_3	TEXT
PBP_D_COMBO_MODE_3	TEXT
PBP_D_COMBO_MODE_OTHER_3	TEXT
PBP_D_COMBO_ENROLLEE_LIM_YN_3	TEXT
PBP_D_COMBO_MAX_PLAN_BEN_YN_3	TEXT
PBP_D_COMBO_MAX_PLAN_BEN_AMT_3	TEXT
PBP_D_COMBO_MAX_PLAN_PERIOD_3	TEXT
PBP_D_COMBO_MAX_PLAN_PRD_D_3	TEXT
PBP_D_COMBO_SHARE_VISIT_YN_3	TEXT
PBP_D_COMBO_SHARE_VISIT_AMT_3	TEXT
PBP_D_COMBO_SHR_VST_PERIOD_3	TEXT
PBP_D_COMBO_GRP_NAME_4	TEXT
PBP_D_COMBO_NMC_CATS_4	TEXT
PBP_D_COMBO_MODE_4	TEXT
PBP_D_COMBO_MODE_OTHER_4	TEXT
PBP_D_COMBO_ENROLLEE_LIM_YN_4	TEXT
PBP_D_COMBO_MAX_PLAN_BEN_YN_4	TEXT
PBP_D_COMBO_MAX_PLAN_BEN_AMT_4	TEXT
PBP_D_COMBO_MAX_PLAN_PERIOD_4	TEXT
PBP_D_COMBO_MAX_PLAN_PRD_D_4	TEXT
PBP_D_COMBO_SHARE_VISIT_YN_4	TEXT
PBP_D_COMBO_SHARE_VISIT_AMT_4	TEXT
PBP_D_COMBO_SHR_VST_PERIOD_4	TEXT
PBP_D_COMBO_GRP_NAME_5	TEXT
PBP_D_COMBO_NMC_CATS_5	TEXT
PBP_D_COMBO_MODE_5	TEXT
PBP_D_COMBO_MODE_OTHER_5	TEXT
PBP_D_COMBO_ENROLLEE_LIM_YN_5	TEXT
PBP_D_COMBO_MAX_PLAN_BEN_YN_5	TEXT
PBP_D_COMBO_MAX_PLAN_BEN_AMT_5	TEXT
PBP_D_COMBO_MAX_PLAN_PERIOD_5	TEXT
PBP_D_COMBO_MAX_PLAN_PRD_D_5	TEXT
PBP_D_COMBO_SHARE_VISIT_YN_5	TEXT
PBP_D_COMBO_SHARE_VISIT_AMT_5	TEXT
PBP_D_COMBO_SHR_VST_PERIOD_5	TEXT
PBP_C_OON_OUTPT_GROUP_NUM_ID	NUMBER
PBP_C_OON_YN	TEXT
PBP_C_POS_OUTPT_GROUP_NUM_ID	TEXT
PBP_D_OPT_IDENTIFIER	TEXT
PBP_D_OPT_OON_CAT_ID	TEXT
PBP_C_OON_BENDESC_BENS	TEXT
PBP_C_OON_OUTPT_GRP_LBL	TEXT
PBP_C_POS_GROUP_LBL	TEXT
PBP_D_OPT_DESCRIPTION	TEXT
PBP_D_OPT_NAME	TEXT
PBP_D_OPT_OON_IDENTIFIER	TEXT
PBP_C_OON_MC_BENDESC_CATS	TEXT
PBP_C_OON_OUTPT_BENDESC_BEN	NUMBER
PBP_C_POS_OUPT_BENCAT_BENS	TEXT
PBP_D_AMT_OPT_PREMIUM	TEXT
PBP_D_OPT_OON_TYPE_ID	TEXT
PBP_C_OON_NMC_BENDESC_CATS	TEXT
PBP_C_OON_OUT_MC_BENDESC_CATS	TEXT
PBP_C_POS_OUTPT_MC_BENCATS	TEXT
PBP_D_OPT_MAXPLAN_BEN_COV_YN	TEXT
PBP_D_OPT_OON_YN	TEXT
PBP_C_OON_COINS_IHS_YN	TEXT
PBP_C_OON_OUT_NMC_BENDESC_CATS	TEXT
PBP_C_POS_OUTPT_NMC_BENCATS	TEXT
PBP_D_OPT_MAXPLAN_BEN_COV_AMT	TEXT
PBP_D_OPT_OON_CSTSHRS_YN	TEXT
PBP_C_OON_COINS_IHS_BEN_TYPE	TEXT
PBP_C_OON_OUTPT_MAXPLAN_YN	NUMBER
PBP_C_POS_OUTPT_COINS_YN	TEXT
PBP_D_OPT_MAXPLAN_PER	TEXT
PBP_D_OPT_OON_COINS_YN	TEXT
PBP_C_OON_COINS_IHA_MC_COST_YN	TEXT
PBP_C_OON_OUTPT_MAXPLAN_AMT	NUMBER
PBP_C_POS_OUTPT_COINS_MIN_PCT	TEXT
PBP_D_OPT_APPLY_MOOP_YN	TEXT
PBP_D_OPT_MAXPLAN_PER_D	TEXT
PBP_D_OPT_OON_COINS_MIN_PCT	TEXT

…and 318 more columns. Run DESCRIBE VIEW DWV.BENEFITS_DATA__PREMIUMS_DEDUCTIBLES 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__PREMIUMS_DEDUCTIBLES 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 - Premiums & Deductibles updated?

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

What years does Benefits Data - Premiums & Deductibles cover?

2019 through 2026.

How many records are in Benefits Data - Premiums & Deductibles?

1,031,536 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 - 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 - Part D Drug CoverageBenefits Data - Plan InformationBenefits Data - Inpatient Hospital (Acute)Benefits Data - Inpatient Hospital (Psychiatric)Benefits Data - Covered Services

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 →