Colorado State Employees (2019 - 2022)

To Whom It May Concern:

Pursuant to the Colorado Open Records Act, I hereby request the following records:

Monthly electronic listings of all employees of the Colorado 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 3 business days, as the statute requires.

Sincerely,

Ben Goehring

Hi Jolina,

Thank you for the message. I will mail you the check next week.

Best,
Ben

Thanks so much, Jolina! Have a great day.

Ben

Dear Jolina,

I hope this finds you well. I am reaching out with a follow up question regarding my data request from this summer.

The dataset I received contains classification codes and titles. Is it possible to figure out, from these codes, whether someone is in the classified or non-classified service? If not, is there a file that crosswalks between the codes and classification status?

Please just let me know if I need to submit a new request.

Thank you very much for all of your time and assistance. Happy Thanksgiving!

Best,
Ben

Thanks Jolina! I hope you have a great Thanksgiving.

Best,
Ben

Hello,

I hope this finds you well. I am reaching out with a question about the data I received on 6-28-2022. Could you please provide a definition of the "Department" and "Agency Title" columns?

I am seeing some odd results (e.g., in the 2022 sheet, some people are shown to work in the department of Corrections Administration but have Arapahoe Community College or the State Historical Society listed as the agency. I just want to be sure this is correct.

Thank you very much for all of your assistance!

Ben

Great - thank you!

Ben