# MA Rate Calculation Data, parse revision 2: one measure_key per column, 1999-2027

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

CMS's ratebook supporting data (how every county's MA rate was built, 1999-2027), re-parsed from the same SHA-pinned publisher zips with measure_key unique within each member. Revision 1 keyed a column by its own header stack only, so a sub-label CMS prints under two spanning labels collapsed into one key. Revision 2 changes ONLY those 725,442 cells: it carries in the spanning label that covers the column ('Medicare Aged Benes In 1996 | Demographic Factor | Part A' vs 'Risk HMO Aged Benes 12/97 | ...'; '{Y} Dialysis Rate (a) | After $6 user fee deduction' vs '{Y} Dialysis Rate for PACE Plan (c) | ...'; 'County Rate ... | 3 Stars' vs 'Region Rate ... | 3 Stars'; 'For Non PACE plan | {Y} AGA factor ...' vs 'For PACE plan | ...') or, where no spanning label separates them, names the rate the column follows ('Rate | Category (for: {Y} Rate | Before Budget | Neutr. Adj.)'). Every other key, value and column is identical to revision 1; measure_key_v1 carries the revision-1 key.

**Grain.** One row per published cell: (rate_year, rate_period, source_member, row_number, column_index), the same 8,268,673 cells as medicare_silver.ma_rate_calculation_cell; measure_key is unique within (rate_year, rate_period, source_member).

| 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 |  |
| parse_revision | int |  |
| measure_key_v1 | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.ma_rate_calculation_cell_v2 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.ma_rate_calculation_cell_v2")` first.