Medicare Advantage, Part D, Medicaid

MA Rate Calculation Data: how CMS computed each county's MA rate, 1999-2027

medicare_silver.ma_rate_calculation_cell·live·silver

Rows

8,268,673

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS's ratebook supporting data: for every rate year and county, how the MA rate was built.
2The risk-rate build (prior FFS and pre-ACA rates, minimum update, GME/IME/KAC, AGA, credibility, the current FFS rate, the quartile (applicable) percent, the qualifying-county double bonus, the caps and the 0%, 3.5% and 5% bonus-tier rates, which are the ratebook), the pre-2012 aged and disabled builds, the PACE and ESRD builds, the county statutory component of the regional benchmarks, and the five-year county FFS risk-score history.
3Joins medicare_silver.ma_county_ratebook on (rate_year, geo_code = ssa_county_code).

Grain

Key	Grain
N/A	1One row per published cell: (rate_year, rate_period, source_member, row_number, column_index). 2Long form; pivot by measure_key.

Columns (25)

Column	Type	Meaning
`rate_year`	int
`rate_period`	string
`effective_period_start`	date
`effective_period_end`	date
`table_kind`	string
`source_member`	string
`geo_level`	string
`geo_code`	string
`state`	string
`county_name`	string
`row_number`	int
`column_index`	int
`column_header`	string
`column_group`	string
`column_formula`	string
`measure_key`	string
`value_text`	string
`value_num`	double
`value_unit`	string
`source_url`	string
`member_sha256`	string
`sha256_content_hash`	string
`bronze_publication_id`	string
`asserted_at`	timestamp
`parser_artifact_hash`	string

Query it

describe_data_source(source_fqn="medicare_silver.ma_rate_calculation_cell")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.ma_rate_calculation_cell WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`rate_year,rate_period,source_member,row_number,column_index`
Join	`how_to_join(source_fqn="medicare_silver.ma_rate_calculation_cell")`
Raw door	Athena (read-only via query_substrate): medicare_silver.ma_rate_calculation_cell
Note	Data Tracker lane F, loaded 2026-09-29: 8,268,673 cells, 29 rate years 1999-2027 (31 editions), 0 duplicate natural keys, 0 lineage nulls (Athena fa08f5a0-c0af-4f08-a31a-d7426998e0ea); rerun left every year unchanged. The bonus-tier rates equal ma_county_ratebook to the cent for all 126,600 values 2015-2027. Register source cms_ma_rate_calculation_data (w3). Superseded for pivoting by medicare_silver.ma_rate_calculation_cell_v2 (2026-09-30, RATECALC-1); this table is unchanged.

This page as markdown: /docs-md/data/medicare_silver_ma_rate_calculation_cell.md · every page in one file: /llms-full.txt