State programs

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·partial·reference

Rows

1,087

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The 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

Key	Grain
N/A	1One 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).

Columns (18)

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

describe_data_source(source_fqn="medicare_silver.medicaid_plan_parent_crosswalk_v2")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.medicaid_plan_parent_crosswalk_v2 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`crosswalk_row_id`
Join	`how_to_join(source_fqn="medicare_silver.medicaid_plan_parent_crosswalk_v2")`
Raw door	Athena (read-only via query_substrate): medicare_silver.medicaid_plan_parent_crosswalk_v2
Company names	`parent_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Registered 2026-09-27 (Data Tracker states program, lane B) under register w8 vlada_w8_medicaid_plan_parent_crosswalk as the current crosswalk; v1 is retired and kept.

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