Statistics of state employees' salary in Massachusetts.

Worst recession since the Great Depression? Hiring freeze? I don't think so, certainly not for Massachusetts' state employees. Check out the summary below of hires, "automatic" union employee salary increases, non-union salary increases, internal promotions, and external promotions since quarter 1 of 2007 through quarter 2 of 2009! If you are curious about the details, please click the links below the summary for details in each category, by quarter, since quarter 1 of 2007.

I have collected detail information from various local media and institution sites over the past 2 years. It's amazing how state government is still hiring by the thousands, giving pay raises to hundreds, and handing out internal promotions in each and every quarter since the Governor and Legislature had started crying "budget shortfall", or "severe cuts" in the fall of 2008. In quarter 2 of 2009 (March through June of 2009) alone, more than 6000 union employees got "automatic" pay raises costing more than $9million dollars. There were 465 internal promotions costing $2.4 million dollars and average increase was more than 10%.

What all major media and institutions have missed to capture is: change over time. Getting details is important, but I wish they had done more analysis on the massive amount of data they gathered. By measuring and benchmarking these changes over time, I was able to come up with useful statistics and segregated them into meaningful categories.

Please note that Google Docs might ask you to sign-in when clicking any links below. I guess we have to accommodate that as it's a free service. If you have a Google account, that's great. I had tried posting the details in this blog but it would greatly impact the speed to even load this page.



or click the link below:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdHZwYV8xTWxUQTFveV9yYnhhcnpFS0E&hl=en

2009 Quarter 2:
Hires:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdFdybGhkazFmY3JXUkxETDM3RXRQTWc&hl=en
Automatic union salary increases:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdGx3YTBzaDR1V2h4bTZTejFybTdINGc&hl=en
Non-union salary increases:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdGZHTWY0NUVDc2MzMkdjZTJ5dnBEdUE&hl=en
Internal promotions:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdEE3dVFjYTJldFQ5a0FGd29CaU02Smc&hl=en
External promotions:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdG9GZm54NUF6MnB6TmU0VDcxNnR3bmc&hl=en

2009 Quarter 1:
Hires:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdHM0UUFVOGdQQjAtRDQ2TENNT2tuLXc&hl=en
Automatic union salary increases:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdEZOazVqc3U1d01uR1Qxb2FTWUYta2c&hl=en
Non-union salary increases:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdEE2YzN1Yk1pakkzdVRIOG9iZEVGWXc&hl=en
Internal promotions:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdHhRRWZlUVYwd0FDSERTeDY3MlowSVE&hl=en
External promotions:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdGtzeE5XUW43ZWNUWEZXWFphM202SWc&hl=en

2008 Quarter 4:
Hires:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdFBVamZ0MHhnZ0ZnaEJlWFJ6bUlGVlE&hl=en
Automatic union salary increases:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdDBNQmJpTHVzY0tOLVU1dGtmQzVWcnc&hl=en
Non-union salary increases:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdFRuVGx1RTE1MjVKZWU1MXpPVE9tZWc&hl=en
Internal promotions:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdF9uSl9XaVd2WDA0SEZXdU44OXE2NEE&hl=en
External promotions:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdGxIbHVLLXNKRW1LdU9ZcE1YNmJEdFE&hl=en

2008 Quarter 3:
Hires:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdGRocEZtWlJRUS0yazVwYzBhUi1KRVE&hl=en
Automatic union salary increases part 1:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdFNRSzNSd0hYTHFVdkVLT2dmaktGRnc&hl=en
part 2:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdFh5aWVfRXgya3JyZWlob2RpRm93eFE&hl=en
Non-union salary increases:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdGJGSXdjRnhHWmE2UHdqU3ZLbTB2UHc&hl=en
Internal promotions:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdDBqZ2NWSDBuTVRidWpNRU9uWGNra1E&hl=en
External promotions:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdGVueUpoLV9UZEVtZ01ZOTFzXzMxZEE&hl=en

2008 Quarter 2:
Hires:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdEJHdVFQRXAyWXpaU3hpbHlaRFhieHc&hl=en
Automatic union salary increases:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdGdFN1pDbTFvSW1BY2tPQ28zSWxRQ0E&hl=en
Non-union salary increases:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdHMzcFdqMmcxMUFPUGF5NVk1b2pEelE&hl=en
Internal promotions:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdF9kOUd4Y3BZd0hkZFNieFowUWpheWc&hl=en
External promotions:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdGFVaXV2Z3E3b1ZickM4V1RLZlZ2eHc&hl=en

2008 Quarter 1:
Hires:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdHpBbXJVYnZURWY5ekF0dUdVYmlJWkE&hl=en
Automatic union salary increases part 1:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdC1OMEFLZmtIQXhDa0dydUFpZXVfVkE&hl=en
part 2:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdG9JcXpqZy1HNEZoRHcwWDVRTWdFTkE&hl=en
Non-union salary increases:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdGZjR3UwOWdaRjdtVTNNQUwtdEx2cFE&hl=en
Internal promotions:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdEg3M1pRbXByTFg5MFNhOENUejlZUGc&hl=en
External promotions:
http://spreadsheets.google.com/ccc?key=0AvKcXJhcxT7SdHROdnF1Zm9mZjUtWjN5LWZMT1Z3MXc&hl=en