Insurer negotiated rates

Virginia Insurance Marketplace enrollment metrics — state publisher history

va_vim_enrollment_metrics·partial·silver

Rows

286

Columns

N/A

History

N/A

Card

nocolumns only

Typed tools

What it is

1Virginia Insurance Marketplace PY2024 quarterly/OE and two byte-distinct but semantically equal PY2025 metric-ID static revisions, plus a separately resolved public Power BI model containing Open Enrollment PY2024-PY2026, quarterly 2025-Q1 through 2026-Q2 and source dictionaries.
2Pre-PY2024 federal-platform history retains CMS lineage.

Grain

Key	Grain
N/A	1One source-native metric observation within one immutable Virginia artifact, publisher snapshot/as-of date, page and source row or metric ID.

Columns (0)

Columns are not in the catalog for this source; describe_data_source("va_vim_enrollment_metrics") reads them live.

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`source_id,source_artifact_sha256,plan_year,snapshot_label,metric_id_or_source_page_row`
Join	`how_to_join(source_fqn="va_vim_enrollment_metrics")`
Raw door	Athena (read-only via query_substrate): medicare_semantic.vw_hix_state_enrollment_observation_v1 WHERE source_id = 'va_vim_enrollment_metrics' (registered 2026-09-25 under w4 vlada_w4_hix_state_enrollment_observation, door RAW). The physical history (medicare_silver.fact_hix_state_artifact_revision_history, source_observation_history, reviewed_current_pointer_history) stays uncatalogued by design; the view is the door.

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