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

`medicare_silver.ma_rate_calculation_cell` · Medicare Advantage, Part D, Medicaid · status live · 8,268,673 rows

CMS's ratebook supporting data: for every rate year and county, how the MA rate was built. The 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. Joins medicare_silver.ma_county_ratebook on (rate_year, geo_code = ssa_county_code).

**Grain.** One row per published cell: (rate_year, rate_period, source_member, row_number, column_index). Long form; pivot by measure_key.

| 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: `query_substrate` with `SELECT ... FROM medicare_silver.ma_rate_calculation_cell WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.ma_rate_calculation_cell")` first.