Premier League Matches 2014-2020

Premier League Match Data 2014-2020

@kaggle.sanjeetsinghnaik_premier_league_matches_20142020

Table List

8 tables(381.52 KB)

Prem2014

@kaggle.sanjeetsinghnaik_premier_league_matches_20142020.prem2014

38.54 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	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	away_team_red_cards Away Team Red Cards
MAN UTD	SWANSEA	1-2	0-1	5.9	5.6	7.6	60	40	5	5	14	4	4	29	86	20	12	14	2			4	5	1		23	80	10	35	20	4
WEST BROM	SUNDERLAND	2-2	1-1	7.3	6.5	7.4	58	42	5	5	10		6	24	80	16	15	18	3		2	2	7	3	3	19	75	15	42	9	1
LEICESTER CITY	EVERTON	2-2	1-2	7	6.5	6.3	37	63	5	3	11	3	3	12	77	27	37	16	1		5	3	13	5	6	17	84	14	28	10	1
WEST HAM	TOTTENHAM	0-1	0-0	4.8	5.9	6.4	47	53	10	4	18	4	8	15	83	15	35	12	2	1	2	4	10	4	5	16	80	12	27	10			1
QPR	HULL CITY	0-1	0-0	3.8	5.7	6.6	51	49	7	6	19	6	8	22	77	30	40	10	1		3	4	11	4	9	26	76	15	56	10	2
STOKE	ASTON VILLA	0-1	0-0	2.8	6.5	7	63	37	4	2	12	6	2	36	84	30	43	14			4	1	7	2	8	35	68	9	26	9	3
ARSENAL	CRYSTAL PALACE	2-1	1-1	5.8	7.7	5.6	76	24	5	6	14	3	9	21	88	23	30	13	2			2	4	2	3	18	57	17	40	19	3	1
LIVERPOOL	SOUTHAMPTON	2-1	1-0	6	7.1	6.7	56	44	5	5	12	2	2	22	86	23	50	8	1		4	6	12	2	6	27	77	14	14	11	2
NEWCASTLE	MAN CITY	0-2	0-1	4.6	5.5	8.1	44	56	9		12	3	3	22	83	14	21	8	1		5	5	13	3	3	14	86	16	32	11	5
BURNLEY	CHELSEA	1-3	1-3	5.3	5.3	7.4	39	61	6	2	9	1	4	35	70	27	21	6	1		4	3	11	4	3	29	82	20	29	7	1


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