# MA rate notices CY2000-2027: every printed risk model factor

`medicare_silver.ma_rate_notice_risk_model_cell` · Medicare Advantage, Part D, Medicaid · status live · 57,194 rows

A product of the CMS MA rate notices (register cms_ma_rate_notices): every printed risk model factor, one row per printed risk factor (CMS-HCC, RxHCC, ESRD, frailty, risk score, predictive ratio, CY2004-2007 dollar coefficients, CY2005-2008 transplant calculations). Built from the same load as the value table and pointing at the printed number (sha256_content_hash, page, line_index, source_line); never more certain than the print. Read the dataset's traps before comparing years.

**Grain.** One row per printed risk factor (CMS-HCC, RxHCC, ESRD, frailty, risk score, predictive ratio, CY2004-2007 dollar coefficients, CY2005-2008 transplant calculations): (sha256_content_hash,page,line_index,token_index).

| column | type | meaning |
|---|---|---|
| rate_year | int |  |
| stage | string |  |
| source_stage | string |  |
| status | string |  |
| model_key | string |  |
| table_kind | string |  |
| table_caption | string |  |
| row_label | string |  |
| variable | string |  |
| calendar_year | int |  |
| column_index | int |  |
| column_header | string |  |
| value_num | double |  |
| value_text | string |  |
| value_unit | string |  |
| engine2_confirmed | boolean |  |
| sha256_content_hash | string |  |
| page | int |  |
| line_index | int |  |
| token_index | int |  |
| source_line | string |  |
| source_url | string |  |
| asserted_at | timestamp |  |
| parser_artifact_hash | string |  |
| row_path | string |  |
| table_block | int |  |

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