State programs

Medicaid MCO parent share, monthly - materialization of 2026-09-27T02:18Z (current, read through the serving pointer)

medicare_silver.fact_medicaid_mco_parent_share_monthly_v20260927t0218z·partial·mart

Rows

28,970

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The CTAS parquet materialization of medicare_semantic.vw_medicaid_mco_parent_share_monthly_v3 taken 2026-09-27T02:18Z.
2The current materialization: the pointer reads it.
3Adds NC, OH, NH, NE, PR and CO (RAE attribution) to v2 and reads the new KY table; the other 30 states equal the prior served table row for row (queries 057ff9bd, d873a213).

Grain

Key	Grain
N/A	1Same grain and columns as the build view it materializes; 228,970 rows, 38 states, 4,315 state-months.

Columns (28)

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)

Query it

describe_data_source(source_fqn="medicare_silver.fact_medicaid_mco_parent_share_monthly_v20260927t0218z")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_medicaid_mco_parent_share_monthly_v20260927t0218z 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_silver.fact_medicaid_mco_parent_share_monthly_v20260927t0218z")`
Raw door	Internal: attributed internal, so the customer door reads it only through the pointer 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	Registered 2026-09-27 (lane B) under register w8 vlada_w8_medicaid_mco_parent_share. Attributed internal so the pointer is the one door.

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