VCS Open data
Please do not conclude anything at all about the voluntary sector from this data! It won’t tell you anything useful! Don’t be tempted… Right now it’s relying on data from 13 very different charities, which isn’t many. The point of this is to show how it’s fairly straightforward (2-3 hours work) to link up some simple data to other data-sets, and how, if you did have some more data, you could start to ask and answer interesting questions.
Beneficiaries by IMD quartile
Spend by IMD quartile
These pie charts look at Index of Multiple Deprivation (IMD) data and the numbers of beneficiaries
and the IMD rank of the LSOA of the postcode of the charity. IMD
rankings are grouped into quartiles.
So these charts show proportions of beneficiaries and spending
split by the level of deprivation of the office of each charity.
What’s happening here?
This is a live demo, mashing-up data from various sources as a demonstration of the sorts of things that can be done when data is available in machine-readable forms.
The starting point is a very simple survey, using Google docs, asking for a charity number and the number of people or organisations the charity worked with in 2011.
In this page, we load up that data, then use the charity number to get other information (spending, what they do, and address, though there’s lots more) from the Charity Commission (via opencharities.org).
Then from there we take the postcode and look up the Index of Multiple of Deprivation (IMD) rankings, and relate those rankings to the spending and beneficiary data we already have.
Sources and credits
This data has come from various places, with some helpers along the way…
- The charities themselves provided beneficiary data as part of the Open Data challenge at VCS Open – thanks to all that have taken the Open Data Challenge. The charities provided the registered charity number and number of beneficiaries. If you go and add your data now and come back here you’ll see your data included.
- Charity Commission data has been lovingly scraped by opencharities.org and provided with an API to get the financial and address data for each charity.
- Index of Multiple Deprivation (IMD) data is produced by the Department for Communities and Local Government. We’ve used the SPARQL endpoint at http://opendatacommunities.org/ to get the data in a useable form – try this link to see it in action
You are welcome to any of the code you find in this hack (view source!)