Medicare Advantage, Part D, Medicaid

LIS Enrollment by Plan, 2006-2026

medicare_silver.lis_enrollment_plan·live·silver

Rows

102,495

Columns

History

N/A

Card

nocolumns only

Typed tools

What it is

1CMS's Low-Income-Subsidy enrollment per Part D plan (contract x PBP) per plan year, with the plan's total enrollment from 2011: the plan's LIS / dual mix.
22026: 5,172 MA-PD plans with 9,424,913 LIS enrollees and 472 PDPs with 4,325,701.

Grain

Key	Grain
N/A	1One row per (plan_year, part_d_stream, contract_id, plan_id): one annual snapshot per plan.

Columns (31)

Column	Type	Meaning
`plan_year`	int
`part_d_stream`	string
`contract_id`	string
`plan_id`	string
`plan_id_raw`	string
`contract_name_raw`	string
`plan_name_raw`	string
`total_enrolled`	int
`total_lower_bound`	int
`total_upper_bound`	int
`total_suppression_reason_code`	string
`lis_enrolled`	int
`lis_lower_bound`	int
`lis_upper_bound`	int
`lis_suppression_reason_code`	string
`lis_measure_basis`	string
`as_of_date`	date
`as_of_date_basis`	string
`schema_era`	string
`source_member`	string
`source_sheet`	string
`publisher_row_multiplicity`	int
`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

Query it

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

Item	Value
Typed tools that read it	none; raw SQL
Identity key	`plan_year,part_d_stream,contract_id,plan_id`
Join	`how_to_join(source_fqn="medicare_silver.lis_enrollment_plan")`
Raw door	Athena (read-only via query_substrate): medicare_silver.lis_enrollment_plan
Note	Register source cms_lis_enrollment_by_plan (w3, serve raw). RAW. Loaded 2026-09-29 (verify_tracker_loads PASS 2026-09-30: 102,495 rows = the publisher files, 0 duplicate keys, 0 lineage nulls; Athena 53d7d672, 30b13c9d, d5353186). Cell reconciliation PASS on 11 editions incl. 2006 and 2026 (docs/data-tracker/CELL-RECONCILIATION-2026-09-30.md). Registered by the Data Tracker registration lane 2026-09-30.

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