Baselight

Premier League Matches 2014-2020

Premier League Match Data 2014-2020

@kaggle.sanjeetsinghnaik_premier_league_matches_20142020

Prem2018
@kaggle.sanjeetsinghnaik_premier_league_matches_20142020.prem2018

  • 38.52 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

home_team_red_cards

Home Team Red 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 UTDLEICESTER CITY2-11-06.47.45.6465416812208210371123413651883131481
NEWCASTLETOTTENHAM1-21-265.8740608215533669331711275153524822143122
HUDDERSFIELDCHELSEA0-30-25.55.18.237634161223762213923413653088172181
WATFORDBRIGHTON2-01-04.16.75.5534795195816751611102561219772426162
BOURNEMOUTHCARDIFF2-01-04.56.95.26337641227317932371115110442061313091
FULHAMCRYSTAL PALACE0-20-15.45.77.86634461555168810229110122525742030112
WOLVESEVERTON2-21-17.26.16.45743541123318321238358619752428711
SOUTHAMPTONBURNLEY0-00-03.36.16.4485263189823762531106616451576283591
LIVERPOOLWEST HAM4-02-068.54.96535781835129078141225141983102092
ARSENALMAN CITY0-20-14.95.47.442584392216801423112581749208489142

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
);