Skip to content

Latest commit

 

History

History
300 lines (182 loc) · 8.39 KB

index.md

File metadata and controls

300 lines (182 loc) · 8.39 KB
layout title
default
Welcome

{{ page.title }}

What's football.db? {#whatis}

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 {#webadmin}

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

National Teams / Leagues and Tournaments {#national-teams}

World

  • FIFA World Cup
  • FIFA World Cup Qualifiers
  • FIFA Confederations Cup

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¹ Copa América

¹ CONMEBOL = South America;

More »

  • CONCACAF¹ Copa Oro / Gold Cup

¹ CONCACAF = North America, Central America and the Caribbeans

More »

Africa

  • CAF Africa Cup of Nations

More »

Europe

  • UEFA Euro / European Football Championship

More »

Football Clubs / Leagues and Tournaments {#clubs}

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;

More » | More »

  • CONCACAF¹ Champions League

¹ CONCACAF = North America, Central America and the Caribbeans

More »

Europe

  • UEFA Champions League
  • UEFA Europa League

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

  • Ö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 {#more}

Talks - Slide Decks {#talks}

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.

{% include thanks.html %}

License {#license}

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

{% include questions.md %}