# USPCC (United States Per Capita Costs), one series key per CMS series, rate years 2003-2027

`medicare_semantic.vw_ma_uspcc_v2` · Medicare Advantage, Part D, Medicaid · status live · 6,033 rows

Every column of medicare_silver.ma_uspcc plus series: the non-ESRD USPCC that CMS labels 'Aged + Disabled' (2007-2018), 'Total USPCC' (2019-2020) and 'Non-ESRD total USPCC' (2021-2027) is series 'non_esrd_total' in every year; every other population keeps its code (aged, disabled, esrd, esrd_dialysis_only, non_esrd_ffs). population keeps the code as published.

**Grain.** One row per published value, the rows of medicare_silver.ma_uspcc (6,033; view minus table = 0, Athena b604a051-7993-489d-9688-272c1827670c).

| 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 |  |
| series | 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_semantic.vw_ma_uspcc_v2 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_ma_uspcc_v2")` first.