Author Archives: admin

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 →

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 →

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 →

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 →

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 →

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 →