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.

Les titres et les descriptions proviennent des sources de données, en anglais.

Source: US County Health-Marketplace Affordability Intelligence (CMS, keyless)
Lignes: 16 724
Colonnes: 37
Cadence de la source: Annuelle
Dernière actualisation: 2 oct. 2026
Thème: health

Colonne	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)

10 premières lignes d’exemple — un aperçu, pas le jeu de données complet.

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

2 oct. 2026Actuelle
20261002T060922Z-c87469e017de · sha256 c87469e017de…
16 724 lignes · premier instantané

Dirigez n’importe quel LLM vers le point d’accès des métadonnées — la documentation ci-dessus est aussi lisible par machine (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)

Point d’accès API : https://datazimuts.com/v1/datasets/cms_marketplace_county_intel/us_county_marketplace_affordability_annual

Astuce : récupérez /llms.txt pour le catalogue complet lisible par machine.

D’où viennent ces données et ce qui en a été fait. Le travail des autres apparaît sous forme de décomptes ; seuls les projets partagés sont nommés.

Citer cet instantané

Épinglé à l’instantané 20261002T060922Z-c87469e017de et à son empreinte, pour que vos lecteurs obtiennent exactement les données utilisées.

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/fr/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/fr/datasets/cms_marketplace_county_intel/us_county_marketplace_affordability_annual?snapshot=20261002T060922Z-c87469e017de}},
  note         = {Snapshot 20261002T060922Z-c87469e017de, sha256 c87469e017de648b1bdbc5bd0bd9e9ff045c454f1795c5660cc9b68e77d47b98; accessed 2026-10-02}
}

Intégrer un tableau ou un graphique

Collez ce code dans n’importe quelle page. L’intégration est épinglée au même instantané, suit le thème clair ou sombre du lecteur et affiche toujours la source, la licence et un lien de retour.

Type

Axe X

Valeur

Agrégat

Thème

HTML

<iframe src="https://datazimuts.com/embed/chart?dataset=cms_marketplace_county_intel%2Fus_county_marketplace_affordability_annual&lang=fr&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>

Connectez-vous pour commenter

Posez une question sur ce jeu de données. Les réponses viennent uniquement de sa fiche, de son profil mesuré et de son historique, et citent les faits utilisés.

US county health-marketplace affordability panel (annual)

Suivre ce jeu de données

Citer cet instantané

Intégrer un tableau ou un graphique

Utiliser votre propre clé d’IA