A budget transparency visualization for New Orleans, displaying appropriations & spending broken down by funds/departments from 2004 to 2014.
This is based on Look at Cook by Derek Eder and Nick Rougeux at Open City, and can be easily re-deployed to visualize other budgets.
- jQuery
- D3 (for CSV manipulation)
- Backbone (javascript MVC framework)
- Highcharts (charting library)
- Datatables (sortable HTML tables)
This code can be customized to visualize another data set. ####Data Prepatation The budget data can be in various forms (csv, google doc, google fusion table), but must adhere to a fixed format in order for the app to process it properly. Budget column headers include: Fund ID, Fund, Results Area ID, Results Area, Department ID, Department, Short Title, Link to Website, Department Description, and Control Officer. Values for appropriations and expenditures must be broken down into a separate column for each year.
See examples of prepped data:
####Configuration
- Once the data is prepared, set dataSource in js/app.js to link up to your data.
If your budget data is in CSV form: Drop the csv file in the data folder, and set dataSource to the file path.
If your data is in a google doc: You will first need to publish the google doc to the web as a CSV. Then, set dataSource to the URL provided.
- Next, set the following configuration variables at the top of js/app.js:
- startYear
- endYear
- activeYear
- municipalityName
If something is not behaving intuitively, it is a bug, and should be reported as an issue
You can also email info@datamade.us or tweet @DataMadeCo.
- Fork the project.
- Make your feature addition or bug fix.
- Commit and send me a pull request. Bonus points for topic branches.