Name: Premier League Detailed Team Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Premier League Detailed Team Data

Context

I was working on FPL points prediction model and I thought that opponent team stats matters a lot, so I started collecting this data.
But, this data is stored in around 550 different csv files and I wanted the data in a single csv file. So, I merged all the csv files according
to the stats. And now I'm sharing these files with all of you so that you could save your precious time.

Content

These files contain data of three seasons 17/18, 18/19 and 19/20. If you want the data for more seasons you can visit to this link mentioned below.

https://fbref.com/en/comps/9/1631/2017-2018-Premier-League-Stats

Tables

Defensive Actions

@kaggle.aditya2803_premier_league_team_data.defensive_actions

98.15 kB
2,280 rows
34 columns

CREATE TABLE defensive_actions (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" BIGINT,
  "ga" BIGINT,
  "opponent" VARCHAR,
  "tkl" BIGINT,
  "tklw" BIGINT,
  "def_3rd" BIGINT,
  "mid_3rd" BIGINT,
  "att_3rd" BIGINT,
  "tkl_1" BIGINT,
  "att" BIGINT,
  "tkl_6c6d02" DOUBLE  -- Tkl%,
  "past" BIGINT,
  "press" BIGINT,
  "succ" BIGINT,
  "n" DOUBLE  -- %,
  "def_3rd_1" BIGINT,
  "mid_3rd_1" BIGINT,
  "att_3rd_1" BIGINT,
  "blocks" BIGINT,
  "sh" BIGINT,
  "shsv" BIGINT,
  "pass" BIGINT,
  "int" BIGINT,
  "clr" BIGINT,
  "err" BIGINT,
  "match_report" VARCHAR,
  "team" VARCHAR
);

Goalkeeping Stats

@kaggle.aditya2803_premier_league_team_data.goalkeeping_stats

99.69 kB
2,280 rows
34 columns

CREATE TABLE goalkeeping_stats (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" BIGINT,
  "ga" BIGINT,
  "opponent" VARCHAR,
  "sota" BIGINT,
  "ga_1" BIGINT,
  "saves" BIGINT,
  "save" DOUBLE  -- Save%,
  "cs" BIGINT,
  "psxg" DOUBLE,
  "psxg_3588aa" DOUBLE  -- PSxG+/-,
  "cmp" BIGINT,
  "att" BIGINT,
  "cmp_fbd6fd" DOUBLE  -- Cmp%,
  "att_1" BIGINT,
  "thr" BIGINT,
  "launch" DOUBLE  -- Launch%,
  "avglen" DOUBLE,
  "att_2" BIGINT,
  "launch_1" DOUBLE  -- Launch%.1,
  "avglen_1" DOUBLE,
  "opp" BIGINT,
  "stp" BIGINT,
  "stp_379866" DOUBLE  -- Stp%,
  "n__opa" BIGINT  -- #OPA,
  "avgdist" DOUBLE,
  "match_report" VARCHAR,
  "team" VARCHAR
);

Match Info

@kaggle.aditya2803_premier_league_team_data.match_info

59.72 kB
2,280 rows
20 columns

CREATE TABLE match_info (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" BIGINT,
  "ga" BIGINT,
  "opponent" VARCHAR,
  "xg" DOUBLE,
  "xga" DOUBLE,
  "poss" BIGINT,
  "attendance" DOUBLE,
  "captain" VARCHAR,
  "formation" VARCHAR,
  "referee" VARCHAR,
  "match_report" VARCHAR,
  "notes" VARCHAR,
  "team" VARCHAR
);

Miscellaneous Stats

@kaggle.aditya2803_premier_league_team_data.miscellaneous_stats

70.85 kB
2,280 rows
28 columns

CREATE TABLE miscellaneous_stats (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" BIGINT,
  "ga" BIGINT,
  "opponent" VARCHAR,
  "crdy" BIGINT,
  "crdr" BIGINT,
  "n_2crdy" BIGINT  -- 2CrdY,
  "fls" BIGINT,
  "fld" BIGINT,
  "off" BIGINT,
  "crs" BIGINT,
  "int" BIGINT,
  "tklw" BIGINT,
  "pkwon" BIGINT,
  "pkcon" BIGINT,
  "og" BIGINT,
  "recov" BIGINT,
  "won" BIGINT,
  "lost" BIGINT,
  "won_27ea4a" DOUBLE  -- Won%,
  "match_report" VARCHAR,
  "team" VARCHAR
);

Passing Stats

@kaggle.aditya2803_premier_league_team_data.passing_stats

135.88 kB
2,280 rows
33 columns

