Michigan State Employees (2016 - 2018)

Ben Goehring filed this request with the Michigan Civil Service Commission of Michigan.

It is a clone of this request.



From: Ben Goehring

To Whom It May Concern:

Pursuant to the Michigan Freedom of Information Act, I hereby request the following records:

Monthly electronic listings of all employees of the Michigan Executive Branch from January 1, 2016 to December 31, 2018. Specifically, I am seeking electronic listings of all non-exempt, classified individuals employed within all state agencies, commissions, and departments for each month from January 1, 2016 to December 31, 2018.

For each month, Iā€™m seeking a spreadsheet, database, or delimited text file(s) ā€” not paper records or a PDF created from data ā€” with the following fields for each employee: full legal name, title, department or agency, full-time/part-time status, work zip code, original hire date, civil service status, and gross annual salary (i.e., the base hourly wage for each hourly employee and the base annual salary for salaried employees for each of the time periods in question). If you cannot produce any of these fields, please let me know and generate only the available variables.

If these data are not available at monthly intervals, please produce the datasets at the most frequent interval possible. For example, if the data is not available monthly, please produce the data at quarterly intervals.

In addition, please include any lookup tables that may be needed to interpret the data. For example, if departments are listed with codes linked to a separate table, I will be happy to join the records myself, rather than require your staff to do so.

I am comfortable working with large data sets and can receive the records in a variety of formats (.dbf, .csv, .mdb, etc).

The requested documents will be made available to the general public, and this request is not being made for commercial purposes.

In the event that there are fees, I would be grateful if you would inform me of the total charges in advance of fulfilling my request. I would prefer the request filled electronically, by e-mail attachment if available or CD-ROM if not.

Thank you in advance for your anticipated cooperation in this matter. I look forward to receiving your response to this request within 5 business days, as the statute requires.


Ben Goehring

From: Michigan Civil Service Commission

Please see attached response to your FOIA request received on January 9. Thank you.

From: Ben Goehring

Thanks Kurt. I just paid using the online portal.

Thank you for all of your assistance!


From: Michigan Civil Service Commission

Requested, non-exempt records of full and part-time active executive branch classified employees for the time periods requested will be provided upon receipt of the balance due. Please see the attached response form for additional information, including applicable statutory exemptions from disclosure.

Thank you.

From: Michigan Civil Service Commission

Please find attached your response to your FOIA request received on January 9. Because the data files (excel spreadhsheets) are large, the responsive documents are being provided in 3 separate emails. This is the first of three.

Thank you.

From: Michigan Civil Service Commission

#3 of 3

From: Michigan Civil Service Commission

#2 of 3.