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

Goalkeeping Stats

@kaggle.aditya2803_premier_league_team_data.goalkeeping_stats

97.36 KB
2280 rows
34 columns

unnamed_0 Unnamed: 0	date Date	time Time	round Round	day Day	venue Venue	result Result	gf GF	ga GA	opponent Opponent	sota SoTA	ga_1 GA.1	saves Saves	save Save%	cs CS	psxg PSxG	psxg_3588aa PSxG+/-	cmp Cmp	att Att	cmp_fbd6fd Cmp%	att_1 Att.1	thr Thr	launch Launch%	avglen AvgLen	att_2 Att.2	launch_1 Launch%.1	avglen_1 AvgLen.1	opp Opp	stp Stp	stp_379866 Stp%	n__opa #OPA	avgdist AvgDist	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	4	3	1	0.25		3		1	2	50	11	1	18.2	31.1	2		32	18	1	5.6	2	23.3	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	4	1	3	0.75		1		1	1	100	14	4	7.1	26.9				8				17	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	10	4	6	0.6		3.2	-0.8	3	8	37.5	16	7	25	35.4	5	80	54.4	10	1	10	1	14.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	2		2	1	1	0.5	0.5	5	20	25	28	1	60.7	48.8	3	100	66	15			1	32.5	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	4		4	1	1	0.8	0.8	4	15	26.7	23	6	56.5	45.3	3	66.7	55.7	9	3	33.3		15.6	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		2	1	1	1	1	4	6	66.7	17	5	23.5	31.6	3	66.7	53.3	4	1	25		15.7	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	1		1	1	1			3	7	42.9	13	3	23.1	32.8	4	100	74	11			1	19.8	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	2				1.6	-0.4	8	19	42.1	20	4	70	48.8	5	100	68	14	2	14.3	1	14.4	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	0.3329999999999999		1.4	-0.6	3	13	23.1	24	4	37.5	40.1	6	66.7	52.3	8				12.7	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	2	1	1	0.5		0.6	-0.4	3	4	75	15	7	26.7	32.7				3	1	33.3	2	19.1	Match Report	Arsenal


CREATE TABLE goalkeeping_stats (
  "unnamed_0" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" BIGINT,
  "ga" BIGINT,
  "opponent" VARCHAR,
  "sota" BIGINT,
  "ga_1" BIGINT,
  "saves" BIGINT,
  "save" DOUBLE,
  "cs" BIGINT,
  "psxg" DOUBLE,
  "psxg_3588aa" DOUBLE,
  "cmp" BIGINT,
  "att" BIGINT,
  "cmp_fbd6fd" DOUBLE,
  "att_1" BIGINT,
  "thr" BIGINT,
  "launch" DOUBLE,
  "avglen" DOUBLE,
  "att_2" BIGINT,
  "launch_1" DOUBLE,
  "avglen_1" DOUBLE,
  "opp" BIGINT,
  "stp" BIGINT,
  "stp_379866" DOUBLE,
  "n__opa" BIGINT,
  "avgdist" DOUBLE,
  "match_report" VARCHAR,
  "team" VARCHAR
);