Business sample
Your state as files you can load.
State Desk and Group plans get these files for each state every month. This is the real Texas set, free to open.
SAMPLE build. Sources: CMS CY2027 plan file (data updated Oct 18, 2026), CY2026 plan file (Sep 2026), CPSC enrollment October 2026, 2027 Plan Crosswalk (Oct 1, 2026). CMS hides counts of 10 or fewer, so member totals are floors.
- Excel workbookCounties, Plans, Insurers, Plans that end, Where members land and a Sources sheet.Excel
- Counties254 counties: plans in 2027 and 2026, $0 plans, special needs plans, insurers, members, the largest insurer.CSV
- Plans9,363 plan and county rows: premium, out of pocket max, stars, drug coverage.CSV
- InsurersMembers and share by parent company in each county.CSV
- Plans that end8,073 plan and county rows with no 2027 plan to land in. 200,898 members, a floor.CSV
- Where members land16,277 rows: each 2026 plan, its 2027 status and the plan CMS moves members to.CSV
Every number ties to the CMS file named on the Sources sheet. Facts, not plan advice. See pricing.