Insurer negotiated rates

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

medicare_semantic.vw_hix_state_enrollment_observation_v1·partial·semantic_view

Rows

232,589

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1The 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.
2It is the observation layer under the enrollment_mix mart, NOT the mart: measure basis (selection, paid, effectuated, current) and population are not classified.

Grain

Key	Grain
N/A	1One reviewed-current source observation; 2(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).

Columns (49)

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

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`source_id,release_key,artifact_id,semantic_release_id,content_unit,row_ordinal`
Join	`how_to_join(source_fqn="medicare_semantic.vw_hix_state_enrollment_observation_v1")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_hix_state_enrollment_observation_v1
Company names	`hios_issuer_id_raw` `issuer_label` resolve to a permanent Vlada ID: `resolve_entity(text=<name>)`; the company pages hold owners and holdings
Note	Registered 2026-09-25 (Data Tracker states program, lane B) under register w4 vlada_w4_hix_state_enrollment_observation, door RAW. status partial: 7 of about 21 state-based exchanges, measure basis unclassified, NY unverified. Versioned, never overwritten: a changed projection is _v2 beside this one. The two underlying medicare_silver tables stay uncatalogued (baselined drift); the view is the door.

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