Premier League Matches 2014-2020

Premier League Match Data 2014-2020

@kaggle.sanjeetsinghnaik_premier_league_matches_20142020

Table List

8 tables(381.52 KB)

Prem2016

@kaggle.sanjeetsinghnaik_premier_league_matches_20142020.prem2016

38.57 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_red_cards Away Team Red Cards
HULL CITY	LEICESTER CITY	2-1	1-0	5.9	6.7	5.4	50	50	7	5	14	2	5	23	76	19	29	8	2	9	5	18	4	3	16	78	18	15	17	2
EVERTON	TOTTENHAM	1-1	1-0	4.9	7	6.4	42	58	4	6	12	2	5	21	73	16	40	10		4	4	13	5	6	42	80	10	22	14
MIDDLESBROUGH	STOKE	1-1	1-0	4.5	6.4	6.2	46	54	6	2	12	4	9	20	75	22	20	18	3	9	1	12	2	6	23	79	27	16	14	5
BURNLEY	SWANSEA	0-1	0-0	4	5.1	7.9	47	53	5	3	10	2	7	41	71	20	16	10	3	6	9	17	2	4	13	78	32	49	14	2
SOUTHAMPTON	WATFORD	1-1	0-1	4.6	7	6.1	64	36	10	6	24	8	6	25	85	9	21	8	1	4	1	5		2	12	69	19	36	12	2	1
CRYSTAL PALACE	WEST BROM	0-1	0-0	3.3	5.9	6.8	62	38	7	4	14	3	3	21	72	21	21	12	2	8	3	13	2	6	34	58	21	23	15	2
MAN CITY	SUNDERLAND	2-1	1-0	5.4	6.1	5.2	77	23	8	4	16	4	9	27	86	16	26	11	1	2	3	7	2	6	27	55	21	35	14	2
BOURNEMOUTH	MAN UTD	1-3	0-1	5.9	5.2	7.9	47	53	2	3	9	4	4	26	85	8	7	7		2	7	11	2	2	17	87	8	30	10	1
ARSENAL	LIVERPOOL	3-4	1-1	9.7	5.5	6.7	51	49	3	5	9	1	5	25	80	22	9	13	3	3	7	16	6	4	22	79	17	26	17	3
CHELSEA	WEST HAM	2-1	0-0	5.9	6.5	5.6	62	38	6	6	16	4	7	29	86	24	17	16	5	2	3	7	2	1	12	73	25	26	16	2


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