[OpenSpending] Using SQL for Lightweight Data Analysis (of Spending)

Rufus Pollock rufus.pollock at okfn.org
Wed Mar 27 11:54:00 UTC 2013

Hi All,

I wanted to mention a new tutorial on the School of Data which drew
its inspiration from some OpenSpending efforts at a recent Open Data
Maker night:


This article introduces the use of SQL for lightweight data analysis
by walking through a small data investigation to answer the question:
who were the top recipients of Greater London Authority spending in
January 2013?

Along the way, it not only introduces SQL (and SQLite) but illustrates
various other skills such as locating and cleaning data and how to
load tabular data into a relational database.

As you see the motivating question was one an OpenSpending one and the
article does get some answers (it's a City legal firm ...)

I also note that there's a repo for my ongoing work on analyzing
preparing the GLA data for OpenSpending and collaborators would be
*very* welcome:

<https://github.com/rgrp/dataset-gla> - Plan

The associating (still empty but soon won't be) entry on OpenSpending:




More information about the openspending mailing list