England (and Wales) - English Premier League

What's football.db?

A free open public domain football database & schema for use in any (programming) language (e.g. uses datasets in plain text). More football.db Project Site »

Intro

Free open public domain football data for England (and Wales). National football club leagues include:

Level
I	English Premier League	20 Clubs
II	English Championship	24 Clubs
III	English League One	24 Clubs
IV	English League Two	24 Clubs

Example:

= English Premier League

Matchday 1

[Sat Aug/16]
  Manchester United    1-2  Swansea City
  Leicester City       2-2  Everton FC
  Queens Park Rangers  0-1  Hull City
  Stoke City           0-1  Aston Villa
  West Bromwich Albion 2-2  Sunderland AFC
  West Ham United      0-1  Tottenham Hotspur
  Arsenal FC           2-1  Crystal Palace
[Sun Aug/17]
  Liverpool FC         2-1  Southampton FC
  Newcastle United     0-2  Manchester City
[Mon Aug/18]
  Burnley FC           1-3  Chelsea FC

...

= Arsenal

 1  Wojciech Szczęsny (POL)      GK  2007-
13  David Ospina (COL)           GK  2014-
26  Damián Martinez (ARG)        GK  2010-

 2  Mathieu Debuchy (FRA)        DF  2014-
 3  Kieran Gibbs                 DF  2007-
 4 (vc) Per Mertesacker (GER)    DF  2011-
 6  Laurent Koscielny (FRA)      DF  2010-
18  Nacho Monreal (ESP)          DF  2013-
21  Calum Chambers               DF  2014-

 7  Tomáš Rosický (CZE)          MF  2006-
 8 (c) Mikel Arteta (ESP)        MF  2011-
10  Jack Wilshere                MF  2008-
11  Mesut Özil (GER)             MF  2013-
15  Alex Oxlade-Chamberlain      MF  2011-
16  Aaron Ramsey (WAL)           MF  2008-
19  Santi Cazorla (ESP)          MF  2012-
20  Mathieu Flamini (FRA)        MF  2013-
24  Abou Diaby (FRA)             MF  2006-
34  Francis Coquelin (FRA)       MF  2008-
35  Gedion Zelalem (GER)         MF  2013-

 9  Lukas Podolski (GER)         FW   2012-
12  Olivier Giroud (FRA)         FW   2012-
14  Theo Walcott                 FW   2006-
17  Alexis Sánchez (CHI)         FW   2014-
22  Yaya Sanogo (FRA)            FW   2013-
23  Danny Welbeck                FW   2014-
27  Serge Gnabry (GER)           FW   2012-
28  Joel Campbell (CRC)          FW   2011-

Build Your Own england.db Copy

Use the sportdb command line tool to build your own england.db copy from the datasets in plain text.

Note: The English Premier League includes teams from Wales (e.g. Swansea City or Cardiff City).

Alternative I - Use the Quick Starter Templates

Use the quick starter datafile templates to start from scratch. Examples:

Build the database for all English (incl. Welsh) clubs, leagues and seasons:

$ sportdb new eng

Build the database for the 2019/20 season:

$ sportdb new eng2019-20

More »

Alternative II - Do-It-Yourself (DIY) - Downlad and Unpack Zip Archive or Git Clone

Download and unpack the zip archive with the datasets or if you have git installed use the git clone command to get a local copy.

Try in your working folder (that is, /england):

$ sportdb build
$ sportdb --verbose build     # or for more (verbose) details incl. debug info

This will

• setup a new single-file SQLite database e.g. ./sport.db and
• read in all datasets in plain text (.txt)

That's it.

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 Open Sports & Friends Forum/Mailing List. Thanks!