Here’s a sampling of links for some of my better work from the four and a half years I spent as a data journalist at the St. Louis Post-Dispatch, where I worked until August 2017. Over time, changes in the stltoday.com CMS could cause some graphics and maps embedded in older stories to not load properly.
Scraped data for thousands of court cases to build a dataset on a handful of very litigious local subprime auto lenders.
For this story, I gathered, analyzed and mapped data for tens of thousands of eviction-related lawsuits in St. Louis.
Dug through lots of datasets containing property records, back taxes, building code violations, unpaid city fines and business filings for this investigation on a prominent St. Louis developer who abandoned hundreds of properties in struggling neighborhoods and then "donated" the assets to an unsuspecting homeless shelter in Georgia.
An investigation into a car title lender that was repossessing 9,000 cars a year in Missouri.
Used python for this analysis of more than a million historical campaign finance records.
For this story, I analyzed historical tax sale data, and to get more detail on individual tax sale properties, I scraped thousands of records from the St. Louis County real estate site.
Visualizations and apps
I analyzed raw federal campaign finance data to map donations to Donald Trump and Hillary Clinton by ZIP code.
An analysis of student test score data from the Missouri Department of Elementary and Secondary Education.
I mapped out ward-level election results from the St. Louis Board of Election Commissioners after voters rejected financing a soccer stadium (St. Louis has since started building a stadium, albeit not one that is publicly financed).
I wrote the Python scripts that downloaded, processed and analyzed the St. Louis city and county raw crime data, which was then visualized by Josh Renaud.
Although this was published after I left the Post-Dispatch, I conceived the idea for this app and contributed heavily to its initial development. This was built using Django and provides searchable political donation data for candidates and officeholders for statewide, Congressional and state legislative offices in Missouri. It was completed by current Post-Dispatch developer Josh Renaud and former developer Andrew Nguyen.
For another reporter's story about how the city fought to get control of parcels on the future site of a federal agency that employs thousands, I analyzed property records to show how parcels changed hands over time.
Analyzed data from the Census and Housing and Urban Development for a story about the concentration of subsidized housing in Ferguson.