English Premier League(2020-2022) Dataset

Team stats for all Premier League games 2020-2022

@kaggle.shubhamgadekar_english_premier_league20202022_dataset

Table List

1 table(38.99 KB)

Matches

@kaggle.shubhamgadekar_english_premier_league20202022_dataset.matches

38.99 KB
1052 rows
28 columns

unnamed_0 Unnamed: 0	date Date	time Time	comp Comp	round Round	day Day	venue Venue	result Result	gf Gf	ga Ga	opponent Opponent	xg Xg	xga Xga	poss Poss	attendance Attendance	captain Captain	formation Formation	referee Referee	match_report Match Report	sh Sh	sot Sot	dist Dist	fk Fk	pk Pk	pkatt Pkatt	season Season	team Team
	Fri Aug 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	20:00	Premier League	Matchweek 1	Fri	Away	W	2		Crystal Palace	1	1.2	44	25286	Martin Ødegaard	4-3-3	Anthony Taylor	Match Report	10	2	14.6	1			2022	Arsenal
1	Sat Aug 13 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	15:00	Premier League	Matchweek 2	Sat	Home	W	4	2	Leicester City	2.7	0.5	50	60033	Martin Ødegaard	4-3-3	Darren England	Match Report	19	7	13				2022	Arsenal
2	Sat Aug 20 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	17:30	Premier League	Matchweek 3	Sat	Away	W	3		Bournemouth	1.3	0.3	57	10423	Martin Ødegaard	4-3-3	Craig Pawson	Match Report	14	6	14.8				2022	Arsenal
3	Sat Aug 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	17:30	Premier League	Matchweek 4	Sat	Home	W	2	1	Fulham	2.6	0.8	71	60164	Martin Ødegaard	4-3-3	Jarred Gillett	Match Report	22	8	15.5	1			2022	Arsenal
4	Wed Aug 31 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	19:30	Premier League	Matchweek 5	Wed	Home	W	2	1	Aston Villa	2.4	0.4	59	60012	Martin Ødegaard	4-3-3	Robert Jones	Match Report	22	8	16.3	1			2022	Arsenal
5	Sun Sep 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	16:30	Premier League	Matchweek 6	Sun	Away	L	1	3	Manchester Utd	1.3	1.5	60	73431	Martin Ødegaard	4-3-3	Paul Tierney	Match Report	16	3	18.6	1			2022	Arsenal
7	Sun Sep 18 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	12:00	Premier League	Matchweek 8	Sun	Away	W	3		Brentford	1.5	0.5	63	17122	Granit Xhaka	4-3-3	David Coote	Match Report	13	7	18.2				2022	Arsenal
8	Sat Oct 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	12:30	Premier League	Matchweek 9	Sat	Home	W	3	1	Tottenham	2.4	1.6	64	60278	Martin Ødegaard	4-3-3	Anthony Taylor	Match Report	22	9	18.6	1			2022	Arsenal
10	Sun Oct 09 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	16:30	Premier League	Matchweek 10	Sun	Home	W	3	2	Liverpool	2.7	1.1	43	60059	Martin Ødegaard	4-3-3	Michael Oliver	Match Report	10	6	14.3		1	1	2022	Arsenal
12	Sun Oct 16 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	14:00	Premier League	Matchweek 11	Sun	Away	W	1		Leeds United	0.5	1.8	53	36700	Martin Ødegaard	4-3-3	Chris Kavanagh	Match Report	9	4	16.6	1			2022	Arsenal


CREATE TABLE matches (
  "unnamed_0" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "comp" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" DOUBLE,
  "ga" DOUBLE,
  "opponent" VARCHAR,
  "xg" DOUBLE,
  "xga" DOUBLE,
  "poss" DOUBLE,
  "attendance" DOUBLE,
  "captain" VARCHAR,
  "formation" VARCHAR,
  "referee" VARCHAR,
  "match_report" VARCHAR,
  "notes" VARCHAR,
  "sh" DOUBLE,
  "sot" DOUBLE,
  "dist" DOUBLE,
  "fk" DOUBLE,
  "pk" DOUBLE,
  "pkatt" DOUBLE,
  "season" BIGINT,
  "team" VARCHAR
);