# Medicaid MCO parent share, monthly - materialization of 2026-09-27T02:18Z (current, read through the serving pointer)

`medicare_silver.fact_medicaid_mco_parent_share_monthly_v20260927t0218z` · State programs · status partial · 28,970 rows

The CTAS parquet materialization of medicare_semantic.vw_medicaid_mco_parent_share_monthly_v3 taken 2026-09-27T02:18Z. The current materialization: the pointer reads it. Adds NC, OH, NH, NE, PR and CO (RAE attribution) to v2 and reads the new KY table; the other 30 states equal the prior served table row for row (queries 057ff9bd, d873a213).

**Grain.** Same grain and columns as the build view it materializes; 28,970 rows, 38 states, 4,315 state-months.

| 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) |  |

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