Massachusetts State Employees (2019 - 2022)

Dear Mr. Goehring,

This responds to your public records request received by this Office on November 14, 2022.

Your request states the following: “Monthly electronic listings of all employees of the Massachusetts Executive Branch from January 1, 2019 to July 31, 2022. Specifically, I am seeking electronic listings of all individuals employed within all state agencies, commissions, and departments for each month from January 1, 2019 to July 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, date of birth or age, 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).

I also request that, if appropriate, fees be waived as we believe this request is in the public interest, as suggested but not stipulated by the recommendations of the Massachusetts Supervisor of Public Records. The requested documents will be made available to the general public free of charge as part of the public information service at MuckRock.com, processed by a representative of the news media/press and is made in the process of news gathering and not for commercial usage.
I expect the request to be filled in an accessible format, including for screen readers, which provide text-to-speech for persons unable to read print. Files that are not accessible to screen readers include, for example, .pdf image files as well as physical documents.
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.”

Upon inquiry, it is my understanding that this Office does not have possession, custody or control of the above public records that you have requested. However, the Commonwealth’s Human Resources Division (HRD) may be the appropriate agency/office to respond to this request. You may submit a public records request with HRD by using the form at the following link: How to Request a Public Record from Human Resources | Mass.gov<https://www.mass.gov/how-to/how-to-request-a-public-record-from-human-resources>.

We are not withholding any public records based on a statutory or other legal exemption, and do not seek an extension to respond to your request. We are not charging fees for this request.

If you wish to challenge any aspect of this response, you may appeal to the Supervisor of Public Records following the procedure set forth in 950 C.M.R. 32.08, a copy of which is available at http://www.mass.gov/courts/case-legal-res/law-lib/laws-by-source/cmr/. You may also file a civil action in accordance with M.G.L. c. 66, § 10A.

Sincerely,

Patrick Lynch
Deputy General Counsel
Executive Office for Administration & Finance