# MA plan payment, county rollup, parser 0.4.0

`medicare_silver.ma_plan_payment_county_v2` · Medicare Advantage, Part D, Medicaid · status live · 232,368 rows

CMS 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). Parser 0.4.0 reload; get_ma_plan_payment (level county) reads this table from 2026-10-05.

**Grain.** One row per (payment_year, ssa_county_code, plan_type, snp_plan_type). 232,368 rows over 2006-2024, the served table's rows one for one (Athena 09c33b17, 2441fad6).

| 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: `query_substrate` with `SELECT ... FROM medicare_silver.ma_plan_payment_county_v2 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.ma_plan_payment_county_v2")` first.