# Medicaid plan-to-parent ownership crosswalk v2 - effective-dated edges from state plan keys to parent companies (current)

`medicare_silver.medicaid_plan_parent_crosswalk_v2` · State programs · status partial · 1,087 rows

The current crosswalk: v1's 1,066 edges byte for byte (the build refuses otherwise) plus 21 reviewed edges with evidence (pipelines/medicare/data/medicaid_plan_parent_crosswalk_extension_v2.yaml): the four NC LME/MCO Tailored Plans (each its own public parent), NC CFSP (Blue Cross NC), CO RAEs (Colorado Access, the CCHA joint venture as its own parent, Rocky Mountain Health Plans to UnitedHealth, Northeast Health Partners, Health Colorado, Denver Health), and NH 2019-09..2022-05 and NE 2017-01..2022-11 continuity of existing decisions.

**Grain.** One effective-dated ownership edge; crosswalk_row_id is unique (measured 2026-09-27, 1,087 rows = 1,087 ids, 271 parents, 44 states, 761 open edges, Athena 9af791cf).

| column | type | meaning |
|---|---|---|
| crosswalk_row_id | string |  |
| state_code | string |  |
| key_type | string |  |
| source_plan_identity_id | string |  |
| plan_name_raw | string |  |
| decision_plan_identity_id | string |  |
| parent_id | string |  |
| parent_name | string |  |
| parent_ticker | string |  |
| organization_type | string |  |
| population_scope | string |  |
| effective_start | string |  |
| effective_end | string |  |
| evidence_method | string |  |
| evidence_source | string |  |
| resolution_id | string |  |
| alias_method | string |  |
| alias_source | string |  |

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