Annual US county health-marketplace affordability panel from the CMS Marketplace Open Enrollment County-Level Public Use Files (keyless, plan years 2020 onward): consumers with a plan selection (new vs renewals, active vs auto, switching), average monthly premium before and after APTC subsidies, APTC/CSR recipiency, metal-level and income-band mix, and dental attachment for every county in the HealthCare.gov states. Carries YoY momentum, a documented 0-100 premium_burden_score with within-year ranks and tiers, and an enrollment record flag. CMS-suppressed cells stay null; five accounting identities are checked per row. Who joins this: subscription businesses read county+year burden for churn-risk regimes; shops use premium-burden momentum as a discretionary-spend headwind; sales teams weight territories by the burden score.

Source: US County Health-Marketplace Affordability Intelligence (CMS, keyless)
Rows: 16,724
Columns: 37
Source cadence: Yearly
Last refreshed: Oct 2, 2026
Theme: health

Column	Type	Description
plan_year	integer	Marketplace open-enrollment plan year (2020 onward). One row per county per plan year; the state set shrinks over time (39 states in 2020 -> 31 in 2026) as states launch their own exchanges — a county missing in a year simply has no row. (unit: year)
date	date	January 1 of the plan year (ISO-date join key). (unit: ISO date)
county_fips	string	5-digit county FIPS code (2-digit state prefix + 3-digit county). Primary geography join key; the prefix is validated against the state abbreviation. (unit: FIPS)
county_name	string	County name from the vintage workbooks (e.g. 'Autauga County'). Null when no workbook carried the FIPS — never invented. (unit: string)
state_abbreviation	string	USPS 2-letter state code (HealthCare.gov states only). (unit: string)
state_name	string	State name. (unit: string)
country_code	string	ISO 3166-1 alpha-3 country code (USA). (unit: string)
consumers	integer	Consumers with a marketplace plan selection. The binding measure: rows with a CMS-suppressed ('*') count are dropped, never zero-filled. (unit: persons)
new_consumers	integer	New consumers (not enrolled the prior plan year). (unit: persons)
total_renewals	integer	Total re-enrollees (active + automatic). (unit: persons)
active_renewals	integer	Consumers who actively re-enrolled (vs automatic). (unit: persons)
auto_renewals	integer	Consumers automatically re-enrolled. (unit: persons)
new_consumer_share	float	new_consumers / consumers — market-expansion leg. (unit: ratio)
auto_renewal_share	float	auto_renewals / consumers — inertia leg. (unit: ratio)
active_switch_share	float	Active re-enrollees who switched plans / active_renewals — shopping-intensity leg. (unit: ratio)
avg_premium_usd	float	Average monthly premium before APTC (published). (unit: USD/month)
avg_premium_after_aptc_usd	float	Average monthly premium after APTC (published) — what households actually pay. (unit: USD/month)
avg_aptc_usd	float	Average monthly APTC among APTC recipients (published). (unit: USD/month)
aptc_share	float	Consumers receiving APTC / consumers — subsidy-dependence leg. (unit: ratio)
csr_share	float	Consumers receiving cost-sharing reductions / consumers. (unit: ratio)
low_income_share	float	Consumers at <=200% of the federal poverty level (FPL_LT100 + FPL_100_150 + FPL_150_200) / consumers. Null for plan years 2020-2021: CMS published FPL_NFA (not comparable) instead of FPL_LT100. (unit: ratio)
bronze_share	float	Bronze-plan consumers / consumers. (unit: ratio)
silver_share	float	Silver-plan consumers / consumers. (unit: ratio)
gold_share	float	Gold-plan consumers / consumers. (unit: ratio)
age_55_plus_share	float	(Age_55_64 + Age_GE65) / consumers — older, pricier risk pool leg. (unit: ratio)
dental_attach_rate	float	Standalone dental plan consumers / consumers. (unit: ratio)
consumers_yoy_pct	float	Year-over-year percent change in consumers (null for a county's first vintage or when the prior vintage is missing — never imputed). (unit: percent)
avg_premium_yoy_pct	float	Year-over-year percent change in average premium. (unit: percent)
premium_after_aptc_yoy_pct	float	Year-over-year percent change in the average out-of-pocket premium — the household-cost momentum leg. (unit: percent)
aptc_share_yoy_pp	float	Year-over-year change in APTC share, percentage points. (unit: percentage points)
premium_burden_score	float	Documented 0-100 affordability-pressure gauge: 100 * mean of within-year min-maxed clip(avg_premium_after_aptc_usd, 0..1500) and clip(premium_after_aptc_yoy_pct, -30..+30). Higher = households pay more out of pocket and it is rising faster. A county's first vintage scores on the level leg alone; null only when both legs are null. (unit: 0-100 score)
burden_rank	integer	Within-plan-year rank of premium_burden_score (1 = heaviest burden). (unit: rank)
burden_tier	string	Quartile bucket of premium_burden_score within the plan year: t1 (lightest) .. t4 (heaviest). (unit: tier)
enrollment_record_flag	integer	1 when consumers equal the county's all-vintage maximum. (unit: binary)
source_url	string	The vintage ZIP URL behind this row. (unit: URL)
row_hash	string	Deterministic 16-hex sha256 of county_fips + plan_year + consumers + avg_premium_usd (idempotency key). (unit: string)
country	string	Country name (shared normalization layer). (unit: string)

First 10 sample rows — a preview, not the complete dataset.

plan_year	date	county_fips	county_name	state_abbreviation	state_name	country_code	consumers	new_consumers	total_renewals	active_renewals	auto_renewals	new_consumer_share	auto_renewal_share	active_switch_share	avg_premium_usd	avg_premium_after_aptc_usd	avg_aptc_usd	aptc_share	csr_share	low_income_share	bronze_share	silver_share	gold_share	age_55_plus_share	dental_attach_rate	consumers_yoy_pct	avg_premium_yoy_pct	premium_after_aptc_yoy_pct	aptc_share_yoy_pp	premium_burden_score	burden_rank	burden_tier	source_url	row_hash	country
2,020	2020-01-01	01001	Autauga County	AL	Alabama	USA	1,658	367	1,291	923	368	0.221	0.222	0.144	682	131	610	0.903	0.68	—	0.109	0.824	0.055	—	0.324	—	—	—	—	25.31	1,534	t2	https://www.cms.gov/files/zip/2020-oep-county-level-public-use-file.zip	f328c434828c0630	United States
2,020	2020-01-01	01003	Baldwin County	AL	Alabama	USA	10,765	2,483	8,282	6,005	2,277	0.231	0.212	0.187	687	141	617	0.886	0.646	—	0.145	0.796	0.051	0.314	0.316	—	—	—	—	27.792	1,387	t2	https://www.cms.gov/files/zip/2020-oep-county-level-public-use-file.zip	4d40b3ab9e5d1fa7	United States
2,020	2020-01-01	01005	Barbour County	AL	Alabama	USA	642	151	491	324	167	0.235	0.26	0.167	711	107	657	0.919	0.698	—	0.126	0.821	0.036	—	0.288	—	—	—	—	19.355	1,992	t2	https://www.cms.gov/files/zip/2020-oep-county-level-public-use-file.zip	1c9a0de748c5c0a1	United States
2,020	2020-01-01	01007	Bibb County	AL	Alabama	USA	487	93	394	283	111	0.191	0.228	0.145	721	134	642	0.914	0.704	—	0.088	0.84	—	0.277	0.292	—	—	—	—	26.055	1,493	t2	https://www.cms.gov/files/zip/2020-oep-county-level-public-use-file.zip	94629f0a6939f7f1	United States
2,020	2020-01-01	01009	Blount County	AL	Alabama	USA	1,871	381	1,490	1,028	462	0.204	0.247	0.176	750	125	681	0.917	0.713	—	0.091	0.857	0.043	—	0.283	—	—	—	—	23.821	1,642	t2	https://www.cms.gov/files/zip/2020-oep-county-level-public-use-file.zip	9c26348f5e23873c	United States
2,020	2020-01-01	01011	Bullock County	AL	Alabama	USA	286	75	211	132	79	0.262	0.276	0.129	659	128	620	0.857	0.738	—	0.066	0.902	—	—	0.252	—	—	—	—	24.566	1,577	t2	https://www.cms.gov/files/zip/2020-oep-county-level-public-use-file.zip	9453028334f822a2	United States
2,020	2020-01-01	01013	Butler County	AL	Alabama	USA	614	126	488	327	161	0.205	0.262	0.196	714	128	645	0.907	0.681	—	0.098	0.852	—	—	0.256	—	—	—	—	24.566	1,577	t2	https://www.cms.gov/files/zip/2020-oep-county-level-public-use-file.zip	2e35b28ff6a0ef29	United States
2,020	2020-01-01	01015	Calhoun County	AL	Alabama	USA	3,375	741	2,634	1,831	803	0.22	0.238	0.17	684	118	627	0.903	0.719	—	0.105	0.839	0.047	0.3	0.278	—	—	—	—	22.084	1,774	t2	https://www.cms.gov/files/zip/2020-oep-county-level-public-use-file.zip	f526ba63340ec34a	United States
2,020	2020-01-01	01017	Chambers County	AL	Alabama	USA	937	202	735	498	237	0.216	0.253	0.169	700	122	648	0.892	0.723	—	0.11	0.838	0.039	—	0.314	—	—	—	—	23.077	1,700	t2	https://www.cms.gov/files/zip/2020-oep-county-level-public-use-file.zip	7f8fe1805cb16976	United States
2,020	2020-01-01	01019	Cherokee County	AL	Alabama	USA	821	153	668	474	194	0.186	0.236	0.15	757	115	695	0.923	0.748	—	0.085	0.867	—	0.402	0.228	—	—	—	—	21.34	1,837	t2	https://www.cms.gov/files/zip/2020-oep-county-level-public-use-file.zip	7b59266efd51981b	United States

Oct 2, 2026Current
20261002T060922Z-c87469e017de · sha256 c87469e017de…
16,724 rows · first snapshot

Point any LLM at the metadata endpoint — the documentation above is machine-readable too (JSON-LD + Croissant).

cURL

curl "https://datazimuts.com/v1/datasets/cms_marketplace_county_intel/us_county_marketplace_affordability_annual" | jq '{title, rows, columns_count, license}'

Python

import requests

ds = requests.get("https://datazimuts.com/v1/datasets/cms_marketplace_county_intel/us_county_marketplace_affordability_annual").json()
print(ds["title"], ds["rows"], "rows")

# Sample rows for an LLM context window
for row in ds.get("sample_rows", [])[:5]:
    print(row)

API endpoint: https://datazimuts.com/v1/datasets/cms_marketplace_county_intel/us_county_marketplace_affordability_annual

Tip: fetch /llms.txt for the full machine-readable catalog.

Where this data comes from and what was made from it. Other people's work shows as counts; only shared projects are named.

Cite this snapshot

Pinned to snapshot 20261002T060922Z-c87469e017de and its content hash, so readers get exactly the data you used.

APA

US County Health-Marketplace Affordability Intelligence (CMS, keyless). (2026). US county health-marketplace affordability panel (annual) [Data set, snapshot 20261002T060922Z-c87469e017de, sha256 c87469e017de]. Datazimuts. Retrieved 2026-10-02, from https://datazimuts.com/en/datasets/cms_marketplace_county_intel/us_county_marketplace_affordability_annual?snapshot=20261002T060922Z-c87469e017de

BibTeX

@misc{dz_cms_marketplace_county_intel_us_county_m_c87469e0,
  title        = {{US county health-marketplace affordability panel (annual)}},
  author       = {{US County Health-Marketplace Affordability Intelligence (CMS, keyless)}},
  year         = {2026},
  publisher    = {Datazimuts},
  howpublished = {\url{https://datazimuts.com/en/datasets/cms_marketplace_county_intel/us_county_marketplace_affordability_annual?snapshot=20261002T060922Z-c87469e017de}},
  note         = {Snapshot 20261002T060922Z-c87469e017de, sha256 c87469e017de648b1bdbc5bd0bd9e9ff045c454f1795c5660cc9b68e77d47b98; accessed 2026-10-02}
}

Embed a table or a chart

Paste this into any page. The embed is pinned to the same snapshot, follows the reader's light or dark setting, and always shows the source, license and a link back.

Type

X axis

Value

Aggregate

Theme

HTML

<iframe src="https://datazimuts.com/embed/chart?dataset=cms_marketplace_county_intel%2Fus_county_marketplace_affordability_annual&lang=en&theme=auto&snapshot=20261002T060922Z-c87469e017de&x=plan_year&y=plan_year&agg=avg" title="US county health-marketplace affordability panel (annual)" width="100%" height="380" style="border:0" loading="lazy"></iframe>

Sign in to comment

Ask about this dataset. Answers come only from its catalog record, measured profile and change history, and list the facts they used.

US county health-marketplace affordability panel (annual)

Follow this dataset

Cite this snapshot

Embed a table or a chart

Use your own AI key