Dataset: Arsenal EPL (2017/18 - 2022/23)

About this Dataset

Arsenal EPL (2017/18 - 2022/23)

Dataset of Arsenal matches and player statistics from 2017/18 season until 28.02.2023.

Content
This dataset includes 214 results of Arsenal FC matches starting from 2017/18 season up to 28.02.2022, 2741 record of every player, who played in these matches with advanced statistics and 218 records of every goalkeeper.

Dataset has three files:
matches.csv - every Arsenal FC match between the 2017-18 season and February 28, 2023.
players.csv - every player who played for Arsenal between the 2017-18 season and February 28, 2023.
goalkeepers.csv - every goalkeeper who played for Arsenal between the 2017-18 season and February 28, 2023.

All columns descriptions you can find in README file.

Tables

Goalkeepers

@kaggle.rustemnagimov_arsenal_epl_dataset.goalkeepers

18.07 KB
218 rows
19 columns


CREATE TABLE goalkeepers (
  "lastname" VARCHAR,
  "firstname" VARCHAR,
  "date" TIMESTAMP,
  "start" BIGINT,
  "pos" VARCHAR,
  "min" DOUBLE,
  "sota" DOUBLE,
  "ga" DOUBLE,
  "saves" DOUBLE,
  "psxg" DOUBLE,
  "pkatt" DOUBLE,
  "pka" DOUBLE,
  "pkm" DOUBLE,
  "passatt" DOUBLE,
  "throws" DOUBLE,
  "avglen" DOUBLE,
  "gkatt" DOUBLE,
  "gkavglen" DOUBLE,
  "c" BIGINT
);

Matches

@kaggle.rustemnagimov_arsenal_epl_dataset.matches

13.33 KB
214 rows
12 columns


CREATE TABLE matches (
  "season" VARCHAR,
  "tour" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "opponent" VARCHAR,
  "hoaw" VARCHAR,
  "arsenalscore" BIGINT,
  "opponentscore" BIGINT,
  "stadium" VARCHAR,
  "attendance" BIGINT,
  "coach" VARCHAR,
  "referee" VARCHAR
);

Players

@kaggle.rustemnagimov_arsenal_epl_dataset.players

57.49 KB
2741 rows
28 columns


CREATE TABLE players (
  "lastname" VARCHAR,
  "firstname" VARCHAR,
  "date" TIMESTAMP,
  "start" BIGINT,
  "pos" VARCHAR,
  "min" DOUBLE,
  "g" DOUBLE,
  "a" DOUBLE,
  "pk" DOUBLE,
  "pka" DOUBLE,
  "s" DOUBLE,
  "sot" DOUBLE,
  "yk" DOUBLE,
  "rk" DOUBLE,
  "touches" DOUBLE,
  "tackles" DOUBLE,
  "ints" DOUBLE,
  "blocks" DOUBLE,
  "xg" DOUBLE,
  "npxg" DOUBLE,
  "xag" DOUBLE,
  "passes" DOUBLE,
  "passesa" DOUBLE,
  "prgpas" DOUBLE,
  "carries" DOUBLE,
  "prgcar" DOUBLE,
  "line" VARCHAR,
  "c" BIGINT
);