State programs

Medicaid managed care market share by parent company, monthly, per state (component sums, not totals)

medicare_semantic.vw_medicaid_mco_parent_share_monthly·partial·semantic_view

Rows

28,970

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1One parent company's share of ONE state's reported comprehensive-medical managed-care plan enrollment in ONE month. parent_reported_value_sum adds the state's detail_component plan rows for one measure at one geography level from the Medicaid MCO enrollment ledger v5, comprehensive-medical programs only, publisher totals printed as plan rows removed, with plans resolved to parents through the effective-dated crosswalk medicare_silver.medicaid_plan_parent_crosswalk_v2. parent_share = parent_reported_value_sum / state_plan_row_sum within the state-month; unmapped_share is the share of plans with no ownership edge.
2CO rows are Regional Accountable Entity attribution, labelled by value_basis.

Grain

Key	Grain
N/A	1One parent company (or the one unmapped bucket) x one state x one month x one measure segment; 2(state_code, observation_period, segment_id, parent) is unique (measured 2026-09-27 on the pointer, 28,970 rows = 28,970 keys over 38 states and 4,315 state-months, Athena 51578552). 3Every segment has exactly one measure and one geography level.

Columns (29)

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)
`reported_after_contract_end`	boolean

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`state_code,observation_period,segment_id,parent_id,is_unmapped_bucket`
Join	`how_to_join(source_fqn="medicare_semantic.vw_medicaid_mco_parent_share_monthly")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_medicaid_mco_parent_share_monthly
Company names	`parent_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	THE SERVED ENTRY for Data Tracker KPI MCD-08 (lane B, register w8 vlada_w8_medicaid_mco_parent_share). A stable serving pointer over the current dated materialization; reads take about 1 s (Athena 51578552 1.1 s). Door RAW. status partial: 38 states, three stale, CO attribution, no state-period authorized as a total. Re-pointed 2026-09-26 from medicare_silver.fact_medicaid_mco_parent_share_monthly_v20260926 to medicare_silver.fact_medicaid_mco_parent_share_monthly_v20260926t2334z (build view v2) and then to medicare_silver.fact_medicaid_mco_parent_share_monthly_v20260927t0218z (build view v3).

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