Insurer negotiated rates

CMS Marketplace monthly effectuated enrollment release history

medicare_silver.fact_marketplace_monthly_effectuated_enrollment_history·live·silver

Rows

6,588

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS rolling monthly Marketplace effectuated enrollment by state and exchange platform from January 2016 through February 2026 in the accepted release, retaining release identity, publisher totals, and Bronze lineage.

Grain

Key	Grain
N/A	1One state-or-publisher-total by platform, coverage year, and coverage month observation inside one immutable CMS release artifact.

Columns (27)

Column	Type	Meaning
`coverage_year`	int
`coverage_month`	int
`coverage_month_name`	string
`state_code`	string
`platform`	string
`effectuated_enrollment`	bigint
`is_publisher_total`	boolean
`source_row_number`	bigint
`source_artifact_sha256`	string
`source_artifact_bytes`	bigint
`publisher_modified`	string
`expected_artifact_rows`	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_monthly_effectuated_enrollment_history")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_marketplace_monthly_effectuated_enrollment_history WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`source_id,source_artifact_sha256,state_code,platform,coverage_year,coverage_month`
Join	`how_to_join(source_fqn="medicare_silver.fact_marketplace_monthly_effectuated_enrollment_history")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_marketplace_monthly_effectuated_enrollment_history

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