Medicare Advantage, Part D, Medicaid

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

medicare_semantic.vw_ma_uspcc_v2·live·semantic_view

Rows

6,033

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Every 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

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

Columns (29)

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

describe_data_source(source_fqn="medicare_semantic.vw_ma_uspcc_v2")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_ma_uspcc_v2 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_semantic.vw_ma_uspcc_v2")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_ma_uspcc_v2
Note	Series-key view (Data Tracker served-defect lane, 2026-09-30, defect USPCC-1). Versioned, never overwritten. Record docs/reference/source-audit/source-mastery/records/cms_ma_uspcc.json field_dictionary.defects USPCC-1.

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