Name: EPL 2019–2020 Match Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

EPL 2019–2020 Match Data

This dataset contains important events of matches on a play by play basis. Metrics include Key Passes, Shots, Assists, and a whole set of OPTA variables.

This is a great dataset for football fans like me who want more than just your run of the mill analysis

Tables

Match Infos Epl 1920

@kaggle.scientistdat_epl_2019_2020_match_data.match_infos_epl_1920

50.87 kB
380 rows
26 columns

CREATE TABLE match_infos_epl_1920 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "a" BIGINT,
  "a_deep" BIGINT,
  "a_goals" BIGINT,
  "a_ppda" DOUBLE,
  "a_shot" BIGINT,
  "a_shotontarget" BIGINT,
  "a_xg" DOUBLE,
  "date" TIMESTAMP,
  "fid" BIGINT,
  "h" BIGINT,
  "h_d" DOUBLE,
  "h_deep" BIGINT,
  "h_goals" BIGINT,
  "h_l" DOUBLE,
  "h_ppda" DOUBLE,
  "h_shot" BIGINT,
  "h_shotontarget" BIGINT,
  "h_w" DOUBLE,
  "h_xg" DOUBLE,
  "id" BIGINT,
  "league" VARCHAR,
  "league_id" BIGINT,
  "season" BIGINT,
  "team_a" VARCHAR,
  "team_h" VARCHAR
);

Rosters Epl 1920

@kaggle.scientistdat_epl_2019_2020_match_data.rosters_epl_1920

440.07 kB
10,614 rows
23 columns

CREATE TABLE rosters_epl_1920 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "assists" BIGINT,
  "goals" BIGINT,
  "h_a" VARCHAR,
  "id" BIGINT,
  "key_passes" BIGINT,
  "match_id" BIGINT,
  "own_goals" BIGINT,
  "player" VARCHAR,
  "player_id" BIGINT,
  "position" VARCHAR,
  "positionorder" BIGINT,
  "red_card" BIGINT,
  "roster_in" BIGINT,
  "roster_out" BIGINT,
  "shots" BIGINT,
  "team_id" BIGINT,
  "time" BIGINT,
  "xa" DOUBLE,
  "xg" DOUBLE,
  "xgbuildup" DOUBLE,
  "xgchain" DOUBLE,
  "yellow_card" BIGINT
);

Shots Epl 1920

@kaggle.scientistdat_epl_2019_2020_match_data.shots_epl_1920

309.57 kB
9,427 rows
21 columns

CREATE TABLE shots_epl_1920 (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "x" DOUBLE,
  "y" DOUBLE,
  "a_goals" BIGINT,
  "a_team" VARCHAR,
  "date" TIMESTAMP,
  "h_a" VARCHAR,
  "h_goals" BIGINT,
  "h_team" VARCHAR,
  "id" BIGINT,
  "lastaction" VARCHAR,
  "match_id" BIGINT,
  "minute" BIGINT,
  "player" VARCHAR,
  "player_assisted" VARCHAR,
  "player_id" BIGINT,
  "result" VARCHAR,
  "season" BIGINT,
  "shottype" VARCHAR,
  "situation" VARCHAR,
  "xg" DOUBLE
);