Get The Data Challenge

Get the data to answer a specific question, finding, cleaning and presenting data along the way.

= Find, Clean and Present Data =

Focus on Find and Clean here rather than presentation (if you can do fancy viz, or build a nice JS app that's brilliant but not essential ...)

Key expected outcome: a clean dataset on http://DataHub.io that contains the data (and possibly more) relevant to answer the posed question.

Note: Credit is given for supplying enough data to answer more general versions of the questions but don't overdo it.

Extras:


 * If you write code then this can (and should) live in a code repository GitHub/Gitorious/... (and remember to link these from your DataHub dataset)
 * Raw data (if versioning is required) can live in GitHub/Gitorious/Google docs and then be pushed to DataHub DataStore (alternative is to just work locally with your favourite spreadsheet and then upload the result to the DataHub FileStore -- the DataHub will automagically import the data into the DataStore)

Using the DataHub: see http://handbook.schoolofdata.org/en/latest/datahub.html

= Possible Questions =

Feel free to pick your own!

Question list: https://docs.google.com/spreadsheet/ccc?key=0Aon3JiuouxLUdDZLNXE5MzdySF9BWTdNMVo4Z3p6VHc#gid=0

How many people are without clean drinking water in the world this year?
Good data in Excel and CSV formats, although only up to 2011, can be found from the WHO / UNICEF Joint Monitoring Programme (JMP) for Water Supply and Sanitation: http://www.wssinfo.org/data-estimates/table/

Uploaded country-by-country and global data from 1990-2011 to Datahub: http://datahub.io/dataset/global-and-country-by-country-access-to-improved-drinking-water-1990-2011

What are the busiest airports in the world
I'm working on a solution here: https://github.com/mihi-tr/Airport-Data. It's partly based on the already available openflight.org database. However passenger, freight and mail data seem to be only commercially available (collected) or dispersed. Will create a datahub.io submission when done (or partly done...) --Mihi 08:34, 18 July 2012 (UTC)

How many congressmen and congresswomen there are in each country of your continent?

 * Bonus: building a simple bar chart that shows the percentage of men and women in congress in different countries

How much money was spent in the last 5 editions of WorldCup and Olympic Games?

 * Bonus: building a timeline showing the evolution of the costs for big events
 * Nominal (local) In US$

Cost of living ...
Anna is going to employ Pedro. She has been planning to hire someone in London and pay them £28,000 but Pedro is going to live in Sao Paolo. How much is the equivalent income in Sao Paolo.


 * Bonus: build an app that lets me enter my salary and current location and then allows me to look at equivalent values in other locations on a map.

How Much Is It Today.
In 1926 Fred bought a house in Bloomsbury, London for £5,000. What would be the equivalent cost in real terms today. If this was an average house how much would this cost today and how much has it gone up in value in real terms?

Which are the 10 countries with the lowest water availability in the world.

 * Provide a simple bar chart showing per capita precipitation and water availability for countries around the world.

Why is Greece going bankrupt?
What is Greece's debt, how has it accumulated and what is a sustainable debt and deficit level


 * Deficit and debt for G-20 (and/or EU-27) countries over the last 10 years
 * Bond yields for 5, 10 and 30y bonds for G-20 and EU-27 countries

How much energy is lost in light pollution by your city each year? and how much does it cost?
Energy calculations and cost of that energy (depends on source). Consider energy usage from the private and public sector. Grey area between clear waste (e.g. street lights shining upwards) and questionable lighting (e.g. massive billboards lit up at 3am).

The more cities the better. Answers to these questions have a direct applicability in real life! See e.g. Earth Hour or Dark Skies Association, who could really use such answers to lobby for more efficient and cost effective use of energy.