# MA plan crosswalk — annual lineage (silver)

`medicare_silver.plan_crosswalks_annual` · Medicare Advantage, Part D, Medicaid · status partial

CMS annual plan-crosswalk lineage (consolidations, renames, terminations) used by the MA enrollment-trend proof rail to stitch enrollment across plan-year boundaries. Pinned to its silver_published snapshot in the proof receipt's lineage_table slot.

**Grain.** Annual plan-crosswalk lineage edges across contract-years.

| column | type | meaning |
|---|---|---|
| previous_contract_id | string |  |
| previous_plan_id | string |  |
| current_contract_id | string |  |
| current_plan_id | string |  |
| plan_year | int |  |
| previous_plan_name_raw | string |  |
| current_plan_name_raw | string |  |
| status_raw | string |  |
| status_normalized | string |  |
| previous_snp_type | string |  |
| previous_snp_institutional | string |  |
| previous_snp_population | string |  |
| previous_snp_percentage | string |  |
| current_snp_type | string |  |
| current_snp_institutional | string |  |
| current_snp_population | string |  |
| current_snp_percentage | string |  |
| schema_era | string |  |
| observed_period | date |  |
| asserted_at | date |  |
| effective_period_start | date |  |
| effective_period_end | date |  |
| cms_vintage_sequence | int |  |
| parse_revision | int |  |
| parser_artifact_hash | string |  |
| source_url | string |  |
| sha256_content_hash | string |  |

Tools that read it: get_county_view, get_landscape_benefit_change, get_landscape_exits, prove_ma_enrollment_trend

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.plan_crosswalks_annual WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.plan_crosswalks_annual")` first.