Premier League Detailed Team Data

Premier League Detailed Team Data of season 17/18, 18/19 and 19/20

@kaggle.aditya2803_premier_league_team_data

Table List

9 tables(830.26 KB)

Shots And Goals Creations

Match Info

@kaggle.aditya2803_premier_league_team_data.match_info

58.32 KB
2280 rows
20 columns

unnamed_0 Unnamed: 0	date Date	time Time	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	team Team
	Fri Aug 11 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	19:45 (00:15)	Matchweek 1	Fri	Home	W	4	3	Leicester City	2.3	1.5	68	59387	Petr Äech	3-4-3	Mike Dean	Match Report	Arsenal
1	Sat Aug 19 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	17:30 (22:00)	Matchweek 2	Sat	Away	L		1	Stoke City	1.4	0.8	77	29459	Petr Äech	3-4-3	Andre Marriner	Match Report	Arsenal
2	Sun Aug 27 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	16:00 (20:30)	Matchweek 3	Sun	Away	L		4	Liverpool	0.7	2.7	51	53206	Laurent Koscielny	3-4-3	Craig Pawson	Match Report	Arsenal
3	Sat Sep 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	15:00 (19:30)	Matchweek 4	Sat	Home	W	3		Bournemouth	1.5	0.7	58	59262	Laurent Koscielny	3-4-3	Anthony Taylor	Match Report	Arsenal
4	Sun Sep 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	13:30 (18:00)	Matchweek 5	Sun	Away	D			Chelsea	1	0.6	50	41478	Laurent Koscielny	3-4-3	Michael Oliver	Match Report	Arsenal
5	Mon Sep 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	20:00 (00:30)	Matchweek 6	Mon	Home	W	2		West Brom	2	1.2	68	59134	Laurent Koscielny	3-4-3	Robert Madley	Match Report	Arsenal
6	Sun Oct 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	12:00 (16:30)	Matchweek 7	Sun	Home	W	2		Brighton	2.4	0.7	65	59378	Petr Äech	3-4-3	Kevin Friend	Match Report	Arsenal
7	Sat Oct 14 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	17:30 (22:00)	Matchweek 8	Sat	Away	L	1	2	Watford	1	1.5	53	20384	Per Mertesacker	3-4-3	Niel Swarbrick	Match Report	Arsenal
8	Sun Oct 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	13:30 (18:00)	Matchweek 9	Sun	Away	W	5	2	Everton	3.2	1.3	67	39189	Per Mertesacker	3-4-3	Craig Pawson	Match Report	Arsenal
9	Sat Oct 28 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	15:00 (19:30)	Matchweek 10	Sat	Home	W	2	1	Swansea City	1.7	0.5	73	59493	Per Mertesacker	3-4-3	Lee Mason	Match Report	Arsenal


CREATE TABLE match_info (
  "unnamed_0" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" BIGINT,
  "ga" BIGINT,
  "opponent" VARCHAR,
  "xg" DOUBLE,
  "xga" DOUBLE,
  "poss" BIGINT,
  "attendance" DOUBLE,
  "captain" VARCHAR,
  "formation" VARCHAR,
  "referee" VARCHAR,
  "match_report" VARCHAR,
  "notes" VARCHAR,
  "team" VARCHAR
);