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 »
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']
Use the sportdb command line tool to build your own worldcup.db copy
from the datasets in (structured) text in the Football.TXT format.
Use the quick starter datafile templates to start from scratch. Examples:
Build the database for all world cups:
$ sportdb new worldcup
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.dband - read in all datasets in plain text (
.txt)
That's it.
Yes, you can. More than welcome. See Help & Support »