Medicare Advantage, Part D, Medicaid

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

medicare_silver.ma_uspcc·live·silver

Rows

6,033

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS'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.
2Through 2012 the columns are retrospective (actual) against prospective (projected); from 2013 current against last year's estimate.
3Populations 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

Key	Grain
N/A	1One row per published value: (rate_year, rate_period, block, part, row_kind, calendar_year, calendar_period, column_index). 2Every rate_year restates the series.

Columns (28)

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

describe_data_source(source_fqn="medicare_silver.ma_uspcc")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.ma_uspcc WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`rate_year,rate_period,block,part,row_kind,calendar_year,calendar_period,column_index`
Join	`how_to_join(source_fqn="medicare_silver.ma_uspcc")`
Raw door	Athena (read-only via query_substrate): medicare_silver.ma_uspcc
Note	Data Tracker lane F, loaded 2026-09-29: 6,033 values, 25 rate years 2003-2027, 0 duplicate natural keys, 0 lineage nulls (Athena df99a912-a73d-4365-972c-c943a3ff3a21); rerun left every year unchanged. FFS USPCC A+B equals the risk-rate file's printed FFS USPCC 2020-2027 (8/8); dialysis-only equals the ESRD file 2013-2027 (15/15). Register source cms_ma_uspcc (w3).

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