Dataset: All Football Players - Stats Per Season

About this Dataset

All Football Players - Stats Per Season

What is this data ?

This dataset contains about 300k rows. Each row corresponds to the performance of a player in a particular season of a tournament.

Points to note:

This contains data for ALL the official tournaments around the world. Most of them do not have all the data points (103) available, hence the histogram will show a heavy deviation towards NULL values.However, the most popular tournaments (CL, EPL, La Liga etc.) will have all of these data points populated accurately

Tables

Players Stats Per Season

@kaggle.sarangpurandare_83k_football_players_103_stats_per_season.players_stats_per_season

23.41 MB
343626 rows
116 columns


CREATE TABLE players_stats_per_season (
  "unnamed_0" BIGINT,
  "player_id" BIGINT,
  "tournament_id" BIGINT,
  "season_id" BIGINT,
  "totalrating" DOUBLE,
  "countrating" DOUBLE,
  "goals" DOUBLE,
  "assists" DOUBLE,
  "goalsassistssum" DOUBLE,
  "yellowcards" DOUBLE,
  "directredcards" DOUBLE,
  "redcards" DOUBLE,
  "minutesplayed" DOUBLE,
  "matchesstarted" DOUBLE,
  "scoringfrequency" DOUBLE,
  "yellowredcards" DOUBLE,
  "substitutionsin" DOUBLE,
  "substitutionsout" DOUBLE,
  "id" DOUBLE,
  "type" VARCHAR,
  "appearances" DOUBLE,
  "rating" DOUBLE,
  "bigchancescreated" DOUBLE,
  "bigchancesmissed" DOUBLE,
  "accuratepasses" DOUBLE,
  "inaccuratepasses" DOUBLE,
  "totalpasses" DOUBLE,
  "accuratepassespercentage" DOUBLE,
  "accurateownhalfpasses" DOUBLE,
  "accurateoppositionhalfpasses" DOUBLE,
  "accuratefinalthirdpasses" DOUBLE,
  "keypasses" DOUBLE,
  "successfuldribbles" DOUBLE,
  "successfuldribblespercentage" DOUBLE,
  "tackles" DOUBLE,
  "interceptions" DOUBLE,
  "accuratecrosses" DOUBLE,
  "accuratecrossespercentage" DOUBLE,
  "totalshots" DOUBLE,
  "shotsontarget" DOUBLE,
  "shotsofftarget" DOUBLE,
  "groundduelswon" DOUBLE,
  "groundduelswonpercentage" DOUBLE,
  "aerialduelswon" DOUBLE,
  "aerialduelswonpercentage" DOUBLE,
  "totalduelswon" DOUBLE,
  "totalduelswonpercentage" DOUBLE,
  "goalconversionpercentage" DOUBLE,
  "penaltiestaken" DOUBLE,
  "penaltygoals" DOUBLE,
  "penaltywon" DOUBLE,
  "penaltyconceded" DOUBLE,
  "shotfromsetpiece" DOUBLE,
  "freekickgoal" DOUBLE,
  "goalsfrominsidethebox" DOUBLE,
  "goalsfromoutsidethebox" DOUBLE,
  "headedgoals" DOUBLE,
  "leftfootgoals" DOUBLE,
  "rightfootgoals" DOUBLE,
  "accuratelongballs" DOUBLE,
  "accuratelongballspercentage" DOUBLE,
  "clearances" DOUBLE,
  "errorleadtogoal" DOUBLE,
  "errorleadtoshot" DOUBLE,
  "dispossessed" DOUBLE,
  "wasfouled" DOUBLE,
  "fouls" DOUBLE,
  "hitwoodwork" DOUBLE,
  "owngoals" DOUBLE,
  "dribbledpast" DOUBLE,
  "offsides" DOUBLE,
  "blockedshots" DOUBLE,
  "passtoassist" DOUBLE,
  "saves" DOUBLE,
  "cleansheet" DOUBLE,
  "penaltyfaced" DOUBLE,
  "penaltysave" DOUBLE,
  "savedshotsfrominsidethebox" DOUBLE,
  "savedshotsfromoutsidethebox" DOUBLE,
  "goalsconcededinsidethebox" DOUBLE,
  "goalsconcededoutsidethebox" DOUBLE,
  "punches" DOUBLE,
  "runsout" DOUBLE,
  "successfulrunsout" DOUBLE,
  "highclaims" DOUBLE,
  "crossesnotclaimed" DOUBLE,
  "penaltyconversion" DOUBLE,
  "setpiececonversion" DOUBLE,
  "totalattemptassist" DOUBLE,
  "totalcontest" DOUBLE,
  "totalcross" DOUBLE,
  "duellost" DOUBLE,
  "aeriallost" DOUBLE,
  "attemptpenaltymiss" DOUBLE,
  "attemptpenaltypost" DOUBLE,
  "attemptpenaltytarget" DOUBLE,
  "totallongballs" DOUBLE,
  "goalsconceded" DOUBLE,
  "savescaught" DOUBLE,
  "savesparried" DOUBLE
);

Player Id Mapping

@kaggle.sarangpurandare_83k_football_players_103_stats_per_season.player_id_mapping

2.08 MB
83483 rows
3 columns


CREATE TABLE player_id_mapping (
  "unnamed_0" BIGINT,
  "player_id" BIGINT,
  "player_name" VARCHAR
);

Season Mapping

@kaggle.sarangpurandare_83k_football_players_103_stats_per_season.season_mapping

20 KB
929 rows
3 columns


CREATE TABLE season_mapping (
  "unnamed_0" BIGINT,
  "season_id" BIGINT,
  "season_name" VARCHAR
);

Tournaments Mapping

@kaggle.sarangpurandare_83k_football_players_103_stats_per_season.tournaments_mapping

6.46 KB
175 rows
3 columns


CREATE TABLE tournaments_mapping (
  "unnamed_0" BIGINT,
  "tournament_name" VARCHAR,
  "tournament_id" BIGINT
);