Premier League Matches 2014-2020

Premier League Match Data 2014-2020

@kaggle.sanjeetsinghnaik_premier_league_matches_20142020

Table List

8 tables(381.52 KB)

Prem2019

@kaggle.sanjeetsinghnaik_premier_league_matches_20142020.prem2019

38.44 KB
380 rows
35 columns

home_team Home Team	away_team Away Team	score Score	half_time_score Half Time Score	match_excitement Match Excitement	home_team_rating Home Team Rating	away_team_rating Away Team Rating	home_team_possession Home Team Possession %	away_team_possession Away Team Possession %	home_team_off_target_shots Home Team Off Target Shots	home_team_on_target_shots Home Team On Target Shots	home_team_total_shots Home Team Total Shots	home_team_blocked_shots Home Team Blocked Shots	home_team_corners Home Team Corners	home_team_throw_ins Home Team Throw Ins	home_team_pass_success Home Team Pass Success %	home_team_aerials_won Home Team Aerials Won	home_team_clearances Home Team Clearances	home_team_fouls Home Team Fouls	home_team_yellow_cards Home Team Yellow Cards	away_team_off_target_shots Away Team Off Target Shots	away_team_on_target_shots Away Team On Target Shots	away_team_total_shots Away Team Total Shots	away_team_blocked_shots Away Team Blocked Shots	away_team_corners Away Team Corners	away_team_throw_ins Away Team Throw Ins	away_team_pass_success Away Team Pass Success %	away_team_aerials_won Away Team Aerials Won	away_team_clearances Away Team Clearances	away_team_fouls Away Team Fouls	away_team_yellow_cards Away Team Yellow Cards	away_team_second_yellow_cards Away Team Second Yellow Cards
LIVERPOOL	NORWICH	4-1	4-0	7	7.8	4.8	58	42	5	7	15	3	11	18	81	15	5	9		6	5	12	1	2	28	77	7	35	9	2
WEST HAM	MAN CITY	0-5	0-1	6.5	4.1	8.8	43	57	2	3	5		1	22	81	17	9	6	2	3	9	14	2	1	14	87	17	13	13	2
BURNLEY	SOUTHAMPTON	3-0	0-0	4.3	7.1	5	46	54	4	4	10	2	2	36	56	25	13	6		5	3	11	3	7	34	64	22	18	12
CRYSTAL PALACE	EVERTON	0-0	0-0	2.2	6.1	6.3	35	65		2	6	4	6	30	60	30	21	16	2	3	3	10	4	2	39	80	18	18	14	2	1
WATFORD	BRIGHTON	0-3	0-1	4.4	5	7.6	48	52	4	3	11	4	5	26	78	14	10	15		2	3	5		2	19	79	19	24	11	1
BOURNEMOUTH	SHEFFIELD UTD	1-1	0-0	4.3	6.3	6.4	53	47	7	3	13	3	3	27	79	15	11	10	2	4	3	8	1	4	27	77	20	15	19	1
TOTTENHAM	ASTON VILLA	3-1	0-1	7.4	7.5	5.7	70	30	14	7	31	10	14	22	89	10	7	13	1	2	4	7	1		9	76	12	34	9
LEICESTER CITY	WOLVES	0-0	0-0	2.3	6.5	6.4	70	30	9	1	15	5	12	24	85	25	13	3		4	2	8	2	3	32	70	22	34	13	2
NEWCASTLE	ARSENAL	0-1	0-0	3.2	6.3	6.7	38	62	4	2	9	3	5	23	76	21	17	12	1	4	2	8	2	3	30	85	14	22	7	3
MAN UTD	CHELSEA	4-0	1-0	6.7	7.7	5	46	54	2	5	11	4	3	16	81	15	19	15	3	7	7	18	4	5	23	85	9	11	13	4


CREATE TABLE prem2019 (
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "score" VARCHAR,
  "half_time_score" VARCHAR,
  "match_excitement" DOUBLE,
  "home_team_rating" DOUBLE,
  "away_team_rating" DOUBLE,
  "home_team_possession" BIGINT,
  "away_team_possession" BIGINT,
  "home_team_off_target_shots" DOUBLE,
  "home_team_on_target_shots" DOUBLE,
  "home_team_total_shots" DOUBLE,
  "home_team_blocked_shots" DOUBLE,
  "home_team_corners" DOUBLE,
  "home_team_throw_ins" DOUBLE,
  "home_team_pass_success" DOUBLE,
  "home_team_aerials_won" DOUBLE,
  "home_team_clearances" DOUBLE,
  "home_team_fouls" DOUBLE,
  "home_team_yellow_cards" DOUBLE,
  "home_team_second_yellow_cards" DOUBLE,
  "home_team_red_cards" DOUBLE,
  "away_team_off_target_shots" DOUBLE,
  "away_team_on_target_shots" DOUBLE,
  "away_team_total_shots" DOUBLE,
  "away_team_blocked_shots" DOUBLE,
  "away_team_corners" DOUBLE,
  "away_team_throw_ins" DOUBLE,
  "away_team_pass_success" DOUBLE,
  "away_team_aerials_won" DOUBLE,
  "away_team_clearances" DOUBLE,
  "away_team_fouls" DOUBLE,
  "away_team_yellow_cards" DOUBLE,
  "away_team_second_yellow_cards" DOUBLE,
  "away_team_red_cards" DOUBLE
);