Arsenal EPL (2017/18 - 2022/23)

Arsenal FC results and player statistics for the last 6 seasons.

@kaggle.rustemnagimov_arsenal_epl_dataset

Table List

3 tables(88.89 KB)

Goalkeepers

Matches

Players

Players

@kaggle.rustemnagimov_arsenal_epl_dataset.players

57.49 KB
2741 rows
28 columns

lastname LastName	firstname FirstName	date Date	start Start	pos Pos	min Min	g G	a A	s S	sot SoT	touches Touches	tackles Tackles	ints Ints	blocks Blocks	xg XG	npxg NpxG	xag XAG	passes Passes	passesa PassesA	prgpas PrgPas	carries Carries	prgcar PrgCar	line Line	c C
Aubameyang	Pierre-Emerick	Sun May 13 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	LW	66	1		1	1	36			2	0.8	0.8		18	31		24		Forward
Bellerin	Hector	Sun May 13 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	RB	90					62	1	1	2				42	47	3	25	2	Defender
Holding	Rob	Sun May 13 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	CB	90					75	2	1	4				54	63	8	42		Defender
Iwobi	Alex	Sun May 13 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	RM	71					55			1				47	52	4	43		Midfielder
Kolasinac	Sead	Sun May 13 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	LB	67			1		52	1	1		0.3	0.3		35	43	1	26	1	Defender
Lacazette	Alexandre	Sun May 13 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	FW	90			1	1	40		1		0.2	0.2		31	36	4	31	2	Forward
Mkhitaryan	Henrikh	Sun May 13 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	RW	90			2		60			2	0.1	0.1	0.2	33	49	5	48	1	Forward
Mustafi	Shkodran	Sun May 13 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	CB	90					67	1	3				0.3	43	48	3	40		Defender
Ramsey	Aaron	Sun May 13 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	LM	90		1	2	1	62	3					0.8	34	50	2	47	1	Midfielder	1
Xhaka	Granit	Sun May 13 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	CM	90			1		66	2		2				54	57	8	39		Midfielder


CREATE TABLE players (
  "lastname" VARCHAR,
  "firstname" VARCHAR,
  "date" TIMESTAMP,
  "start" BIGINT,
  "pos" VARCHAR,
  "min" DOUBLE,
  "g" DOUBLE,
  "a" DOUBLE,
  "pk" DOUBLE,
  "pka" DOUBLE,
  "s" DOUBLE,
  "sot" DOUBLE,
  "yk" DOUBLE,
  "rk" DOUBLE,
  "touches" DOUBLE,
  "tackles" DOUBLE,
  "ints" DOUBLE,
  "blocks" DOUBLE,
  "xg" DOUBLE,
  "npxg" DOUBLE,
  "xag" DOUBLE,
  "passes" DOUBLE,
  "passesa" DOUBLE,
  "prgpas" DOUBLE,
  "carries" DOUBLE,
  "prgcar" DOUBLE,
  "line" VARCHAR,
  "c" BIGINT
);