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

Rosters Epl 1920

@kaggle.scientistdat_epl_2019_2020_match_data.rosters_epl_1920

429.75 KB
10614 rows
23 columns

unnamed_0 Unnamed: 0	assists Assists	goals Goals	h_a H A	id Id	key_passes Key Passes	match_id Match Id	player Player	player_id Player Id	position Position	positionorder PositionOrder	roster_in Roster In	shots Shots	team_id Team Id	time Time	xa XA	xg XG	xgbuildup XGBuildup	xgchain XGChain
			h	341152		11643	Alisson	1257	GK	1	341164		87	38
1	1		h	341153	3	11643	Trent Alexander-Arnold	1791	DR	2		2	87	90	1.055701494216919	0.1754923015832901	0.1266910284757614	1.2044261693954468
2		1	h	341154		11643	Virgil van Dijk	833	DC	3		1	87	90		0.105315513908863	0.1266910284757614	0.1266910284757614
3			h	341155	1	11643	Joseph Gomez	987	DC	3			87	90	0.0220335964113473			0.0220335964113473
4			h	341156	1	11643	Andrew Robertson	1688	DL	4		2	87	90	0.0457283854484558	0.0668550133705139	0.2219675034284591	0.3214750587940216
5			h	341159		11643	Jordan Henderson	605	MC	9		2	87	90		0.2322127074003219	0.3535287380218506	0.5857414603233337
6			h	341157	1	11643	Fabinho	3420	MC	9		1	87	90	0.0779922530055046	0.0147264264523983	0.5857414603233337	0.6784601211547852
7			h	341158		11643	Georginio Wijnaldum	771	MC	9			87	90			0.3849433064460754	0.3849433064460754
8	1	1	h	341160	3	11643	Mohamed Salah	1250	FWR	14		2	87	90	0.3061136603355407	0.4448091089725494	0.943657398223877	1.5892646312713623
9	1		h	341161	1	11643	Roberto Firmino	482	FW	15	341165	4	87	89	0.3668168783187866	0.9384540915489196		1.305271029472351


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