# States K1H SBM enrollment history: marketplace_sbm_issuer_enrollment_history_v1

`medicare_silver.marketplace_sbm_issuer_enrollment_history_v1` · Insurer negotiated rates · status partial · 1,715 rows

Marketplace product K1H (SBM enrollment history) of the States lane: state-based exchange enrollment by issuer before CMS's issuer file reaches them (2014-2017), from the exchanges' own reports. THE EXCHANGE'S OWN COUNT, NOT THE CMS ISSUER PUF: never splice it onto the CMS series (vw_marketplace_enrollment_by_parent_v1) without keeping source_label beside every year. The measure differs by state: NY is qhp_individual_enrollees from the open enrollment report, CA is active_members_paid_effectuated, so never compare or add the two as one measure. Filter geo_level: NY prints counties and the state row is derivation sum_of_printed_county_cells, so summing both double counts. CA is quarterly snapshots (one source_label per as_of_date): pick one, never sum a year's quarters. parent_id_as_now is null where the issuer has no parent match (issuer_match_basis says why); WA does not publish it (absent is not zero). 2 state(s): CA NY.

**Grain.** State-based exchange enrollment by issuer before CMS's issuer file reaches them (2014-2017), from the exchanges' own reports. 1,715 rows (Athena, 2026-10-30). Period 2014 to 2017 (business_year).

| column | type | meaning |
|---|---|---|
| state_code | string |  |
| business_year | int |  |
| measure_name | string |  |
| measure_raw | string |  |
| as_of_date | date |  |
| source_label | string |  |
| document_url | string |  |
| document_sha256 | string |  |
| geo_level | string |  |
| geography_raw | string |  |
| issuer_name_raw | string |  |
| enrollees | int |  |
| pct_raw | string |  |
| derivation | string |  |
| hios_issuer_id | string |  |
| issuer_match_basis | string |  |
| locator | string |  |
| parent_id_as_now | string |  |
| parent_name_as_now | string |  |
| parent_as_now_row_key | string |  |
| parent_id_as_was | string |  |
| parent_as_was_status | string |  |
| source_file | string |  |
| source_file_git_blob | string |  |
| source_row_number | int |  |
| row_key | string |  |

Query it: `query_substrate` with `SELECT ... FROM medicare_silver.marketplace_sbm_issuer_enrollment_history_v1 WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.marketplace_sbm_issuer_enrollment_history_v1")` first.