Teacher at a chalkboard

The Pennsylvania Department of Education released salary data for K-12 teachers this week from the 2012-’13 school year.

According to the Pittsburgh Post-Gazette:

The announcement about access to financial data was made at a news conference sponsored by state Rep. Jim Christiana, R-Beaver, who in the past has sponsored legislation calling for the compilation and posting of school financial data. The Department of Education picked up on his idea; compiled the information, which is reported annually to the department; and made it available through a link on the SPP website.

The data was added to paschoolperformance.org, which is the education department’s site that hosts demographic and academic performance statistics for schools in the state’s 500 school districts.

However, the salary data is not particularly easy to find on the site.

So we’ve downloaded it for you here.

The spreadsheet contains all the salaries for teachers and staff in every school district, more than 190,000 rows. You will need Microsoft Excel or another spreadsheet program if you’d like to work with the data on your own computer.

When you open the file in your spreadsheet program, you can filter the data to find information more quickly. The filter function in Excel is located under the “Data” tab. Once you click filter, arrows will appear next to each column in the first row.

If you’re looking for a specific teacher, click on the arrow next to the last name or first name column and type in a name.

If you’d like to see the salaries for all the staff members in your school district, click on the arrow next to the “LEA” column, which is the school district, and click the “Select All” box to uncheck all the school districts and then click on the box next to the school district you’d like to see. You can search for or select “Pittsburgh SD,” “Philadelphia City SD,” or the school district of your choice.

You can do the same thing if you’d like to see all the salaries for teachers and staff in a specific county. Click on the arrow next to the “LEACounty” column and either select or search for the county you’d like to see.

Reach Eric Holmberg at 412-315-0266 or at eholmberg@publicsource.org. Follow him on Twitter @holmberges.

This fact-based local reporting drives impact and creates change. Help power that impact.

James Baldwin wrote, “Not everything that is faced can be changed, but nothing can be changed until it is faced.” PublicSource exists to help the Pittsburgh region face its realities and create opportunities for change. When we shine a light on inequity in our region, like the “completely unacceptable” conditions in low-income housing in McKeesport, things change. When we ask questions about policymakers’ decisions, like how Allegheny County is handling COVID-19 safety for its employees, things change. When we push for transparency on issues that affect the public, like in the use of facial recognition software by Pittsburgh police, things change.

It takes a lot of time, skill and resources to produce journalism like this. Our stories are always made available for free so that they can benefit the most people, regardless of ability to pay. But as an independent, nonprofit newsroom, we count on donations from our readers to support this crucial work. Can you make a contribution of any amount (or better yet, set up a recurring monthly gift) to help ensure we can continue to report on what matters and tell stories for a better Pittsburgh?