State programs

Medicaid MCO public-parent forward exposure, partial v7 cohort

medicare_silver.medicaid_mco_forward_exposure_v1·partial·silver

Rows

216

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Reported v7 same-store component members facing a dated RFP or contract end, or a certified rate-cycle reset.
2Includes the observed denominator, known-schedule members, coverage, lower and upper exposure bounds, and an explicit held reason.
3The current edition contains ten accepted states and no publishable headline.

Grain

Key	Grain
N/A	1One public parent x forecast quarter x event_type x horizon_months.

Columns (26)

Column	Type	Meaning
`ticker`	string
`public_parent_name`	string
`quarter`	string
`event_type`	string
`as_of_date`	string
`horizon_months`	bigint
`horizon_end`	string
`enrollment_anchor_month`	string
`enrollment_source_version`	string
`cohort_scope`	string
`cohort_publication_authorized`	boolean
`accepted_state_codes_json`	string
`coverage_denominator_note`	string
`same_store_cohort_sha256`	string
`observed_same_store_enrollment_denominator`	double
`known_schedule_enrollment`	double
`exposed_enrollment`	double
`unknown_schedule_enrollment`	double
`schedule_coverage_pct`	double
`exposure_lower_bound_pct`	double
`exposure_upper_bound_pct`	double
`exposure_point_estimate_pct`	double
`headline_publishable`	boolean
`headline_blocker`	string
`matched_schedule_ids_json`	string
`input_fingerprints_json`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`ticker,quarter,event_type,horizon_months`
Join	`how_to_join(source_fqn="medicare_silver.medicaid_mco_forward_exposure_v1")`
Raw door	Athena (read-only) at medicare_silver.medicaid_mco_forward_exposure_v1; filter headline_publishable=true for any point estimate.
Company names	`public_parent_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Content-addressed Parquet with serving lock, Glue location readback, 216 unique keys, six parents and zero published rows.

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