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

Goalkeepers

@kaggle.rustemnagimov_arsenal_epl_dataset.goalkeepers

18.07 KB
218 rows
19 columns

lastname LastName	firstname FirstName	date Date	start Start	pos Pos	min Min	sota SoTA	ga GA	saves Saves	psxg PSxG	pkatt PKatt	pka PKA	passatt PassAtt	throws Throws	avglen AvgLen	gkatt GKAtt	gkavglen GKAvgLen	c C
Ospina	David	Sun May 13 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	GK	90	3		3	0.4			39	8	31.9	9	48.2
Cech	Petr	Wed May 09 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	GK	90	10	3	7	3.2	1	1	26	7	34.5	11	66	1
Cech	Petr	Sun May 06 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	GK	90	2		2	0.2			31	8	32.4	2	56	1
Ospina	David	Sun Apr 29 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	GK	90	2	2		1.3			15	4	41.1	5	49
Ospina	David	Sun Apr 22 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	GK	90	4	1	3	0.6			24	6	20.8	4	44.3
Cech	Petr	Sun Apr 15 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	GK	90	4	2	2	0.6			28	6	26.3	6	34	1
Cech	Petr	Sun Apr 08 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	GK	90	7	2	5	2.6			17	9	33.5	6	52.8	1
Ospina	David	Sun Apr 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	GK	90	2		2	0.1			30	6	26.3	7	48
Cech	Petr	Sun Mar 11 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	GK	90	4		3	1.8	1		17	7	32.9	11	45.1	1
Cech	Petr	Sun Mar 04 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	1	GK	90	6	2	4	0.9			31	7	35.8	7	43.9


CREATE TABLE goalkeepers (
  "lastname" VARCHAR,
  "firstname" VARCHAR,
  "date" TIMESTAMP,
  "start" BIGINT,
  "pos" VARCHAR,
  "min" DOUBLE,
  "sota" DOUBLE,
  "ga" DOUBLE,
  "saves" DOUBLE,
  "psxg" DOUBLE,
  "pkatt" DOUBLE,
  "pka" DOUBLE,
  "pkm" DOUBLE,
  "passatt" DOUBLE,
  "throws" DOUBLE,
  "avglen" DOUBLE,
  "gkatt" DOUBLE,
  "gkavglen" DOUBLE,
  "c" BIGINT
);