I worked as part of the team that turned thousands of pages of prescription invoices into a database that we could analyze for a series of stories on prescribing trends at state-owned juvenile detention facilities.
The Allegheny County Council rejected an A-B-C food grading scale for restaurants twice, siding with local restaurant owners. The health department had already created a proposed grading system as a part of this proposal, so I requested the grading system and three years of restaurant inspection records. I then applied the proposed grading system to nearly a year of inspections that had already taken place. The story showed that an A-B-C grading scale would provide more gradation for consumers than a green sticker on the door, which was not an indicator of cleanliness.
I helped our criminal justice reporter digitize and analyze 10 years of Pennsylvania State Police discipline reports.
Pennsylvania had the second-worst vaccination rate in the country, according to the Centers for Disease Control and Prevention. I digitized eight years of vaccination records to find out why the state was failing. I found that Pennsylvania’s low vaccination rate was not caused by the state’s medical, religious or philosophical exemptions, but because the state allowed students to attend school for up to eight months without having all of their required vaccines. In response to my reporting, the Secretary of Health wrote an op-ed in the Pittsburgh Post-Gazette and the Department of Health changed the provisional period to five days.
I contributed data work for this story by a PublicSource freelance writer.
I compared an ambitious tax proposal from Gov. Tom Wolf with a competing plan from members of the Republican Legislature with an interactive tax calculator. The story also showed how the Republican plan disproportionately benefited school districts with higher median property values while Wolf’s plan provided more property tax relief to poorer school districts. This story was PublicSource’s most republished story in 2015. It was picked up by 15 of our print partners with a combined audience of six million readers.
Gov. Tom Wolf proposed ambitious changes to the state’s tax structure in his first budget address. Wolf proposed increases to the state’s income and sales tax while cutting property taxes. We wanted to show Allegheny County residents whether they would pay more under Wolf’s proposal with our tax calculator, which allowed a user to input their school district, marital status, income and property value.
I contributed data work to this portion of our series on millennials in Pennsylvania.
Even though Tom Wolf had won the 2014 gubernatorial election, we thought it was important to point out the major corporations who had given money to his opponent during the campaign and were now giving to the Governor-elect after the election.