Update: New Season Match Schedules - English Premier League 2014/15, Deutsche Bundesliga 2014/15, Champions League 2014/15 and More

Welcome

Contents:

What’s football.db?

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

### 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.)]

...

Web Admin Site

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.

Articles

Talks - Slide Decks

Tables, Schema

The football.db includes the following tables:

(add schema pic here)

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

openLigaDB - free community-contributed sport results available via XML/SOAP HTTP web service; database not available for download

SportsDB - archive (no more activity); open database schema for sports data (formerly known as XTOSS: The XML Team Open Sports Schema.)

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

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 mailinglist/forum. Thanks!

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