2014 World Cup Matches And Results

The world cup is the biggest sporting event on the planet. During the last world cup in 2010, 3.2 billion people watched at least one of the games. As I know, many groups are going to ‘make it interesting’ by placing bets on the results, I thought it would be good to have all the data on a spreadsheet. Google sheets are ideal for that as they offer a great ability to share, comment and ‘play’ with the data. You can see the demo spreadsheet: http://goo.gl/ZjdfqE and fork the code from: https://github.com/greenido/WorldCup

For now, we are fetching the info from these end points:

• http://worldcup.sfg.io/matches
• http://worldcup.sfg.io/today

and they are updated every minute.

Code

[gist https://gist.github.com/greenido/03714faa3b813828e501]

Improvements ideas

1. Integration with BigQuery to give more stats on each match vs historic worlds cap.
2. Fetch more data (e.g. bets, weather conditions to help find formula(s) to make prediction.
3. Create a UI that will merge: http://fivethirtyeight.com/interactives/world-cup/ and #1 outputs.

Special thanks to the good people of softwareforgood.com who created the API. Btw, if you have a cool idea for projects that will be based on this spreadsheet… Please share.

Advertisement