Texas State Salary Report
Annual salary distribution by ethnicity across five salary brackets — exported as a formatted PDF.
What This Report Contains
This report queries live data from the Texas State Employees database and breaks down the workforce by ethnicity within five annual salary brackets. Each section shows a count of employees and their percentage share within that bracket.
Under $50,000
Entry-level & support roles
$50K – $99,999
Mid-range state positions
$100K – $149,999
Senior & professional roles
$150K – $199,999
Director & executive level
$200,000 & Above
Top-tier compensation
Sample Query Logic
The report runs one query per salary bracket. Here is an example of the query used for the $100K–$149,999 bracket:
FROM `tx_employees`
WHERE CAST(REPLACE(REPLACE(`ANNUAL`, ',', ''), '$', '') AS DECIMAL(12,2)) >= 100000.00
AND CAST(REPLACE(REPLACE(`ANNUAL`, ',', ''), '$', '') AS DECIMAL(12,2)) < 150000.00
GROUP BY `ETHNICITY`
ORDER BY cnt DESC;
Note: The ANNUAL column is stored as VARCHAR in the database, so each query uses CAST + REPLACE to handle any values containing $ signs or commas before numeric comparison.
Related Texas Data Tools
TX Employee Explorer
Search and filter individual employee records by agency, class code, ethnicity, and more.
TX Salary Browser
Browse the full workforce ranked by annual salary with visual salary bars.
TX Agency Explorer
Browse all Texas state agencies ranked by workforce size with full payroll details.