I did the data work and co-wrote this story that found nurses at nursing homes owned by Allegheny County were working the equivalent of 80 hours a week for an entire year. We found that with the amount of money that they were paying in overtime, they could hire 45 full-time nursing assistants. This story won the 2015 PICPA Truth in Finances Award.
Continuing our “Price of the Prize” coverage, we update the state of fundraising and television advertising a few days before the 2014 Pennsylvania gubernatorial election.
In conjunction with the Pittsburgh Post-Gazette, PublicSource launched our 2014 campaign finance app “Price of the Prize” along with this story. I compiled and published campaign finance data for the Pennsylvania governor’s race and continued to track television advertising across 24 stations in Pennsylvania’s six TV markets. This series of stories won a second prize for enterprise reporting in the 2015 Pennsylvania SPJ Spotlight Awards. Our app “Price of the Prize” also won second place for web use in the Spotlight Awards.
There was lots of misinformation about the problems with Pittsburgh payroll system, so we decided to investigate and write an explainer. This story relied on documents from Pittsburgh and Allegheny County that showed the slow progress of the previous payroll vendor.
I worked with our criminal justice reporter to analyze the most recent four years of Pittsburgh crime stats at the neighborhood level. I converted the data from PDFs to a spreadsheet and wrote roughly half of the story that showed South Side Flats had the most crime since 2010.
As the first story in PublicSource’s coverage of money in the 2014 governor’s race, I show the early start that Tom Wolf got on the airwaves and the major sources of money for each candidate. Over the course of the election, I tracked ad spending on 24 TV stations in Pennsylvania’s six TV markets.
In my first story for PublicSource, I wrote an explainer about Pennsylvania’s oversight program for financially distressed cities. The financial oversight team was critical of Pittsburgh’s infrastructure, pension costs and record keeping.
Using the OSHA database on IRE’s website, I worked on the data portion of this Sunday A1 story about the dangerous work of cleaning industrial tanks. Starting with two Texas companies, I went through the OSHA database and identified companies in this tank cleaning sub-industry across multiple NAICS codes. At the end of my work, I gave the reporter a spreadsheet with companies, specific workplace accidents and summary statistics. He ran with those leads to proceed a fantastic feature story.
In order to put the West Fertilizer fine in context after it was announced, we looked at the 56,800 fatality and catastrophe investigations conducted by OSHA since 2001.
This was a quick turnaround when the U.S. Census Bureau released its 2012 1-year estimate American Community Survey data. While there are lots of interesting topics in the ACS data, we focused on healthcare coverage in Texas. Three of the four counties in the country with the highest percentage of uninsured residents are in Texas.