Insurer negotiated rates

States K8 Forward exposure: marketplace_forward_exposure_v1

medicare_silver.marketplace_forward_exposure_v1·partial·silver

Rows

19,530

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Marketplace product K8 (Forward exposure) of the States lane: forward exposure in the Marketplace: members facing a known event by parent.
2One row per state x parent x measure x forecast quarter.
3Quote the lower and upper bounds beside the point estimate; headline_publishable = false rows are held (held_reasons) and are not a headline.
451 state(s): AK AL AR AZ CA CO CT DC DE FL GA HI IA ID IL IN KS KY LA MA MD ME MI MN MO MS MT NC ND NE NH NJ NM NV NY OH OK OR PA RI SC SD TN TX UT VA VT WA WI WV WY.

Grain

Key	Grain
N/A	1Forward exposure in the Marketplace: members facing a known event by parent. 219,530 rows (Athena, 2026-10-29). 3Period 2026 to 2028 (forecast_year).

Columns (33)

Column	Type	Meaning
`row_key`	string
`state_code`	string
`parent_id`	string
`parent_name`	string
`parent_basis`	string
`business_year`	int
`measure_name`	string
`exchange_platform`	string
`coverage_scope`	string
`forecast_quarter`	string
`forecast_year`	int
`forecast_anchor`	date
`horizon_months`	int
`horizon_end`	date
`event_family`	string
`evidence_as_of`	date
`observed_members_denominator`	double
`n_suppressed_plan_rows`	int
`members_high_confidence`	double
`matched_event_members`	double
`known_no_event_members`	double
`unknown_schedule_members`	double
`schedule_coverage_pct`	double
`exposure_lower_bound_members`	double
`exposure_upper_bound_members`	double
`exposure_point_estimate_members`	double
`exposure_point_estimate_pct`	double
`headline_publishable`	boolean
`held_reasons`	string
`candidate_event_count`	int
`candidate_events_json`	string
`input_receipts_json`	string
`participation_status_json`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	N/A
Join	`how_to_join(source_fqn="medicare_silver.marketplace_forward_exposure_v1")`
Raw door	Athena (read-only via query_substrate): medicare_silver.marketplace_forward_exposure_v1 (filter state_code)
Company names	`parent_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings

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