March 16, 2026

Building a 15-Year CrossFit Open Database with Claude (And Auditing the Results)

I handed Claude a vague goal — build a queryable database of every CrossFit Open workout from 2011 to 2026 — and watched what it did. How it stored data, where it sourced the gaps, and whether I could trust the result.

The 2026 Open just wrapped. And now that the gym is back to normal, I find myself doing what I always do: overthinking the Open workouts. Which movements keep showing up? Are AMRAPs actually more common than For Time workouts, or does it just feel that way? And is the rig ladder format — the one that ends every Open with a pull-up-to-C2B-to-muscle-up escalation — a recent programming method?