Comprehensive Plan Data Audit

Latest run: April 14, 2026

Tier	Result	Match Rate	Status
Tier 4 — Internal integrity	4044 plans, 28196 zips	100% functional	✅
Tier 1 — Zip → County	18,415 / 18,801	97.95%	⚠️ 352 zips need fix
Tier 2 — Zip → Premium	28,048 / 28,196	99.475%	✅ Fixed in audit
Tier 3 — Scenario matrix	1,813 / 2,000 (S1-S9: 100%)	90.65%	⚠️ Tobacco gap

TL;DR

• Premium accuracy: 99.475% of all zips return the exact CMS cheapest Silver
• Medicaid auto-adjustment: 100% match (S6 + S7 combined: 400/400 exact)
• Family households: 100% (S4 + S5: 400/400)
• CSR tier handling: 100% (S8: 200/200)
• Tobacco rates: 0% support — known gap, see Tier 3
• County resolution (zip picker): 97.95% — 310 multi-county zips have missing entries we should add

What this proves

✅ Our database matches CMS / Healthcare.gov for:

• 99.475% of all 28K zips
• 100% of common scenarios (single, couple, family, near-retirement, over-400% FPL)
• 100% of Medicaid auto-adjustment cases
• 100% of CSR boundary cases
• All 30 federal states

⚠️ Known gaps:

• Tobacco rate field not ingested (Option A in Tier 3 doc)
• 310 zips need additional county entries for full multi-county picker support
• 89 AK/OR zips fixed live during audit (Tier 2)

Documents

• Methodology — How the audit works
• Tier 1 — Zip → County
• Tier 2 — Zip → Premium
• Tier 3 — Scenario Matrix
• Tier 4 — Internal Integrity
• Audit History — Run log and snapshots
• Known Gotchas — Things learned the hard way

Atlas snapshots

ID	When	Description
69ddbd4ed42c81ca30f8f88c	2026-04-14	98.7% county baseline
69ddd37f1bff7151ab5cccd4	2026-04-14	Pre-targeted-fix snapshot
69ddd94e61499fe4a72e0b3d	2026-04-14	100% county match
(post-audit)	2026-04-14	After audit fixes (TBD)