Name: Premier League Advance Stats
Creator: Kaggle
License: https://www.apache.org/licenses/

About this Dataset

Premier League Advance Stats

This dataset contains 2 csv files, containing advance Premier League stats for each team, ever since it started being recording. The other csv file contains stats for the 2023-2024 season from game week 1 to game week 18. All stats were obtained from fbref

Tables

Epl Stats

@kaggle.tientr_premier_league_advance_stats.epl_stats

55.5 kB
120 rows
53 columns

CREATE TABLE epl_stats (
  "season" VARCHAR,
  "squad" VARCHAR,
  "points" BIGINT,
  "sota" DOUBLE,
  "saves" DOUBLE,
  "save" DOUBLE  -- Save%,
  "cs" DOUBLE  -- CS%,
  "ga" DOUBLE,
  "pka" DOUBLE,
  "fk" DOUBLE,
  "ck" DOUBLE,
  "og" DOUBLE,
  "psxg" DOUBLE,
  "psxg_sot" DOUBLE,
  "psxg_3588aa" DOUBLE  -- PSxG+/-,
  "gls" DOUBLE,
  "sh" DOUBLE,
  "sot" DOUBLE,
  "sot_d2d6f4" DOUBLE  -- SoT%,
  "g_sh" DOUBLE,
  "g_sot" DOUBLE,
  "xg" DOUBLE,
  "npxg" DOUBLE,
  "npxg_sh" DOUBLE,
  "patt" DOUBLE,
  "cmp" DOUBLE  -- Cmp%,
  "ast" DOUBLE,
  "xag" DOUBLE,
  "xa" DOUBLE,
  "kp" DOUBLE,
  "ppa" DOUBLE,
  "crspa" DOUBLE,
  "prgp" DOUBLE,
  "sca" DOUBLE,
  "gca" DOUBLE,
  "tklw" DOUBLE,
  "dc" DOUBLE,
  "tkl" DOUBLE  -- Tkl%,
  "lost" DOUBLE,
  "blocks" DOUBLE,
  "sh_1" DOUBLE,
  "pass" DOUBLE,
  "int" DOUBLE,
  "tkl_int" DOUBLE,
  "clr" DOUBLE,
  "err" DOUBLE,
  "touches" DOUBLE,
  "att" DOUBLE,
  "succ" DOUBLE,
  "succ_c8ffb4" DOUBLE  -- Succ%,
  "prgdist" DOUBLE,
  "prgc" DOUBLE,
  "prgr" DOUBLE
);

Prem 2023–2024

@kaggle.tientr_premier_league_advance_stats.prem_2023_2024

39.64 kB
20 rows
53 columns

CREATE TABLE prem_2023_2024 (
  "season" VARCHAR,
  "squad" VARCHAR,
  "points" BIGINT,
  "sota" DOUBLE,
  "saves" DOUBLE,
  "save" DOUBLE  -- Save%,
  "cs" DOUBLE  -- CS%,
  "ga" DOUBLE,
  "pka" DOUBLE,
  "fk" DOUBLE,
  "ck" DOUBLE,
  "og" DOUBLE,
  "psxg" DOUBLE,
  "psxg_sot" DOUBLE,
  "psxg_3588aa" DOUBLE  -- PSxG+/-,
  "gls" DOUBLE,
  "sh" DOUBLE,
  "sot" DOUBLE,
  "sot_d2d6f4" DOUBLE  -- SoT%,
  "g_sh" DOUBLE,
  "g_sot" DOUBLE,
  "xg" DOUBLE,
  "npxg" DOUBLE,
  "npxg_sh" DOUBLE,
  "patt" DOUBLE,
  "cmp" DOUBLE  -- Cmp%,
  "ast" DOUBLE,
  "xag" DOUBLE,
  "xa" DOUBLE,
  "kp" DOUBLE,
  "ppa" DOUBLE,
  "crspa" DOUBLE,
  "prgp" DOUBLE,
  "sca" DOUBLE,
  "gca" DOUBLE,
  "tklw" DOUBLE,
  "dc" DOUBLE,
  "tkl" DOUBLE  -- Tkl%,
  "lost" DOUBLE,
  "blocks" DOUBLE,
  "sh_1" DOUBLE,
  "pass" DOUBLE,
  "int" DOUBLE,
  "tkl_int" DOUBLE,
  "clr" DOUBLE,
  "err" DOUBLE,
  "touches" DOUBLE,
  "att" DOUBLE,
  "succ" DOUBLE,
  "succ_c8ffb4" DOUBLE  -- Succ%,
  "prgdist" DOUBLE,
  "prgc" DOUBLE,
  "prgr" DOUBLE
);