Name: EPL 2022: Player Statistics (historic & Current)
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

EPL 2022: Player Statistics (historic & Current)

Data obtain through API calls to EPL website (https://fantasy.premierleague.com/api/)

This data focuses on player statistics with game, team and fantasy points information
Data is obtained and refreshed via this kaggle notebook

Tables

Player Current Stats

@kaggle.slythe_epl_2022_player_statistics_historic_current.player_current_stats

147.75 KB
3579 rows
37 columns


CREATE TABLE player_current_stats (
  "unnamed_0" BIGINT,
  "playerid" BIGINT,
  "fixture" BIGINT,
  "opponent_team" BIGINT,
  "total_points" BIGINT,
  "was_home" BOOLEAN,
  "kickoff_time" VARCHAR,
  "team_h_score" BIGINT,
  "team_a_score" BIGINT,
  "round" BIGINT,
  "minutes" BIGINT,
  "goals_scored" BIGINT,
  "assists" BIGINT,
  "clean_sheets" BIGINT,
  "goals_conceded" BIGINT,
  "own_goals" BIGINT,
  "penalties_saved" BIGINT,
  "penalties_missed" BIGINT,
  "yellow_cards" BIGINT,
  "red_cards" BIGINT,
  "saves" BIGINT,
  "bonus" BIGINT,
  "bps" BIGINT,
  "influence" DOUBLE,
  "creativity" DOUBLE,
  "threat" DOUBLE,
  "ict_index" DOUBLE,
  "value" BIGINT,
  "transfers_balance" BIGINT,
  "selected" BIGINT,
  "transfers_in" BIGINT,
  "transfers_out" BIGINT,
  "first_name" VARCHAR,
  "second_name" VARCHAR,
  "opponent_team_name" VARCHAR,
  "team" BIGINT,
  "positionid" BIGINT
);

Player Hist Stats

@kaggle.slythe_epl_2022_player_statistics_historic_current.player_hist_stats

98.43 KB
2151 rows
26 columns


CREATE TABLE player_hist_stats (
  "unnamed_0" BIGINT,
  "season_name" VARCHAR,
  "element_code" DOUBLE,
  "start_cost" DOUBLE,
  "end_cost" DOUBLE,
  "total_points" DOUBLE,
  "minutes" DOUBLE,
  "goals_scored" DOUBLE,
  "assists" DOUBLE,
  "clean_sheets" DOUBLE,
  "goals_conceded" DOUBLE,
  "own_goals" DOUBLE,
  "penalties_saved" DOUBLE,
  "penalties_missed" DOUBLE,
  "yellow_cards" DOUBLE,
  "red_cards" DOUBLE,
  "saves" DOUBLE,
  "bonus" DOUBLE,
  "bps" DOUBLE,
  "influence" DOUBLE,
  "creativity" DOUBLE,
  "threat" DOUBLE,
  "ict_index" DOUBLE,
  "playerid" BIGINT,
  "first_name" VARCHAR,
  "second_name" VARCHAR
);

Player Upcoming Fixtures

@kaggle.slythe_epl_2022_player_statistics_historic_current.player_upcoming_fixtures

33.51 KB
19968 rows
17 columns


CREATE TABLE player_upcoming_fixtures (
  "unnamed_0" BIGINT,
  "id" BIGINT,
  "code" BIGINT,
  "team_h" BIGINT,
  "team_h_score" VARCHAR,
  "team_a" BIGINT,
  "team_a_score" VARCHAR,
  "event" DOUBLE,
  "finished" BOOLEAN,
  "minutes" BIGINT,
  "provisional_start_time" BOOLEAN,
  "kickoff_time" VARCHAR,
  "event_name" VARCHAR,
  "is_home" BOOLEAN,
  "difficulty" BIGINT,
  "team_h_name" VARCHAR,
  "team_a_name" VARCHAR
);

Teams

@kaggle.slythe_epl_2022_player_statistics_historic_current.teams

15.97 KB
20 rows
22 columns


CREATE TABLE teams (
  "unnamed_0" BIGINT,
  "code" BIGINT,
  "draw" BIGINT,
  "form" VARCHAR,
  "id" BIGINT,
  "loss" BIGINT,
  "name" VARCHAR,
  "played" BIGINT,
  "points" BIGINT,
  "position" BIGINT,
  "short_name" VARCHAR,
  "strength" BIGINT,
  "team_division" VARCHAR,
  "unavailable" BOOLEAN,
  "win" BIGINT,
  "strength_overall_home" BIGINT,
  "strength_overall_away" BIGINT,
  "strength_attack_home" BIGINT,
  "strength_attack_away" BIGINT,
  "strength_defence_home" BIGINT,
  "strength_defence_away" BIGINT,
  "pulse_id" BIGINT
);