Tennessee State Employees (2010 - 2018)

To Whom It May Concern:

Pursuant to the Tennessee Public Records Act, I hereby request the following records:

Copies of the State of Tennessee employee salary data published on the "Transparent Tennessee" website (https://salary.app.tn.gov/public/searchsalary) for each month from January 2010 through December 2018.

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 every employee who worked in the Tennessee Executive Branch: Agency Name, Last Name, First Name, Job Title, Comp Rate, Comp Rate Period, Full/Part, and Bonus. If possible, please also provide information on employees' race/ethnicity, sex, hire date, and termination date. If these latter variables are unavailable, please exclude them and provide only the variables listed above.

If the data is not available for every month, please provide it at the most frequent interval possible. For instance, if the data is not available for each month, please provide quarterly listings. If unavailable quarterly, please provide bi-annual listings.

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 7 business days, as the statute requires.

Sincerely,

Kent Hoover, a citizen of Tennessee, in coordination with Ben Goehring.

Hi Teresa,

Thanks for your response. Just to be clear, you do not maintain any of the records requested above for dates earlier than 1/1/2019?

Best,
Ben

Does the Department maintain similar payroll data for state employees in earlier periods in a location other than Transparent TN? If it would help, I would happily resubmit a request for payroll data over this period that does not specify that it be from the Transparent TN website.

Thank you so much for your continued assistance with this matter!

Best,
Ben

Thank you for all of your help!

Best,
Ben