- 		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
							
		