Premier League

All matches from Season 1993-1994 up to date

@kaggle.ajaxianazarenka_premier_league

Table List

1 table(369.92 KB)

Premierleague

@kaggle.ajaxianazarenka_premier_league.premierleague

369.92 KB
11979 rows
43 columns

matchid MatchID	season Season	matchweek MatchWeek	date Date	time Time	hometeam HomeTeam	awayteam AwayTeam	fulltimehometeamgoals FullTimeHomeTeamGoals	fulltimeawayteamgoals FullTimeAwayTeamGoals	fulltimeresult FullTimeResult	halftimeresult HalfTimeResult	referee Referee	hometeampoints HomeTeamPoints	awayteampoints AwayTeamPoints
1993-1994_Arsenal_Coventry	1993-1994	1	Sat Aug 14 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	Arsenal	Coventry		3	A	nan	nan		3
1993-1994_Aston Villa_QPR	1993-1994	1	Sat Aug 14 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	Aston Villa	QPR	4	1	H	nan	nan	3
1993-1994_Chelsea_Blackburn	1993-1994	1	Sat Aug 14 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	Chelsea	Blackburn	1	2	A	nan	nan		3
1993-1994_Liverpool_Sheffield Weds	1993-1994	1	Sat Aug 14 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	Liverpool	Sheffield Weds	2		H	nan	nan	3
1993-1994_Man City_Leeds	1993-1994	1	Sat Aug 14 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	Man City	Leeds	1	1	D	nan	nan	1	1
1993-1994_Newcastle_Tottenham	1993-1994	1	Sat Aug 14 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	Newcastle	Tottenham		1	A	nan	nan		3
1993-1994_Oldham_Ipswich	1993-1994	1	Sat Aug 14 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	Oldham	Ipswich		3	A	nan	nan		3
1993-1994_Sheffield United_Swindon	1993-1994	1	Sat Aug 14 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	Sheffield United	Swindon	3	1	H	nan	nan	3
1993-1994_Southampton_Everton	1993-1994	1	Sat Aug 14 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	Southampton	Everton		2	A	nan	nan		3
1993-1994_West Ham_Wimbledon	1993-1994	1	Sat Aug 14 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	West Ham	Wimbledon		2	A	nan	nan		3


CREATE TABLE premierleague (
  "matchid" VARCHAR,
  "season" VARCHAR,
  "matchweek" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "hometeam" VARCHAR,
  "awayteam" VARCHAR,
  "fulltimehometeamgoals" BIGINT,
  "fulltimeawayteamgoals" BIGINT,
  "fulltimeresult" VARCHAR,
  "halftimehometeamgoals" DOUBLE,
  "halftimeawayteamgoals" DOUBLE,
  "halftimeresult" VARCHAR,
  "referee" VARCHAR,
  "hometeamshots" DOUBLE,
  "awayteamshots" DOUBLE,
  "hometeamshotsontarget" DOUBLE,
  "awayteamshotsontarget" DOUBLE,
  "hometeamcorners" DOUBLE,
  "awayteamcorners" DOUBLE,
  "hometeamfouls" DOUBLE,
  "awayteamfouls" DOUBLE,
  "hometeamyellowcards" DOUBLE,
  "awayteamyellowcards" DOUBLE,
  "hometeamredcards" DOUBLE,
  "awayteamredcards" DOUBLE,
  "b365hometeam" DOUBLE,
  "b365draw" DOUBLE,
  "b365awayteam" DOUBLE,
  "b365over2_5goals" DOUBLE,
  "b365under2_5goals" DOUBLE,
  "marketmaxhometeam" DOUBLE,
  "marketmaxdraw" DOUBLE,
  "marketmaxawayteam" DOUBLE,
  "marketavghometeam" DOUBLE,
  "marketavgdraw" DOUBLE,
  "marketavgawayteam" DOUBLE,
  "marketmaxover2_5goals" DOUBLE,
  "marketmaxunder2_5goals" DOUBLE,
  "marketavgover2_5goals" DOUBLE,
  "marketavgunder2_5goals" DOUBLE,
  "hometeampoints" BIGINT,
  "awayteampoints" BIGINT
);