19

Are there any public data sets for the World Cup in Brazil 2014?

Didn't find anything for download on the official FIFA site (besides a single-page PDF booklet for the match schedule).

Ideally the data set includes groups, teams, players, squads, matches, stadiums and so on and is in an open plain text format such as CSV (comma-separated values), JSON (javascript objects), SQL (structured query language), etc.

Any insight appreciated.

Disclosure: I'm the project lead of the football.db project collecting open public domain football data e.g.

|improve this question
  • How does the FIFA license results, schedule etc? – Ulrich Apr 4 '14 at 10:04
  • Good question. Best to ask FIFA. I do not know. Note that team names, cities names, player names, matche results etc. are facts (no copyright, no license needed). Cheers. – Gerald Bauer Apr 4 '14 at 18:16
11

Edit: A new initiative on the web open_data_world_cup

Edit 2: Gerald also started collecting a list of other football projects on GitHub.

Edit 3: Here is a list of the football players ages in a spreadsheet format.

You can create data by putting the information from the wikipedia page into a more structured format.

There are plenty of tools available that make scraping easier. A starting point might be ScraperWiki, but it depends a bit on your interest and skills.

Here's a quick proof-of-concept with GoogleDocs' ImportHTML function.

enter image description here

|improve this answer
  • Thanks. Great. How would you import match data (if not in a table or list), for example? – Gerald Bauer Mar 21 '14 at 12:22
  • @GeraldBauer see the new link. – Ulrich Mar 25 '14 at 10:27
  • Great. Thanks. Fantastic project ;-) || Disclosure: I'm the project lead of the open football project. || Just wondering if there's anything else out there (for the world's biggest sport event). – Gerald Bauer Mar 25 '14 at 12:28
  • haha, ok the circle is closed. – Ulrich Mar 25 '14 at 15:27
8

I found one more free, open database you can use. http://openfootball.github.io/

What’s football.db?

A free open public domain football (soccer) database & schema for use in any (programming) language (e.g. uses plain text fixtures/data sets). Example:

### Teams

barcelona, Barcelona|FC Barcelona|Fútbol Club Barcelona, BAR, city:barcelona
madrid,    Real Madrid|Real Madrid CF,                   RMD, city:madrid
malaga,    Málaga|FC Málaga|Málaga CF|CF Málaga,         MAG, city:malaga
...
### Matches

2013-03-12 20:45  Schalke 04      2-3  Galatasaray
2013-03-12 20:45  Barcelona       4-0  Milan

2013-03-13 20:45  Málaga          2-0  Porto
2013-03-13 20:45  Bayern München  0-2  Arsenal

License

The football.db schema, data and scripts are dedicated to the public domain. Use it as you please with no restrictions whatsoever.

Try the football.db web admin app running on Heroku footballdb.herokuapp.com.

|improve this answer
5

You can find here an excel file with the schedule of the tournament and the groups. Inside the folder, you will find a license txt file containing the following:

LICENSE. The Software may be freely distributed.

The Software is licensed to you. So, you may not:

  • rent, lease, grant a security interest in, or otherwise transfer rights to the Software;

  • modify or remove any proprietary notices or labels on the Software;

  • disassemble the Software;

  • change the executable code of the Software;

  • sell this Software both standalone and part of a purchasable collection of software without author's explicit permission.

|improve this answer
  • Thanks. Any open plain text formats available for the world's biggest (sport) event? Anything without license e.g. public domain data? Any structured data (e.g. via Wikidata? Dbpedia? Freebase?) – Gerald Bauer Mar 17 '14 at 7:51
  • @GeraldBauer See an update to my question! – Tasos May 23 '14 at 8:30
  • Thanks. Fantastic project ;-) I started the football.db project. Cheers. – Gerald Bauer May 23 '14 at 18:10
  • I might make sense to split the 2 answers... I would like to upvote openfootball but I don't want to upvote excely because it is not open. Thanks! – Nicolas Raoul May 26 '14 at 4:20
  • @NicolasRaoul Done – Tasos May 26 '14 at 8:39
5

Mashape has an API listed for the World Cup 2014 which would return in Json some of the info you're looking for - https://www.mashape.com/leolima77/copa-do-mundo-2014-world-cup-brazil#!documentation

It is listed in Portugese so you might need to translate it to English.

|improve this answer
5

I've made a database of 736 players by scraping and refining.
The database (in French) is available here:
http://mondial-de-football.com/WorldCupData

It contains many data fields: age, number of selections, clubs, championship, etc.

|improve this answer
3

I just added this API to mashape, it's not realtime and the scores will take awhile to be updated but it gives you all the teams and matchups.

https://www.mashape.com/montanaflynn/fifa-world-cup/

|improve this answer
  • Is it fully updated now? – Nicolas Raoul Sep 12 '14 at 10:02

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.