Wisconsin State Employees (2018 - 2022)
| Submitted | June 7, 2022 |
| Est. Completion | None |
MuckRock users can file, duplicate, track, and share public records requests like this one. Learn more.
Communications
From: Ben Goehring
To Whom It May Concern:
Pursuant to the Wisconsin Open Records Act, I hereby request the following records:
Monthly electronic listings of all employees of the Wisconsin Executive Branch from January 1, 2018 to the present. Specifically, I am seeking electronic listings of all individuals employed within the offices of the Governor and Lieutenant Governor and all state agencies, commissions, and departments for each month from January 1, 2018 to May 31, 2022.
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, unique employee identification code, title, department or agency, race, gender, full-time/part-time status, location, hire date, termination date, civil service status, and gross annual salary. 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 10 business days.
Sincerely,
Ben Goehring
From: Wisconsin Department of Administration
Good afternoon, Mr. Goehring,
This message is to acknowledge receipt of your public records request. We are processing your request and will respond as soon as our work is complete.
Sincerely,
[cid:image001.png@01D87A79.0BB40BD0]<https://doa.wi.gov/>
Patricia Reardon | Program & Policy Analyst
Department of Administration
Division of Legal Services
Patricia.Reardon@wisconsin.gov
Direct: (608) 264-9595
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Wisconsin Open Records Act request, copied below, and originally submitted on June 7, 2022. Please let me know when I can expect to receive a response.
Thanks for your help, and let me know if further clarification is needed.
From: Wisconsin Department of Administration
Good morning, Mr. Goehring,
We are still working on your request and will respond as soon as our work is complete.
Sincerely,
[cid:image001.png@01D8861D.A4B52C60]<https://doa.wi.gov/>
Patricia Reardon | Program & Policy Analyst
Department of Administration
Division of Legal Services
Patricia.Reardon@wisconsin.gov
Direct: (608) 264-9595
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Wisconsin Open Records Act request, copied below, and originally submitted on June 7, 2022. Please let me know when I can expect to receive a response.
Thanks for your help, and let me know if further clarification is needed.
From: Wisconsin Department of Administration
Mr. Goehring,
Thank you for your email. Your request remains in our queue. We receive a high volume of public records requests requiring our attention and response, but that we must also balance with our other responsibilities, some of which are also statutorily mandated. Please rest assured that your request will be addressed as soon as practicable and without delay.
Sincerely,
[cid:image001.png@01D891DB.00D53DF0]<https://doa.wi.gov/>
Patricia Reardon | Program & Policy Analyst
Department of Administration
Division of Legal Services
Patricia.Reardon@wisconsin.gov
Direct: (608) 264-9595
From: Wisconsin Department of Administration
To: requests@muckrock.com
CC : patricia.reardon@wisconsin.gov
One or more files have been sent to you.
Visit the Workspace<https://wibox.wi.gov:443/anonymous/ed0780cf-9322-4900-b593-f0b197f45046/> to retrieve files.
You may be prompted to register an account if authentication is required.
This link will expire on 8/18/2022 5:11:48 PM
Dear Mr. Goehring,
Please use the Workspace link above to access our response to your public records request.
Sincerely,
Patricia Reardon
DOA-Division of Legal Services
From: Ben Goehring
Hello,
Thank you very much for sending these data! They look great. I have one follow up question. Could you please clarify the difference between the separate annual salary files (e.g., "State_of_WI_2018_Payroll_Data-Final.xlsx") and the "Enterprise_Personnel_Reports_REDACTED.xlsx" file? I see that there are some differences in which variables are included (e.g. "term_date" is in the former but not the latter). Are there other differences I should be aware of?
Thank you very much for your time and assistance.
Best,
Ben
Files
pages