Premier League Matches 2014-2020
Premier League Match Data 2014-2020
@kaggle.sanjeetsinghnaik_premier_league_matches_20142020
Premier League Match Data 2014-2020
@kaggle.sanjeetsinghnaik_premier_league_matches_20142020
home_teamHome Team | away_teamAway Team | scoreScore | half_time_scoreHalf Time Score | match_excitementMatch Excitement | home_team_ratingHome Team Rating | away_team_ratingAway Team Rating | home_team_possessionHome Team Possession % | away_team_possessionAway Team Possession % | home_team_off_target_shotsHome Team Off Target Shots | home_team_on_target_shotsHome Team On Target Shots | home_team_total_shotsHome Team Total Shots | home_team_blocked_shotsHome Team Blocked Shots | home_team_cornersHome Team Corners | home_team_throw_insHome Team Throw Ins | home_team_pass_successHome Team Pass Success % | home_team_aerials_wonHome Team Aerials Won | home_team_clearancesHome Team Clearances | home_team_foulsHome Team Fouls | home_team_yellow_cardsHome Team Yellow Cards | home_team_second_yellow_cardsHome Team Second Yellow Cards | home_team_red_cardsHome Team Red Cards | away_team_off_target_shotsAway Team Off Target Shots | away_team_on_target_shotsAway Team On Target Shots | away_team_total_shotsAway Team Total Shots | away_team_blocked_shotsAway Team Blocked Shots | away_team_cornersAway Team Corners | away_team_throw_insAway Team Throw Ins | away_team_pass_successAway Team Pass Success % | away_team_aerials_wonAway Team Aerials Won | away_team_clearancesAway Team Clearances | away_team_foulsAway Team Fouls | away_team_yellow_cardsAway Team Yellow Cards | away_team_second_yellow_cardsAway Team Second Yellow Cards | away_team_red_cardsAway Team Red Cards |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MAN UTD | LEICESTER CITY | 2-1 | 1-0 | 6.4 | 7.4 | 5.6 | 46 | 54 | 1 | 6 | 8 | 1 | 2 | 20 | 82 | 10 | 37 | 11 | 2 | 3 | 4 | 13 | 6 | 5 | 18 | 83 | 13 | 14 | 8 | 1 | ||||
NEWCASTLE | TOTTENHAM | 1-2 | 1-2 | 6 | 5.8 | 7 | 40 | 60 | 8 | 2 | 15 | 5 | 3 | 36 | 69 | 33 | 17 | 11 | 2 | 7 | 5 | 15 | 3 | 5 | 24 | 82 | 21 | 43 | 12 | 2 | ||||
HUDDERSFIELD | CHELSEA | 0-3 | 0-2 | 5.5 | 5.1 | 8.2 | 37 | 63 | 4 | 1 | 6 | 1 | 2 | 23 | 76 | 22 | 13 | 9 | 2 | 3 | 4 | 13 | 6 | 5 | 30 | 88 | 17 | 21 | 8 | 1 | ||||
WATFORD | BRIGHTON | 2-0 | 1-0 | 4.1 | 6.7 | 5.5 | 53 | 47 | 9 | 5 | 19 | 5 | 8 | 16 | 75 | 16 | 11 | 10 | 2 | 5 | 6 | 1 | 2 | 19 | 77 | 24 | 26 | 16 | 2 | |||||
BOURNEMOUTH | CARDIFF | 2-0 | 1-0 | 4.5 | 6.9 | 5.2 | 63 | 37 | 6 | 4 | 12 | 2 | 7 | 31 | 79 | 32 | 37 | 11 | 1 | 5 | 1 | 10 | 4 | 4 | 20 | 61 | 31 | 30 | 9 | 1 | ||||
FULHAM | CRYSTAL PALACE | 0-2 | 0-1 | 5.4 | 5.7 | 7.8 | 66 | 34 | 4 | 6 | 15 | 5 | 5 | 16 | 88 | 10 | 22 | 9 | 1 | 10 | 12 | 2 | 5 | 25 | 74 | 20 | 30 | 11 | 2 | |||||
WOLVES | EVERTON | 2-2 | 1-1 | 7.2 | 6.1 | 6.4 | 57 | 43 | 5 | 4 | 11 | 2 | 3 | 31 | 83 | 21 | 23 | 8 | 3 | 5 | 8 | 6 | 19 | 75 | 24 | 28 | 7 | 1 | 1 | |||||
SOUTHAMPTON | BURNLEY | 0-0 | 0-0 | 3.3 | 6.1 | 6.4 | 48 | 52 | 6 | 3 | 18 | 9 | 8 | 23 | 76 | 25 | 31 | 10 | 6 | 6 | 16 | 4 | 5 | 15 | 76 | 28 | 35 | 9 | 1 | |||||
LIVERPOOL | WEST HAM | 4-0 | 2-0 | 6 | 8.5 | 4.9 | 65 | 35 | 7 | 8 | 18 | 3 | 5 | 12 | 90 | 7 | 8 | 14 | 1 | 2 | 2 | 5 | 1 | 4 | 19 | 83 | 10 | 20 | 9 | 2 | ||||
ARSENAL | MAN CITY | 0-2 | 0-1 | 4.9 | 5.4 | 7.4 | 42 | 58 | 4 | 3 | 9 | 2 | 2 | 16 | 80 | 14 | 23 | 11 | 2 | 5 | 8 | 17 | 4 | 9 | 20 | 84 | 8 | 9 | 14 | 2 |
CREATE TABLE prem2018 (
"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
);
Anyone who has the link will be able to view this.