FIFA 20 Complete Player Dataset
18k+ players, 100+ attributes extracted from the latest edition of FIFA
@kaggle.stefanoleone992_fifa_20_complete_player_dataset
18k+ players, 100+ attributes extracted from the latest edition of FIFA
@kaggle.stefanoleone992_fifa_20_complete_player_dataset
The most up-to-date FIFA dataset is available here.
The datasets provided include the players data for the Career Mode from FIFA 15 to FIFA 20 ("players_20.csv"). The data allows multiple comparison of the same players across the last 6 version of the videogame.
Some ideas of possible analysis:
Historical comparison between Messi and Ronaldo (what skill attributes changed the most during time - compared to real-life stats);
Ideal budget to create a competitive team (at the level of top n teams in Europe) and at which point the budget does not allow to buy significantly better players for the 11-men lineup. An extra is the same comparison with the Potential attribute for the lineup instead of the Overall attribute;
Sample analysis of top n% players (e.g. top 5% of the player) to see if some important attributes as Agility or BallControl or Strength have been popular or not acroos the FIFA versions. An example would be seeing that the top 5% players of FIFA 20 are more fast (higher Acceleration and Agility) compared to FIFA 15. The trend of attributes is also an important indication of how some attributes are necessary for players to win games (a version with more top 5% players with high BallControl stats would indicate that the game is more focused on the technique rather than the physicial aspect).
Feel free to use the available dataset the way you prefer and do not hesitate to flag additional files (player images - datasets prior FIFA 15) that could be implemented to the existing CSV files.
Updated dataset available here:
https://www.kaggle.com/stefanoleone992/fifa-21-complete-player-dataset
Data has been scraped from the publicly available website https://sofifa.com.
CREATE TABLE players_15 (
"sofifa_id" BIGINT,
"player_url" VARCHAR,
"short_name" VARCHAR,
"long_name" VARCHAR,
"age" BIGINT,
"dob" TIMESTAMP,
"height_cm" BIGINT,
"weight_kg" BIGINT,
"nationality" VARCHAR,
"club" VARCHAR,
"overall" BIGINT,
"potential" BIGINT,
"value_eur" BIGINT,
"wage_eur" BIGINT,
"player_positions" VARCHAR,
"preferred_foot" VARCHAR,
"international_reputation" BIGINT,
"weak_foot" BIGINT,
"skill_moves" BIGINT,
"work_rate" VARCHAR,
"body_type" VARCHAR,
"real_face" VARCHAR,
"release_clause_eur" VARCHAR,
"player_tags" VARCHAR,
"team_position" VARCHAR,
"team_jersey_number" DOUBLE,
"loaned_from" VARCHAR,
"joined" TIMESTAMP,
"contract_valid_until" DOUBLE,
"nation_position" VARCHAR,
"nation_jersey_number" DOUBLE,
"pace" DOUBLE,
"shooting" DOUBLE,
"passing" DOUBLE,
"dribbling" DOUBLE,
"defending" DOUBLE,
"physic" DOUBLE,
"gk_diving" DOUBLE,
"gk_handling" DOUBLE,
"gk_kicking" DOUBLE,
"gk_reflexes" DOUBLE,
"gk_speed" DOUBLE,
"gk_positioning" DOUBLE,
"player_traits" VARCHAR,
"attacking_crossing" VARCHAR,
"attacking_finishing" VARCHAR,
"attacking_heading_accuracy" VARCHAR,
"attacking_short_passing" VARCHAR,
"attacking_volleys" VARCHAR,
"skill_dribbling" VARCHAR,
"skill_curve" VARCHAR,
"skill_fk_accuracy" VARCHAR,
"skill_long_passing" VARCHAR,
"skill_ball_control" VARCHAR,
"movement_acceleration" VARCHAR,
"movement_sprint_speed" VARCHAR,
"movement_agility" VARCHAR,
"movement_reactions" VARCHAR,
"movement_balance" VARCHAR,
"power_shot_power" VARCHAR,
"power_jumping" VARCHAR,
"power_stamina" VARCHAR,
"power_strength" VARCHAR,
"power_long_shots" VARCHAR,
"mentality_aggression" VARCHAR,
"mentality_interceptions" VARCHAR,
"mentality_positioning" VARCHAR,
"mentality_vision" VARCHAR,
"mentality_penalties" VARCHAR,
"mentality_composure" VARCHAR,
"defending_marking" VARCHAR,
"defending_standing_tackle" VARCHAR,
"defending_sliding_tackle" VARCHAR,
"goalkeeping_diving" VARCHAR,
"goalkeeping_handling" VARCHAR,
"goalkeeping_kicking" VARCHAR,
"goalkeeping_positioning" VARCHAR,
"goalkeeping_reflexes" VARCHAR,
"ls" VARCHAR,
"st" VARCHAR,
"rs" VARCHAR,
"lw" VARCHAR,
"lf" VARCHAR,
"cf" VARCHAR,
"rf" VARCHAR,
"rw" VARCHAR,
"lam" VARCHAR,
"cam" VARCHAR,
"ram" VARCHAR,
"lm" VARCHAR,
"lcm" VARCHAR,
"cm" VARCHAR,
"rcm" VARCHAR,
"rm" VARCHAR,
"lwb" VARCHAR,
"ldm" VARCHAR,
"cdm" VARCHAR,
"rdm" VARCHAR,
"rwb" VARCHAR,
"lb" VARCHAR
);CREATE TABLE players_16 (
"sofifa_id" BIGINT,
"player_url" VARCHAR,
"short_name" VARCHAR,
"long_name" VARCHAR,
"age" BIGINT,
"dob" TIMESTAMP,
"height_cm" BIGINT,
"weight_kg" BIGINT,
"nationality" VARCHAR,
"club" VARCHAR,
"overall" BIGINT,
"potential" BIGINT,
"value_eur" BIGINT,
"wage_eur" BIGINT,
"player_positions" VARCHAR,
"preferred_foot" VARCHAR,
"international_reputation" BIGINT,
"weak_foot" BIGINT,
"skill_moves" BIGINT,
"work_rate" VARCHAR,
"body_type" VARCHAR,
"real_face" VARCHAR,
"release_clause_eur" VARCHAR,
"player_tags" VARCHAR,
"team_position" VARCHAR,
"team_jersey_number" DOUBLE,
"loaned_from" VARCHAR,
"joined" TIMESTAMP,
"contract_valid_until" DOUBLE,
"nation_position" VARCHAR,
"nation_jersey_number" DOUBLE,
"pace" DOUBLE,
"shooting" DOUBLE,
"passing" DOUBLE,
"dribbling" DOUBLE,
"defending" DOUBLE,
"physic" DOUBLE,
"gk_diving" DOUBLE,
"gk_handling" DOUBLE,
"gk_kicking" DOUBLE,
"gk_reflexes" DOUBLE,
"gk_speed" DOUBLE,
"gk_positioning" DOUBLE,
"player_traits" VARCHAR,
"attacking_crossing" VARCHAR,
"attacking_finishing" VARCHAR,
"attacking_heading_accuracy" VARCHAR,
"attacking_short_passing" VARCHAR,
"attacking_volleys" VARCHAR,
"skill_dribbling" VARCHAR,
"skill_curve" VARCHAR,
"skill_fk_accuracy" VARCHAR,
"skill_long_passing" VARCHAR,
"skill_ball_control" VARCHAR,
"movement_acceleration" VARCHAR,
"movement_sprint_speed" VARCHAR,
"movement_agility" VARCHAR,
"movement_reactions" VARCHAR,
"movement_balance" VARCHAR,
"power_shot_power" VARCHAR,
"power_jumping" VARCHAR,
"power_stamina" VARCHAR,
"power_strength" VARCHAR,
"power_long_shots" VARCHAR,
"mentality_aggression" VARCHAR,
"mentality_interceptions" VARCHAR,
"mentality_positioning" VARCHAR,
"mentality_vision" VARCHAR,
"mentality_penalties" VARCHAR,
"mentality_composure" VARCHAR,
"defending_marking" VARCHAR,
"defending_standing_tackle" VARCHAR,
"defending_sliding_tackle" VARCHAR,
"goalkeeping_diving" VARCHAR,
"goalkeeping_handling" VARCHAR,
"goalkeeping_kicking" VARCHAR,
"goalkeeping_positioning" VARCHAR,
"goalkeeping_reflexes" VARCHAR,
"ls" VARCHAR,
"st" VARCHAR,
"rs" VARCHAR,
"lw" VARCHAR,
"lf" VARCHAR,
"cf" VARCHAR,
"rf" VARCHAR,
"rw" VARCHAR,
"lam" VARCHAR,
"cam" VARCHAR,
"ram" VARCHAR,
"lm" VARCHAR,
"lcm" VARCHAR,
"cm" VARCHAR,
"rcm" VARCHAR,
"rm" VARCHAR,
"lwb" VARCHAR,
"ldm" VARCHAR,
"cdm" VARCHAR,
"rdm" VARCHAR,
"rwb" VARCHAR,
"lb" VARCHAR
);CREATE TABLE players_17 (
"sofifa_id" BIGINT,
"player_url" VARCHAR,
"short_name" VARCHAR,
"long_name" VARCHAR,
"age" BIGINT,
"dob" TIMESTAMP,
"height_cm" BIGINT,
"weight_kg" BIGINT,
"nationality" VARCHAR,
"club" VARCHAR,
"overall" BIGINT,
"potential" BIGINT,
"value_eur" BIGINT,
"wage_eur" BIGINT,
"player_positions" VARCHAR,
"preferred_foot" VARCHAR,
"international_reputation" BIGINT,
"weak_foot" BIGINT,
"skill_moves" BIGINT,
"work_rate" VARCHAR,
"body_type" VARCHAR,
"real_face" VARCHAR,
"release_clause_eur" VARCHAR,
"player_tags" VARCHAR,
"team_position" VARCHAR,
"team_jersey_number" DOUBLE,
"loaned_from" VARCHAR,
"joined" TIMESTAMP,
"contract_valid_until" DOUBLE,
"nation_position" VARCHAR,
"nation_jersey_number" DOUBLE,
"pace" DOUBLE,
"shooting" DOUBLE,
"passing" DOUBLE,
"dribbling" DOUBLE,
"defending" DOUBLE,
"physic" DOUBLE,
"gk_diving" DOUBLE,
"gk_handling" DOUBLE,
"gk_kicking" DOUBLE,
"gk_reflexes" DOUBLE,
"gk_speed" DOUBLE,
"gk_positioning" DOUBLE,
"player_traits" VARCHAR,
"attacking_crossing" VARCHAR,
"attacking_finishing" VARCHAR,
"attacking_heading_accuracy" VARCHAR,
"attacking_short_passing" VARCHAR,
"attacking_volleys" VARCHAR,
"skill_dribbling" VARCHAR,
"skill_curve" VARCHAR,
"skill_fk_accuracy" VARCHAR,
"skill_long_passing" VARCHAR,
"skill_ball_control" VARCHAR,
"movement_acceleration" VARCHAR,
"movement_sprint_speed" VARCHAR,
"movement_agility" VARCHAR,
"movement_reactions" VARCHAR,
"movement_balance" VARCHAR,
"power_shot_power" VARCHAR,
"power_jumping" VARCHAR,
"power_stamina" VARCHAR,
"power_strength" VARCHAR,
"power_long_shots" VARCHAR,
"mentality_aggression" VARCHAR,
"mentality_interceptions" VARCHAR,
"mentality_positioning" VARCHAR,
"mentality_vision" VARCHAR,
"mentality_penalties" VARCHAR,
"mentality_composure" BIGINT,
"defending_marking" VARCHAR,
"defending_standing_tackle" VARCHAR,
"defending_sliding_tackle" VARCHAR,
"goalkeeping_diving" VARCHAR,
"goalkeeping_handling" VARCHAR,
"goalkeeping_kicking" VARCHAR,
"goalkeeping_positioning" VARCHAR,
"goalkeeping_reflexes" VARCHAR,
"ls" VARCHAR,
"st" VARCHAR,
"rs" VARCHAR,
"lw" VARCHAR,
"lf" VARCHAR,
"cf" VARCHAR,
"rf" VARCHAR,
"rw" VARCHAR,
"lam" VARCHAR,
"cam" VARCHAR,
"ram" VARCHAR,
"lm" VARCHAR,
"lcm" VARCHAR,
"cm" VARCHAR,
"rcm" VARCHAR,
"rm" VARCHAR,
"lwb" VARCHAR,
"ldm" VARCHAR,
"cdm" VARCHAR,
"rdm" VARCHAR,
"rwb" VARCHAR,
"lb" VARCHAR
);CREATE TABLE players_18 (
"sofifa_id" BIGINT,
"player_url" VARCHAR,
"short_name" VARCHAR,
"long_name" VARCHAR,
"age" BIGINT,
"dob" TIMESTAMP,
"height_cm" BIGINT,
"weight_kg" BIGINT,
"nationality" VARCHAR,
"club" VARCHAR,
"overall" BIGINT,
"potential" BIGINT,
"value_eur" BIGINT,
"wage_eur" BIGINT,
"player_positions" VARCHAR,
"preferred_foot" VARCHAR,
"international_reputation" BIGINT,
"weak_foot" BIGINT,
"skill_moves" BIGINT,
"work_rate" VARCHAR,
"body_type" VARCHAR,
"real_face" VARCHAR,
"release_clause_eur" DOUBLE,
"player_tags" VARCHAR,
"team_position" VARCHAR,
"team_jersey_number" DOUBLE,
"loaned_from" VARCHAR,
"joined" TIMESTAMP,
"contract_valid_until" DOUBLE,
"nation_position" VARCHAR,
"nation_jersey_number" DOUBLE,
"pace" DOUBLE,
"shooting" DOUBLE,
"passing" DOUBLE,
"dribbling" DOUBLE,
"defending" DOUBLE,
"physic" DOUBLE,
"gk_diving" DOUBLE,
"gk_handling" DOUBLE,
"gk_kicking" DOUBLE,
"gk_reflexes" DOUBLE,
"gk_speed" DOUBLE,
"gk_positioning" DOUBLE,
"player_traits" VARCHAR,
"attacking_crossing" VARCHAR,
"attacking_finishing" VARCHAR,
"attacking_heading_accuracy" VARCHAR,
"attacking_short_passing" VARCHAR,
"attacking_volleys" VARCHAR,
"skill_dribbling" VARCHAR,
"skill_curve" VARCHAR,
"skill_fk_accuracy" VARCHAR,
"skill_long_passing" VARCHAR,
"skill_ball_control" VARCHAR,
"movement_acceleration" VARCHAR,
"movement_sprint_speed" VARCHAR,
"movement_agility" VARCHAR,
"movement_reactions" VARCHAR,
"movement_balance" VARCHAR,
"power_shot_power" VARCHAR,
"power_jumping" VARCHAR,
"power_stamina" VARCHAR,
"power_strength" VARCHAR,
"power_long_shots" VARCHAR,
"mentality_aggression" VARCHAR,
"mentality_interceptions" VARCHAR,
"mentality_positioning" VARCHAR,
"mentality_vision" VARCHAR,
"mentality_penalties" VARCHAR,
"mentality_composure" VARCHAR,
"defending_marking" VARCHAR,
"defending_standing_tackle" VARCHAR,
"defending_sliding_tackle" VARCHAR,
"goalkeeping_diving" VARCHAR,
"goalkeeping_handling" VARCHAR,
"goalkeeping_kicking" VARCHAR,
"goalkeeping_positioning" VARCHAR,
"goalkeeping_reflexes" VARCHAR,
"ls" VARCHAR,
"st" VARCHAR,
"rs" VARCHAR,
"lw" VARCHAR,
"lf" VARCHAR,
"cf" VARCHAR,
"rf" VARCHAR,
"rw" VARCHAR,
"lam" VARCHAR,
"cam" VARCHAR,
"ram" VARCHAR,
"lm" VARCHAR,
"lcm" VARCHAR,
"cm" VARCHAR,
"rcm" VARCHAR,
"rm" VARCHAR,
"lwb" VARCHAR,
"ldm" VARCHAR,
"cdm" VARCHAR,
"rdm" VARCHAR,
"rwb" VARCHAR,
"lb" VARCHAR
);CREATE TABLE players_19 (
"sofifa_id" BIGINT,
"player_url" VARCHAR,
"short_name" VARCHAR,
"long_name" VARCHAR,
"age" BIGINT,
"dob" TIMESTAMP,
"height_cm" BIGINT,
"weight_kg" BIGINT,
"nationality" VARCHAR,
"club" VARCHAR,
"overall" BIGINT,
"potential" BIGINT,
"value_eur" BIGINT,
"wage_eur" BIGINT,
"player_positions" VARCHAR,
"preferred_foot" VARCHAR,
"international_reputation" BIGINT,
"weak_foot" BIGINT,
"skill_moves" BIGINT,
"work_rate" VARCHAR,
"body_type" VARCHAR,
"real_face" VARCHAR,
"release_clause_eur" DOUBLE,
"player_tags" VARCHAR,
"team_position" VARCHAR,
"team_jersey_number" DOUBLE,
"loaned_from" VARCHAR,
"joined" TIMESTAMP,
"contract_valid_until" DOUBLE,
"nation_position" VARCHAR,
"nation_jersey_number" DOUBLE,
"pace" DOUBLE,
"shooting" DOUBLE,
"passing" DOUBLE,
"dribbling" DOUBLE,
"defending" DOUBLE,
"physic" DOUBLE,
"gk_diving" DOUBLE,
"gk_handling" DOUBLE,
"gk_kicking" DOUBLE,
"gk_reflexes" DOUBLE,
"gk_speed" DOUBLE,
"gk_positioning" DOUBLE,
"player_traits" VARCHAR,
"attacking_crossing" VARCHAR,
"attacking_finishing" VARCHAR,
"attacking_heading_accuracy" VARCHAR,
"attacking_short_passing" VARCHAR,
"attacking_volleys" VARCHAR,
"skill_dribbling" VARCHAR,
"skill_curve" VARCHAR,
"skill_fk_accuracy" VARCHAR,
"skill_long_passing" VARCHAR,
"skill_ball_control" VARCHAR,
"movement_acceleration" VARCHAR,
"movement_sprint_speed" VARCHAR,
"movement_agility" VARCHAR,
"movement_reactions" VARCHAR,
"movement_balance" VARCHAR,
"power_shot_power" VARCHAR,
"power_jumping" VARCHAR,
"power_stamina" VARCHAR,
"power_strength" VARCHAR,
"power_long_shots" VARCHAR,
"mentality_aggression" VARCHAR,
"mentality_interceptions" VARCHAR,
"mentality_positioning" VARCHAR,
"mentality_vision" VARCHAR,
"mentality_penalties" VARCHAR,
"mentality_composure" VARCHAR,
"defending_marking" VARCHAR,
"defending_standing_tackle" VARCHAR,
"defending_sliding_tackle" VARCHAR,
"goalkeeping_diving" VARCHAR,
"goalkeeping_handling" VARCHAR,
"goalkeeping_kicking" VARCHAR,
"goalkeeping_positioning" VARCHAR,
"goalkeeping_reflexes" VARCHAR,
"ls" VARCHAR,
"st" VARCHAR,
"rs" VARCHAR,
"lw" VARCHAR,
"lf" VARCHAR,
"cf" VARCHAR,
"rf" VARCHAR,
"rw" VARCHAR,
"lam" VARCHAR,
"cam" VARCHAR,
"ram" VARCHAR,
"lm" VARCHAR,
"lcm" VARCHAR,
"cm" VARCHAR,
"rcm" VARCHAR,
"rm" VARCHAR,
"lwb" VARCHAR,
"ldm" VARCHAR,
"cdm" VARCHAR,
"rdm" VARCHAR,
"rwb" VARCHAR,
"lb" VARCHAR
);CREATE TABLE players_20 (
"sofifa_id" BIGINT,
"player_url" VARCHAR,
"short_name" VARCHAR,
"long_name" VARCHAR,
"age" BIGINT,
"dob" TIMESTAMP,
"height_cm" BIGINT,
"weight_kg" BIGINT,
"nationality" VARCHAR,
"club" VARCHAR,
"overall" BIGINT,
"potential" BIGINT,
"value_eur" BIGINT,
"wage_eur" BIGINT,
"player_positions" VARCHAR,
"preferred_foot" VARCHAR,
"international_reputation" BIGINT,
"weak_foot" BIGINT,
"skill_moves" BIGINT,
"work_rate" VARCHAR,
"body_type" VARCHAR,
"real_face" VARCHAR,
"release_clause_eur" DOUBLE,
"player_tags" VARCHAR,
"team_position" VARCHAR,
"team_jersey_number" DOUBLE,
"loaned_from" VARCHAR,
"joined" TIMESTAMP,
"contract_valid_until" DOUBLE,
"nation_position" VARCHAR,
"nation_jersey_number" DOUBLE,
"pace" DOUBLE,
"shooting" DOUBLE,
"passing" DOUBLE,
"dribbling" DOUBLE,
"defending" DOUBLE,
"physic" DOUBLE,
"gk_diving" DOUBLE,
"gk_handling" DOUBLE,
"gk_kicking" DOUBLE,
"gk_reflexes" DOUBLE,
"gk_speed" DOUBLE,
"gk_positioning" DOUBLE,
"player_traits" VARCHAR,
"attacking_crossing" BIGINT,
"attacking_finishing" BIGINT,
"attacking_heading_accuracy" BIGINT,
"attacking_short_passing" BIGINT,
"attacking_volleys" BIGINT,
"skill_dribbling" BIGINT,
"skill_curve" BIGINT,
"skill_fk_accuracy" BIGINT,
"skill_long_passing" BIGINT,
"skill_ball_control" BIGINT,
"movement_acceleration" BIGINT,
"movement_sprint_speed" BIGINT,
"movement_agility" BIGINT,
"movement_reactions" BIGINT,
"movement_balance" BIGINT,
"power_shot_power" BIGINT,
"power_jumping" BIGINT,
"power_stamina" BIGINT,
"power_strength" BIGINT,
"power_long_shots" BIGINT,
"mentality_aggression" BIGINT,
"mentality_interceptions" BIGINT,
"mentality_positioning" BIGINT,
"mentality_vision" BIGINT,
"mentality_penalties" BIGINT,
"mentality_composure" BIGINT,
"defending_marking" BIGINT,
"defending_standing_tackle" BIGINT,
"defending_sliding_tackle" BIGINT,
"goalkeeping_diving" BIGINT,
"goalkeeping_handling" BIGINT,
"goalkeeping_kicking" BIGINT,
"goalkeeping_positioning" BIGINT,
"goalkeeping_reflexes" BIGINT,
"ls" VARCHAR,
"st" VARCHAR,
"rs" VARCHAR,
"lw" VARCHAR,
"lf" VARCHAR,
"cf" VARCHAR,
"rf" VARCHAR,
"rw" VARCHAR,
"lam" VARCHAR,
"cam" VARCHAR,
"ram" VARCHAR,
"lm" VARCHAR,
"lcm" VARCHAR,
"cm" VARCHAR,
"rcm" VARCHAR,
"rm" VARCHAR,
"lwb" VARCHAR,
"ldm" VARCHAR,
"cdm" VARCHAR,
"rdm" VARCHAR,
"rwb" VARCHAR,
"lb" VARCHAR
);CREATE TABLE teams_and_leagues (
"url" BIGINT,
"league_name" VARCHAR
);Anyone who has the link will be able to view this.