Step 6: Other uses for the data

There are many more possibilities for the data we’ve been exploring.

For example, loaded into statistical software (and cleaned up more) it could be used to explore how much of a charities income grants from the Foundation made up in a given year. Or, if we could merge non-charity grants with details of those organisations, it could be used to explore the difference between grants to charities and other organisations.

We could explore how photos, media and reports from Flickr and other websites could be attached to unique grant identifiers and displayed on the Foundation’s website to give a visual impression of the impact of the grantmaking.

One way to explore the impact of grantmaking is to see what grant recipients are saying about the Foundation on their websites. Because Open Charities provides websites URLs for many charities, we can take the list of website addresses from our merged Fusion Table and use this to create a Google Custom Search Engine (CSE) that searches just the websites of grant recipients.

Try searching for ‘Esme Fairbairn’ in the search engine below. Or perhaps if your interest has been piqued by something you saw in the other visualisations, search for a particular topic.


What else would you like to do with the data?

This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Your email address will not be published. Required fields are marked *


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>