Same query solved in duckdb instead (generated by claude). I wasn't able to run on the full dataset due to an encoding issue I didn't feel like solving... but with everything up until 2001, it returns seconds on my M4 MBP.
https://gist.github.com/ChuckJonas/4ffb0743de0c20a61394a6b95...