Update: New Season Match Schedules - English Premier League 2020/21, Deutsche Bundesliga 2020/21, Italian Serie A 2020/21, Spanish Primera División 2020/21, French Ligue 2020/21, and Many More

Welcome

Contents:

What’s football.db?

A free and open public domain football database & schema for use in any (programming) language (e.g. uses plain datasets).

Dataset Examples

### Teams

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

Quarter-finals - 1st Leg

[Tue Apr/1]
  20.45   FC Barcelona        1-1  Atlético Madrid     @ Camp Nou, Barcelona
            [Neymar 71'; Diego 56']
  20.45   Manchester United   1-1  Bayern München      @ Old Trafford, Manchester
            [Vidić 58'; Schweinsteiger 67']
[Wed Apr/2]
  20.45   Real Madrid         3-0  Borussia Dortmund   @ Santiago Bernabéu, Madrid
            [Bale 3' Isco 27' Ronaldo 57']
  20.45   Paris Saint-Germain 3-1  Chelsea FC          @ Parc des Princes, Paris
            [Lavezzi 4' Luiz 61' (o.g.) Pastore 90+3'; Hazard 27' (pen.)]

...

Schema Diagram

Web Admin Site Example

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

National Teams / Leagues and Tournaments

World

More »

Example - FIFA 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
...


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)
                      [Oribe 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']

Source: world-cup/2014/cup.txt

America (South America; North America, Central America and the Caribbeans)

¹ CONMEBOL = South America;

More »

¹ CONCACAF = North America, Central America and the Caribbeans

More »

Africa

More »

Europe

More »

Football Clubs / Leagues and Tournaments

Intn’l Club Tournaments (Champions Leagues & Friends)

Amercia (South America; North America, Central America and the Caribbeans)

¹ CONMEBOL = South America;

More » | More »

¹ CONCACAF = North America, Central America and the Caribbeans

More »

Europe

More »

Example - Champions League 2012/13:

##############################
# Champions League 2012/13

Round of 16 - 2nd Leg // Tu+We, 5.+6./12.+13. Mar 2013

[Tue Mar/5]
  20.45 Manchester United  1-2  Real Madrid        @ Old Trafford, Manchester
          [S. Ramos 48' (o.g.); L. Modric 66' C. Ronaldo 69']
  20.45 Borussia Dortmund  3-0  Schachtar Donezk   @ Signal Iduna Park, Dortmund
          [F. Santana 31' M. Götze 37' J. Blaszczykowski 59']
[Wed Mar/6]
  20.45 Paris Saint-Germain  1-1  Valencia         @ Parc des Princes, Paris
           [E. Lavezzi 66'; Jonas 55']
  20.45 Juventus             2-0  Celtic Glasgow   @ Juventus Stadium, Turin
           [A. Matri 24' F. Quagliarella 65']

[Tue Mar/12]
  20.45 Schalke 04        2-3  Galatasaray      @ Veltins-Arena, Gelsenkirchen
           [R. Neustädter 17' M. Bastos 63'; Hamit Altintop 37' Burak Yilmaz 42' U. Bulut 95']
  20.45 Barcelona         4-0  Milan            @ Camp Nou, Barcelona
           [L. Messi 5', 40' D. Villa 55' Jordi Alba 92']
[Wed Mar/13]
  20.45 Málaga            2-0  Porto            @ La Rosaleda, Málaga
           [Isco 43' R. Santa Cruz 77']
  20.45 Bayern München    0-2  Arsenal          @ Allianz Arena, München
           [-; Giroud 3' L. Koscielny 86']
...

Source: europe-champions-league/2012-13/cl_finals.txt

National Leagues & Cups

Europe

North America

South America

and more.

More

Talks - Slide Decks

Real World Usage

sport.db Web Admin - sport.db Web Admin Tool in Ruby on Rails (version 3.2 and up).

Sportbook - Free, open source sports betting pool in Ruby on Rails (version 3.2 and up).

football.js - Free, open source football widgets - matchday, today’s rounds, team of the day, etc.

Any others? Let us know on the mailing list/forum. Thanks!

Alternatives

See the awesome-football page at the Planet Open Data.

Alumnis - Thank You!

Thanks for helping with match updates! Come back soon.

4lp bjoern3 cecomp64 Chakaitos davidavz dirkgomez enadol fchristysen gr33ndata hidenobunagai jokecamp Kaspi kivanccakmak larkov lokomass mahdi marfire mgidon mpodell noso2k1 pratul-nayak rlpereira SDoehren stvhwrd

License

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

Questions? Comments?

Send them along to the forum. Thanks!

Edit Me! This website is a public GitHub repo. Please help by forking the project and adding to it.