I used shell scripting and spatial analysis tools in R to extract sea surface temperature and ocean heatwave data for every point in an Atlantic tropical cyclone path since 1980. The story found that ocean warming due to climate change statistically increased the chances of rapidly intensification. We also examined how these powerful storms are uniquely threatening to communnities along the Gulf of Mexico coastline.

For these stories on major hurricanes, I analyzed building footprints, flood zone data, and surge inundation predictions to determine which properties in Tampa Bay counties and in Florida's Big Bend were most vulnerable to severe flooding. These reports offered some of the earliest and most comprehensive estimates of the storms' devastating impact.

Using command-line tools, I extracted Florida Department of Transportation camera footage to create gifs and videos. These visuals showed flooding, storm surge, and heavy traffic during Florida's largest evacuation in recent memory, enhancing our live storm coverage.

I analyzed school parcel, crime and demographic data to show how shootings of teenagers in Baltimore were increasing, all within just blocks of schools. Ninety four percent of those shootings were in the “Black Butterfly," an area of the city with a history of disinvestment and segregation. See the code here. This story is the foundation for a NICAR class I co-teach about spatial analysis in R.

I created a custom shapefile of downtown Baltimore using QGIS to determine crime rates in a redevelopment area prioritized by investors.

I analyzed and visualized census tract data, joining state lottery vendor locations and cellphone location data with R to supplement reporting on exploitative state lottery systems. I also cleaned and prepared back-end geojson data for a collaboratively-created interactive news application created with D3 and JavaScript.

I analyzed data to determine the number of projects on which a Texas housing board member earned fees for his law firm and also analyzed broader data about projects the housing board approves.