-
Recent Posts
Recent Comments
Archives
Categories
Meta
Category Archives: Uncategorized
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