# National Medicaid MCO enrollment ledger - every state's reported plan enrollment observations, one view

`medicare_semantic.vw_medicaid_mco_enrollment_tracker_reported_observation_v6` · State programs · status partial · 2,900,494 rows

A ledger, not a total. The union of every structured state Medicaid managed-care enrollment observation Vlada holds: 45 jurisdictions, 87 medicare_silver state tables, observation periods January 1996 to September 2026. Each row keeps the publisher's own cadence, measure name, unit, time basis, program, geography and plan label, its value status (reported, zero, suppressed, missing), its row role (detail component, publisher control, overlapping summary) and its file lineage. Plan and parent identities are the publisher's text; no canonical crosswalk is applied. v5 = v4 plus NC, OH, NH, NE, CO and PR monthly, AR and KS quarterly, and the new KY monthly table. v6 preserves every v5 field and source branch, correcting only Michigan native publisher_county_total and publisher_overall_total to publisher_control.

**Grain.** One source-native reported observation; (source_table_fqn, source_observation_key) is unique. Full candidate measured 2,900,494 rows and zero duplicate/null keys on 2026-10-15.

| column | type | meaning |
|---|---|---|
| state_code | varchar(2) |  |
| observation_period | timestamp |  |
| cadence | string |  |
| source_table_fqn | varchar(86) |  |
| source_id | string |  |
| source_observation_key | string |  |
| source_time_basis | string |  |
| source_observation_grain | string |  |
| source_measure_name_raw | string |  |
| program_name_raw | string |  |
| program_class | string |  |
| geography_type | string |  |
| geography_name_raw | string |  |
| geography_fips | string |  |
| plan_name_raw | string |  |
| source_plan_identity_id | string |  |
| canonical_plan_id | string |  |
| canonical_parent_id | string |  |
| source_dimension_1_raw | string |  |
| source_dimension_2_raw | string |  |
| reported_value | double |  |
| value_unit | string |  |
| value_status | string |  |
| source_row_role | string |  |
| row_role | varchar(19) |  |
| aggregation_status | varchar(18) |  |
| national_aggregation_authorized | boolean |  |
| source_url | string |  |
| sha256_content_hash | string |  |
| semantic_row_sha256 | string |  |
| bronze_object_key | string |  |
| s3_version_id | string |  |

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