# MA rate notices CY2000-2027: the per capita cost (USPCC) history

`medicare_silver.ma_rate_notice_uspcc_estimate` · Medicare Advantage, Part D, Medicaid · status live · 5,571 rows

A product of the CMS MA rate notices (register cms_ma_rate_notices): the per capita cost (USPCC) history, one row per calendar year x part x population as printed in one edition, current and prior estimate. 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 calendar year x part x population as printed in one edition, current and prior estimate: (sha256_content_hash,table_kind,population,part,calendar_year,row_variant).

| column | type | meaning |
|---|---|---|
| rate_year | int |  |
| stage | string |  |
| source_stage | string |  |
| table_kind | string |  |
| population | string |  |
| part | string |  |
| calendar_year | int |  |
| row_variant | string |  |
| current_estimate | double |  |
| prior_estimate | double |  |
| ratio_printed | double |  |
| ratio_basis | string |  |
| ratio_check | boolean |  |
| table_caption | string |  |
| sha256_content_hash | string |  |
| page | int |  |
| line_index | int |  |
| source_line | string |  |
| source_url | string |  |
| asserted_at | timestamp |  |
| parser_artifact_hash | string |  |
| prior_kind | string |  |

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