# CMS Marketplace monthly effectuated enrollment release history

`medicare_silver.fact_marketplace_monthly_effectuated_enrollment_history` · Insurer negotiated rates · status live · 6,588 rows

CMS 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.** One state-or-publisher-total by platform, coverage year, and coverage month observation inside one immutable CMS release artifact.

| 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: `query_substrate` with `SELECT ... FROM medicare_silver.fact_marketplace_monthly_effectuated_enrollment_history WHERE ... LIMIT 100`; read `describe_data_source("medicare_silver.fact_marketplace_monthly_effectuated_enrollment_history")` first.