The Guardian has been following this closely and, when the UK Treasury released “Coins“, its huge database of Government spending, the Guardian invited a small group of programmers and experts to work with them and help unravel the hidden stories buried beneath the data.
Expenditure per Government department
This interactive visualisation, which I created with Rufus Pollock, shows the relative amounts of spending, per Government department. You can left-click a department to see the distribution of spending per geographical region (and right-click to get back again).
It’s worth seeing this fullscreen, to catch the numerous small departments.
The Coins Explorer
I also produced an article for web developers, about getting more from the Coins Explorer. The Explorer lets you search for particular types of spending, and export subsets of the data to use elsewhere. It was pulled together by the Guardian’s razor-sharp team of developers in just a matter of hours.