Medicare Advantage, Part D, Medicaid

MA plan payment, Part D (plan x year), parser 0.4.0

medicare_silver.ma_plan_payment_part_d_v2·live·silver

Rows

84,466

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS Part D plan-payment reference per plan and payment year: the average direct subsidy PMPM (standardized to a 1.0 risk score), reinsurance and low-income cost-sharing PMPMs and the average Part D risk score, for MA-PD and stand-alone PDP plans.
2Parser 0.4.0 reload; get_plan_payment and get_ma_plan_payment read this table from 2026-10-05.

Grain

Key	Grain
N/A	1One row per (payment_year, contract_id, plan_id). 284,466 rows over 2006-2024: the served table's 84,455 rows one for one plus the 11 contract rows of 2006 (Athena 09c33b17, 2441fad6).

Columns (15)

Column	Type	Meaning
`payment_year`	int
`contract_id`	string
`plan_id`	string
`contract_name`	string
`organization_type`	string
`avg_direct_subsidy_pmpm`	double
`avg_part_d_risk_score`	double
`avg_reinsurance_pmpm`	double
`avg_low_income_cost_sharing_pmpm`	double
`contract_level_row`	boolean
`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_part_d_v2")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.ma_plan_payment_part_d_v2 WHERE <filter> LIMIT 100")

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

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