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)

Br Football Dataset

@kaggle.cuecacuela_england_football_matches.br_football_dataset

277.87 KB
23408 rows
18 columns

tournament Tournament	home Home	away Away	time Time	date Date	ht_result Ht Result	at_result At Result
Premier League	Wolverhampton	Man Utd	20:15:00	Thu Feb 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	West Ham	Bournemouth	19:30:00	Thu Feb 01 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	Liverpool	Chelsea	20:15:00	Wed Jan 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	Tottenham	Brentford	19:30:00	Wed Jan 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	Man City	Burnley	19:30:00	Wed Jan 31 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	Aston Villa	Newcastle	20:15:00	Tue Jan 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	Crystal Palace	Sheff Utd	20:00:00	Tue Jan 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	Fulham	Everton	19:45:00	Tue Jan 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	Luton	Brighton	19:45:00	Tue Jan 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW
Premier League	Nottm Forest	Arsenal	19:30:00	Tue Jan 30 2024 00:00:00 GMT+0000 (Coordinated Universal Time)	DRAW	DRAW


CREATE TABLE br_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
);