Name: Premier League 2020-21 Season Stats
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Premier League 2020-21 Season Stats

This dataset contains statistics of all the 38 matchdays played in the season 2020-21.
There are 3 files:
away_teams: This contains stats of the away team that played on a particular matchday.
home_teams: This contains stats of the home team that played on a particular matchday.
matchday_results: Contains the match result (goals scored) of both the teams that played.

This data was fetched with the help of Api-football-Beta api hosted on rapidapi.

Tables

Away Teams Stats

@kaggle.afnanurrahim_premier_league_2020_21_season_stats.away_teams_stats

26.39 kB
380 rows
20 columns

CREATE TABLE away_teams_stats (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "fixture_id" BIGINT,
  "away_team_id" BIGINT,
  "away_team_name" VARCHAR,
  "shots_on_goal" DOUBLE,
  "shots_off_goal" DOUBLE,
  "total_shots" BIGINT,
  "blocked_shots" DOUBLE,
  "shots_insidebox" DOUBLE,
  "shots_outsidebox" DOUBLE,
  "fouls" BIGINT,
  "corner_kicks" DOUBLE,
  "offsides" DOUBLE,
  "ball_possession" VARCHAR,
  "yellow_cards" DOUBLE,
  "red_cards" DOUBLE,
  "goalkeeper_saves" DOUBLE,
  "total_passes" BIGINT,
  "passes_accurate" BIGINT,
  "passes" VARCHAR  -- Passes %
);

Home Teams Stats

@kaggle.afnanurrahim_premier_league_2020_21_season_stats.home_teams_stats

26.5 kB
380 rows
20 columns

CREATE TABLE home_teams_stats (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "fixture_id" BIGINT,
  "home_team_id" BIGINT,
  "home_team_name" VARCHAR,
  "shots_on_goal" DOUBLE,
  "shots_off_goal" DOUBLE,
  "total_shots" BIGINT,
  "blocked_shots" DOUBLE,
  "shots_insidebox" DOUBLE,
  "shots_outsidebox" DOUBLE,
  "fouls" BIGINT,
  "corner_kicks" DOUBLE,
  "offsides" DOUBLE,
  "ball_possession" VARCHAR,
  "yellow_cards" DOUBLE,
  "red_cards" DOUBLE,
  "goalkeeper_saves" DOUBLE,
  "total_passes" BIGINT,
  "passes_accurate" BIGINT,
  "passes" VARCHAR  -- Passes %
);

Matchday Results

@kaggle.afnanurrahim_premier_league_2020_21_season_stats.matchday_results

17 kB
380 rows
11 columns

CREATE TABLE matchday_results (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "fixture_id" BIGINT,
  "fixture_date" VARCHAR,
  "teams_home_id" BIGINT,
  "teams_home_name" VARCHAR,
  "teams_home_winner" VARCHAR,
  "teams_away_id" BIGINT,
  "teams_away_name" VARCHAR,
  "teams_away_winner" VARCHAR,
  "goals_home" BIGINT,
  "goals_away" BIGINT
);