Florida State Employees (2019 - 2022)
| Submitted | May 4, 2022 |
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 Florida Sunshine Law, I hereby request the following records:
Copies of the State of Florida salary data published on the "Florida Has a Right to Know" website (https://salaries.myflorida.com/) for each month from January 2019 through March 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 every employee who worked in the Florida Executive Branch: Agency, Budget Entity, Last Name, First Name, Middle Initial, Salaried/Hourly, Full/Part Time, Title, Hire Date, Annual Salary (or hourly rate). If possible, please also include each employee's race/ethnicity and gender. If these latter two variables are unavailable, please exclude them and proceed with the other variables outlined above.
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: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Florida Sunshine Law request, copied below, and originally submitted on May 4, 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: Department of Management Services
[Share image]
Hall, Debbie shared a folder with you
Here's the folder that Hall, Debbie shared with you.
<https://fldms-my.sharepoint.com/:f:/g/personal/halld_mydms_fl_gov/EphwvvIPoEBKmUT8v2weAsMBBcyhrbqIiXaUGcVLcSLW7A?email=128467-85553419%40requests.muckrock.com&e=5%3A6JF5xj>
[icon] PRR 2022-1292
[permission globe icon] This link only works for the direct recipients of this message.
Open <https://fldms-my.sharepoint.com/:f:/g/personal/halld_mydms_fl_gov/EphwvvIPoEBKmUT8v2weAsMBBcyhrbqIiXaUGcVLcSLW7A?email=128467-85553419%40requests.muckrock.com&e=5%3A6JF5xj>
[Microsoft logo] [Custom logo]
Privacy Statement <https://privacy.microsoft.com/privacystatement\>
From: Department of Management Services
Muck Rock News,
I sent the link for this public record request. There is a total of eight large documents.
Please confirm you received.
Sincerely,
Debbie Hall | Communications Director
Office of the Secretary
850-921-5266 (office) | 850-544-7099 (mobile)
Florida Department of Management Services
We Serve Those Who Serve Florida
[cid:image001.png@01D876A6.2EAC4480] [cid:image002.png@01D876A6.2EAC4480] [cid:image003.png@01D876A6.2EAC4480] [cid:image004.png@01D876A6.2EAC4480]
How Are We Doing? Click Here<https://gcc02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.surveymonkey.com%2Fr%2Fdmscustomersatisfactionsurvey&data=05%7C01%7CDebbie.Hall%40dms.fl.gov%7Cd6c43585183d4c4672bc08da2937deba%7Ced173fed38394a3ca952140e906fed8d%7C0%7C0%7C6378676171905> to Take the DMS Customer Satisfaction
From: Ben Goehring
Dear Debbie,
Thank you very much for sending along these files! I see that there are two excel files covering each period. Could you please let me know what information each one contains and how they differ?
Thank you very much for your time and assistance!
Best,
Ben
From: Department of Management Services
What are the names of the files and will get clarification.
Get Outlook for iOS<https://aka.ms/o0ukef>
From: Ben Goehring
Thanks for getting back to me. Here is an example:
"202104 202204 Florida Sunshine Law Request - Florida State Employees 2.xlsx" and "202104 202204 Florida Sunshine Law Request - Florida State Employees.xlsx"
I am attaching screenshots of the first few rows of each of these files.
Thanks,
Ben
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Florida Sunshine Law request, copied below, and originally submitted on May 4, 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: Ben Goehring
Hi Debbie,
I hope you had a good weekend. I am just following up on my question regarding the multiple excel files covering each period.
Thank you very much for your time and assistance!
Best,
Ben
From: Department of Management Services
Happy Monday to you Ben,
This morning, I just followed up with this request to thee subject matter expert and asked for clarification on the files. As soon as I receive, I will forward the information to you.
From: Department of Management Services
Ben,
There were 6 files that had the historical data from each month. They were too big to place in one file. The data field titles were included.
The other 2 files were the Class Descriptions and the Race Descriptions.
Let me know if this did or did not clarify the file names.
From: Ben Goehring
Perfect -- that is helpful.
Thank you!
Ben
From: Muckrock Staff
To Whom It May Concern:
I wanted to follow up on the following Florida Sunshine Law request, copied below, and originally submitted on May 4, 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: Department of Management Services
Morning Ben,
I had this request answered. Please see below the chain of emails for this request highlighted in yellow. Let me know if you need anything else.
---
On June 22, 2022:
Subject: RE: Florida Sunshine Law Request: Florida State Employees (2019 - 2022)
Perfect -- that is helpful.
Thank you!
Ben
---
On June 22, 2022:
Subject: RE: Florida Sunshine Law Request: Florida State Employees (2019 - 2022)
Ben,
There were 6 files that had the historical data from each month. They were too big to place in one file. The data field titles were included.
The other 2 files were the Class Descriptions and the Race Descriptions.
Let me know if this did or did not clarify the file names.
---
On June 20, 2022:
Subject: RE: Florida Sunshine Law Request: Florida State Employees (2019 - 2022)
Happy Monday to you Ben,
This morning, I just followed up with this request to thee subject matter expert and asked for clarification on the files. As soon as I receive, I will forward the information to you.
---
On June 20, 2022:
Subject: RE: Florida Sunshine Law Request: Florida State Employees (2019 - 2022)
Hi Debbie,
I hope you had a good weekend. I am just following up on my question regarding the multiple excel files covering each period.
Thank you very much for your time and assistance!
Best,
Ben
---
On June 4, 2022:
Subject: RE: Florida Sunshine Law Request: Florida State Employees (2019 - 2022)
Thanks for getting back to me. Here is an example:
"202104 202204 Florida Sunshine Law Request - Florida State Employees 2.xlsx" and "202104 202204 Florida Sunshine Law Request - Florida State Employees.xlsx"
I am attaching screenshots of the first few rows of each of these files.
Thanks,
Ben
---
On May 4, 2022:
Subject: Florida Sunshine Law Request: Florida State Employees (2019 - 2022)
To Whom It May Concern:
Pursuant to the Florida Sunshine Law, I hereby request the following records:
Copies of the State of Florida salary data published on the "Florida Has a Right to Know" website (https://salaries.myflorida.com/) for each month from January 2019 through March 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 every employee who worked in the Florida Executive Branch: Agency, Budget Entity, Last Name, First Name, Middle Initial, Salaried/Hourly, Full/Part Time, Title, Hire Date, Annual Salary (or hourly rate). If possible, please also include each employee's race/ethnicity and gender. If these latter two variables are unavailable, please exclude them and proceed with the other variables outlined above.
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
View request history, upload responsive documents, and report problems here:
https://www.muckrock.com/
If prompted for a passcode, please enter:
••••••••
Filed via MuckRock.com
E-mail (Preferred): requests@muckrock.com<mailto:requests@muckrock.com>
PLEASE NOTE OUR NEW ADDRESS
For mailed responses, please address (see note):
MuckRock News
DEPT MR 128467
263 Huntington Ave
Boston, MA 02115
PLEASE NOTE: This request is not filed by a MuckRock staff member, but is being sent through MuckRock by the above in order to better track, share, and manage public records requests. Also note that improperly addressed (i.e., with the requester's name rather than "MuckRock News" and the department number) requests might be returned as undeliverable.
[http://email.requests.muckrock.com/o/eJwNyjEOwyAMAMDXlBEZY0MY2Dr0FxUB06KAUJOm729065XI7JSM1PqzlWiIiJ1T72h9gCqYAntMUhGSyYExEXsqbqmqRQRE8BcGMKjJFcBgrNgFSTzcCHb5nHJ8Dz3OvO0zbzrPofZ4l3Vtoh-p92uVceja9Wv-_tv3KTQ]