Premier League Matches 2014-2020

Premier League Match Data 2014-2020

@kaggle.sanjeetsinghnaik_premier_league_matches_20142020

Table List

8 tables(381.52 KB)

Prem2015

@kaggle.sanjeetsinghnaik_premier_league_matches_20142020.prem2015

38.29 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_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
MAN UTD	TOTTENHAM	1-0	1-0	3.1	6.8	6.4	50	50	4	1	9	4	1	25	82	8	30	12	2		2	4	9	3	2	24	80	11	20	12	3
EVERTON	WATFORD	2-2	0-1	7.4	6.1	6.9	67	33	3	5	10	2	8	30	81	20	25	7	1		3	5	11	3	2	14	70	29	53	13	2
NORWICH	CRYSTAL PALACE	1-3	0-1	6.6	5.2	7.4	63	37	9	6	17	2	1	23	83	10	26	14	1		2	7	11	2	4	19	74	8	34	20
LEICESTER CITY	SUNDERLAND	4-2	3-0	7.8	6.6	4.9	44	56	8	8	20	4	6	21	73	16	21	13	2		4	5	11	2	3	25	79	25	14	17	4
BOURNEMOUTH	ASTON VILLA	0-1	0-0	3.2	5.8	7.1	58	42	7	2	11	2	6	30	85	17	16	13	3		2	3	7	2	3	19	79	17	39	13	4
CHELSEA	SWANSEA	2-2	2-1	8.5	5.2	7.2	52	48	5	3	11	3	4	24	80	14	14	15	1	1	2	10	17	5	8	22	81	21	29	16	3
NEWCASTLE	SOUTHAMPTON	2-2	1-1	6.8	6.4	6.4	56	44	3	4	9	2	6	34	82	14	24	9	2		7	4	14	3	6	19	79	21	32	12	4
ARSENAL	WEST HAM	0-2	0-1	4.7	6	7.1	62	38	7	6	22	9	5	18	87	32	18	12	1		2	4	8	2	4	21	71	19	25	9	3
STOKE	LIVERPOOL	0-1	0-0	3.1	6	6.8	47	53	4	1	7	2	3	25	73	16	16	9	2		1	3	8	4	5	22	79	21	33	16	4
WEST BROM	MAN CITY	0-3	0-2	5.4	5.3	8.2	31	69	6	2	9	1	6	16	81	6	21	12	4		2	7	20	11	6	12	91	12	21	9	1


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