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

Matches

@kaggle.rustemnagimov_arsenal_epl_dataset.matches

13.33 KB
214 rows
12 columns

season Season	tour Tour	date Date	time Time	opponent Opponent	hoaw HoAw	arsenalscore ArsenalScore	opponentscore OpponentScore	stadium Stadium	attendance Attendance	coach Coach	referee Referee
2017/18	1	Fri Aug 11 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	20:45:00	Leicester	home	4	3	Emirates Stadium	59387	Arsène Wenger	Mike Dean
2017/18	2	Sat Aug 19 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	18:30:00	Stoke City	away		1	bet365 Stadium	29459	Arsène Wenger	Andre Marriner
2017/18	3	Sun Aug 27 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	17:00:00	Liverpool	away		4	Anfield	53206	Arsène Wenger	Craig Pawson
2017/18	4	Sat Sep 09 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	16:00:00	Bournemouth	home	3		Emirates Stadium	59262	Arsène Wenger	Anthony Taylor
2017/18	5	Sun Sep 17 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	14:30:00	Chelsea	away			Stamford Bridge	41478	Arsène Wenger	Michael Oliver
2017/18	6	Mon Sep 25 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	21:00:00	West Brom	home	2		Emirates Stadium	59134	Arsène Wenger	Bobby Madley
2017/18	7	Sun Oct 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	13:00:00	Brighton	home	2		Emirates Stadium	59378	Arsène Wenger	Kevin Friend
2017/18	8	Sat Oct 14 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	18:30:00	Watford	away	1	2	Vicarage Road	20384	Arsène Wenger	Neil Swarbrick
2017/18	9	Sun Oct 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	14:30:00	Everton	away	5	2	Goodison Park	39189	Arsène Wenger	Craig Pawson
2017/18	10	Sat Oct 28 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	16:00:00	Swansea	home	2	1	Emirates Stadium	59493	Arsène Wenger	Lee Mason


CREATE TABLE matches (
  "season" VARCHAR,
  "tour" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "opponent" VARCHAR,
  "hoaw" VARCHAR,
  "arsenalscore" BIGINT,
  "opponentscore" BIGINT,
  "stadium" VARCHAR,
  "attendance" BIGINT,
  "coach" VARCHAR,
  "referee" VARCHAR
);