U.S. City Open Data Census
Powered by Open Data Census
Annual salary information including base pay and overtime pay for all active, permanent employees. Employee salary data show the public how individual staff positions are compensated, and help taxpayers hold city staff accountable for the work the are paid to do. Transparent publication of this dataset can also identify and disincentivize corrupt hiring or compensation in government.
Note that some cities may list only directors and high-level employee salaries. This will not fulfill the requirement for Employee Salaries data for Census purposes.
(More info)
| Question | Answer | Comment |
|---|---|---|
| Openly licensed | Yes | |
| Available in bulk | Yes | |
| Up-to-date | Yes | This data was last updated 3/18/18. It is updated at least once a year, but usually more often as new staff are appointed or existing appointees change titles. |
| Available free online | No | Data incomplete. Mayoral only. |
| Available free of charge | Yes | |
| In an open format | CSV, RDF, TXT, XML | |
| findable | 3 | |
| findable_steps | 1) Go to Detroit's open data portal data.detroitmi.gov; 2) Search "Salary" in upper right | |
| licence_url | Public domain license | This dataset is licensed in the Public Domain. The license is visible in the metadata page here: https://data.detroitmi.gov/d/fwu6-4nb5 |
| Collected by government | Yes | |
| usability | 3 | |
| collector_name | City of Detroit Mayor's Office | |
| online_otherwise | No | |
| characteristics | Employee full name, Department, Position title, Base salary or wages, Overtime | |
| location | https://data.detroitmi.gov/d/fwu6-4nb5 - Mayoral Appointee Salaries / City of Detroit open data portal | This dataset captures Mayoral Appointees only, not all staff members. |
Data incomplete. Mayoral appointees only. Invalid to show green on this one.