Guardian Datastore Explorer - UK Gov Spending Data, Released November 2010

Explore the details of the UK Government Spending Data by using the departmental spreadsheets as individual databases (Guardian Data Blog: data details). For information about the query syntax, see Google Chart Tools: Query Language Reference (Version 0.7). For more details about this application, see OUseful.info. Tony Hirst, Dept of Communication and Systems, The Open University


Grab a sheet from the Guardian Data store:

If you are prompted to sign in, wait a few seconds and then try again.




Using data from spreadsheet:

Education (DFE)





Try out some visualisation queries here...


Select the columns from the list box (ctrl+click for multiple selections in IE, command+click on a Mac) or type the elements directly into the appropriate text box.


select

where group by

order by limit
Display as: | Table | Scatter chart | Line chart | Pie chart | Bar chart | Column chart |
So you are asking:
Here is the URL for that query: ,
here is a link to this page:

Go fish...

Now it's time to write your own query in two parts - the columns you want to select, and the conditions you want each returned result to satisfy. ***FOLLOWING EXAMPLES NEED TWEAKING FOR CURRENT CONTEXT
Departmentselect inputwhere inputgroup by inputorder by inputlimit inputComments
All*   20Display everything (dangerous! May take some time and/or kill your browser! Hence the limit term...) [try it]
TreasuryF,G,H Display columns F,G, H (Expense Type, Expense area and supplier) 20Use this approach to get a feel for what a column contains [try it]
Home OfficeE,I,KK > 20000000   Display columns E, I and K (Entity, Supplier, Amount) sums over 20 million [try it]
DFIDH,I,KH contains 'Africa' and K > 10000000   View suppliers and amounts over a million for expense areas containing 'Africa'; (as well as the free text search 'contains', 'matches' must match exactly) [try it]
Government Equalities OfficeF,G,H,JJ > 100000 J desc View suppliers and amounts over a hundred thousand, sorted by amount (note that if you click on column headings in the table, you can sort the table by that column) [try it]
HealthH,JJ < 0 J asc View suppliers and amounts where the amount is negative... [try it]
DCMSG,H,I,sum(K),count(K)K >0 and H contains 'Museums'G,H,I  Look at expense type, area and supplier where area contains 'Museums', then group by expense type, area and supplier, reporting total amount awarded to each supplier correspondingly, along with a count of how many payments were made[try it]