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

`medicare_semantic.vw_medicaid_mco_enrollment_tracker_reported_observation_v5` · State programs · status partial · 2,895,719 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.

**Grain.** One source-native reported enrollment observation from one of 87 state adapter branches; (source_table_fqn, source_observation_key) is unique (measured 2026-09-27, 2,895,719 rows = 2,895,719 distinct keys, Athena 44526aa8).

| 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_v5 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_medicaid_mco_enrollment_tracker_reported_observation_v5")` first.