Dataset: English Premier League Players Points

About this Dataset

English Premier League Players Points

This dataset contains data for each player in the current English premier league 2022-2023 season. the dataset contains all statistics for the player in each game they have participated in and the points they were awarded in the game. The columns are self-explanatory.

Tables

Points

@kaggle.enockmokua_english_premier_league_players_points.points

403.39 KB
10508 rows
38 columns


CREATE TABLE points (
  "id_player" BIGINT,
  "web_name" VARCHAR,
  "element" BIGINT,
  "fixture" BIGINT,
  "opponent_team" BIGINT,
  "total_points" BIGINT,
  "was_home" BOOLEAN,
  "kickoff_time" TIMESTAMP,
  "team_h_score" DOUBLE,
  "team_a_score" DOUBLE,
  "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,
  "starts" BIGINT,
  "expected_goals" DOUBLE,
  "expected_assists" DOUBLE,
  "expected_goal_involvements" DOUBLE,
  "expected_goals_conceded" DOUBLE,
  "value" BIGINT,
  "transfers_balance" BIGINT,
  "selected" BIGINT,
  "transfers_in" BIGINT,
  "transfers_out" BIGINT
);