England Football Matches

Last 21,801 football matches from the main England Football Leagues

@kaggle.cuecacuela_england_football_matches

Table List

2 tables(538.67 KB)

England Football Dataset

@kaggle.cuecacuela_england_football_matches.england_football_dataset

260.8 KB
21894 rows
18 columns

tournament Tournament	home Home	away Away	time Time	date Date	ht_result Ht Result	at_result At Result
Premier League	Newcastle	Leicester	20:00:00	Mon May 22 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	Man City	Chelsea	16:00:00	Sun May 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	Brighton	Southampton	14:00:00	Sun May 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	West Ham	Leeds	13:30:00	Sun May 21 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	Nottm Forest	Arsenal	17:30:00	Sat May 20 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	Bournemouth	Man Utd	15:00:00	Sat May 20 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	Fulham	Crystal Palace	15:00:00	Sat May 20 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	Liverpool	Aston Villa	15:00:00	Sat May 20 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	Wolverhampton	Everton	15:00:00	Sat May 20 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	Tottenham	Brentford	12:30:00	Sat May 20 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW


CREATE TABLE england_football_dataset (
  "tournament" VARCHAR,
  "home" VARCHAR,
  "home_goal" DOUBLE,
  "away_goal" DOUBLE,
  "away" VARCHAR,
  "home_corner" DOUBLE,
  "away_corner" DOUBLE,
  "home_attack" DOUBLE,
  "away_attack" DOUBLE,
  "home_shots" DOUBLE,
  "away_shots" DOUBLE,
  "time" VARCHAR,
  "date" TIMESTAMP,
  "ht_diff" DOUBLE,
  "at_diff" DOUBLE,
  "ht_result" VARCHAR,
  "at_result" VARCHAR,
  "total_corners" DOUBLE
);