Arizona State Employees (2019 - 2022)

Ben Goehring filed this request with the Department of Administration of Arizona.
Status
Completed

Communications

From: Ben Goehring

To Whom It May Concern:

Pursuant to the Arizona Public Records Law, I hereby request the following records:

Quarterly electronic listings of all employees of the Arizona 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 quarter from January 2019 to the present.

For each quarter, 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, 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 quarterly intervals, please produce the datasets at the most frequent interval possible. For example, if the data is not available quarterly, please produce the data at bi-annual 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, as the statute requires.

Sincerely,

Ben Goehring

From: Department of Administration

Hello,

This email is to confirm receipt of your public records request.

In the future, please send all follow up emails directly to me. I also
recommend you submit your public records request directly through our
portal (https://doa.az.gov/services/public-information-and-records-request
).

In response to your request, be advised that we can only pull the data from
a point in time. Please let me know what dates you want pulled.

Thank you.

*Anakaren Lemus*

Paralegal Project Specialist | Governor's Regulatory Review Council

Public Records Manager | Department of Administration - Director's Office
100 North 15th Avenue, Suite 302, Phoenix, AZ 85007
Office: 602.542.2058

Anakaren.Lemus@azdoa.gov <anakaren.lemus@azdoa.gov> | http://www.azdoa.gov
<https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgrrc.az.gov%2F&data=02%7C01%7Cegomes%40teamdrg.com%7C50e23e00626740a5e14108d7c5142957%7C5d6495b15cd44a4fa6dd1f5f3bf58831%7C0%7C0%7C637194562696940628&sdata=4t88GifS6%2FYPvokUv%2BlqhBriLZ11D7SCJ5R3krpMzcI%3D&reserved=0>

From: Ben Goehring

Hi Anakaren,

Thanks for getting back to me. I will be sure to submit future requests via the portal.

Regarding dates, would it be possible to do data pulls every month from January 2019 to the present on the first of the month? If not, the first day of every fourth month (1/1/2019, 4/1/2019, 8/1/2019, 12/1/2019 and so on) would be great.

Thanks!
Ben

From: Department of Administration

Hello Ben,

Attached are the list of active state employees I've received thus far. I
will send you the rest as soon as I get them.

Thank you.

*Anakaren Lemus*

Paralegal Project Specialist | Governor's Regulatory Review Council

Public Records Manager | Department of Administration - Director's Office
100 North 15th Avenue, Suite 302, Phoenix, AZ 85007
Office: 602.542.2058

Anakaren.Lemus@azdoa.gov <anakaren.lemus@azdoa.gov> | http://www.azdoa.gov
<https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgrrc.az.gov%2F&data=02%7C01%7Cegomes%40teamdrg.com%7C50e23e00626740a5e14108d7c5142957%7C5d6495b15cd44a4fa6dd1f5f3bf58831%7C0%7C0%7C637194562696940628&sdata=4t88GifS6%2FYPvokUv%2BlqhBriLZ11D7SCJ5R3krpMzcI%3D&reserved=0>

From: Ben Goehring

Thank you, Anakaren! These look great. I look forward to receiving the rest of the files for 2020.

Ben

From:

Thank you for your email.

I am currently out of the office, and will be returning Monday October 3, 2022.

If you need immediate assistance relating to GRRC, please email grrc@azdoa.gov. (mailto:grrc@azdoa.gov)

If you are emailing in regards to a public records request, and need immediate assistance please contact Megan Rose at megan.rose@azdoa.gov. (mailto:megan.rose@azdoa.gov)

I will respond to your email upon my return.

Thank you.

Anakaren Lemus

--
Anakaren Lemus Paralegal Project Specialist | Governor's Regulatory Review Council Public Records Manager | ADOA - Director's Office 100 North 15th Avenue, Suite 305, Phoenix, AZ 85007
Office: 602.542.2058 Anakaren.Lemus@azdoa.gov (mailto:anakaren.lemus@azdoa.gov) | http://www.azdoa.gov

From:

Thank you for your email.

I am currently out of the office, and will be returning Monday October 3, 2022.

If you need immediate assistance relating to GRRC, please email grrc@azdoa.gov. (mailto:grrc@azdoa.gov)

If you are emailing in regards to a public records request, and need immediate assistance please contact Megan Rose at megan.rose@azdoa.gov. (mailto:megan.rose@azdoa.gov)

I will respond to your email upon my return.

Thank you.

Anakaren Lemus

--
Anakaren Lemus Paralegal Project Specialist | Governor's Regulatory Review Council Public Records Manager | ADOA - Director's Office 100 North 15th Avenue, Suite 305, Phoenix, AZ 85007
Office: 602.542.2058 Anakaren.Lemus@azdoa.gov (mailto:anakaren.lemus@azdoa.gov) | http://www.azdoa.gov

From: Department of Administration

Hi Ben,

I've updated the folders with the missing spreadsheets.

Thank you for your patience on this.

Ben Goering-20221027T174914Z-001.zip
<https://drive.google.com/file/d/16Ce-cn1gxOMpBxNCId2YjJ4_6XRiuIGi/view?usp=drive_web>

*Anakaren Lemus*

Paralegal Project Specialist | Governor's Regulatory Review Council

Public Records Manager | ADOA - Director's Office
100 North 15th Avenue, Suite 305, Phoenix, AZ 85007
Office: 602.542.2058

Anakaren.Lemus@azdoa.gov <anakaren.lemus@azdoa.gov> | http://www.azdoa.gov
<https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgrrc.az.gov%2F&data=02%7C01%7Cegomes%40teamdrg.com%7C50e23e00626740a5e14108d7c5142957%7C5d6495b15cd44a4fa6dd1f5f3bf58831%7C0%7C0%7C637194562696940628&sdata=4t88GifS6%2FYPvokUv%2BlqhBriLZ11D7SCJ5R3krpMzcI%3D&reserved=0>

From: Ben Goehring

Thanks! Quick follow up. It looks like the January file for 2021 is actually for January 2020. Could you please send me the January 2021 file or confirm that it is in fact the data from January 2021?

Thank you!
Ben

From: Department of Administration

Hi Ben,

Attached is the list for January 2021.

Thank you.

*Anakaren Lemus*

Paralegal Project Specialist | Governor's Regulatory Review Council

Public Records Manager | ADOA - Director's Office
100 North 15th Avenue, Suite 305, Phoenix, AZ 85007
Office: 602.542.2058

Anakaren.Lemus@azdoa.gov <anakaren.lemus@azdoa.gov> | http://www.azdoa.gov
<https://nam01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgrrc.az.gov%2F&data=02%7C01%7Cegomes%40teamdrg.com%7C50e23e00626740a5e14108d7c5142957%7C5d6495b15cd44a4fa6dd1f5f3bf58831%7C0%7C0%7C637194562696940628&sdata=4t88GifS6%2FYPvokUv%2BlqhBriLZ11D7SCJ5R3krpMzcI%3D&reserved=0>

From: Ben Goehring

Perfect -- thank you!

Ben

Files