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_v5·partial·semantic_view

Rows

2,895,719

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.

Grain

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

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_v5")     # the card, live
query_substrate(sql="SELECT * FROM medicare_semantic.vw_medicaid_mco_enrollment_tracker_reported_observation_v5 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_v5")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_medicaid_mco_enrollment_tracker_reported_observation_v5
Note	Registered 2026-09-27 (Data Tracker states program, lane B) under register source w8 vlada_w8_national_medicaid_mco_enrollment_ledger as the served ledger; supersedes v3 and v4, which are retired and kept. status is partial because coverage is incomplete (5 jurisdictions without monthly plan rows, 7 absent, 5 stale) and no row is authorized for aggregation, so every raw read carries the status caveat. The underlying state tables stay uncatalogued: the view is the only door, and the guard parses only the table the SQL names.

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