US Medicaid/CHIP enrollment stress panel (CMS, monthly by state)

Commercial use OKFresh

The full snapshot isn't published yet — check back after the next refresh.Download sample CSV Download sample JSONSample rows only (up to 20) — not the complete dataset.

Monthly US household-stress panel by state, 2017-06 onward: CMS Medicaid/CHIP Performance Indicator enrollment (total, Medicaid, CHIP, child, adult), new applications, and eligibility determinations for all 50 states + DC, keyless via the data.medicaid.gov datastore API. Carries enrollment MoM/YoY, applications YoY (a leading indicator), determination rate, each state's share of national enrollment, a documented 0-100 household_stress_score (within-month min-max of clipped enrollment and applications YoY; higher = more strain), a within-month stress_rank, Medicaid-expansion and unwinding-era flags, and a trailing-12-month record-high flag. The total == Medicaid + CHIP identity is checked every row (<= 1 person). The 2023-04..2024-12 unwinding window is flagged: enrollment drops there are largely procedural disenrollments, not improving finances. Who joins this: subscription businesses read state+month stress for churn-risk regimes; retailers use applications YoY as a demand-softness lead; sales teams weight outreach by the stress score.

Source: US Medicaid/CHIP Enrollment Stress Intelligence (CMS, keyless)
Rows: 5,559
Columns: 25
Source cadence: Monthly
Last refreshed: Oct 1, 2026
Theme: health

