# States M6 Ownership + subcontracting: medicaid_plan_subcontract_v1

`medicare_silver.medicaid_plan_subcontract_v1` · State programs · status partial · 378 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. 3 state(s): FL PA TX.

**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. 378 rows (Athena, 2026-10-30). Period 2010-04-23 to 2026-10-30 (valid_from).

| column | type | meaning |
|---|---|---|
| row_key | string |  |
| state_code | string |  |
| program_code | string |  |
| plan_identity_id | string |  |
| plan_identity_source | string |  |
| plan_name_raw | string |  |
| plan_parent_id | string |  |
| plan_parent_valid_from | string |  |
| plan_parent_valid_to | string |  |
| plan_parent_covers_period | string |  |
| function | string |  |
| function_detail | string |  |
| arrangement | string |  |
| subcontractor_org_id | string |  |
| subcontractor_name_raw | string |  |
| subcontractor_parent_id | string |  |
| subcontractor_parent_valid_from | string |  |
| subcontractor_parent_valid_to | string |  |
| subcontractor_parent_evidence | string |  |
| affiliate_status | string |  |
| valid_from | string |  |
| valid_from_precision | string |  |
| valid_to | string |  |
| valid_to_precision | string |  |
| date_basis | string |  |
| period_start | string |  |
| period_end | string |  |
| members | string |  |
| members_as_of | string |  |
| members_basis | string |  |
| status | string |  |
| source_url | string |  |
| source_sha256 | string |  |
| source_locator | string |  |
| source_kind | string |  |
| capture_uri | string |  |
| first_observed_source_sha256 | string |  |
| first_observed_locator | string |  |
| source_observation_id | string |  |
| review_status | string |  |
| built_at | string |  |

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