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
- FIFA World Cup
- FIFA World Cup Qualifiers
- FIFA Confederations Cup
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¹ Copa América
¹ CONMEBOL = South America;
- CONCACAF¹ Copa Oro / Gold Cup
¹ CONCACAF = North America, Central America and the Caribbeans
Africa
- CAF Africa Cup of Nations
Europe
- UEFA Euro / European Football Championship
Football Clubs / Leagues and Tournaments
Intn’l Club Tournaments (Champions Leagues & Friends)
Amercia (South America; North America, Central America and the Caribbeans)
- CONMEBOL¹ Copa Libertadores
- CONMEBOL¹ Copa Sudamericana
¹ CONMEBOL = South America;
- CONCACAF¹ Champions League
¹ CONCACAF = North America, Central America and the Caribbeans
Europe
- UEFA Champions League
- UEFA Europa League
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
- Österreichische Bundesliga + ÖFB Cup
- English Premier League
- Deutsche Bundesliga
- Spanish La Liga
North America
- México Primera División Apertura + Clausura
South America
- Campeonato Brasileiro Série A
and more.
More
Talks - Slide Decks
- Using Open Football Data - Get Ready for the World Cup in Brazil 2014 w/ JavaScript (Vienna.js, 2014)
- Using Open Football Data - Get Ready for the World Cup in Brazil 2014 w/ Ruby (Vienna.rb, 2014)
football.db
- Using Open Football Data in JavaScript (Vienna.js, 2013)
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.
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.