Premier League Matches 2014-2020

Premier League Match Data 2014-2020

@kaggle.sanjeetsinghnaik_premier_league_matches_20142020

Table List

8 tables(381.52 KB)

Prem2020

@kaggle.sanjeetsinghnaik_premier_league_matches_20142020.prem2020

38.36 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
FULHAM	ARSENAL	0-3	0-1	5.2	5.2	8.1	45	55	2	2	5	1	2	20	88	9	7	12	2	4	6	13	3	3	21	90	6	10	12	2
CRYSTAL PALACE	SOUTHAMPTON	1-0	1-0	3	5.8	6.5	30	70	2	3	5	1	7	33	51	27	22	14	2	3	5	9	1	3	32	79	30	13	11	1
LIVERPOOL	LEEDS UTD	4-3	3-2	9.1	6.8	5.8	48	52	3	6	22	13	9	34	76	15	11	9	1	1	3	6	2		25	76	10	34	6
WEST HAM	NEWCASTLE	0-2	0-0	5.3	5.6	6.7	58	42	5	3	15	7	8	17	83	16	16	13	2	7	2	15	6	7	10	78	22	27	7	2
WEST BROM	LEICESTER CITY	0-3	0-0	4.9	4.5	8.6	37	63	3	1	7	3	2	22	76	14	12	12	1	3	7	13	3	5	31	84	9	14	9	1
TOTTENHAM	EVERTON	0-1	0-0	3.8	6	7.2	51	49	1	5	9	3	5	34	85	18	17	15	1	7	4	15	4	3	17	85	15	35	7
SHEFFIELD UTD	WOLVES	0-2	0-2	4.7	5.6	6.9	55	45	5	2	9	2	12	23	81	31	10	13	2	5	4	11	2	5	19	78	27	30	7	1
BRIGHTON	CHELSEA	1-3	0-1	5.6	5.3	7.7	52	48	6	3	13	4	4	24	82	9	8	8	1	2	5	10	3	3	21	83	13	14	13
BURNLEY	MAN UTD	0-1	0-0	3.3	5.3	7	37	63	7		12	5	3	22	66	12	18	15	1	2	7	13	4	4	14	84	21	19	13	2
MAN CITY	ASTON VILLA	2-0	0-0	6	7.7	5	69	31	7	9	28	12	16	14	88	21	9	10		4	4	11	3	2	13	71	11	28	9	2


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