Delaware State Employees (2019 - 2022)

To Whom It May Concern:

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

Monthly electronic listings of all employees of the Delaware Executive Branch from January 1, 2019 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, 2019 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 15 business days, as the statute requires.

Sincerely,

Jonathan Rudenberg, a citizen of Delaware, in coordination with Ben Goehring.

Thanks so much, Brenda. I do have one follow up question. Could you please provide some additional information about the salary plan, grade, and step variables and the values within each one?

Thank you!

Ben

Hi Brenda,

Thanks for following up on this.

I am hoping to receive a key that provides more information about the values in the following variables: Fund Type, Appropriation, Sal Plan, and Grade. In the excel sheets you provided, the values of these variables do not make sense on their own. For instance, the Fund Type variable includes values like A, G, N, O, and R; The Appropriation column includes a number of different 5 digit numbers. These values do not make a lot of sense on their own, so I am hoping to receive additional datasets that say what each of these values mean.

I do have one other question too. In my original request, I asked for the civil service status of state employees. Is it possible to discern someone's civil service status from these data? If not, is it possible to receive a copy of the data that includes this information?

Thank you very much for your continued time and assistance.

Best,
Ben

Sounds good -- thanks Brenda!

Hi Brenda,

I just checked the data you originally sent me on August 11th and it does not include the employee class for each employee. Is it possible to receive copies of these data that include the employee classes?

Thanks,
Ben