# USPCC (United States Per Capita Costs), rate years 2003-2027

`medicare_silver.ma_uspcc` · Medicare Advantage, Part D, Medicaid · status live · 6,033 rows

CMS's national Medicare cost per beneficiary per month by calendar year, Part A and Part B: the growth base behind every MA benchmark and, from 2020, the FFS USPCC that scales county FFS rates. Through 2012 the columns are retrospective (actual) against prospective (projected); from 2013 current against last year's estimate. Populations change by era: aged, disabled and ESRD (2003-2011); aged+disabled and dialysis-only (2012-2018); total (2019); non-ESRD total, non-ESRD FFS and dialysis-only (2020-2027); a growth-rate row from 2020.

**Grain.** One row per published value: (rate_year, rate_period, block, part, row_kind, calendar_year, calendar_period, column_index). Every rate_year restates the series.

| column | type | meaning |
|---|---|---|
| rate_year | int |  |
| rate_period | string |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| as_of_label | string |  |
| block | string |  |
| part | string |  |
| row_kind | string |  |
| row_label | string |  |
| calendar_year | int |  |
| calendar_year_correction | string |  |
| calendar_period | string |  |
| footnote_ref | string |  |
| footnote_text | string |  |
| column_index | int |  |
| column_header | string |  |
| population | string |  |
| estimate_basis | string |  |
| value_text | string |  |
| value_num | double |  |
| value_unit | string |  |
| source_member | 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_uspcc WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.ma_uspcc")` first.