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

Match Infos Epl 1920

@kaggle.scientistdat_epl_2019_2020_match_data.match_infos_epl_1920

49.68 KB
380 rows
26 columns

unnamed_0 Unnamed: 0	a A	a_deep A Deep	a_goals A Goals	a_ppda A Ppda	a_shot A Shot	a_shotontarget A ShotOnTarget	a_xg A Xg	date Date	fid Fid	h H	h_d H D	h_deep H Deep	h_goals H Goals	h_l H L	h_ppda H Ppda	h_shot H Shot	h_shotontarget H ShotOnTarget	h_w H W	h_xg H Xg	id Id	league League	league_id League Id	season Season	team_a Team A	team_h Team H
	79	5	1	21.4545	12	5	0.842407	Fri Aug 09 2019 20:00:00 GMT+0000 (Coordinated Universal Time)	1375927	87	0.1732	11	4	0.0891	5.9429	15	7	0.7377	2.23456	11643	EPL	1	2019	Norwich	Liverpool
1	88	9	5	6.9355	14	9	3.18377	Sat Aug 10 2019 12:30:00 GMT+0000 (Coordinated Universal Time)	1375928	81	0.1166	1		0.8382	16.4	5	3	0.0452	1.2003	11644	EPL	1	2019	Manchester City	West Ham
2	238	6	1	9.1333	8	3	1.59864	Sat Aug 10 2019 15:00:00 GMT+0000 (Coordinated Universal Time)	1375929	73	0.3923	4	1	0.3994	13.6	13	3	0.2083	1.34099	11645	EPL	1	2019	Sheffield United	Bournemouth
3	74	9		5.5	11	3	1.08752	Sat Aug 10 2019 15:00:00 GMT+0000 (Coordinated Universal Time)	1375930	92	0.3442		3	0.3898	9.2778	10	4	0.266	0.909241	11646	EPL	1	2019	Southampton	Burnley
4	72	5		4.0741	10	3	1.2246	Sat Aug 10 2019 15:00:00 GMT+0000 (Coordinated Universal Time)	1375931	78	0.3231	5		0.4342	11.3077	6	2	0.2427	0.87159	11647	EPL	1	2019	Everton	Crystal Palace
5	220	5	3	11.5	5	3	0.855516	Sat Aug 10 2019 15:00:00 GMT+0000 (Coordinated Universal Time)	1375933	90	0.362	7		0.3946	9.7857	11	3	0.2434	0.670022	11648	EPL	1	2019	Brighton	Watford
6	71	2	1	13.4211	7	4	0.639599	Sat Aug 10 2019 17:30:00 GMT+0000 (Coordinated Universal Time)	1375934	82	0.1273	15	3	0.0507	5.25	31	7	0.822	2.57262	11649	EPL	1	2019	Aston Villa	Tottenham
7	83	10	1	11.0526	8	2	1.13309	Sun Aug 11 2019 14:00:00 GMT+0000 (Coordinated Universal Time)	1375935	86	0.3057	1		0.5891	13.2069	9	2	0.1052	0.380551	11650	EPL	1	2019	Arsenal	Newcastle United
8	229	3		18.6667	8	2	0.812949	Sun Aug 11 2019 14:00:00 GMT+0000 (Coordinated Universal Time)	1375932	75	0.3819	7		0.4007	6.4348	16	1	0.2174	0.543759	11651	EPL	1	2019	Wolverhampton Wanderers	Leicester
9	80	4		6.4524	18	7	1.09534	Sun Aug 11 2019 16:30:00 GMT+0000 (Coordinated Universal Time)	1375936	89	0.1782	8	4	0.107	9.0645	11	5	0.7148	2.37442	11652	EPL	1	2019	Chelsea	Manchester United


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