Medicare Advantage, Part D, Medicaid

Medicare Plan Finder Online Enrollment Center requests, monthly, 2014-2026

medicare_silver.fact_oec_monthly_enrollment·live·silver

Rows

205

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1National monthly count of enrollment requests completed through the Medicare Plan Finder Online Enrollment Center: total, PDP and MA, since 2014-12.
22026-08: 120,591 requests (24,424 MA, 96,167 PDP);
32025 total 3,298,042 (789,036 MA).

Grain

Key	Grain
N/A	1One row per (edition, data_month); is_current marks each data month's newest edition.

Columns (37)

Column	Type	Meaning
`edition`	string
`edition_through_month`	date
`data_month`	date
`month_raw`	string
`publisher_era`	string
`source_member`	string
`source_member_sha256`	string
`capture_origin`	string
`captured_at`	string
`wayback_raw_url`	string
`total_enrollments`	bigint
`total_enrollments_raw`	string
`pdp_enrollments`	bigint
`pdp_enrollments_raw`	string
`ma_enrollments`	bigint
`ma_enrollments_raw`	string
`ytd_total_enrollments`	bigint
`ytd_total_enrollments_raw`	string
`ytd_pdp_enrollments`	bigint
`ytd_pdp_enrollments_raw`	string
`ytd_ma_enrollments`	bigint
`ytd_ma_enrollments_raw`	string
`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_oec_monthly_enrollment")     # the card, live
query_substrate(sql="SELECT * FROM medicare_silver.fact_oec_monthly_enrollment WHERE <filter> LIMIT 100")

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`edition,data_month`
Join	`how_to_join(source_fqn="medicare_silver.fact_oec_monthly_enrollment")`
Raw door	Athena (read-only via query_substrate): medicare_silver.fact_oec_monthly_enrollment
Note	Register source cms_oec_monthly_report (w3, serve raw). RAW. Loaded 2026-09-29 (verify_tracker_loads PASS 2026-09-30: 205 rows, 141 current data months, total = PDP + MA on every row, 2026 total = the file's YTD; Athena 256dd552, 710ec76a, 1d0d544e). Cell reconciliation PASS on both eras (every row compared). Registered 2026-09-30.

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