Name: All Premier League Matches 2010-2021
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

All Premier League Matches 2010-2021

Data for all English Premier League matches, collected via web scraping from the official Premier League website. There are 4,070 matches, from 2010 to 2021, with 113 stats features for each match and team performance throughout the season at the time of each match.
Ideal dataset for use in prediction models (winner of the match) or other scouts (Number of goals, cards, corners, etc.).

Tables

Df Full Premierleague

@kaggle.pablohfreitas_all_premier_league_matches_20102021.df_full_premierleague

671.69 KB
4070 rows
114 columns


CREATE TABLE df_full_premierleague (
  "unnamed_0" BIGINT,
  "link_match" VARCHAR,
  "season" VARCHAR,
  "date" TIMESTAMP,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "result_full" VARCHAR,
  "result_ht" VARCHAR,
  "home_clearances" DOUBLE,
  "home_corners" DOUBLE,
  "home_fouls_conceded" DOUBLE,
  "home_offsides" DOUBLE,
  "home_passes" DOUBLE,
  "home_possession" DOUBLE,
  "home_red_cards" DOUBLE,
  "home_shots" DOUBLE,
  "home_shots_on_target" DOUBLE,
  "home_tackles" DOUBLE,
  "home_touches" DOUBLE,
  "home_yellow_cards" DOUBLE,
  "away_clearances" DOUBLE,
  "away_corners" DOUBLE,
  "away_fouls_conceded" DOUBLE,
  "away_offsides" DOUBLE,
  "away_passes" DOUBLE,
  "away_possession" DOUBLE,
  "away_red_cards" DOUBLE,
  "away_shots" DOUBLE,
  "away_shots_on_target" DOUBLE,
  "away_tackles" DOUBLE,
  "away_touches" DOUBLE,
  "away_yellow_cards" DOUBLE,
  "goal_home_ft" BIGINT,
  "goal_away_ft" BIGINT,
  "sg_match_ft" BIGINT,
  "goal_home_ht" BIGINT,
  "goal_away_ht" BIGINT,
  "sg_match_ht" BIGINT,
  "clearances_avg_h" DOUBLE,
  "corners_avg_h" DOUBLE,
  "fouls_conceded_avg_h" DOUBLE,
  "offsides_avg_h" DOUBLE,
  "passes_avg_h" DOUBLE,
  "possession_avg_h" DOUBLE,
  "red_cards_avg_h" DOUBLE,
  "shots_avg_h" DOUBLE,
  "shots_on_target_avg_h" DOUBLE,
  "tackles_avg_h" DOUBLE,
  "touches_avg_h" DOUBLE,
  "yellow_cards_avg_h" DOUBLE,
  "goals_scored_ft_avg_h" DOUBLE,
  "goals_conced_ft_avg_h" DOUBLE,
  "sg_match_ft_acum_h" DOUBLE,
  "goals_scored_ht_avg_h" DOUBLE,
  "goals_conced_ht_avg_h" DOUBLE,
  "sg_match_ht_acum_h" DOUBLE,
  "performance_acum_h" DOUBLE,
  "clearances_avg_a" DOUBLE,
  "corners_avg_a" DOUBLE,
  "fouls_conceded_avg_a" DOUBLE,
  "offsides_avg_a" DOUBLE,
  "passes_avg_a" DOUBLE,
  "possession_avg_a" DOUBLE,
  "red_cards_avg_a" DOUBLE,
  "shots_avg_a" DOUBLE,
  "shots_on_target_avg_a" DOUBLE,
  "tackles_avg_a" DOUBLE,
  "touches_avg_a" DOUBLE,
  "yellow_cards_avg_a" DOUBLE,
  "goals_scored_ft_avg_a" DOUBLE,
  "goals_conced_ft_avg_a" DOUBLE,
  "sg_match_ft_acum_a" DOUBLE,
  "goals_scored_ht_avg_a" DOUBLE,
  "goals_conced_ht_avg_a" DOUBLE,
  "sg_match_ht_acum_a" DOUBLE,
  "performance_acum_a" DOUBLE,
  "clearances_avg_home" DOUBLE,
  "corners_avg_home" DOUBLE,
  "fouls_conceded_avg_home" DOUBLE,
  "offsides_avg_home" DOUBLE,
  "passes_avg_home" DOUBLE,
  "possession_avg_home" DOUBLE,
  "red_cards_avg_home" DOUBLE,
  "shots_avg_home" DOUBLE,
  "shots_on_target_avg_home" DOUBLE,
  "tackles_avg_home" DOUBLE,
  "touches_avg_home" DOUBLE,
  "yellow_cards_avg_home" DOUBLE,
  "goals_scored_ft_avg_home" DOUBLE,
  "goals_conced_ft_avg_home" DOUBLE,
  "sg_match_ft_acum_home" DOUBLE,
  "goals_scored_ht_avg_home" DOUBLE,
  "goals_conced_ht_avg_home" DOUBLE,
  "sg_match_ht_acum_home" DOUBLE,
  "performance_acum_home" DOUBLE,
  "clearances_avg_away" DOUBLE,
  "corners_avg_away" DOUBLE,
  "fouls_conceded_avg_away" DOUBLE,
  "offsides_avg_away" DOUBLE,
  "passes_avg_away" DOUBLE
);