# State-based exchange enrollment observations - seven state marketplaces' own published figures, one view

`medicare_semantic.vw_hix_state_enrollment_observation_v1` · Insurer negotiated rates · status partial · 232,589 rows

The enrollment figures seven state-based marketplaces publish themselves (CA Covered California, KY kynect/KHBE, NJ DOBI and GetCoveredNJ, NY State of Health, VA Insurance Marketplace, WA Healthplanfinder), projected from the reviewed-current observation_json into typed columns: state, source, release, observation period and its kind, measure name, unit, market scope, geography, issuer, plan, breakdown axis and value, value and suppression status, with full file lineage. It is the observation layer under the enrollment_mix mart, NOT the mart: measure basis (selection, paid, effectuated, current) and population are not classified.

**Grain.** One reviewed-current source observation; (source_id, release_key, artifact_id, semantic_release_id, content_unit, row_ordinal) is unique (measured 2026-09-25, 232,589 rows = 232,589 distinct keys, Athena e0877aa7).

| column | type | meaning |
|---|---|---|
| state_code | string |  |
| source_id | string |  |
| release_key | string |  |
| source_url | string |  |
| observation_period | string |  |
| observation_period_kind | varchar(15) |  |
| observation_period_source_key | varchar(18) |  |
| snapshot_release_period | string |  |
| measure_name | string |  |
| measure_name_source_key | varchar(44) |  |
| measure_qualifier | string |  |
| observation_family | string |  |
| unit | string |  |
| market_scope | string |  |
| population_raw | string |  |
| geography_type | string |  |
| geography_label | string |  |
| issuer_label | string |  |
| hios_issuer_id_raw | string |  |
| hios_issuer_id | string |  |
| plan_label | string |  |
| plan_id | string |  |
| breakdown_axis | string |  |
| breakdown_value | string |  |
| breakdown_detail_raw | string |  |
| row_type | string |  |
| value | double |  |
| value_raw | string |  |
| suppression_status | string |  |
| reported_percentage | double |  |
| market_share_percent | double |  |
| source_locator | string |  |
| source_worksheet | string |  |
| schema_era_id | string |  |
| artifact_id | string |  |
| sha256_content_hash | string |  |
| semantic_release_id | string |  |
| parser_id | string |  |
| parser_version | string |  |
| profile_sha256 | string |  |
| parsed_at | string |  |
| content_unit | string |  |
| row_ordinal | bigint |  |
| observation_sha256 | string |  |
| releases_carrying_this_observation | bigint |  |
| reviewed_at | string |  |
| reviewer | string |  |
| review_decision_sha256 | string |  |
| observation_json | string |  |

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