TDCJ Correctional Officers (2019-2022)

Ben Goehring filed this request with the Texas Department of Criminal Justice of Texas.
Tracking #

1483-10-2022

Status
Completed

Communications

From: Ben Goehring

To Whom It May Concern:

Pursuant to the Texas Public Information Act, I hereby request the following records:

Monthly electronic listings of all correctional officers employed in the Texas Department of Criminal Justice from January 1, 2019 to the present.

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 ID, race, gender, title, unit, full-time/part-time status, 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 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 10 business days, as the statute requires.

Sincerely,

Ben Goehring

From: Texas Department of Criminal Justice

Good Morning,

Attached you will find the cost estimate for your Public Information Request dated, October 27, 2022.

Thank you,

Office of the General Counsel-TDCJ
P: (936) 437-6700

The information contained in this email and any attachments is intended for the exclusive use of the addressee(s) and may contain confidential, privileged, or proprietary information. Any other use of these materials is strictly prohibited. This email shall not be forwarded outside the Texas Department of Criminal Justice, Office of the General Counsel, without the permission of the original sender. If you have received this material in error, please notify me immediately by telephone and destroy all electronic, paper, or other versions.

From: Ben Goehring

Hello,

Thank you for your prompt response. Before I send in the check, can you please confirm that which data I requested are available? In particular, I am most interested in the employees' names and the corresponding units in which they work.

Once you confirm that, I will put the check in the mail. Thank you very much for your time and assistance.

Best,
Ben

From: Ben Goehring

Hello,

I apologize for the double email. If possible, would It also be possible to add employees' birth date to the list of requested data? I understand that this will likely affect the final cost of the request.

Thanks,
Ben

From: Ben Goehring

Hello,

I apologize for the follow up, but I realized I might have initially responded to the wrong email address. Before I send the deposit for the data, could you please confirm which of the requested variables are in fact available?

Thank you,
Ben

From: Texas Department of Criminal Justice

Good Afternoon,

We apologize for the delayed response to your question.

The termination dates are not maintained in the source files used for the remaining data. Therefore, the termination date will not be included in this format.

If you are wanting that information you may submit a new request for the termination dates but they will not be broken out in monthly reports like the remaining data.

Thank you,

Office of the General Counsel-TDCJ
P: (936) 437-6700

The information contained in this email and any attachments is intended for the exclusive use of the addressee(s) and may contain confidential, privileged, or proprietary information. Any other use of these materials is strictly prohibited. This email shall not be forwarded outside the Texas Department of Criminal Justice, Office of the General Counsel, without the permission of the original sender. If you have received this material in error, please notify me immediately by telephone and destroy all electronic, paper, or other versions.

From: Ben Goehring

Not a problem -- thank you for the information!

I will put the check in the mail today.

Best,
Ben

From: Texas Department of Criminal Justice

Good Morning,

Our office has received your payment for the cost estimate this morning. We will be sending our custodians instructions to start processing the responsive information for your request.

Thank you for your patients,

Office of the General Counsel-TDCJ
P: (936) 437-6700

The information contained in this email and any attachments is intended for the exclusive use of the addressee(s) and may contain confidential, privileged, or proprietary information. Any other use of these materials is strictly prohibited. This email shall not be forwarded outside the Texas Department of Criminal Justice, Office of the General Counsel, without the permission of the original sender. If you have received this material in error, please notify me immediately by telephone and destroy all electronic, paper, or other versions.

From: Ben Goehring

Great -- thank you!

Ben

From: Texas Department of Criminal Justice

Good Morning,

The Texas Department of Criminal Justice is working diligently to compile the information responsive to your request received October 27, 2022. In accordance with Texas Government Code § 552.221(d), an additional 10 business days is required to process your request. The information you requested is anticipated to be available on January 6, 2023. We appreciate your patience and cooperation.

Thank you,

Office of the General Counsel-TDCJ
P: (936) 437-6700

The information contained in this email and any attachments is intended for the exclusive use of the addressee(s) and may contain confidential, privileged, or proprietary information. Any other use of these materials is strictly prohibited. This email shall not be forwarded outside the Texas Department of Criminal Justice, Office of the General Counsel, without the permission of the original sender. If you have received this material in error, please notify me immediately by telephone and destroy all electronic, paper, or other versions.

From: Texas Department of Criminal Justice

Good Afternoon,

The Texas Department of Criminal Justice is working diligently to compile the information responsive to your request received October 27, 2022. In accordance with Texas Government Code § 552.221(d), an additional 10 business days is required to process your request. The information you requested is anticipated to be available on January 24, 2023. We appreciate your patience and cooperation.

Thank you,

Office of the General Counsel-TDCJ
P: (936) 437-6700

The information contained in this email and any attachments is intended for the exclusive use of the addressee(s) and may contain confidential, privileged, or proprietary information. Any other use of these materials is strictly prohibited. This email shall not be forwarded outside the Texas Department of Criminal Justice, Office of the General Counsel, without the permission of the original sender. If you have received this material in error, please notify me immediately by telephone and destroy all electronic, paper, or other versions.

From: Texas Department of Criminal Justice

Good morning,

The Office of the General Counsel is prepared to mail the responsive information in a CD file in response to your October 27, 2022 Public Information Act Request.

Please verify that you wish the CD to be mailed to the address below.

MuckRock
News DEPT
MR 135827
263 Huntington Ave
Boston, MA 02115

Thank you,

Office of the General Counsel - TDCJ
Phone: 936-437-6700

The information contained in this email and any attachments is intended for the exclusive use of the addressee(s) and may contain confidential, privileged, or proprietary information. Any other use of these materials is strictly prohibited. This email shall not be forwarded outside the Texas Department of Criminal Justice, Office of the General Counsel, without the permission of the original sender. If you have received this material in error, please notify me immediately by telephone and destroy all electronic, paper, or other versions.

From: Ben Goehring

Hello,

Could you please mail it to the following address:

Ben Goehring
323 Packard St.
Apartment 11
Ann Arbor, MI 48104

If possible, could you mail it on a USB drive instead of a CD? If not, that is just fine.

Thanks!
Ben

From: Ben Goehring

I received the data in the mail -- thank you! I have one quick question. What is the definition of the LAST EMPL DATE variable?

Thanks,
Ben

From: Ben Goehring

Could you please also include a crosswalk of the various single letter race value in the data (e.g., B, W, I, P) to their full names?

Thanks,
Ben

From: Texas Department of Criminal Justice

Mr. Goehring,

I will address both of your follow up questions in this email.

1. What is the definition of the LAST EMPL DATE variable?
* The most recent employment date for employees that have multiple employment dates.

1. Could you please also include a crosswalk of the various single letter race value in the data (e.g., B, W, I, P) to their full names?
* The letter represents the ethnic origin as present on their applications for employment.

i. W-White

ii. B-Black

iii. H-Hispanic

iv. A-Asian

v. I-American Indian or Alaskan Native

vi. P-Native Hawaiian or Other Pacific Islander

vii. M-Two or More races

Please note that if you have any other questions, you will need to submit a new public information request.

Thank you,

Office of the General Counsel-TDCJ
P: (936) 437-6700

The information contained in this email and any attachments is intended for the exclusive use of the addressee(s) and may contain confidential, privileged, or proprietary information. Any other use of these materials is strictly prohibited. This email shall not be forwarded outside the Texas Department of Criminal Justice, Office of the General Counsel, without the permission of the original sender. If you have received this material in error, please notify me immediately by telephone and destroy all electronic, paper, or other versions.

Files

pages

Close