We’re opening up our database of £4m of spending based on FOI request responses from 100 local councils and police authorities.
As we reported last week, the responses contain some interesting budget decisions – from a specific staff position in one authority lasting 18 months to the excessive cost of bunting. What can you find in the figures?
Here are just some more that we’ve found:
Data tucked away in the Ticketing Report by London 2012 confirms that the UK public’s ability to buy tickets for more popular events was significantly restricted.
The triathlon, track cycling, and ceremonies topped the table of events where low proportions of tickets sold to the public. Continue reading
In a third post publishing cleaned data from the Ticketing Report by London 2012 we’ve extracted Appendix III: £20 or less tickets available by sport. The data is in the table below, as well as a Google spreadsheet here. Continue reading
In our second post publishing cleaned data from the Ticketing Report by London 2012 we’ve extracted Appendix IV: PYA [Pay Your Age tickets] Allocation by Sport. The data is in the table below, as well as a Google spreadsheet here. Continue reading
Following the publication of the Ticketing Report by London 2012 this week (thanks Claire Miller for the tip), we’ve extracted some of the data buried within. First up is Appendix V from the report: Price category of sold tickets by Olympic sport. We’ve put this into a table below, but you can also copy the spreadsheet here (or view a webpage here).
Unfortunately, like a lot of data in this report, there is some vital context lacking – namely, how many tickets were available, as well as how many were bought. If you do anything with this please let us know so we can pass it on: Continue reading
The Spreadsheet Journalism blog has published a set of data on all Olympic athletes from London 2012, including medals won, age, height, weight, gender, DOB and birthplace.
Let us know if you do anything with it!
Thanks to Muckraker‘s Lyra McKee for pointing us to this.
It’s now two months since we first gathered data on Olympic torchbearers. In that time people have appeared on the list and then disappeared, appeared late, appeared without stories, or not appeared at all.
Here is the data gathered across those 8 weeks – 7,041 torchbearers in total. If you can do anything with it, let us know.
Infographic by @carolinebeavon
An allocation of how the 8,000 Olympic torchbearer places were allocated has found that just 71% were allocated through the four main public campaigns.
The figure – published in the ebook 8,000 Holes - casts doubt on the promise by organisers LOCOG that 90% of places would be made available to the general public. Continue reading
Olympic torch relay organisers are over 1,000 places short of meeting the promise that over half of Olympic torchbearers would be young people aged 12-24, according to an analysis of data in the official site.
Of just over 7,000 torchbearers published on the site by July 24, only 2,272 – 32% – are under 25. The proportion has remained consistent since details were first published in late May, but even if the other 1,000 torchbearers were under 25, the final proportion would be 40% – still well short of the target set at the relay’s launch.
UPDATE: Now over 60% complete.
The Guardian have published our list of the 500 torchbearers lacking a nomination story, with an appeal to users to help identify the 400 or so yet to be identified. Of the other hundred or so that we’ve already looked at, around a third share names with senior figures at sponsor organisations and commercial partners.
But we figured many eyes on the problem would help.
Among those already ticked off the list thanks to contributions via email and Twitter are Vegard Killingland (nominated through the Coca Cola campaign), David Heeley (a well known blind marathon runner whose nomination was originally turned down but later awarded following a public campaign), and fundraiser Derek Chisnall. There’s also a Mexican rock star – and more leads to company directors. UPDATE: One German daily newspaper used the list to find executives nominated by Samsung.
Many commenters on the article have pointed out the more obvious sportspeople and celebrities, such as Gordon Banks, Gethin Jones and Ruby Walsh. These were identified in the article itself or the linked HMI spreadsheet (not The Guardian’s), but it’s clear we should have been more explicit about the fact that those had already been identified, and that the focus was on the names that weren’t immediately recognisable.
You can access the full data here – post a comment, tweet @HMIolympics or email paul@helpmeinvestigate.com to add details.