Code Monkey home page Code Monkey logo

worldcup's Introduction

World Cup

What's football.db?

A free open public domain football database & schema for use in any (programming) language e.g. uses datasets in (structured) text in the football.txt format. More football.db Project Site »

Intro

Free open public domain football data for the World Cup (e.g. Qatar 2022, Russia 2018, Brazil 2014, etc.) and the World Cup Quali(fiers). Example:

= World Cup 2022

Group A  | Qatar      Ecuador        Senegal        Netherlands
Group B  | England    Iran           United States  Wales
Group C  | Argentina  Saudi Arabia   Mexico         Poland
Group D  | France     Australia      Denmark        Tunisia
Group E  | Spain     Costa Rica      Germany        Japan
Group F  | Belgium    Canada   Morocco    Croatia
Group G  | Brazil    Serbia  Switzerland   Cameroon
Group H  | Portugal   Ghana   Uruguay    South Korea


Matchday 1  |  Sun Nov/20
Matchday 2  |  Mon Nov/21
Matchday 3  |  Tue Nov/22

...

Group A:

(1) Sun Nov/20 19:00      Qatar  0-2 (0-2)  Ecuador    @ Al Bayt Stadium, Al Khor
                              [-; Enner Valencia 16' (pen.), 31']
(2) Mon Nov/21 19:00     Senegal  0-2 (0-0)  Netherlands  @ Al Thumama Stadium, Doha
                              [-; Cody Gakpo 84' Davy Klaassen 90+9']


...

or

= World Cup 2018

Group A  |  Russia       Saudi Arabia         Egypt          Uruguay
Group B  |  Portugal     Spain                Morocco        Iran
Group C  |  France       Australia            Peru           Denmark
Group D  |  Argentina    Iceland              Croatia        Nigeria
Group E  |  Brazil       Switzerland          Costa Rica     Serbia
Group F  |  Germany      Mexico               Sweden         South Korea
Group G  |  Belgium      Panama               Tunisia        England
Group H  |  Poland       Senegal              Colombia       Japan


Matchday 1  |  Thu Jun/14
Matchday 2  |  Fri Jun/15
Matchday 3  |  Sat Jun/16

...

