Medicare Advantage, Part D, Medicaid

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

medicare_silver.ma_rate_calculation_cell_v2·live·silver

Rows

8,268,673

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS'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.
2Revision 1 keyed a column by its own header stack only, so a sub-label CMS prints under two spanning labels collapsed into one key.
3Revision 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.
4Adj.)').
5Every other key, value and column is identical to revision 1; measure_key_v1 carries the revision-1 key.

Grain

Key	Grain
N/A	1One 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).

Columns (27)

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

describe_data_source(source_fqn="medicare_silver.ma_rate_calculation_cell_v2")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.ma_rate_calculation_cell_v2 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_v2")`
Raw door	Athena (read-only via query_substrate): medicare_silver.ma_rate_calculation_cell_v2
Note	New parse revision (Data Tracker served-defect lane, 2026-09-30, defect RATECALC-1) written to a NEW table; medicare_silver.ma_rate_calculation_cell stays queryable and unchanged. Record docs/reference/source-audit/source-mastery/records/cms_ma_rate_calculation_data.json field_dictionary.defects RATECALC-1.

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