Public Sample Data

Medicare Monthly Enrollment by State & County 2013-2026 (CMS)

Explore the official Medicare Monthly Enrollment dataset from the Centers for Medicare & Medicaid Services (CMS). This filter-ready sheet contains 587,117 rows of Medicare enrollment counts for every year and month from 2013 through July 2026, reported at the national, state, and county level.

What is in the dataset?

Each row is a geography-and-period record with 60 fields of beneficiary counts: total Medicare beneficiaries, Original Medicare versus Medicare Advantage and other plans, Part A and Part B coverage, Part D prescription drug enrollment split by stand-alone PDP and MA-PD plans, Low-Income Subsidy status, dual Medicare-Medicaid eligibility categories (QMB, SLMB, QDWI/QI, full and partial dual), and demographics by age band, sex, race and ethnicity, disability, and ESRD status. State abbreviations, county names, and FIPS codes make it easy to join with other public health, provider, and plan datasets.

Common use cases

  • Measure Medicare Advantage penetration and Original Medicare share by county, state, or month.
  • Track Medicare enrollment growth and demographic shifts from 2013 to 2026.
  • Size Part D, dual-eligible, and Low-Income Subsidy populations for market planning.
  • Build enrollment denominators for provider, claims, pricing, and plan-landscape analysis.
  • Create county-level maps and territory prioritization for healthcare sales and policy research.

Counts are aggregate CMS administrative enrollment statistics, not individual beneficiary records; small-cell values suppressed by CMS are left blank. The source is a U.S. government work and is in the public domain.

View in Gigasheet ➜

Turn Price Transparency Data into Actionable Market Intelligence

‍
Healthcare organizations are using machine-readable price transparency data to uncover real market dynamics. Gigasheet's breakthrough analytic platform helps you translate that data into clear, decision-ready insights.

Analyze negotiated rates across payers and providers, identify pricing variation, benchmark against the market, and surface opportunities to improve contracts and reduce costs. This sample dataset is a preview of what’s possible.

Gigasheet scales from high-level aggregates down to row-level detail across billions of records, in a single click. Our analytics are enabling deeper analysis that leads to better decisions, stronger negotiations, and measurable financial impact.

Book A Demo

More Sample Data Files

Previous Spreadsheet

No previous post!
Back to all sample data

Next Spreadsheet

No next post!
Back to all sample data

Healthcare price intelligence

National Coverage
Scored & Benchmarked Rates
Expert Support
Request a Demo
LOW $1,804
MEDIAN $6,537
HIGH $21,743

By using this website, you agree to the storing of cookies on your device to enhance site navigation, analyze site usage, and assist in our marketing efforts. View our Privacy Policy for more information.