Welcome

Contents:

What’s football.db?

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

### Teams

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

2013-03-12 20:45  Schalke 04      2-3  Galatasaray
2013-03-12 20:45  Barcelona       4-0  Milan

2013-03-13 20:45  Málaga          2-0  Porto
2013-03-13 20:45  Bayern München  0-2  Arsenal
...

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 2010:

###########
# Groups

Group A  |  South Africa    Mexico              Uruguay          France
Group B  |  Argentina       Nigeria             South Korea      Greece
Group C  |  England         United States       Algeria          Slovenia
Group D  |  Germany         Australia           Serbia           Ghana
Group E  |  Netherlands     Denmark             Japan            Cameroon
Group F  |  Italy           Paraguay            New Zealand      Slovakia
Group G  |  Brazil          North Korea         Côte d'Ivoire    Portugal
Group H  |  Spain           Switzerland         Honduras         Chile


################
# Group A

Matchday 1 / Group A

(1) Fr  2010-06-11 16:00    South Africa  1-1  Mexico
(2) Fr  2010-06-11 20:30    Uruguay       0-0  France
...

Source: world-cup/2010/cup.txt

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

¹ CONMEBOL = South America; ² 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; ² CONCACAF = North America, Central America and the Caribbeans

More »

Europe

More »

Example - Champions League 2012/13:

####################################
# Champions League 2012/13 - Finalrunden

(8)  Achtelfinale Rückspiele  // Di./Mi., 5.+6./12.+13. Mär 2013

2013-03-05 20:45  Manchester United    1-2  Real Madrid
2013-03-05 20:45  Borussia Dortmund    3-0  Schachtar Donezk

2013-03-06 20:45  Paris Saint-Germain  1-1  Valencia
2013-03-06 20:45  Juventus             2-0  Celtic Glasgow

2013-03-12 20:45  Schalke 04           2-3  Galatasaray
2013-03-12 20:45  Barcelona            4-0  Milan

2013-03-13 20:45  Málaga               2-0  Porto
2013-03-13 20:45  Bayern München       0-2  Arsenal
...

Source: europe/2012_13/cl_finals.txt

National Leagues & Cups

Europe

North America

South America

and more.

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.