Insurer negotiated rates

Marketplace enrollment by parent company (state, national, federal vs SBM)

medicare_semantic.vw_marketplace_enrollment_by_parent_v1·live·semantic_view

Rows

10,353

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1Sums issuer-level enrollment PUF plan rows through the parent bridge; average monthly enrollment BY2018-2025 (federal from BY2021) and federal ever-enrolled BY2014-2021, never mixed; geography-table rows never summed; suppressed cells kept as a lower bound.

Grain

Key	Grain
N/A	1parent_basis x parent x geography (state or US) x business_year x exchange platform x measure.

Columns (19)

Column	Type	Meaning
`parent_basis`	varchar(6)
`business_year`	int
`measure_name`	string
`exchange_platform`	string
`coverage_scope`	varchar(42)
`geo_level`	varchar(8)
`state_code`	string
`parent_id`	string
`parent_name`	string
`resolution_statuses`	string
`issuer_parent_kinds`	string
`brand_family`	string
`members`	decimal(38,6)
`n_issuers`	bigint
`n_plan_rows`	bigint
`n_suppressed_plan_rows`	bigint
`members_high_confidence`	decimal(38,6)
`share_of_geo`	decimal(38,6)
`members_note`	varchar(79)

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`parent_basis,business_year,measure_name,exchange_platform,state_code,parent_id`
Join	`how_to_join(source_fqn="medicare_semantic.vw_marketplace_enrollment_by_parent_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_marketplace_enrollment_by_parent_v1
Company names	`issuer_parent_kinds` `parent_name` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Created 2026-10-13 by the coordinator from pipelines/medicare/semantic/vw_marketplace_enrollment_by_parent_v1.sql: 10,353 rows (Athena 46b5288a). Registered 2026-10-13 by the Data Tracker registration lane (PR claude/tracker-registration-2026-10-13). Door RAW, World W4.

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