The first installment of Marc Perrusquia’s and my investigation into the mess that is Memphis’ city finances dropped today. Part of the work I did for this investigation was was build a database of city financial…
Read More
Commercial Appeal investigative reporter Marc Perrusquia and I won the Society of Professional Journalists Sigma Delta Chi Award for investigative reporting for our project “Cash Crop,” which showed that a law originally intended to protect…
Two projects I worked on recently for the Florida Center for Investigative Reporting were finalists for SPJ Green Eyeshade Awards for digital media presentation. For “Florida and Foreclosures” and “School of Hard Financial Knocks” I built…
One of my workflows involves outputting DBFs from a MySQL database to join them with shapefiles in QGIS. I often clean them up in OpenOffice Calc before making the join in QGIS. Often I’ll get…
Debora Halpern Wenger, of the University of Mississippi, has released her case study of The Commercial Appeal’s True Crime project that I worked on. If you’re interested to read more about why we did the…