Name: Football Database
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Football Database

Basic Information

This dataset contains football-related data covering the Top5 leagues in Europe from 2014-2020. It is structured like a relational database, which makes it easy to work with, regardless of the problem you want so solve.

Sources

https://understat.com/ provides modern football figures like 'expected goals'
https://www.football-data.co.uk/ comprehensive betting data

Last Time Updated

27 August 2021

Tables

Appearances

@kaggle.technika148_football_database.appearances

9.88 MB
356,513 rows
19 columns

CREATE TABLE appearances (
  "gameid" BIGINT,
  "playerid" BIGINT,
  "goals" BIGINT,
  "owngoals" BIGINT,
  "shots" BIGINT,
  "xgoals" DOUBLE,
  "xgoalschain" DOUBLE,
  "xgoalsbuildup" DOUBLE,
  "assists" BIGINT,
  "keypasses" BIGINT,
  "xassists" DOUBLE,
  "position" VARCHAR,
  "positionorder" BIGINT,
  "yellowcard" BIGINT,
  "redcard" BIGINT,
  "time" BIGINT,
  "substitutein" BIGINT,
  "substituteout" BIGINT,
  "leagueid" BIGINT
);

Games

@kaggle.technika148_football_database.games

676.03 kB
12,680 rows
34 columns

CREATE TABLE games (
  "gameid" BIGINT,
  "leagueid" BIGINT,
  "season" BIGINT,
  "date" TIMESTAMP,
  "hometeamid" BIGINT,
  "awayteamid" BIGINT,
  "homegoals" BIGINT,
  "awaygoals" BIGINT,
  "homeprobability" DOUBLE,
  "drawprobability" DOUBLE,
  "awayprobability" DOUBLE,
  "homegoalshalftime" BIGINT,
  "awaygoalshalftime" BIGINT,
  "b365h" DOUBLE,
  "b365d" DOUBLE,
  "b365a" DOUBLE,
  "bwh" DOUBLE,
  "bwd" DOUBLE,
  "bwa" DOUBLE,
  "iwh" DOUBLE,
  "iwd" DOUBLE,
  "iwa" DOUBLE,
  "psh" DOUBLE,
  "psd" DOUBLE,
  "psa" DOUBLE,
  "whh" DOUBLE,
  "whd" DOUBLE,
  "wha" DOUBLE,
  "vch" DOUBLE,
  "vcd" DOUBLE,
  "vca" DOUBLE,
  "psch" DOUBLE,
  "pscd" DOUBLE,
  "psca" DOUBLE
);

Leagues

@kaggle.technika148_football_database.leagues

2.93 kB
5 rows
3 columns

CREATE TABLE leagues (
  "leagueid" BIGINT,
  "name" VARCHAR,
  "understatnotation" VARCHAR
);

Shots

@kaggle.technika148_football_database.shots

5.23 MB
324,543 rows
11 columns

CREATE TABLE shots (
  "gameid" BIGINT,
  "shooterid" BIGINT,
  "assisterid" DOUBLE,
  "minute" BIGINT,
  "situation" VARCHAR,
  "lastaction" VARCHAR,
  "shottype" VARCHAR,
  "shotresult" VARCHAR,
  "xgoal" DOUBLE,
  "positionx" DOUBLE,
  "positiony" DOUBLE
);

Teams

@kaggle.technika148_football_database.teams

4.71 kB
146 rows
2 columns

CREATE TABLE teams (
  "teamid" BIGINT,
  "name" VARCHAR
);

Teamstats

@kaggle.technika148_football_database.teamstats

669.39 kB
25,360 rows
16 columns

CREATE TABLE teamstats (
  "gameid" BIGINT,
  "teamid" BIGINT,
  "season" BIGINT,
  "date" TIMESTAMP,
  "location" VARCHAR,
  "goals" BIGINT,
  "xgoals" DOUBLE,
  "shots" BIGINT,
  "shotsontarget" BIGINT,
  "deep" BIGINT,
  "ppda" DOUBLE,
  "fouls" BIGINT,
  "corners" BIGINT,
  "yellowcards" DOUBLE,
  "redcards" BIGINT,
  "result" VARCHAR
);