I just finished the IRE boot camp in data reporitng, and I’m ready to use SQL in my last week of intersession reporting at the Missourian. Katherine asked me a while back to look into I-70’s crash rates near Columbia, and so I’ve brainstormed with Charles Minshew of IRE to scrape data from the Missouri State Highway Patrol’s online records. I’ll use these not just to finish my CAR final project, but to analyze and write a piece on the crashes near the city, looking for the why/how of crashes, whether they’ve increased with time, and how they compare to other stretches of the highway.