Simon Willison’s Weblog

Dealing with election results data. Alf Eaton loaded the Guardian’s European election results spreadsheet in to Google’s new Fusion Tables tool.

# 12th June 2009, 6:06 pm / guardian, datablog, datastore, elections, alf-eaton, google, fusiontables

Exactly how well did the BNP do where you live? Guardian journalists spent a day and a half calling round different local authorities to get a proper breakdown of the European election results (which are only officially published in aggregate) and published the results as a spreadsheet on the Datablog.

# 11th June 2009, 11:37 am / datablog, guardian, elections, datastore, bnp

#DataJourn part 1: a new conversation. Journalism.co.uk report on the first instance of a Guardian story that was driven by an external developer’s work with data originally released on our Datablog.

# 9th April 2009, 10:57 am / openplatform, guardian, datablog, datastore, journalism

Automating PowerPoint with Python. Useful tutorial on using ActivePython’s win32com module to automate PowerPoint. The example code pulls in the top 50 banks by assets from the Guardian Data Store and generates a treemap using PowerPoint’s shape drawing primitives.

# 3rd April 2009, 3:13 pm / powerpoint, python, activepython, treemap, guardian, datastore, visualisation

UK Guardian Data + ManyEyes = ISAF Troops Contribution Story. Including a heat map showing countries that are contributing the most troops to Afghanistan.

# 3rd April 2009, 2:44 pm / afghanistan, military, guardian, datastore, heatmap, manyeyes, visualisation

Get our full university data. “The Guardian’s university rankings are the most visited part of Education Guardian”—and now they’re available as a spreadsheet.

# 11th March 2009, 1:52 pm / university, leaguetables, guardian, openplatform, datastore