Premier League Matches 2014-2020

Premier League Match Data 2014-2020

@kaggle.sanjeetsinghnaik_premier_league_matches_20142020

Table List

8 tables(381.52 KB)

Matchesall2014–2020

@kaggle.sanjeetsinghnaik_premier_league_matches_20142020.matchesall2014_2020

112.3 KB
2660 rows
41 columns

unnamed_0 Unnamed: 0	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	home_team_goals_scored Home Team Goals Scored	away_team_goals_scored Away Team Goals Scored	home_team_goals_conceeded Home Team Goals Conceeded	away_team_goals_conceeded Away Team Goals Conceeded	year Year
	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			1	2	2	1	2014
1	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			2	2	2	2	2014
2	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			2	2	2	2	2014
3	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		1	1		2014
4	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				1	1		2014
5	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				1	1		2014
6	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		2	1	1	2	2014
7	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			2	1	1	2	2014
8	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				2	2		2014
9	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			1	3	3	1	2014


CREATE TABLE matchesall2014_2020 (
  "unnamed_0" BIGINT,
  "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,
  "home_team_goals_scored" BIGINT,
  "away_team_goals_scored" BIGINT,
  "home_team_goals_conceeded" BIGINT,
  "away_team_goals_conceeded" BIGINT,
  "year" BIGINT
);