The dataset contains the name, gender, county or city of residence (when possible), official title, total salary received during each fiscal year, base salary for the employee, and traveling and subsistence expense reimbursed to personnel at Iowa State University, University of Iowa and University of Northern Iowa. A status of "TERMINATED" in the column providing the base salary does not indicate that the employee was fired, only that the person no longer works in that position.
This dataset has the following 11 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Fiscal Year | fiscal_year | number | Fiscal year (July 1 - June 30) salary data is associated with | 2022 2020 2007 2021 2019 view top 100 |
Department | department | text | Department employing the individual | University of Iowa Iowa State University University of Northern Iowa view top 100 |
Agency/Institution | agency_institution | text | Department sub-agency or institution employing the individual (where applicable) | Univ. Of Iowa Hospital & Clinics Univ. Of Iowa - Hygienic Lab Hospital & Clinics Univ. Of Iowa - Psych Hospital Univ. Of Iowa - C.D.D. view top 100 |
Name | name | text | Name of the employee | KATES,KENNETH PHILIP MILLER,MARY ANN ANDERSON,MARILYN BUCKWALTER,JOSEPH ADDISON BARNES,JANICE L view top 100 |
Gender | gender | text | Gender of the employee | F M * U view top 100 |
Place of Residence | place_of_residence | text | City or county where the state employee resides (where available) | JOHNSON STORY BLACK HAWK LINN Story view top 100 |
Position | position | text | Position the state employee held during Fiscal Year | Staff Nurse CASUAL HOURLY Professor Custodian I Associate Professor view top 100 |
Base Salary | base_salary | text | Annual, biweekly or hourly base salary for the employee | 0 0.00 -0- TERMINATED 46583 view top 100 |
Base Salary Date | base_salary_date | calendar_date | Date base salary was computed | 2022-07-01T00:00:00.000 2020-07-01T00:00:00.000 2007-07-01T00:00:00.000 2021-07-01T00:00:00.000 2019-07-01T00:00:00.000 view top 100 |
Total Salary Paid | total_salary_paid | number | Total salary paid during Fiscal Year | 0.00 2000.00 3000.00 1000.00 1600.00 view top 100 |
Travel & Subsistence | travel_subsistence | number | Total travel & subsistance expenses reimbursed during Fiscal Year | 0 1000 500 300 200 view top 100 |