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

Miscellaneous Stats

@kaggle.aditya2803_premier_league_team_data.miscellaneous_stats

69.19 KB
2280 rows
28 columns

unnamed_0 Unnamed: 0	date Date	time Time	round Round	day Day	venue Venue	result Result	gf GF	ga GA	opponent Opponent	crdy CrdY	fls Fls	fld Fld	off Off	crs Crs	int Int	tklw TklW	pkwon PKwon	pkcon PKcon	recov Recov	won Won	lost Lost	won_27ea4a Won%	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		9	12	5	21	14	13			113	11	7	61.1	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		12	5	3	24	8	5			102	5	8	38.5	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	4	9	6	5	7	17	5			93	8	6	57.1	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		14	9	4	12	18	14			95	8	12	40	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	3	15	11	3	8	20	10			97	11	11	50	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	1	8	17		18	13	6	1		103	9	6	60	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		7	8	2	12	13	5			82	15	5	75	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		10	8		14	10	14		1	107	16	14	53.3	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	1	14	14	1	15	10	10			103	16	20	44.4	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		9	9	2	18	7	11			105	4	2	66.7	Match Report	Arsenal


CREATE TABLE miscellaneous_stats (
  "unnamed_0" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" BIGINT,
  "ga" BIGINT,
  "opponent" VARCHAR,
  "crdy" BIGINT,
  "crdr" BIGINT,
  "n_2crdy" BIGINT,
  "fls" BIGINT,
  "fld" BIGINT,
  "off" BIGINT,
  "crs" BIGINT,
  "int" BIGINT,
  "tklw" BIGINT,
  "pkwon" BIGINT,
  "pkcon" BIGINT,
  "og" BIGINT,
  "recov" BIGINT,
  "won" BIGINT,
  "lost" BIGINT,
  "won_27ea4a" DOUBLE,
  "match_report" VARCHAR,
  "team" VARCHAR
);