Through a series of Freedom of Information requests starting in April of 2011, I obtained a good deal of information on the compensation of City of Lansing employees. In the first request, I asked for the following for all employees who were on the payroll in 2010:
That information was received as a computer file in text form. Here it is exactly as received. I loaded the file into Microsoft Excel and spent hours arranging the data, trying to come up with helpful ways to present it. Links to those presentations are below. Here is the original file as converted to Excel, before any of my manipulations.
2010 Wages
I also calculated average salaries and earnings by position for the Police and Fire departments. |
||||||||||||||||||||||||||