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

Table List

3 tables(781.75 KB)

Match Infos Epl 1920

Rosters Epl 1920

Shots Epl 1920

Shots Epl 1920

@kaggle.scientistdat_epl_2019_2020_match_data.shots_epl_1920

302.31 KB
9427 rows
21 columns

unnamed_0 Unnamed: 0	x X	y Y	a_goals A Goals	a_team A Team	date Date	h_a H A	h_goals H Goals	h_team H Team	id Id	lastaction LastAction	match_id Match Id	minute Minute	player Player	player_assisted Player Assisted	player_id Player Id	result Result	season Season	shottype ShotType	situation Situation	xg XG
	0.8830000305175781	0.7130000305175781	1	Norwich	Fri Aug 09 2019 20:00:00 GMT+0000 (Coordinated Universal Time)	h	4	Liverpool	309897	Pass	11643	15	Andrew Robertson	Divock Origi	1688	MissedShots	2019	LeftFoot	OpenPlay	0.0537791661918163
1	0.933000030517578	0.3670000076293945	1	Norwich	Fri Aug 09 2019 20:00:00 GMT+0000 (Coordinated Universal Time)	h	4	Liverpool	309898	Pass	11643	18	Mohamed Salah	Roberto Firmino	1250	Goal	2019	LeftFoot	OpenPlay	0.3668168783187866
2	0.921999969482422	0.5109999847412109	1	Norwich	Fri Aug 09 2019 20:00:00 GMT+0000 (Coordinated Universal Time)	h	4	Liverpool	309901	Cross	11643	27	Virgil van Dijk	Mohamed Salah	833	Goal	2019	Head	FromCorner	0.105315513908863
3	0.8780000305175781	0.555	1	Norwich	Fri Aug 09 2019 20:00:00 GMT+0000 (Coordinated Universal Time)	h	4	Liverpool	309902	Cross	11643	30	Roberto Firmino	Trent Alexander-Arnold	482	SavedShot	2019	LeftFoot	OpenPlay	0.1120441555976867
4	0.8909999847412109	0.53	1	Norwich	Fri Aug 09 2019 20:00:00 GMT+0000 (Coordinated Universal Time)	h	4	Liverpool	309904	Chipped	11643	41	Divock Origi	Trent Alexander-Arnold	484	Goal	2019	Head	OpenPlay	0.2582522630691528
5	0.8480000305175781	0.6940000152587891	1	Norwich	Fri Aug 09 2019 20:00:00 GMT+0000 (Coordinated Universal Time)	h	4	Liverpool	309905	Pass	11643	46	Roberto Firmino	Andrew Robertson	482	BlockedShot	2019	LeftFoot	OpenPlay	0.0457283854484558
6	0.875	0.53	1	Norwich	Fri Aug 09 2019 20:00:00 GMT+0000 (Coordinated Universal Time)	h	4	Liverpool	309906	Cross	11643	47	Jordan Henderson	Divock Origi	605	SavedShot	2019	RightFoot	OpenPlay	0.1266910284757614
7	0.9640000152587892	0.5420000076293945	1	Norwich	Fri Aug 09 2019 20:00:00 GMT+0000 (Coordinated Universal Time)	h	4	Liverpool	309907	Pass	11643	47	Roberto Firmino	Trent Alexander-Arnold	482	ShotOnPost	2019	LeftFoot	OpenPlay	0.6854050755500793
8	0.88	0.3390000152587891	1	Norwich	Fri Aug 09 2019 20:00:00 GMT+0000 (Coordinated Universal Time)	h	4	Liverpool	309908	BallRecovery	11643	53	Mohamed Salah	Fabinho	1250	MissedShots	2019	LeftFoot	OpenPlay	0.0779922530055046
9	0.8490000152587891	0.4179999923706055	1	Norwich	Fri Aug 09 2019 20:00:00 GMT+0000 (Coordinated Universal Time)	h	4	Liverpool	309909	Pass	11643	54	Jordan Henderson	Mohamed Salah	605	BlockedShot	2019	RightFoot	OpenPlay	0.1055216640233993


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
);