Insurer negotiated rates

CMS Marketplace issuer and plan enrollment measure history

medicare_silver.fact_marketplace_plan_enrollment_measure_history·live·silver

Rows

233,906

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS annual Marketplace plan-level enrollment measures across federal-platform and independent state-based Marketplace workbooks through business year 2025, preserving measure eras, suppression, exact plan identifiers, and workbook/Bronze lineage.

Grain

Key	Grain
N/A	1One source-native plan measure observation per business year, platform, issuer, plan, workbook sheet row, and immutable workbook artifact.

Columns (40)

Column	Type	Meaning
`business_year`	int
`workbook_release_year`	int
`platform`	string
`methodology_era`	string
`coverage_type`	string
`grain`	string
`state_code`	string
`issuer_hios_id`	string
`plan_id`	string
`plan_id_kind`	string
`county_fips`	string
`county_raw`	string
`workbook_sheet`	string
`source_row_number`	bigint
`source_measure_name`	string
`measure_name`	string
`raw_value`	string
`numeric_value`	decimal(24,6)
`value_state`	string
`source_workbook_sha256`	string
`source_workbook_bytes`	bigint
`sheet_logical_sha256`	string
`publisher_modified_at`	string
`publisher_observation_status`	string
`expected_table_measure_observations`	bigint
`observed_period`	date
`asserted_at`	date
`effective_period_start`	date
`effective_period_end`	date
`cms_vintage_sequence`	int
`parse_revision`	int
`parser_artifact_hash`	string
`source_url`	string
`sha256_content_hash`	string
`source_id`	string
`is_current`	boolean
`bronze_object_key`	string
`s3_version_id`	string
`vintage_tag`	string
`drug_source_version_id`	string

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`source_id,source_workbook_sha256,workbook_sheet,source_row_number,source_measure_name`
Join	`how_to_join(source_fqn="medicare_silver.fact_marketplace_plan_enrollment_measure_history")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_marketplace_plan_enrollment_measure_history

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