openfootball / england

Free open public domain football data for England (and Wales) incl. English Premier League (EPL) etc.

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

Notes:

• Starting with the 2004/05 season the Football League's Division 1, Division 2 and Division 3 changed to Championship, League One and League Two.

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 2020/21 season:

$ sportdb new eng2020-21

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.

Alternative III - Read / Load Match files with football-to-sqlite / football-to-psql

Run the football-to-sqlite tool against match files in the Football.TXT format like so:

$ football-to-sqlite england.db 2020-21/1-premierleague.txt

or pass in more than one match file (e.g. different leagues or more seasons):

$ football-to-sqlite england.db 2020-21/1-premierleague.txt \
                                2020-21/2-championship.txt  \
                                2020-21/3-league1.txt       \
                                2020-21/4-league2.txt       \
                                2020-21/5-nationalleague.txt

# -or-

$ football-to-sqlite premier.db 2020-21/1-premierleague.txt  \
                                2019-20/1-premierleague.txt  \
                                2018-19/1-premierleague.txt  \
                                2017-18/1-premierleague.txt  \
                                2016-17/1-premierleague.txt

Note: If the single-file SQLite database (and its tables, views & indices) do not (yet) exist, they get auto-created on the first run.

More »

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!

england's Issues

Matches after July don't appear on sport.db

After "sportdb build", when I open the "sport.db" file, it only contains matches up until 30th June.
Matches after 1st July were not there.
No match after July appeared on sport.db.

My guess is, a kind of "lock" is present somewhere (sportdb itself or some config file) that it recognizes matches only up until June, because June is normally assumed as after the end of a season. (But current Corona situation is abnormal)

Could you test this and comment that this bug happens only to me or to everyone?

how do I get the 2018-19 results

When I clone the repo and run

sportdb new en

It does not add the 2018-19 results or anything past 2010.

Is it possible to get these results?

I have tried changing ./setups/all.txt to:

##################
# All Fixtures

# - Leagues
eng-england!/leagues

# - Clubs
eng-england!/clubs/1-premierleague
eng-england!/clubs/2-championship
eng-england!/clubs/wales
eng-england!/clubs/more

# - Fixtures
eng-england!/2018-19/1-premierleague.conf
eng-england!/2018-19/1-premierleague

eng-england!/2017-18/1-premierleague.conf
eng-england!/2017-18/1-premierleague

eng-england!/2016-17/1-premierleague.conf
eng-england!/2016-17/1-premierleague

eng-england!/2015-16/1-premierleague.conf
eng-england!/2015-16/1-premierleague

eng-england!/2014-15/1-premierleague.conf
eng-england!/2014-15/1-premierleague

eng-england!/2013-14/1-premierleague.conf
eng-england!/2013-14/1-premierleague

eng-england!/2012-13/1-premierleague.conf
eng-england!/2012-13/1-premierleague

eng-england!/2011-12/1-premierleague.conf
eng-england!/2011-12/1-premierleague

eng-england!/2010-11/1-premierleague.conf
eng-england!/2010-11/1-premierleague

eng-england!/2009-10/1-premierleague.conf
eng-england!/2009-10/1-premierleague

eng-england!/2008-09/1-premierleague.conf
eng-england!/2008-09/1-premierleague

eng-england!/2007-08/1-premierleague.conf
eng-england!/2007-08/1-premierleague

eng-england!/2006-07/1-premierleague.conf
eng-england!/2006-07/1-premierleague

eng-england!/2005-06/1-premierleague.conf
eng-england!/2005-06/1-premierleague

eng-england!/2004-05/1-premierleague.conf
eng-england!/2004-05/1-premierleague

eng-england!/2003-04/1-premierleague.conf
eng-england!/2003-04/1-premierleague

eng-england!/2002-03/1-premierleague.conf
eng-england!/2002-03/1-premierleague

eng-england!/2001-02/1-premierleague.conf
eng-england!/2001-02/1-premierleague

eng-england!/2000-01/1-premierleague.conf
eng-england!/2000-01/1-premierleague

eng-england!/1999-00/1-premierleague.conf
eng-england!/1999-00/1-premierleague

eng-england!/1998-99/1-premierleague.conf
eng-england!/1998-99/1-premierleague

but this is not working

I get an error running sportdb new en

On Windows 10 + ruby 2.5, i get the below error when calling "sportdb new en"

*** error: undefined method `get_input_stream' for nil:NilClass

Can you help?

Heres the preceeding output...

[info] parsing data in zip 'setups/all' (eng-england-master/setups/all.txt)...
[info] parsing data in zip (league) 'eng-england!/leagues' (eng-england-master/leagues.txt)...
DEPRECATION WARNING: update_attributes! is deprecated and will be removed from Rails 6.1 (please, use update! instead) (called from load at C:/Ruby25-x64/bin/sportdb:23)
DEPRECATION WARNING: update_attributes! is deprecated and will be removed from Rails 6.1 (please, use update! instead) (called from load at C:/Ruby25-x64/bin/sportdb:23)
DEPRECATION WARNING: update_attributes! is deprecated and will be removed from Rails 6.1 (please, use update! instead) (called from load at C:/Ruby25-x64/bin/sportdb:23)
DEPRECATION WARNING: update_attributes! is deprecated and will be removed from Rails 6.1 (please, use update! instead) (called from load at C:/Ruby25-x64/bin/sportdb:23)
[info] parsing data in zip (team) 'eng-england!/clubs/1-premierleague' (eng-england-master/clubs/1-premierleague.txt)...

*** error: undefined method `get_input_stream' for nil:NilClass

2012/13 season, Manchester united is not correctly handled.

When I did sportdb build and looked up the exported sport.db sqlite file, I found that Manchester United's match number is only 19 in 2012/13 season.

https://github.com/openfootball/england/blob/master/2012-13/1-premierleague-ii.txt
This file describes Manchester united as "Manchester U" and Manchester City as "Manchester C", and
https://github.com/openfootball/england/blob/master/.build/conf.txt

[10/81] >2012-13/1-premierleague-ii.txt<
  1 section(s):
    261 lines - league: >English Premier League< (eng.1), season: >2012/13<
      20 clubs:
        Arsenal x19 => Arsenal FC
        Aston Villa x19 => Aston Villa FC
        Chelsea x19 => Chelsea FC
        Everton x19 => Everton FC
        Fulham x19 => Fulham FC
        Liverpool x19 => Liverpool FC
        Manchester C x19 => Manchester City FC
        Manchester U x19 => Manchester United FC

I think the last two line don't handle the conversion correctly.
I don't know why.
But you can confirm something is wrong by doing what I did:

When I did sportdb build and looked up the exported sport.db sqlite file, I found that Manchester United's match number is only 19 in 2012/13 season.

England 1998/1999 games all one day offset

Hi all,

Looks like in all of the 1998-99 files for England, the games are 1 day too early. For example, see:

https://github.com/openfootball/england/blob/master/archive/1990s/1998-99/1-premierleague.txt

This file tells us that:

Matchday 1
[Fri Aug/14]
  Wimbledon FC             3-1  Tottenham

But actually it was played on Sat Aug/15:

https://www.premierleague.com/match/2534

Can I go and correct all these files?

eng-england/2003-04/1-premierleague.txt File is empty

This file is empty
eng-england/2003-04/1-premierleague.txt