Data
Interested in helping us dig in to the data? Get started by reading our data wrangler’s guide.
All the data we’ve extracted and cleaned is available on google docs linked from our summary spreadsheet.
To the extent we have any rights in this data, they are waived using the Public Domain Dedication and License v1.0.
The majority of our present data comes from the Public Expenditure Statistical Analysis (PESA) which is the highest level breakdown of Government spending. However, we aim to have information at a much more granular level down to the lowest levels of government expenditure.
If have ideas for data we should incorporate and where we can find it please let us know using the form below.
An
A parallel project could be “Where Does The Money Come From?” to highlight where the revenue TO the Government, both local and central and movements between, can be seen.
Well done and if there is anything I may be able to help with – let me know!
[Reply]
lisa Reply:
December 23rd, 2009 at 7:32 pm
Hi Andrew, Thank you for your kind offer of help. If you could drop me a quick email to lisa.evans@okfn.org we can talk about the work you would like to do.
[Reply]
and .. could extra measures be introduced to the spending categories so they can be aligned to Ministerial Departments?
This way we can actually see the spend of each Minister.
see http://www.cabinetoffice.gov.uk/ministerial_responsibilities/departments.aspx
The next logical step would be the introduction of “Public Body” measures too .. that way we can see the spend by “Non Departmental Public Bodies” ..
(perhaps also some collaboration with the good people at mysociety.org?)
[Reply]
Rufus Pollock Reply:
December 29th, 2009 at 12:43 pm
Andrew: we already have spending by department in the data, though we aren’t showing that in the current prototype. Also agree that getting spending data from quangos is important and it already out there (at least partially). The general challenge with using such info is integrating it, in particular ensuring we aren’t double counting somewhere.
Re mysociety.org suggestion: we’re already in close contact with them (Tom Steinberg is on our Advisory Panel) and we’re looking to collaborate wherever we can!
[Reply]
The user should be able to manipulate the data themselves. It would make the tool incredibly useful as a resource for investigating the success and failures of spend as well as comparing data sets themselves. It’s great that you provide the source, but the public really needs this data as easy and flexible to access as the market research tools used by firms to analyse sales and growth.
Great job though guys. I’m a huge fan of this project! Good luck.
[Reply]
Rufus Pollock Reply:
December 29th, 2009 at 12:44 pm
El: like your suggestion of using market research tools to analyse this kind of data. Do you know of any opensource systems of this kind or are they all proprietary?
[Reply]
Andrew S Reply:
December 29th, 2009 at 1:49 pm
Perhaps a word with Cyberscience, Cognos, Microsoft or Oracle could produce a good result if “sold” to them about the benfits of publicity and social empowerment etc.
Cyberscience have a fantastic reporting and BI tool that presents into a webpage – sitting on most platforms and databases concurrently http://www.cyberscience.com
[Reply]
Rufus Pollock Reply:
January 19th, 2010 at 11:04 am
Andrew: Interesting idea.We do have a fairly heavy commitment to using “free/open source” software, especially in a situation like this where customization would likely be needed which could be difficult with a proprietary system. Is there any free/open source work out there or is it all proprietary?
This site is great, the gripe I have is it only shows spending.
You need to add national income, and its various sources. That way it would be easier for people to see real data and figures on the national deficit etc.
James
[Reply]
Rufus Pollock Reply:
December 29th, 2009 at 12:45 pm
James: you’re not alone in your suggestion to including income as well as expenditure (see the prototype feedback page). This is at the top of our list of things to do next.
[Reply]