Compare salaries of city, county workers in same jobs, departments

The Eagle publishes a database that shows how much each city or county worker has made over the past five years.

This week, we’re rolling out a tool that allows you to easily compare how much workers make in the same department or who had the same jobs. Because these searches can yield many results, the display will look best if you are on a desktop computer or tablet rather than your phone.

This is how it works.

First, type in a person’s name whom you know works for the city or county, and then click search.

Try different spellings if you don’t find it: For example, if you type in “Cathy” and the person’s name is listed as “Catherine,” it won’t work.

The results should list the person’s job title. Highlight and copy the job title and paste it into the search tool below, then click on “search.”

For example, if you typed in Brett Smith, you would see his job title as “Staff Attorney II.” When we search for “Staff Attorney II,” we get a list of all 14 people who have held this job over the past five years and their salaries in each of those years.

It shows that Matthew Maloney earned the most in this position, more than $68,000 in 2013, while a more typical salary for this position was between $56,000 and $62,000. You can also see that this is the first year Smith has held the position and that Staci Lane, who has held this job for the past five years, has increased her salary by $2,000 over that period.

You need to type in the exact name of the job title or department for the database to work. The software won’t read it if there is even a single mistake.

You can do this by department, too, but the search will yield many more results. Brett Smith’s department is “DA.” If we type in DA in the department field, we get a list of all 65 jobs in this department, every person who worked in each of those jobs for the past five years and how much each of them made.

So we can see that Marc Bennett received a $40,000 raise when he moved from senior administrative attorney to district attorney in 2013, and he has made more than $800,000 in the past five years.

This story was originally published June 27, 2017 at 7:25 AM with the headline "Compare salaries of city, county workers in same jobs, departments."