The latest list of organisations that are receiving money from the Cabinet Office’s Transition Fund was released on Tuesday.
Despite my call for better data when the first list was released, this second list was still not helpful for anyone wanting to analyse where the money had gone. In fact that it was presented in PDF meant that it was even more difficult to get at.
Anyway, I have managed to extract the list of organisations, and convert to a useful format. I’ve used Google Fusion Tables to display the data, and have attached some extra info about each charity – such as which region they are in, and what subsector they work in.
Transition Fund Recipients on Google Fusion Tables
More importantly, I’ve also matched the charities to the register of charities, and come up with a charity number for each one. This means that we can merge this data with other data held about them on the Charity Commission register.
I’ve heard it said that the “Hello World” of data is a map – so here’s a map of all the recipients of transition funds so far.
You can also view the data by subsector, using the classification exercise that we’ve previously released as open data. This shows that the results so far reflect the funding criteria set out when the Fund was launched – a particular focus on organisations working in social care. (The graph shows the amount in £ given to charities in each classification).
One further view shows the amounts awarded by region (although some organisations may work across more than one region). As the Cabinet Office continue to make public the next rounds of funded organisations, I’ll carry on adding them to this list.
David Kane was formerly NCVO’s Senior Research Officer. He discusses open data and emerging trends in the voluntary and community sector and wider civil society. 
