Dataset: Premier League Detailed Team Data

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

95.85 KB
2280 rows
34 columns


CREATE TABLE defensive_actions (
  "unnamed_0" BIGINT,
  "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,
  "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

97.36 KB
2280 rows
34 columns


CREATE TABLE goalkeeping_stats (
  "unnamed_0" BIGINT,
  "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,
  "cs" BIGINT,
  "psxg" DOUBLE,
  "psxg_3588aa" DOUBLE,
  "cmp" BIGINT,
  "att" BIGINT,
  "cmp_fbd6fd" DOUBLE,
  "att_1" BIGINT,
  "thr" BIGINT,
  "launch" DOUBLE,
  "avglen" DOUBLE,
  "att_2" BIGINT,
  "launch_1" DOUBLE,
  "avglen_1" DOUBLE,
  "opp" BIGINT,
  "stp" BIGINT,
  "stp_379866" DOUBLE,
  "n__opa" BIGINT,
  "avgdist" DOUBLE,
  "match_report" VARCHAR,
  "team" VARCHAR
);

Match Info

@kaggle.aditya2803_premier_league_team_data.match_info

58.32 KB
2280 rows
20 columns


CREATE TABLE match_info (
  "unnamed_0" BIGINT,
  "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

69.19 KB
2280 rows
28 columns


CREATE TABLE miscellaneous_stats (
  "unnamed_0" BIGINT,
  "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,
  "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,
  "match_report" VARCHAR,
  "team" VARCHAR
);

Passing Stats

@kaggle.aditya2803_premier_league_team_data.passing_stats

132.7 KB
2280 rows
33 columns


CREATE TABLE passing_stats (
  "unnamed_0" BIGINT,
  "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,
  "totdist" BIGINT,
  "prgdist" BIGINT,
  "cmp_1" BIGINT,
  "att_1" BIGINT,
  "cmp_1_c8ea36" DOUBLE,
  "cmp_2" BIGINT,
  "att_2" BIGINT,
  "cmp_2_b6e57c" DOUBLE,
  "cmp_3" BIGINT,
  "att_3" BIGINT,
  "cmp_3_98370a" DOUBLE,
  "ast" BIGINT,
  "xa" DOUBLE,
  "kp" BIGINT,
  "n_1_3" BIGINT,
  "ppa" BIGINT,
  "crspa" BIGINT,
  "prog" BIGINT,
  "match_report" VARCHAR,
  "team" VARCHAR
);

Passing Type

@kaggle.aditya2803_premier_league_team_data.passing_type

120.92 KB
2280 rows
37 columns


CREATE TABLE passing_type (
  "unnamed_0" BIGINT,
  "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

133.89 KB
2280 rows
32 columns


CREATE TABLE possession_stats (
  "unnamed_0" BIGINT,
  "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,
  "n__pl" BIGINT,
  "megs" BIGINT,
  "carries" BIGINT,
  "totdist" BIGINT,
  "prgdist" BIGINT,
  "targ" BIGINT,
  "rec" BIGINT,
  "rec_04e8c8" DOUBLE,
  "miscon" BIGINT,
  "dispos" BIGINT,
  "match_report" VARCHAR,
  "team" VARCHAR
);

Shooting Stats

@kaggle.aditya2803_premier_league_team_data.shooting_stats

65.06 KB
2280 rows
26 columns


CREATE TABLE shooting_stats (
  "unnamed_0" BIGINT,
  "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,
  "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

56.98 KB
2280 rows
25 columns


CREATE TABLE shots_and_goals_creations (
  "unnamed_0" BIGINT,
  "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
);