Philadelphia Budget Data data visualization
The data set is in /data
We used convert.rb to convert the .csv file to json and to a sql insert statement
index.html sends json requests to jrequest.rb which returns json
Mandel for Controller Bulldog Budget
The Mandel for Controller Bulldog Budget allows users, for the first time ever, to see how every single dollar of our money was spent from the Philadelphia city budget. You can dig for information like a dog digs for a bone, but before you do, a note on navigation.
The Philadelphia budget is adopted by City Council each year with expenditures approved by agency and by "class" and classes refer to:
Class 100 - Salaries and fringe benefits
Class 200 - Contracts for the purchase of services and leases
Class 300 - Materials and supplies
Class 400 - Equipment
Class 500 - Contributions and indemnities (payments for compensation by the city)
class 700 - Debt Service (payments for long-term loans/bonds)
Class 800 - Payments to other funds
Class 900 - Advances and miscellaneous payment
The city budget ordinance passed by City Council shows only how much money is allocated to each city agency and how that money is divided by class -- how much for personnel, how much for contracts, how much for supplies, and so on. But, with the Mandel for Controller Bulldog Budget you can search for any agency, vendor, or type of expenditure or click through each agency to each class to each type of expenditure to see a list of the actual payments down to the last cent.
The Bulldog Budget was developed by Brett Mandel and Ben Garvey