English Premier League 2022-2023

Dataset of EPL 2022-2023

@kaggle.agarwalyashhh_english_premier_league_2022_2023

Table List

1 table(20.97 KB)

Epl Results 2022–23

@kaggle.agarwalyashhh_english_premier_league_2022_2023.epl_results_2022_23

20.97 KB
380 rows
23 columns

date Date	time Time	hometeam HomeTeam	awayteam AwayTeam	fthg FTHG	ftag FTAG	ftr FTR	hthg HTHG	htag HTAG	htr HTR	referee Referee	hs HS	as AS	hst HST	ast AST	hf HF	af AF	hc HC	ac AC	hy HY	ay AY
Fri Aug 05 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	20:00	Crystal Palace	Arsenal		2	A		1	A	A Taylor	10	10	2	2	16	11	3	5	1	2
Sat Aug 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	12:30	Fulham	Liverpool	2	2	D	1		H	A Madley	9	11	3	4	7	9	4	4	2
Sat Aug 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	15:00	Bournemouth	Aston Villa	2		H	1		H	P Bankes	7	15	3	2	18	16	5	5	3	3
Sat Aug 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	15:00	Leeds	Wolves	2	1	H	1	1	D	R Jones	12	15	4	6	13	9	6	4	2
Sat Aug 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	15:00	Newcastle	Nottingham	2		H			D	S Hooper	23	5	10		9	14	11	1		3
Sat Aug 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	15:00	Tottenham	Southampton	4	1	H	2	1	H	A Marriner	18	10	8	2	11	6	10	2	3
Sat Aug 06 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	17:30	Everton	Chelsea		1	A		1	A	C Pawson	8	15	4	6	14	11	4	16	3	2
Sun Aug 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	14:00	Leicester	Brentford	2	2	D	1		H	J Gillett	14	8	5	3	6	5	5	6
Sun Aug 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	14:00	Man United	Brighton	1	2	A		2	A	P Tierney	17	15	5	4	7	12	6	2	4	1
Sun Aug 07 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	16:30	West Ham	Man City		2	A		1	A	M Oliver	6	14	1	2	8	4	1	4		1


CREATE TABLE epl_results_2022_23 (
  "date" TIMESTAMP,
  "time" VARCHAR,
  "hometeam" VARCHAR,
  "awayteam" VARCHAR,
  "fthg" BIGINT,
  "ftag" BIGINT,
  "ftr" VARCHAR,
  "hthg" BIGINT,
  "htag" BIGINT,
  "htr" VARCHAR,
  "referee" VARCHAR,
  "hs" BIGINT,
  "as" BIGINT,
  "hst" BIGINT,
  "ast" BIGINT,
  "hf" BIGINT,
  "af" BIGINT,
  "hc" BIGINT,
  "ac" BIGINT,
  "hy" BIGINT,
  "ay" BIGINT,
  "hr" BIGINT,
  "ar" BIGINT
);