# Medicaid managed care market share by parent company, monthly, per state (component sums, not totals)

`medicare_semantic.vw_medicaid_mco_parent_share_monthly` · State programs · status partial · 28,970 rows

One parent company's share of ONE state's reported comprehensive-medical managed-care plan enrollment in ONE month. parent_reported_value_sum adds the state's detail_component plan rows for one measure at one geography level from the Medicaid MCO enrollment ledger v5, comprehensive-medical programs only, publisher totals printed as plan rows removed, with plans resolved to parents through the effective-dated crosswalk medicare_silver.medicaid_plan_parent_crosswalk_v2. parent_share = parent_reported_value_sum / state_plan_row_sum within the state-month; unmapped_share is the share of plans with no ownership edge. CO rows are Regional Accountable Entity attribution, labelled by value_basis.

**Grain.** One parent company (or the one unmapped bucket) x one state x one month x one measure segment; (state_code, observation_period, segment_id, parent) is unique (measured 2026-09-27 on the pointer, 28,970 rows = 28,970 keys over 38 states and 4,315 state-months, Athena 51578552). Every segment has exactly one measure and one geography level.

| column | type | meaning |
|---|---|---|
| state_code | varchar(2) |  |
| observation_period | timestamp |  |
| segment_id | varchar(24) |  |
| measure | varchar(146) |  |
| value_unit | string |  |
| geography_type | string |  |
| geography_level | varchar(48) |  |
| source_time_basis | string |  |
| parent_id | string |  |
| parent_name | string |  |
| parent_ticker | string |  |
| is_unmapped_bucket | boolean |  |
| plan_rows | bigint |  |
| plan_keys | bigint |  |
| plan_labels | string |  |
| parent_reported_value_sum | double |  |
| state_plan_row_sum | double |  |
| state_mapped_sum | double |  |
| state_unmapped_sum | double |  |
| parent_share | double |  |
| unmapped_share | double |  |
| null_or_suppressed_rows | bigint |  |
| duplicate_rows_collapsed | bigint |  |
| evidence_methods | string |  |
| identity_edge_conflict | boolean |  |
| value_basis | varchar(39) |  |
| enrollment_total_authorized | boolean |  |
| crosswalk_version | varchar(125) |  |
| reported_after_contract_end | boolean |  |

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