Slice and slice the Civil Beat salary database
Civil Beat’s Public Employee Salary Database can tell you much more than what civil servants are paid on the islands.
With just a few keystrokes, the possibilities of splitting and splitting the database are vast.
To get started, a single click on the red SEARCH button displays the entire database – 411,379 entries covering selected years dating back to 2011.
It’s an unsightly queue that you can escape by clicking “Search Again” in red letters at the top.
To tame the database, use the drop-down menus to search by departments, job titles, and fiscal years. If desired, also enter names or salary ranges.
Each time you press this SEARCH button, the database spits out a new queue according to your specifications. At the bottom of the queue is the total number of entries you tapped into.
And still, clicking Search again allows you to escape when you want to change your search or go in a totally different direction.
Here’s a closer look at the options you can use individually or, for better effect, simultaneously.
Public Employees Salary Database
Department: There are 18 “departments”, ranging in size from 10 employees (Hawaii Ethics Commission) to 21,997 (Education). For the total number of states, click “Select all”.
Sub-department: Three of these giant “departments” have many “sub-departments”. For the city and county of Honolulu, there are 29, including the police and fire department. For the state of Hawaii, there are 19, including health, public safety, and transportation. And for the University of Hawaii, there are 16, including 14 individual campuses.
If you don’t want a “sub-department”, keep this section on “Select All”.
First name: You should generally fill this field with the following category of “last name” when searching for a specific employee. Although the database sometimes includes middle names or initials, they are not essential to finding who you are looking for.
Last name: Again, this category is generally used to find individuals. Once the names are entered, you can follow them through the years of their employment in the public service as long as you have not selected a specific fiscal year.
If you fill in “last name” without “first name”, you will find everyone with the same last name, in some cases parents.
Title: This is a drop-down list that only appears after you enter a “department” and / or a “sub-department”. Some lists are quite long, reflecting the way this agency labels its positions. But it is a useful option for large organizations, offering the possibility, for example, of separating teachers from other employees of the Ministry of Education.
Start of the salary scale: A good tool if you want to enter a dollar amount and find out which employees are earning that amount or more. But remember that the database contains wide salary ranges for many employees. If you enter $ 50,000 here and the range for an individual worker is $ 40,000 to $ 60,000, they won’t show up even though they could actually earn more than $ 50,000.
Some smaller departments provide specific salaries for all of their employees; in other cases, exact figures are only available for high-end employees who are exempt from collective bargaining.
End of salary range: Enter an amount and see whoever earns it or less. Individual employee pay scales are not an issue here, as the top end would always be less than the dollar amount entered.
Fiscal year: Most of your research will focus on a single exercise. The only other choice, “Select All,” provides all of the exercises. This is useful if you follow a certain person over the years or want to know, for example, who the highest paid current and former employees have been over the past decade.
The database contains information for fiscal years 2022, 2020, 2018, 2016, 2013, 2012 and 2011.
These are your options, and again, you’ll usually want to use two or more simultaneously when exploring the data.
Sign up for our FREE morning newsletter and be more informed every day.