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

Shooting Stats

@kaggle.aditya2803_premier_league_team_data.shooting_stats

65.06 KB
2280 rows
26 columns

unnamed_0 Unnamed: 0	date Date	time Time	round Round	day Day	venue Venue	result Result	gf GF	ga GA	opponent Opponent	gls Gls	sh Sh	sot SoT	fk FK	sot_d2d6f4 SoT%	g_sh G/Sh	g_sot G/SoT	xg XG	npxg NpxG	npxg_sh NpxG/Sh	g_xg G-xG	np_g_xg Np:G-xG	match_report Match Report	team Team
	Sun Aug 12 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	16:00 (20:30)	Matchweek 1	Sun	Home	L		2	Manchester City		9	3		33.3			0.4	0.4	0.05	-0.4	-0.4	Match Report	Arsenal
1	Sat Aug 18 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	17:30 (22:00)	Matchweek 2	Sat	Away	L	2	3	Chelsea	2	16	6		37.5	0.13	0.33	2	2	0.13			Match Report	Arsenal
2	Sat Aug 25 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	15:00 (19:30)	Matchweek 3	Sat	Home	W	3	1	West Ham	2	18	10	1	55.6	0.11	0.2	1.7	1.7	0.09	0.3	0.3	Match Report	Arsenal
3	Sun Sep 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	13:30 (18:00)	Matchweek 4	Sun	Away	W	3	2	Cardiff City	3	17	11		64.7	0.18	0.27	1.8	1.8	0.11	1.2	1.2	Match Report	Arsenal
4	Sat Sep 15 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	15:00 (19:30)	Matchweek 5	Sat	Away	W	2	1	Newcastle Utd	2	11	2	1	18.2	0.18	1	0.7	0.7	0.06	1.3	1.3	Match Report	Arsenal
5	Sun Sep 23 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	16:00 (20:30)	Matchweek 6	Sun	Home	W	2		Everton	2	9	5		55.6	0.22	0.4	0.9	0.9	0.1	1.1	1.1	Match Report	Arsenal
6	Sat Sep 29 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	15:00 (19:30)	Matchweek 7	Sat	Home	W	2		Watford	1	9	2		22.2	0.11	0.5	1.4	1.4	0.16	-0.4	-0.4	Match Report	Arsenal
7	Sun Oct 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	12:00 (16:30)	Matchweek 8	Sun	Away	W	5	1	Fulham	5	9	7		77.8	0.56	0.71	1.1	1.1	0.13	3.9	3.9	Match Report	Arsenal
8	Mon Oct 22 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	20:00 (00:30)	Matchweek 9	Mon	Home	W	3	1	Leicester City	3	19	7	2	36.8	0.16	0.43	2.9	2.9	0.15	0.1	0.1	Match Report	Arsenal
9	Sun Oct 28 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	13:30 (19:00)	Matchweek 10	Sun	Away	D	2	2	Crystal Palace	2	7	2	2	28.6	0.29	1	0.6	0.6	0.09	1.4	1.4	Match Report	Arsenal


CREATE TABLE shooting_stats (
  "unnamed_0" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" BIGINT,
  "ga" BIGINT,
  "opponent" VARCHAR,
  "gls" BIGINT,
  "pk" BIGINT,
  "pkatt" BIGINT,
  "sh" BIGINT,
  "sot" BIGINT,
  "fk" BIGINT,
  "sot_d2d6f4" DOUBLE,
  "g_sh" DOUBLE,
  "g_sot" DOUBLE,
  "xg" DOUBLE,
  "npxg" DOUBLE,
  "npxg_sh" DOUBLE,
  "g_xg" DOUBLE,
  "np_g_xg" DOUBLE,
  "match_report" VARCHAR,
  "team" VARCHAR
);