Medicare Advantage·Part D

Part D Plans & Formularies

Ask it in Studio3 days free, then $99 a month
Query from your AIFree · 300 calls a month
A file to your specEvery table, every row, Parquet, invoiced
Rows
1,646,668,601
Tables
10
Free
10 of 10
Levels
plan · contract · parent · state · drug · prescriber specialty
Years
2019-2026
Updates
quarterly / annual
Publisher
CMS
10 tables · the sheet opens any of them
The product's tables
TableRows
Plans and formulariesplan × quarter2019–26 · quarterly160,922
Formulary drug coverageformulary × drug (NDC) × quarter2019–26 · quarterly42,858,106
Excluded drugsplan × drug × quarter2019–26 · quarterly355,140
Cost sharing by tierplan × tier × days supply × quarter2019–26 · quarterly4,939,689
Drug prices by planplan × drug (NDC) × days supply × quarter2019–26 · quarterly1,593,644,611
Service area by planplan × county × quarter2019–26 · quarterly2,387,499
Drug benefit by planplan × year2006–26 · annual247,907
Coverage gap benefitplan × year, to 20252008–24 · annual592,300
Pharmacy tiersplan × tier × year2007–26 · annual623,619
Filed drug tiersplan × tier × year2007–26 · annual858,808

Plans and formularies

drug_silver.dim_part_d_planone row is plan × quarter

Plans and formularies: the rows
#
Enter applies a filter · * is a wildcard · ! leaves a value out · a column's name sorts it · null is drawn as · · a page is what the engine returns in one answer; narrow the cut to see more of it