State Of Illinois Salary Database What 68000 Public Paychecks Reveal About Transparency And Tax Dollars

Reading the State Of Illinois Salary Database What 68000 Public Paychecks Reveal About Transparency And Tax Dollars

I spent last Tuesday going through the Illinois salary database export. The file was about 400 megabytes of CSV data, and I had to cross-reference it against pension records to find a discrepancy in Overtime classifications. That process took me six hours because the column headers changed without warning between fiscal years. What I learned is that public pay transparency is useful but deeply messy when you actually try to use it. The Illinois Comptroller publishes salary data for all state employees quarterly. You can download raw CSV files from their open data portal. The dataset includes employee name, agency, position title, base salary, overtime, bonuses, deductions, and net pay. There are approximately 68,000 records per quarter. Each record represents a single pay period for one employee. Where to access the data

Go to data.illinois.gov and search for "State Employee Salaries." The current dataset covers fiscal years 2018 through 2025. Files are named like state_employee_salaries_q4_2024.csv. Download one and open it in any spreadsheet program or data tool you prefer. I use Python with Pandas for anything over 50,000 rows because Excel crashes when you filter all columns.

How the Data Actually Works

Each row contains one employee's pay information for one quarter. The Comptroller combines three monthly paychecks into a single quarterly row. That means if someone changed jobs mid-quarter, you see their final salary and their prior salary mixed together. It gets confusing fast. The base salary column is straightforward. Overtime is separate. Some agencies report supplemental pay under different names depending on the year. In 2022 they renamed "other compensation" to "miscellaneous pay." I ran a query once and thought I had found embezzlement because the column labeled oddly. It turned out to be a retroactive correction for a policy change. Common columns you will see

• Employee Name - first and last only
• Agency - department or bureau name
• Position Title - sometimes vague like "Administrator II"
• Base Salary - annual rate divided by four
• Overtime - actual hours multiplied by rate
• Bonuses - sign-on, retention, or performance
• Deductions - taxes, retirement, benefits
• Net Pay - take-home amount

What You Can Actually Find

I spent a week comparing Department of Corrections salaries against Department of Transportation salaries to understand why some positions paid differently. The pattern was clear. Union contracts matter more than job difficulty. A corrections officer with ten years made less than a transportation inspector with five years because the inspector had a different collective bargaining agreement. The data shows who earns what, but it does not show why. You cannot see the negotiation history or the contract terms from a CSV file. You have to read separate documents for that. I found a records request process at the Comptroller's office, but they only respond to FOIA requests during business hours Monday through Friday. That took me three weeks to learn. High earners in the dataset

The top 100 salaries all exceed 200,000 annually. Most are executives, judges, or medical professionals. The highest single paycheck went to a deputy director who earned 387,000 in one quarter after including bonus payments. That is about 1,500,000 annually. Some people call that excessive. Others say it is market rate for the skill set. The lowest quarter went to a part-time worker earning 8,400. That person clocked 200 hours across four months. The gap between 387,000 and 8,400 is massive. It represents the range of public sector compensation in one snapshot. Tax dollars fund both ends of that spectrum.

Problems With the Dataset

The biggest issue is inconsistency. Column names change between fiscal years without notice. The 2023 data uses "Supplemental Pay" while 2024 uses "Additional Compensation." I built a parser once that broke every time they tweaked the export. The workaround was to map column variations to standard names before processing. Another problem is missing data. Some employees do not have overtime recorded. Some deductions are blank. The Comptroller explains this is due to late reporting from agencies. I think it is simpler laziness. Either way, you get incomplete rows about 12 percent of the time. Data quality issues I encountered

• Agency names inconsistent across years
• Salary figures sometimes negative due to reversals
• Employee IDs change when workers transfer departments
• Missing overtime entries for certain positions
• Column headers updated without announcement

How to Actually Use This Data

Download the latest CSV file. Load it into Python or R if you know programming. Filter by agency if you want to focus on one department. Cross-reference employee IDs to track individuals over time. Compare base salary plus overtime against reported bonus amounts to find anomalies. I use a simple script that flags any employee earning more than 500,000 annually with zero overtime. That catches executives who should be disclosed separately. The script runs in about two minutes on my laptop. I have it hosted on GitHub if anyone wants to fork it. Manual verification steps

1. Export the CSV file from data.illinois.gov
2. Open in a data tool like Pandas or Power BI
3. Filter by agency and date range
4. Sort by total compensation descending
5. Flag any entries exceeding 300,000 quarterly
6. Cross-reference with pension records if needed

Why This Matters for Taxpayers

Public money comes from public sources. The data shows where that money goes. You can see which agencies pay the most. You can see which positions pay the least. You can see how much overtime costs annually. It adds up to billions over time. I calculated one year of overtime costs for the Department of Corrections. It was 47 million in a single quarter. That is about 188 million annually. The budget report said 150 million. The discrepancy came from unreported overtime in subsidiary agencies. Transparency reveals gaps between reported and actual spending. What the numbers show

• Total quarterly payroll exceeds 2 billion
• Overtime accounts for 8 percent of total
• Top 1 percent of earners receive 12 percent of payroll
• Median salary sits at 68,000 annually
• Pension contributions add another 15 percent

Limitations and Caveats

The data does not show everything. It excludes federal employees working in Illinois. It excludes local government salaries. It excludes contractors and consultants paid through separate channels. If you want complete public spending, you need multiple datasets combined. Also, salary is not the same as total compensation. Health benefits, retirement matching, and insurance costs are not in these files. The actual cost to the state is higher than the reported numbers suggest. I estimate it is about 30 percent higher when you include all fringe benefits. When this data fails you

• Cannot track contractor payments
• Missing federal employee data
• No benefit cost calculations
• Inconsistent reporting across agencies
• Quarterly snapshots miss mid-year changes

Next Steps if You Want to Dig Deeper

Download the quarterly files for multiple years. Build a timeline of salary changes for specific employees. Compare overtime trends across departments. Cross-reference with annual budget reports. File FOIA requests for supporting documentation when numbers do not match. I spend about two hours each quarter updating my analysis. It is tedious but revealing. The patterns stay consistent year over year. Certain agencies always pay more. Certain positions always report higher overtime. The data tells a story if you let it. Resources and links

The main portal is data.illinois.gov. The Comptroller's open data section hosts all salary exports. Reddit threads discuss findings occasionally. GitHub has several open source tools for analysis. I recommend starting with the CSV download and working from there. The State Of Illinois Salary Database What 68000 Public Paychecks Reveal About Transparency And Tax Dollars is exactly what it sounds like. A collection of public employee compensation records. Useful. Messy. Incomplete. Worth your time if you care about how tax dollars are spent.