State programs

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

medicare_semantic.vw_medicaid_mco_enrollment_tracker_reported_observation_v6·partial·semantic_view

Rows

2,900,494

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1A ledger, not a total.
2The 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.
3Each 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.
4Plan 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

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

Columns (32)

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

describe_data_source(source_fqn="medicare_semantic.vw_medicaid_mco_enrollment_tracker_reported_observation_v6")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_medicaid_mco_enrollment_tracker_reported_observation_v6 WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`source_table_fqn,source_observation_key`
Join	`how_to_join(source_fqn="medicare_semantic.vw_medicaid_mco_enrollment_tracker_reported_observation_v6")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_medicaid_mco_enrollment_tracker_reported_observation_v6
Note	v6 corrects Michigan control roles while preserving values, keys, cadence, suppression, lineage and all other source branches. The inherited per-state counts and coverage caveats below were measured 2026-09-27 and are historical, not a new full-source acceptance. GA March source correction was independently applied and verified; MI missing files, OH restatements and derived parent-share materializations remain separate gates.

This page as markdown: /docs-md/data/medicare_semantic_vw_medicaid_mco_enrollment_tracker_reported_observation_v6.md · every page in one file: /llms-full.txt