search

jms301 / pfi-explorer

MIT License
2 stars 2 forks source link

Pull in data from OSCAR about how much department is spending on PFI in total #6

Open xavriley opened 10 years ago

xavriley commented 10 years ago

This is a bit hand wavy but...

http://oscar-explorer.herokuapp.com/?statement=select+organisation_long_name%2C+sum%28amount_int%29+as+total+from+oscar+where++CHART_OF_ACCOUNTS_L5_LONG_NAME+like+%27%25+PFI%25%27+and+version_code+%3D+%27R13%27+and+status_code+%3D+%27CONFIRMED%27+group+by+organisation_long_name+order+by+total+desc

Shows the amount spent on PFI by different departments using spending data from 2013. I'm not sure how it would all fit together but it might give some context to the figures for an individual project.

atiro commented 10 years ago

I suppose in theory the same figure could be reached by summing all the payments for projects in that department?