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

`medicare_semantic.vw_marketplace_enrollment_by_parent_v1` · Insurer negotiated rates · status live · 10,353 rows

Sums 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.** parent_basis x parent x geography (state or US) x business_year x exchange platform x measure.

| 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: `query_substrate` with `SELECT ... FROM medicare_semantic.vw_marketplace_enrollment_by_parent_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_semantic.vw_marketplace_enrollment_by_parent_v1")` first.