England Football Matches
Last 21,801 football matches from the main England Football Leagues
@kaggle.cuecacuela_england_football_matches
England Football Dataset
@kaggle.cuecacuela_england_football_matches.england_football_dataset
- 260.8 KB
- 21894 rows
- 18 columns
tournamentTournament | homeHome | home_goalHome Goal | away_goalAway Goal | awayAway | home_cornerHome Corner | away_cornerAway Corner | home_attackHome Attack | away_attackAway Attack | home_shotsHome Shots | away_shotsAway Shots | timeTime | dateDate | ht_diffHt Diff | at_diffAt Diff | ht_resultHt Result | at_resultAt Result | total_cornersTotal Corners |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 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
);