Baselight
Sign In

EPL 2019–2020 Match Data

The dataset gives play by play data for the EPL 2019-20 season

@kaggle.scientistdat_epl_2019_2020_match_data

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
  • 49.68 KB
  • 380 rows
  • 26 columns
Loading...
 

CREATE TABLE match_infos_epl_1920 (
  "unnamed_0" BIGINT,
  "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
  • 429.75 KB
  • 10614 rows
  • 23 columns
Loading...
 

CREATE TABLE rosters_epl_1920 (
  "unnamed_0" BIGINT,
  "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
  • 302.31 KB
  • 9427 rows
  • 21 columns
Loading...
 

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