Group A:

 (1) Thu Jun/14 18:00   Russia        5-0 (2-0)  Saudi Arabia     @ Luzhniki Stadium, Moscow (UTC+3)
                          [Gazinsky 12' Cheryshev 43', 90+1' Dzyuba 71' Golovin 90+4']
 (2) Fri Jun/15 17:00   Egypt         0-1 (0-0)  Uruguay          @ Ekaterinburg Arena, Ekaterinburg (UTC+5)
                          [Giménez 89']
...

Match for third place

(63) Sat Jul/14  17:00   Belgium    2-0 (1-0)  England      @ Saint Petersburg Stadium, St. Petersburg (UTC+3)
                           [Thomas Meunier 4' Eden Hazard 82']

Final

(64) Sun Jul/15  18:00   France     4-2 (2-1)   Croatia     @ Luzhniki Stadium, Moscow (UTC+3)
                   [Mandžukić 18' (o.g.) Griezmann 38' (pen.) Pogba 59' Mbappé 65'; Perišić 28' Mandžukić 69']

or

= World Cup 2014

Group A  |  Brazil       Croatia              Mexico         Cameroon
Group B  |  Spain        Netherlands          Chile          Australia
Group C  |  Colombia     Greece               Côte d'Ivoire  Japan
Group D  |  Uruguay      Costa Rica           England        Italy
Group E  |  Switzerland  Ecuador              France         Honduras
Group F  |  Argentina    Bosnia-Herzegovina   Iran           Nigeria
Group G  |  Germany      Portugal             Ghana          United States
Group H  |  Belgium      Algeria              Russia         South Korea


Matchday 1  |  Thu Jun/12
Matchday 2  |  Fri Jun/13
Matchday 3  |  Sat Jun/14

...

Group A:

(1) Thu Jun/12 17:00   Brazil   3-1 (1-1)  Croatia       @ Arena de São Paulo, São Paulo (UTC-3)
                         [Neymar 29', 71' (pen.) Oscar 90+1';  Marcelo 11' (o.g.)]
(2) Fri Jun/13 13:00   Mexico   1-0 (0-0)  Cameroon      @ Estádio das Dunas, Natal (UTC-3)
                         [Peralta 61']

...

Match for third place

(63) Sat Jul/12 17:00   Brazil  0-3 (0-2)  Netherlands   @ Estádio Nacional Mané Garrincha, Brasília (UTC-3)
                         [Robin Van Persie 3' (pen.) Daley Blind 17' Georginio Wijnaldum 90+1']

Final

(64) Sun Jul/13 16:00   Germany  1-0 a.e.t. (0-0, 0-0)  Argentina   @ Estádio do Maracanã, Rio de Janeiro (UTC-3)
                          [Mario Götze 113']

Build Your Own worldcup.db Copy

Use the sportdb command line tool to build your own worldcup.db copy from the datasets in (structured) text in the Football.TXT format.

Alternative I - Use the Quick Starter Templates

Use the quick starter datafile templates to start from scratch. Examples:

Build the database for all world cups:

$ sportdb new worldcup

More »

Alternative II - Do-It-Yourself (DIY) - Downlad and Unpack Zip Archive or Git Clone

Download and unpack the zip archive with the datasets or if you have git installed use the git clone command to get a local copy.

Try in your working folder (that is, /world-cup):

$ sportdb build
$ sportdb --verbose build     # or for more (verbose) details incl. debug info

This will

  • setup a new single-file SQLite database e.g. ./sport.db and
  • read in all datasets in plain text (.txt)

That's it.

Questions? Comments?

Send them along to the Open Sports & Friends Forum/Mailing List. Thanks!

worldcup's People

Contributors

anhornsby avatar basmoura avatar chakaitos avatar dirkgomez avatar geraldb avatar gr33ndata avatar hidenobunagai avatar jokecamp avatar larkov avatar lokomass avatar mahdi avatar mmahrous avatar mozyok avatar mpodell avatar pmartelletti avatar pratul-nayak avatar rauberdaniel avatar sturdy-robot avatar techex777 avatar tiagomennaold avatar yltlatl avatar yorobot avatar zikofv avatar

Stargazers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

Watchers

 avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar  avatar

worldcup's Issues

Error building db

I tried to build using sportdb with

sportdb setup --include ./world-cup --worldinclude ./world.db

But when it runs to the brazil-2014 it yields the following error:

[info] parsing data 'world-cup!/2014--brazil/quali/africa' (./world-cup/2014--brazil/quali/africa.yml)...
[error] league with key >>world.quali.africa<< missing

It does not include 1924 and 1928

If starts in 1930, then its missing something important .. The Uruguayan jersey has 4 stars [1] Two of them representing gold medals received at the 1924 and 1928 Summer Olympics [2], recognised by FIFA as World Championships. [3]

[1] http://en.wikipedia.org/wiki/File:Uruguay_football_association.svg
[2] http://en.wikipedia.org/wiki/Uruguay_national_football_team#Kit_evolution
[3] http://es.fifa.com/mm/document/fifafacts/mcwc/ip-201_02s_fwc-origin_8819.pdf

The later document, translated somewhat like:

The FIFA Congress agreed in 1924 to take responsibility for the organization of the Olympic Football Tournaments after ratifying the proposal that "provided that the Olympic Football Tournaments are held according to FIFA regulations , the latter shall recognize this tournament as a World Soccer Championship."

The 1924 tournament was a huge success and was attended by over 60,000 spectators at the final between Uruguay and Switzerland. The South Americans won by 3-0 and were received as World Champions in Montevideo.

The South American superiority became apparent again in the Olympic Football Tournament in 1928 in Amsterdam. The Uruguayans did not give up another win against their Argentine neighbours.

The success of the Olympic Games increased desire FIFA have their own World Championship. The FIFA President Jules Rimet led the struggle for the means to achieve this dream . Following a proposal of the Executive Committee, the FIFA Congress of May 26, 1928 held in Amsterdam decided to organize an official FIFA World Cup :World Cup was born !

A year later , Uruguay , Olympic champion in 1930 he planned to celebrate the centenary of its independence, was commissioned to organize the first World Cup .

:-)

Building the worldcup database fails with country not found

Here's what I did, I created this Datafile:

####################################
# Datafile for World Cups
#
#  use
#    $ sportdb new worldcup


football 'world-cup'

Ran

sportdb new worldcup

which results in this:

(auto config) try matching teams:
["Uruguay", "Austria"]
[debug]    [parse_matchdata] hash: >{:day=>"4", :month_name=>"July"}<
[debug]    [calc_year] ????-7-4 -- start: 1954-01-01
[debug]    date: >1954-07-04<
(auto config) try matching teams:
["Hungary", "West Germany"]
** !!! ERROR - no match for national team >1-1  Yugoslavia< found

*** error: exit

I think this line cannot be parsed: https://github.com/openfootball/world-cup/blob/master/1954--switzerland/cup.txt#L21

Bug in worldcup.db built on 2018.06.22

Hi,
Fantastic work. I just came across some wrong result entries. I had a look at the world cup from 1954 using the worldcup.db built on 2018.06.22. It appears that the result at half time made it into the database, rather than the final result. Compare e.g. game 21 GER-BEL (database: 1:2, wiki: 5:2), Game 22 ESP-BRA (database: 3:0, wiki: 3:1) and the following games... I didn't test any further. Would be great if this was taken care of.
Cheers

2010 Game POS Ordering

I'm trying to make a visualization that is dependent on knowing the order the games were played in and I'm just wondering where the POS data came from? As far as I can tell, the 3rd and 4th games are out of order unless I'm misunderstanding how it works. I tried to order the games by play_at date using the query "Event.last.games.order('play_at')", but my query contains "ORDER BY pos, play_at". Any ideas on whether the data is wrong or why the 'sportdb/console' automatically orders by 'pos'?

Connect to Wikidata?

Hello! Congrats on the amazing dataset.

I am studying ways of parsing it and adding the information to Wikidata, that is also CC0 and people can query using the SPARQL query language.

Just thought to let you know.

I'm still thinking about ways to model the data there; it is amazing to have a CC0 resource like yours, kudos!

Here is an example entry: https://www.wikidata.org/wiki/Q115329387

Cheers!

Adding squad members

Do you need any help with adding the members for each squad?
I offer it, if u are interested!

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.