Medicare Advantage·Risk scores and benchmarks

Medicare Advantage Plan Payments

Ask it in Studio3 days free, then $99 a month
Query from your AIFree · 300 calls a month
Order the file · $2,500Every table, every row, Parquet, invoiced
Rows
387,679
Tables
4
Free
4 of 4
Levels
plan · contract · parent · county (CMS's county rollup)
Years
2006-2024
Updates
annual
Publisher
CMS
4 tables · the sheet opens any of them
The product's tables
TableRows
/ Part D Medical Loss Ratio (MLR)(contract_id, contract_year). CMS MA/Part-D Medical Loss Ratio Public Use File, 4,984 rows across 2014-2023. Contract-level (no plan grain).2014–23 · annual4,984
Risk scores by countycounty × plan type × year2006–24 · annual232,368
Part C risk scores by planplan × year2006–24 · annual65,872
Part D risk scores by planplan × year2006–24 · annual84,455

/ Part D Medical Loss Ratio (MLR)

medicare_silver.fact_ma_mlrone row is (contract_id, contract_year). CMS MA/Part-D Medical Loss Ratio Public Use File, 4,984 rows across 2014-2023. Contract-level (no plan grain).

/ Part D Medical Loss Ratio (MLR): 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