Need help with world-cup?
Click the “chat” button below for chat support from the developer who created it, or find similar developers for support.

About the developer

openfootball
447 Stars 158 Forks Creative Commons Zero v1.0 Universal 365 Commits 1 Opened issues

Description

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

Services available

!
?

Need anything else?

Contributors list

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 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!

We use cookies. If you continue to browse the site, you agree to the use of cookies. For more information on our use of cookies please see our Privacy Policy.