Monthly Archives: October 2010

Step 1: Getting the list of Esme Fairbairn Grants

At the moment it does not appear that the foundation publish details of grants in an open machine-readable format, but a short description of each grant is provided on the website. Using ScraperWiki and a little programming know-how we can … Continue reading

Posted in Uncategorized | Leave a comment

Step 2: Exploring the data in Google Spreadsheets

Scraper Wiki gives us the option to download our dataset, or explore it as an online Google Spreadsheet. By opening up the document as a Google Spreadsheet we can: Sort and filter the data; Clean up any rows which contain … Continue reading

Posted in Uncategorized | Leave a comment

Step 3: Exploring the data in Datapress

Data press is a WordPress plugin for exploring data. It allows ‘faceted browsing’ of a dataset. It can read data from specially formatted Google Spreadsheets. We changed in the headings in the Google Spreadsheet generated by Scraper Wiki to datapress … Continue reading

Posted in Uncategorized | Leave a comment

Step 4: Fusion Tables – combining our data

The Open Charities project have created a dataset of all UK Charities including, where available, details of their income and expenditure, taking the data from the Charity Commission website. Using Google Fusion Tables we can combine data on Esme Fairbairn … Continue reading

Posted in Uncategorized | Leave a comment

Step 5: Geocode and visualise the data

Geocoding converts an organisation name or address to a geographic location that can be plotted on a map. Fusion Tables has a geocoder built in. Initially we tried asking Fusion Tables to ‘geocode’ based on the names or organisations (it … Continue reading

Posted in Uncategorized | Leave a comment

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 … Continue reading

Posted in Uncategorized | Leave a comment