Column	Type	Description
date	date	Reference month, first of month (panel join key). One row per state per month, 2017-06 onward, no gaps — a missing month fails the ingest loudly. (unit: date)
year_month	string	Calendar month as YYYY-MM. (unit: string)
state_abbreviation	string	USPS 2-letter state/District code (50 states + DC). Join key for state-level merges. (unit: string)
state_name	string	State/District name as reported by CMS. (unit: string)
country	string	Country name (shared normalization layer). (unit: string)
country_code	string	ISO 3166-1 alpha-3 country code (USA). (unit: string)
total_enrollment	float	Total Medicaid + CHIP enrollment (all populations receiving comprehensive benefits). The binding measure: null in-grid fails loudly. Identity: total == medicaid_enrollment + chip_enrollment (<= 1 person) wherever both components are present. (unit: persons)
medicaid_enrollment	integer	Total Medicaid enrollment (all ages). (unit: persons)
chip_enrollment	integer	Total CHIP enrollment. (unit: persons)
child_enrollment	integer	Medicaid + CHIP child enrollment. (unit: persons)
adult_medicaid_enrollment	float	Total adult Medicaid enrollment. (unit: persons)
applications	float	New applications submitted to Medicaid and CHIP agencies. A leading indicator: households turn to the safety net before enrollment rises. (unit: persons)
determinations	float	Total individuals determined eligible for Medicaid/CHIP at application. (unit: persons)
determination_rate	float	determinations / applications (null when applications is null or zero). (unit: ratio)
enrollment_mom_pct	float	Month-over-month percent change in total enrollment (null for 2017-06). (unit: percent)
enrollment_yoy_pct	float	Year-over-year percent change in total enrollment (null for the first 12 months). (unit: percent)
applications_yoy_pct	float	Year-over-year percent change in new applications (null for the first 12 months). The demand-softness leading leg. (unit: percent)
share_of_national_pct	float	State total enrollment as a percent of the national (50 states + DC) total that month. (unit: percent)
household_stress_score	float	Documented 0-100 composite: within-month min-max of clip(enrollment_yoy_pct, -15, +15) and clip(applications_yoy_pct, -30, +30), averaged x100. Higher = more households turning to safety-net coverage = more financial strain. Null when both legs are null (first 12 months). Caveat: during the 2023-04 ..2024-12 unwinding window the enrollment leg understates strain (procedural disenrollments). (unit: score 0-100)
stress_rank	integer	Within-month rank of household_stress_score (1 = most stressed state). Null when the score is null. (unit: rank)
expansion_state_flag	integer	1 when the state had expanded Medicaid under the ACA in that month (from the period's own state_expanded_medicaid), 0 otherwise. (unit: flag)
unwinding_era_flag	integer	1 for 2023-04..2024-12: the continuous-enrollment unwinding, when enrollment declines were largely procedural disenrollments rather than improving household finances. Read enrollment momentum in this window with that caveat. (unit: flag)
record_high_12m_flag	integer	1 when total enrollment is at its trailing-12-month maximum, 0 otherwise. (unit: flag)
report_status	string	'final' for updated/final CMS reports, 'preliminary' for the latest not-yet-finalized month. (unit: string)
row_hash	string	Deterministic 16-hex sha256 of state + period + total + applications + determinations (idempotency key). (unit: string)

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

date	year_month	state_abbreviation	state_name	country	country_code	total_enrollment	medicaid_enrollment	chip_enrollment	child_enrollment	adult_medicaid_enrollment	applications	determinations	determination_rate	enrollment_mom_pct	enrollment_yoy_pct	applications_yoy_pct	share_of_national_pct	household_stress_score	stress_rank	expansion_state_flag	report_status	row_hash
2017-06-01	2017-06	AK	Alaska	United States	USA	194,534	182,080	12,454	90,081	—	3,069	3,422	1.115	—	—	—	0.264	—	—	1	final	bb9c10d9ae57e88c
2017-06-01	2017-06	AL	Alabama	United States	USA	885,767	729,368	156,399	629,763	—	16,449	28,634	1.741	—	—	—	1.204	—	—	0	final	2c2f09cfeac80853
2017-06-01	2017-06	AR	Arkansas	United States	USA	923,807	842,290	81,517	437,556	—	0	0	—	—	—	—	1.256	—	—	1	final	5afd5663f0f512f2
2017-06-01	2017-06	AZ	Arizona	United States	USA	1,744,617	1,649,411	95,206	0	—	0	0	—	—	—	—	2.371	—	—	1	final	b643f8c457747788
2017-06-01	2017-06	CA	California	United States	USA	12,293,428	11,004,981	1,288,447	5,181,237	—	163,743	174,775	1.067	—	—	—	16.709	—	—	1	final	e5da24787d8376fd
2017-06-01	2017-06	CO	Colorado	United States	USA	1,412,331	1,261,644	150,687	630,075	—	18,278	16,143	0.883	—	—	—	1.92	—	—	1	final	baddf2985d64151e
2017-06-01	2017-06	CT	Connecticut	United States	USA	794,805	777,208	17,597	316,717	—	4,793	9,493	1.981	—	—	—	1.08	—	—	1	final	20d066dbedb12517
2017-06-01	2017-06	DC	District of Columbia	United States	USA	254,253	242,621	11,632	90,783	—	2,313	4,436	1.918	—	—	—	0.346	—	—	1	final	cb9753dd296c5a0e
2017-06-01	2017-06	DE	Delaware	United States	USA	227,659	215,041	12,618	105,633	—	0	0	—	—	—	—	0.309	—	—	1	final	3d8f1369b0ec2f60
2017-06-01	2017-06	FL	Florida	United States	USA	3,874,106	3,678,987	195,119	2,592,522	—	280,705	188,360	0.671	—	—	—	5.266	—	—	0	final	b8b12bbb36946005

Profiled Oct 1, 2026 from snapshot 20261001T002208Z-9b10c8d016dd

Measured

Completeness: 94.8%
Rows: 5,559
Columns: 25
Columns with gaps: 7

Rows per yeardate · 2017–2026 · 10 years

20172026

Column	Missing	Distinct	Range	Distribution
datedate	0%	99	Jun 1, 2017 → Jun 1, 2026	—
year_monthvarchar	0%	120	—	2017-0651 2017-0751 2017-0851
state_abbreviationvarchar	0%	55	—	AK109 AL109 AR109
state_namevarchar	0%	59	—	Alabama109 Alaska109 Arizona109
countryvarchar	0%	1	—	United States5,559
country_codevarchar	0%	1	—	USA5,559
total_enrollmentdouble	0%	6,103	0 → 14,462,560median 1,037,696	112 outside 1st–99th percentile
medicaid_enrollmentbigint	0%	5,957	0 → 13,160,563median 954,801	112 outside 1st–99th percentile
chip_enrollmentbigint	0%	4,887	0 → 1,317,347median 79,858	112 outside 1st–99th percentile
child_enrollmentbigint	0%	5,811	0 → 5,339,904median 512,541	56 outside 1st–99th percentile
adult_medicaid_enrollmentdouble	78%	1,044	0 → 8,497,290median 547,049	26 outside 1st–99th percentile
applicationsdouble	0%	4,368	0 → 733,651median 14,851	56 outside 1st–99th percentile
determinationsdouble	0%	5,110	0 → 464,412median 12,015	56 outside 1st–99th percentile
determination_ratedouble	3.9%	6,578	0 → 39.86median 0.843	54 outside 1st–99th percentile
enrollment_mom_pctdouble	0.92%	6,787	-100 → 17.46median 0.1093	112 outside 1st–99th percentile
enrollment_yoy_pctdouble	11%	4,220	-100 → 40.76median 0.0892	100 outside 1st–99th percentile
applications_yoy_pctdouble	13.8%	5,133	-100 → 4,987median -0.7834	96 outside 1st–99th percentile
share_of_national_pctdouble	0%	6,005	0 → 17.17median 1.34	112 outside 1st–99th percentile
household_stress_scoredouble	11%	4,298	0 → 100median 48.83	50 outside 1st–99th percentile
stress_rankbigint	11%	45	1 → 51median 26
expansion_state_flagbigint	0%	2	0 → 1median 1
unwinding_era_flagbigint	0%	2	0 → 1median 0
record_high_12m_flagbigint	0%	2	0 → 1median 0
report_statusvarchar	0%	2	—	final5,508 preliminary51
row_hashvarchar	0%	6,346	—	0002183869d21e221 001bd9be74d7d3661 003a4fd2127e593f1

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_medicaid_enrollment_intel/us_medicaid_enrollment_stress_monthly" | jq '{title, rows, columns_count, license}'

Python

import requests

ds = requests.get("https://datazimuts.com/v1/datasets/cms_medicaid_enrollment_intel/us_medicaid_enrollment_stress_monthly").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_medicaid_enrollment_intel/us_medicaid_enrollment_stress_monthly

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

Cite this snapshot

Pinned to snapshot 20261001T002208Z-9b10c8d016dd and its content hash, so readers get exactly the data you used.

APA

US Medicaid/CHIP Enrollment Stress Intelligence (CMS, keyless). (2026). US Medicaid/CHIP enrollment stress panel (CMS, monthly by state) [Data set, snapshot 20261001T002208Z-9b10c8d016dd, sha256 9b10c8d016dd]. Datazimuts. Retrieved 2026-10-01, from https://datazimuts.com/en/datasets/cms_medicaid_enrollment_intel/us_medicaid_enrollment_stress_monthly?snapshot=20261001T002208Z-9b10c8d016dd

BibTeX

@misc{dz_cms_medicaid_enrollment_intel_us_medicai_9b10c8d0,
  title        = {{US Medicaid/CHIP enrollment stress panel (CMS, monthly by state)}},
  author       = {{US Medicaid/CHIP Enrollment Stress Intelligence (CMS, keyless)}},
  year         = {2026},
  publisher    = {Datazimuts},
  howpublished = {\url{https://datazimuts.com/en/datasets/cms_medicaid_enrollment_intel/us_medicaid_enrollment_stress_monthly?snapshot=20261001T002208Z-9b10c8d016dd}},
  note         = {Snapshot 20261001T002208Z-9b10c8d016dd, sha256 9b10c8d016ddc9243f278db9ce548af3429da43c4ce22c4a4f6c8d4ab0d4bc6b; accessed 2026-10-01}
}

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_medicaid_enrollment_intel%2Fus_medicaid_enrollment_stress_monthly&lang=en&theme=auto&snapshot=20261001T002208Z-9b10c8d016dd&x=date&y=total_enrollment&agg=avg" title="US Medicaid/CHIP enrollment stress panel (CMS, monthly by state)" width="100%" height="380" style="border:0" loading="lazy"></iframe>

US Medicaid/CHIP enrollment stress panel (CMS, monthly by state)

Follow this dataset

Cite this snapshot

Embed a table or a chart

Use your own AI key