# Medicaid plan quality plan-ID crosswalk v1 (publisher plan name to canonical Medicaid plan id)

`medicare_silver.medicaid_plan_quality_plan_xwalk_v1` · State programs · status partial · 372 rows

Maps each plan name as a state printed it, per program and measurement year, to the canonical medicaid_plan_id + plan_product, with plan_display_name, program_class, parent_name, match_method (Q1_exact 212, Q2_reviewed 160) and basis (the publisher evidence for a reviewed decision). 157 printed plans resolve to 127 canonical plans; 372 of 372 plan-years resolved.

**Grain.** One row per (state_code, program_name_raw, plan_name_raw, measurement_year); 372 rows = 372 keys (Athena 6be006f0).

| column | type | meaning |
|---|---|---|
| state_code | string |  |
| program_name_raw | string |  |
| plan_name_raw | string |  |
| measurement_year | int |  |
| medicaid_plan_id | string |  |
| plan_product | string |  |
| plan_display_name | string |  |
| program_class | string |  |
| parent_name | string |  |
| match_method | string |  |
| basis | string |  |
| quality_rows | int |  |

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