CREATE TABLE passing_stats (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" BIGINT,
  "ga" BIGINT,
  "opponent" VARCHAR,
  "cmp" BIGINT,
  "att" BIGINT,
  "cmp_fbd6fd" DOUBLE  -- Cmp%,
  "totdist" BIGINT,
  "prgdist" BIGINT,
  "cmp_1" BIGINT,
  "att_1" BIGINT,
  "cmp_1_c8ea36" DOUBLE  -- Cmp%.1,
  "cmp_2" BIGINT,
  "att_2" BIGINT,
  "cmp_2_b6e57c" DOUBLE  -- Cmp%.2,
  "cmp_3" BIGINT,
  "att_3" BIGINT,
  "cmp_3_98370a" DOUBLE  -- Cmp%.3,
  "ast" BIGINT,
  "xa" DOUBLE,
  "kp" BIGINT,
  "n_1_3" BIGINT  -- 1/3,
  "ppa" BIGINT,
  "crspa" BIGINT,
  "prog" BIGINT,
  "match_report" VARCHAR,
  "team" VARCHAR
);

Passing Type

@kaggle.aditya2803_premier_league_team_data.passing_type

123.82 kB
2,280 rows
37 columns

CREATE TABLE passing_type (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" BIGINT,
  "ga" BIGINT,
  "opponent" VARCHAR,
  "att" BIGINT,
  "live" BIGINT,
  "dead" BIGINT,
  "fk" BIGINT,
  "tb" BIGINT,
  "press" BIGINT,
  "sw" BIGINT,
  "crs" BIGINT,
  "ck" BIGINT,
  "in" BIGINT,
  "out" BIGINT,
  "str" BIGINT,
  "ground" BIGINT,
  "low" BIGINT,
  "high" BIGINT,
  "left" BIGINT,
  "right" BIGINT,
  "head" BIGINT,
  "ti" BIGINT,
  "other" BIGINT,
  "cmp" BIGINT,
  "off" BIGINT,
  "out_1" BIGINT,
  "int" BIGINT,
  "blocks" BIGINT,
  "match_report" VARCHAR,
  "team" VARCHAR
);

Possession Stats

@kaggle.aditya2803_premier_league_team_data.possession_stats

137.11 kB
2,280 rows
32 columns

CREATE TABLE possession_stats (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" BIGINT,
  "ga" BIGINT,
  "opponent" VARCHAR,
  "touches" BIGINT,
  "def_pen" BIGINT,
  "def_3rd" BIGINT,
  "mid_3rd" BIGINT,
  "att_3rd" BIGINT,
  "att_pen" BIGINT,
  "live" BIGINT,
  "succ" BIGINT,
  "att" BIGINT,
  "succ_c8ffb4" DOUBLE  -- Succ%,
  "n__pl" BIGINT  -- #Pl,
  "megs" BIGINT,
  "carries" BIGINT,
  "totdist" BIGINT,
  "prgdist" BIGINT,
  "targ" BIGINT,
  "rec" BIGINT,
  "rec_04e8c8" DOUBLE  -- Rec%,
  "miscon" BIGINT,
  "dispos" BIGINT,
  "match_report" VARCHAR,
  "team" VARCHAR
);

Shooting Stats

@kaggle.aditya2803_premier_league_team_data.shooting_stats

66.62 kB
2,280 rows
26 columns

CREATE TABLE shooting_stats (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" BIGINT,
  "ga" BIGINT,
  "opponent" VARCHAR,
  "gls" BIGINT,
  "pk" BIGINT,
  "pkatt" BIGINT,
  "sh" BIGINT,
  "sot" BIGINT,
  "fk" BIGINT,
  "sot_d2d6f4" DOUBLE  -- SoT%,
  "g_sh" DOUBLE,
  "g_sot" DOUBLE,
  "xg" DOUBLE,
  "npxg" DOUBLE,
  "npxg_sh" DOUBLE,
  "g_xg" DOUBLE,
  "np_g_xg" DOUBLE,
  "match_report" VARCHAR,
  "team" VARCHAR
);

Shots And Goals Creations

@kaggle.aditya2803_premier_league_team_data.shots_and_goals_creations

58.34 kB
2,280 rows
25 columns

CREATE TABLE shots_and_goals_creations (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" BIGINT,
  "ga" BIGINT,
  "opponent" VARCHAR,
  "sca" BIGINT,
  "passlive" BIGINT,
  "passdead" BIGINT,
  "drib" BIGINT,
  "sh" BIGINT,
  "fld" BIGINT,
  "gca" BIGINT,
  "passlive_1" BIGINT,
  "passdead_1" BIGINT,
  "drib_1" BIGINT,
  "sh_1" BIGINT,
  "fld_1" BIGINT,
  "og" BIGINT,
  "match_report" VARCHAR,
  "team" VARCHAR
);