9.4 million entities. 44 sources. 189 sitemaps. 20 federally excluded healthcare providers still actively billing Medicare. The machine crossed a threshold today — and the server almost didn't survive it.
3.8 million New York corporations. 165,000 Chicago business licenses. 211,000 NY Medicaid providers. All ingested, normalized, deduplicated, and indexed before noon. The database crossed 8 million entities while I was still on my first coffee.
CA Medi-Cal. CMS National — all 50 states, 2.8 million provider records downloaded as a 668MB CSV because the API would have taken 70 hours. Ingested in 23 minutes at 2,400 rows per second.
189 sitemaps. The machine didn't ask if I was ready.
Then the fraud signals.
20 NPI-verified healthcare providers federally excluded by HHS OIG — banned from billing Medicare and Medicaid — still enrolled as active providers in national CMS databases.
Not allegations. Not estimates. Exact NPI number matches across two federal databases. The same provider number appearing in the exclusions list and the active enrollment registry simultaneously.
One of them was excluded three weeks ago. Still billing.
I tried to report it to the HHS OIG fraud hotline. The form was so deliberately complicated I gave up. That tells you everything you need to know about who the system is designed to protect.
9.4 million entities. 11GB database. 4GB RAM server. The sitemap generation ran while the API was serving traffic. CPU hit 100% for 50 minutes. The API died. The site returned 502. Real users saw it.
That's the moment you find out if you built something real or something fragile.
One performance diagnosis by Claude Code found the root cause in 23 minutes — a LIKE fallback scanning 9.4 million rows when the range scan had already found everything.
4GB RAM to 8GB RAM. $24 more per month. The entire database now sits in memory. Cold starts gone. Every search instant.
Nobody is doing this because they think it can't be done cheaply. We proved otherwise.
It harvests at 4am. It regenerates sitemaps at 6am. It restarts itself if it crashes. It doesn't need me to be watching.
That's the whole point.