Medicare Advantage, Part D, Medicaid

MA plan payment, county rollup, parser 0.4.0

medicare_silver.ma_plan_payment_county_v2·live·silver

Rows

232,368

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS county-level summary of MA Part C payments and risk by county, plan type and SNP type: average A/B payment PMPM (standardized to a 1.0 risk score), average risk score, average rebate PMPM and the average MSA monthly deposit (2006-2012).
2Parser 0.4.0 reload; get_ma_plan_payment (level county) reads this table from 2026-10-05.

Grain

Key	Grain
N/A	1One row per (payment_year, ssa_county_code, plan_type, snp_plan_type). 2232,368 rows over 2006-2024, the served table's rows one for one (Athena 09c33b17, 2441fad6).

Columns (15)

Column	Type	Meaning
`payment_year`	int
`ssa_county_code`	string
`state_abbreviation`	string
`county_name`	string
`plan_type`	string
`snp_plan_type`	string
`avg_ab_pmpm_payment`	double
`avg_part_c_risk_score`	double
`avg_rebate_pmpm_payment`	double
`avg_msa_monthly_deposit_pmpm`	double
`source_url`	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_plan_payment_county_v2")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.ma_plan_payment_county_v2 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`ssa_county_code`
Join	`how_to_join(source_fqn="medicare_silver.ma_plan_payment_county_v2")`
Raw door	Tool: get_ma_plan_payment (level county); Athena: medicare_silver.ma_plan_payment_county_v2 (pin payment_year)
Note	Wave-1A reload (Data Tracker, docs/data-tracker/RELOAD-PLAN-WAVE1A-MA-LOADERS-2026-10-01.md, defects MAPAY-4/-5). Versioned, never overwritten; the legacy card stays live as the rollback.

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