Overview
The goal of CyChecks is to allow users easy access to the publicly available data concerning Iowa State University (the Cyclones) employee salaries.
Some of the services this access could offer include:
- Aiding job seekers in negotiating starting salaries.
- Shedding light on possible pay inequities with respect to gender
- Seeing what the highest paid positions are at the university.
Background
The state of Iowa offers a large amount of public data at this site. You can access the data by signing up for an API token here. Iowa state employee salaries are available at this site. Using an API token, CyChecks provides a function to easily get data for any given year.
The data from this site does not include the employee's home department. Unfortunately, to our knowledge the data linking names to departments is not easily accessible. ISU's Human Resources Department kindly provided a list of employees with their home departments and associated colleges valid as of January 1 2019. Although we realize this isn't ideal, this data is included in the package. We have merged the 2018 employee list with salary data fom 2018, and provide this data with the package. However, we realize that the department data may not always be received in the same form, so have not included a function to automate this process.
Summary
This package currently includes:
- A function to download data directly from the iowa.gov website.
- Employee/salary dataset for X-2018 (scraped from the web)
- Employee/department/college dataset valid as of Jan 1 2019 (received by ISU Human Resources)
- Employee/salary/department/college dataset assumed to be valid for 2018
- A function to anonymize names in the web scraped dataset
- A shiny app for visualizing the 2018 dataset (4)
You can install the development version CyChecks from github with:
devtools::install_github("https://github.com/vanichols/CyChecks")
You can access the data using our XX function.
## basic example code