OUseful.Info, the blog…

Trying to find useful things to do with emerging technologies in open education

And a Tweet Later – Querying Shadow Cabinet Expenses on Google Spreadsheets with the Google Query Language

6 minutes past 5 this evening:

(There was a problem with the publishing/privacy settings – maybe the tech team would like to post a comment saying what, exactly – that meant while the spreadsheet was viewable in preview form and as CSV, it was impossible to run Google visualisation API query language queries against it.)

Half an hour later:

And ten minutes after that:

So what? So this:

(That’s a test query using the Google visulisation API query language on the Shadow Cabinet expenses (via Google the Shadow Cabinet’s expenses).

And with a little tweaking, we can get a summary of the expenses by Shadow Cabinet member – run a select A,C,sum(E) group by A,C query on the spreadsheet:

(If you prefer to see the full total by member, use this query: select A,sum(E) group by A)

Now take the CSV output version of the query, pipe it into a Many Eyes Wikified dta page and plot it as an interactive tree map:

Or if you prefer a bubble chart?

Or maybe a matrix chart?

(I think that Many Eyes WIkified updates its data pages from live data feeds, so hopefully the linked to visualisation should remain pretty much up to date? [All the visulisations can be reached from this Many Eyes Wikified page.])

Isn’t this fun?:-) So why don’t you have a go?????

PS for a more comprehensive review of what’s possible with the query language, I’ve posted a wide selection of examples here: Using Google Spreadsheets as a Database with the Google Visualisation API Query Language.

Written by Tony Hirst

May 18, 2009 at 8:18 pm

Posted in Data, Tinkering, Visualisation

Tagged with

3 Responses

Subscribe to comments with RSS.

  1. […] Tony then takes the data and visualises it using Many Eyes Wikified. Very impressive and a site I hadn’t heard of or used before. Applying the same principles Tony has now applied visualisations to the Shadow Cabinet spreadsheet. […]

  2. […] there has been a wave of excellent mashups and analytic reports based on the data that has been released and […]

  3. […] there has been a wave of excellent mashups and analytic reports based on the data that has been released and […]

Comments are closed.


Get every new post delivered to your Inbox.

Join 1,355 other followers

%d bloggers like this: