# States M6 Ownership + subcontracting: vw_medicaid_mco_ownership_bridge_v1

`medicare_semantic.vw_medicaid_mco_ownership_bridge_v1` · State programs · status partial · 577 rows

Medicaid product M6 (Ownership + subcontracting) of the States lane: who owns each Medicaid managed care plan and who it subcontracts to: the reviewed plan-to-parent bridge, the state ownership disclosures and the plan subcontracts. vw_medicaid_mco_ownership_bridge_v1: one reviewed decision per plan identity, effective-dated (effective_start, effective_end); read the row whose interval covers your date. org_control_disclosure: one row per disclosed owner, ownership_percent as printed; a plan can list several owners and the percents need not sum to 100. medicaid_plan_subcontract_v1 (the subcontracting half): one row per state x plan (canonical id, dated parent) x function (pharmacy_pbm, dental, vision, behavioral_health, nemt) x subcontractor, dated valid_from / valid_to; arrangement says delegated_subcontract, affiliate_subcontract, plan_performs or carved_out_state_program. status = not_published rows are findings, never zero or absence. A delegate's members are never added to the prime's, and a delegated network is not a full-risk transfer. 43 state(s): AR AZ CA DC DE FL GA HI IA ID IL IN KS KY LA MA MD MI MN MO MS NC ND NE NH NJ NM NV NY OH OK OR PA PR RI SC TN TX UT VA WA WI WV.

**Grain.** Who owns each Medicaid managed care plan and who it subcontracts to: the reviewed plan-to-parent bridge, the state ownership disclosures and the plan subcontracts. 577 rows (Athena, 2026-10-29). Period 2004-01-01 to 2026-07-01 (effective_start).

| column | type | meaning |
|---|---|---|
| decision_ordinal | int |  |
| resolution_id | string |  |
| reviewed_at | string |  |
| state_code | string |  |
| plan_identity_id | string |  |
| legal_entity_name | string |  |
| ultimate_parent_name | string |  |
| canonical_parent_id | string |  |
| organization_type | string |  |
| ticker | string |  |
| relationship_type | string |  |
| ownership_pct_raw | string |  |
| minority_owner_name | string |  |
| minority_ownership_pct_raw | string |  |
| joint_owners_raw | string |  |
| administrator_name | string |  |
| analytic_role | string |  |
| public_parent_rollup_authorized | boolean |  |
| effective_start | date |  |
| effective_end | date |  |
| state_evidence_url | string |  |
| ownership_evidence_url | string |  |
| evidence_locator | string |  |

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