Thursday, September 8, 2016

U.S. Federal Employee Salary Raw Data

I was attempting to collect information on U.S. Federal Employees and their Salaries and came across a few sites that allowed you to search and see a few salaries at once, but did not provide the entire raw data set.

examples:
http://www.fedsdatacenter.com/federal-pay-rates/
https://www.federalpay.org/employees


Ultimately I used the raw data set provided here: https://www.opm.gov/data/index.aspx (I downloaded the Fiscal Year 2015 data from August 28, 2016)

However they only provide the data in CSV files, so I imported them into a SQL Database and I've made that available for download here: https://sfhot.blob.core.windows.net/public/OpmFedScope-fy2015.zip

The ZIP Archive contains a SQL Server DB Backup file that can be restored on your local SQL Server instance.

The schema of the database, and an example query, can be found here: https://gist.github.com/aaronhoffman/ebc6468da8485d26aea4751034c83d5f


Hope this helps,
Aaron