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

Passing Stats

@kaggle.aditya2803_premier_league_team_data.passing_stats

132.7 KB
2280 rows
33 columns

unnamed_0 Unnamed: 0	date Date	time Time	round Round	day Day	venue Venue	result Result	gf GF	ga GA	opponent Opponent	cmp Cmp	att Att	cmp_fbd6fd Cmp%	totdist TotDist	prgdist PrgDist	cmp_1 Cmp.1	att_1 Att.1	cmp_1_c8ea36 Cmp%.1	cmp_2 Cmp.2	att_2 Att.2	cmp_2_b6e57c Cmp%.2	cmp_3 Cmp.3	att_3 Att.3	cmp_3_98370a Cmp%.3	ast Ast	xa XA	kp KP	n_1_3 1/3	ppa PPA	crspa CrsPA	prog Prog	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	319	430	74.2	6264	2100	3	11	27.3	239	293	81.6	77	126	61.1		0.4	9	25	7	1	36	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	351	447	78.5	7285	2304	4	12	33.3	241	283	85.2	106	152	69.7	1	1.9	14	28	8	1	36	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	473	580	81.6	8722	3193	2	4	50	380	445	85.4	91	131	69.5	2	1.1	13	38	9	1	50	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	546	655	83.4	10863	3543	1	12	8.3	414	465	89	131	178	73.6	3	0.8	12	38	16	1	65	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	533	642	83	10302	3192	6	17	35.3	400	450	88.9	127	175	72.6		0.4	7	47	12	3	50	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	505	612	82.5	10497	3345	5	11	45.5	360	401	89.8	140	200	70	2	0.9	8	41	10	2	59	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	467	591	79	9061	3026	8	20	40	354	405	87.4	105	166	63.3	1	0.9	7	43	14	3	51	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	431	552	78.1	8581	3202	5	17	29.4	326	386	84.5	100	149	67.1	5	1.1	8	29	11	1	50	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	632	738	85.6	11052	3365	2	12	16.7	520	581	89.5	110	145	75.9	3	2.5	9	36	14	2	48	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	488	596	81.9	9273	2457	9	17	52.9	368	430	85.6	111	149	74.5		0.1	2	28	4		29	Match Report	Arsenal


CREATE TABLE passing_stats (
  "unnamed_0" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "round" VARCHAR,
  "day" VARCHAR,
  "venue" VARCHAR,
  "result" VARCHAR,
  "gf" BIGINT,
  "ga" BIGINT,
  "opponent" VARCHAR,
  "cmp" BIGINT,
  "att" BIGINT,
  "cmp_fbd6fd" DOUBLE,
  "totdist" BIGINT,
  "prgdist" BIGINT,
  "cmp_1" BIGINT,
  "att_1" BIGINT,
  "cmp_1_c8ea36" DOUBLE,
  "cmp_2" BIGINT,
  "att_2" BIGINT,
  "cmp_2_b6e57c" DOUBLE,
  "cmp_3" BIGINT,
  "att_3" BIGINT,
  "cmp_3_98370a" DOUBLE,
  "ast" BIGINT,
  "xa" DOUBLE,
  "kp" BIGINT,
  "n_1_3" BIGINT,
  "ppa" BIGINT,
  "crspa" BIGINT,
  "prog" BIGINT,
  "match_report" VARCHAR,
  "team" VARCHAR
);