code-for-nashville / inclucivics

Data visualization of Nashville Metropolitan Government employee salary and demographics
http://www.codefornashville.org/inclucivics/
MIT License
12 stars 18 forks source link

Save all fields from Metro Report (since they don't) #168

Closed combinatorist closed 3 years ago

combinatorist commented 5 years ago

It looks like we only save 4 fields that we need: https://github.com/code-for-nashville/inclucivics/blob/gh-pages/data/2014-12-07/employees.csv

But the original Metro Report has lots of other info, including age, and start date, etc: https://data.nashville.gov/General-Government/General-Government-Employees-Demographics/4ibi-mxs4

The problem with the original report is that it is overwritten every quarter in the Open Data Portal, so there's no way to get historical reports. So, we could provide that public service (In fact, I just opened a public record request).

combinatorist commented 3 years ago

I think this was solved a long time ago by our open data portal repo: https://github.com/code-for-nashville/open-data-portal/tree/master/nashville/metro-general-government-employees-demographic-data