Premier League Matches 2014-2020

Premier League Match Data 2014-2020

@kaggle.sanjeetsinghnaik_premier_league_matches_20142020

Table List

8 tables(381.52 KB)

Prem2017

@kaggle.sanjeetsinghnaik_premier_league_matches_20142020.prem2017

38.51 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	home_team_second_yellow_cards Home Team Second Yellow Cards	home_team_red_cards Home Team Red 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
ARSENAL	LEICESTER CITY	4-3	2-2	9.9	7.7	5.2	70	30	9	10	27	8	9	21	85	18	30	9				3	3	6		4	31	64	18	24	12	1
WATFORD	LIVERPOOL	3-3	2-1	9	6.3	6.3	46	54	4	4	9	1	3	26	70	22	28	14				8	5	14	1	3	27	74	25	22	8	3
CHELSEA	BURNLEY	2-3	0-3	9.6	4.7	6.9	62	38	6	6	19	7	8	13	86	17	22	16	4	1	1	4	5	10	1	5	7	75	22	42	11	3
EVERTON	STOKE	1-0	1-0	3	7.2	6.2	62	38	3	4	9	2	6	24	79	19	43	13	1			6	1	9	2	7	27	72	25	24	10	1
WEST BROM	BOURNEMOUTH	1-0	1-0	3.6	6.9	5.6	29	71	9	6	16	1	8	30	65	12	26	15	3			2	2	9	5	2	14	86	18	17	3	1
SOUTHAMPTON	SWANSEA	0-0	0-0	2.8	6.1	6.4	60	40	16	2	29	11	13	26	83	17	11	10	2			2		4	2		15	78	18	38	13	1
CRYSTAL PALACE	HUDDERSFIELD	0-3	0-2	5.2	5.1	7.8	57	43	7	4	14	3	12	19	78	18	18	7	1			3	6	9		9	30	65	16	29	19	3
BRIGHTON	MAN CITY	0-2	0-0	4.3	5.3	7.1	22	78	2	2	6	2	3	18	61	13	39	6				5	4	14	5	10	17	90	13	8	9	2
NEWCASTLE	TOTTENHAM	0-2	0-0	4.6	5	7.3	27	73	4	2	6		5	26	64	16	29	6	1		1	5	6	18	7	7	26	89	15	22	10	2
MAN UTD	WEST HAM	4-0	1-0	6.5	8.3	4.8	55	45	8	5	21	8	11	21	85	23	19	19	2			6	1	9	2	1	13	80	13	26	7	2


CREATE TABLE prem2017 (
  "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
);