Baselight

FIFA Players Dataset

Data from FIFA with 16k+ players and 100+ attributes

@kaggle.luisfucros_fifa_players

Loading...
Loading...

About this Dataset

FIFA Players Dataset

Fifa players dataset

These datasets contain detailed player statistics and attributes for football players as featured in the Sofifa database, which is a widely recognized source of football player data used for simulation and analysis purposes. The dataset includes player-specific information such as personal details, club affiliations, performance metrics, and skill ratings, providing a comprehensive overview of player profiles within the world of football.

Key Features:

  • Player Information: Includes unique player identifiers, names (short and full), positions, nationality, date of birth, age, and physical attributes (height, weight).
  • Club Information: Club team ID, club name, league information (name and level), club position, and contract details (joining date and contract duration).
  • Player Performance and Skills: Ratings and metrics for various skills including pace, shooting, passing, dribbling, defending, and physicality. Additional data for specialized attributes like crossing, heading accuracy, and free kick accuracy.
  • Player Traits and Tags: Traits that define a player's playstyle (e.g., "Speed Dribbler", "Clinical Finisher") and tags that categorize player capabilities.
  • Mentality and Movement: Data on a player's mental attributes such as aggression, composure, and positioning, as well as movement statistics like acceleration, sprint speed, agility, and reactions.
  • Goalkeeping Stats: For players in goalkeeping positions, specific data on goalkeeping attributes like diving, handling, and reflexes.
  • International Data: Information about national team participation including national team ID, position, and jersey number.
  • Visual Assets: URLs to player face images, club logos, and national flags, allowing for visual representation of players and teams.

Example:

The datasets include iconic players like Lionel Messi, providing comprehensive data such as:

  • Overall Rating: 93
  • Potential Rating: 95
  • Market Value: €100.5M
  • Wage: €550K/week
  • Club: FC Barcelona (La Liga)
  • Nationality: Argentina
  • Position: Center Forward (CF)
  • Key Attributes:
  • Pace: 93
  • Dribbling: 96
  • Shooting: 89
  • Passing: 86
  • Physicality: 71

Additionally, player traits like "Clinical Finisher", "Speed Dribbler", and "One Club Player" offer insights into their playing style and impact on the pitch.

Applications:

  • Football Simulation: Ideal for use in building football simulation models (e.g., for video games, fantasy football platforms, and performance analytics).
  • Player Scouting: Offers an extensive resource for scouting players, analyzing potential transfers, or creating player rankings based on specific skillsets.
  • Sports Analytics: Provides valuable data for performing statistical analysis on player performance, team dynamics, and league trends.

Data Columns:

  • Personal Info: sofifa_id, player_url, short_name, long_name, age, dob, height_cm, weight_kg, nationality_name
  • Club Info: club_name, league_name, club_position, club_jersey_number, club_joined, club_contract_valid_until
  • Player Skills: pace, shooting, passing, dribbling, defending, physic
  • Movement & Mentality: movement_acceleration, movement_sprint_speed, mentality_composure, mentality_aggression
  • Goalkeeping (if applicable): goalkeeping_diving, goalkeeping_handling, goalkeeping_kicking
  • Visual Assets: player_face_url, club_logo_url, nation_flag_url

These datasets are a valuable resource for sports data enthusiasts, analysts, and game developers aiming to enrich their football-related projects with rich, player-centric data.

Tables

Players 15

@kaggle.luisfucros_fifa_players.players_15
  • 2.67 MB
  • 16,155 rows
  • 110 columns
Loading...
CREATE TABLE players_15 (
  "sofifa_id" BIGINT,
  "player_url" VARCHAR,
  "short_name" VARCHAR,
  "long_name" VARCHAR,
  "player_positions" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "value_eur" DOUBLE,
  "wage_eur" DOUBLE,
  "age" BIGINT,
  "dob" TIMESTAMP,
  "height_cm" BIGINT,
  "weight_kg" BIGINT,
  "club_team_id" DOUBLE,
  "club_name" VARCHAR,
  "league_name" VARCHAR,
  "league_level" DOUBLE,
  "club_position" VARCHAR,
  "club_jersey_number" DOUBLE,
  "club_loaned_from" VARCHAR,
  "club_joined" TIMESTAMP,
  "club_contract_valid_until" DOUBLE,
  "nationality_id" BIGINT,
  "nationality_name" VARCHAR,
  "nation_team_id" DOUBLE,
  "nation_position" VARCHAR,
  "nation_jersey_number" DOUBLE,
  "preferred_foot" VARCHAR,
  "weak_foot" BIGINT,
  "skill_moves" BIGINT,
  "international_reputation" BIGINT,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "release_clause_eur" VARCHAR,
  "player_tags" VARCHAR,
  "player_traits" VARCHAR,
  "pace" DOUBLE,
  "shooting" DOUBLE,
  "passing" DOUBLE,
  "dribbling" DOUBLE,
  "defending" DOUBLE,
  "physic" DOUBLE,
  "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" VARCHAR,
  "defending_marking_awareness" BIGINT,
  "defending_standing_tackle" BIGINT,
  "defending_sliding_tackle" BIGINT,
  "goalkeeping_diving" BIGINT,
  "goalkeeping_handling" BIGINT,
  "goalkeeping_kicking" BIGINT,
  "goalkeeping_positioning" BIGINT,
  "goalkeeping_reflexes" BIGINT,
  "goalkeeping_speed" DOUBLE,
  "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
);

Players 16

@kaggle.luisfucros_fifa_players.players_16
  • 2.6 MB
  • 15,623 rows
  • 110 columns
Loading...
CREATE TABLE players_16 (
  "sofifa_id" BIGINT,
  "player_url" VARCHAR,
  "short_name" VARCHAR,
  "long_name" VARCHAR,
  "player_positions" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "value_eur" DOUBLE,
  "wage_eur" DOUBLE,
  "age" BIGINT,
  "dob" TIMESTAMP,
  "height_cm" BIGINT,
  "weight_kg" BIGINT,
  "club_team_id" DOUBLE,
  "club_name" VARCHAR,
  "league_name" VARCHAR,
  "league_level" DOUBLE,
  "club_position" VARCHAR,
  "club_jersey_number" DOUBLE,
  "club_loaned_from" VARCHAR,
  "club_joined" TIMESTAMP,
  "club_contract_valid_until" DOUBLE,
  "nationality_id" BIGINT,
  "nationality_name" VARCHAR,
  "nation_team_id" DOUBLE,
  "nation_position" VARCHAR,
  "nation_jersey_number" DOUBLE,
  "preferred_foot" VARCHAR,
  "weak_foot" BIGINT,
  "skill_moves" BIGINT,
  "international_reputation" BIGINT,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "release_clause_eur" VARCHAR,
  "player_tags" VARCHAR,
  "player_traits" VARCHAR,
  "pace" DOUBLE,
  "shooting" DOUBLE,
  "passing" DOUBLE,
  "dribbling" DOUBLE,
  "defending" DOUBLE,
  "physic" DOUBLE,
  "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" VARCHAR,
  "defending_marking_awareness" BIGINT,
  "defending_standing_tackle" BIGINT,
  "defending_sliding_tackle" BIGINT,
  "goalkeeping_diving" BIGINT,
  "goalkeeping_handling" BIGINT,
  "goalkeeping_kicking" BIGINT,
  "goalkeeping_positioning" BIGINT,
  "goalkeeping_reflexes" BIGINT,
  "goalkeeping_speed" DOUBLE,
  "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
);

Players 17

@kaggle.luisfucros_fifa_players.players_17
  • 2.95 MB
  • 17,596 rows
  • 110 columns
Loading...
CREATE TABLE players_17 (
  "sofifa_id" BIGINT,
  "player_url" VARCHAR,
  "short_name" VARCHAR,
  "long_name" VARCHAR,
  "player_positions" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "value_eur" DOUBLE,
  "wage_eur" DOUBLE,
  "age" BIGINT,
  "dob" TIMESTAMP,
  "height_cm" BIGINT,
  "weight_kg" BIGINT,
  "club_team_id" DOUBLE,
  "club_name" VARCHAR,
  "league_name" VARCHAR,
  "league_level" DOUBLE,
  "club_position" VARCHAR,
  "club_jersey_number" DOUBLE,
  "club_loaned_from" VARCHAR,
  "club_joined" TIMESTAMP,
  "club_contract_valid_until" DOUBLE,
  "nationality_id" BIGINT,
  "nationality_name" VARCHAR,
  "nation_team_id" DOUBLE,
  "nation_position" VARCHAR,
  "nation_jersey_number" DOUBLE,
  "preferred_foot" VARCHAR,
  "weak_foot" BIGINT,
  "skill_moves" BIGINT,
  "international_reputation" BIGINT,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "release_clause_eur" VARCHAR,
  "player_tags" VARCHAR,
  "player_traits" VARCHAR,
  "pace" DOUBLE,
  "shooting" DOUBLE,
  "passing" DOUBLE,
  "dribbling" DOUBLE,
  "defending" DOUBLE,
  "physic" DOUBLE,
  "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_awareness" BIGINT,
  "defending_standing_tackle" BIGINT,
  "defending_sliding_tackle" BIGINT,
  "goalkeeping_diving" BIGINT,
  "goalkeeping_handling" BIGINT,
  "goalkeeping_kicking" BIGINT,
  "goalkeeping_positioning" BIGINT,
  "goalkeeping_reflexes" BIGINT,
  "goalkeeping_speed" DOUBLE,
  "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
);

Players 18

@kaggle.luisfucros_fifa_players.players_18
  • 3.04 MB
  • 17,954 rows
  • 110 columns
Loading...
CREATE TABLE players_18 (
  "sofifa_id" BIGINT,
  "player_url" VARCHAR,
  "short_name" VARCHAR,
  "long_name" VARCHAR,
  "player_positions" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "value_eur" DOUBLE,
  "wage_eur" DOUBLE,
  "age" BIGINT,
  "dob" TIMESTAMP,
  "height_cm" BIGINT,
  "weight_kg" BIGINT,
  "club_team_id" DOUBLE,
  "club_name" VARCHAR,
  "league_name" VARCHAR,
  "league_level" DOUBLE,
  "club_position" VARCHAR,
  "club_jersey_number" DOUBLE,
  "club_loaned_from" VARCHAR,
  "club_joined" TIMESTAMP,
  "club_contract_valid_until" DOUBLE,
  "nationality_id" BIGINT,
  "nationality_name" VARCHAR,
  "nation_team_id" DOUBLE,
  "nation_position" VARCHAR,
  "nation_jersey_number" DOUBLE,
  "preferred_foot" VARCHAR,
  "weak_foot" BIGINT,
  "skill_moves" BIGINT,
  "international_reputation" BIGINT,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "release_clause_eur" DOUBLE,
  "player_tags" VARCHAR,
  "player_traits" VARCHAR,
  "pace" DOUBLE,
  "shooting" DOUBLE,
  "passing" DOUBLE,
  "dribbling" DOUBLE,
  "defending" DOUBLE,
  "physic" DOUBLE,
  "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_awareness" BIGINT,
  "defending_standing_tackle" BIGINT,
  "defending_sliding_tackle" BIGINT,
  "goalkeeping_diving" BIGINT,
  "goalkeeping_handling" BIGINT,
  "goalkeeping_kicking" BIGINT,
  "goalkeeping_positioning" BIGINT,
  "goalkeeping_reflexes" BIGINT,
  "goalkeeping_speed" DOUBLE,
  "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
);

Players 19

@kaggle.luisfucros_fifa_players.players_19
  • 3.07 MB
  • 18,085 rows
  • 110 columns
Loading...
CREATE TABLE players_19 (
  "sofifa_id" BIGINT,
  "player_url" VARCHAR,
  "short_name" VARCHAR,
  "long_name" VARCHAR,
  "player_positions" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "value_eur" DOUBLE,
  "wage_eur" DOUBLE,
  "age" BIGINT,
  "dob" TIMESTAMP,
  "height_cm" BIGINT,
  "weight_kg" BIGINT,
  "club_team_id" DOUBLE,
  "club_name" VARCHAR,
  "league_name" VARCHAR,
  "league_level" DOUBLE,
  "club_position" VARCHAR,
  "club_jersey_number" DOUBLE,
  "club_loaned_from" VARCHAR,
  "club_joined" TIMESTAMP,
  "club_contract_valid_until" DOUBLE,
  "nationality_id" BIGINT,
  "nationality_name" VARCHAR,
  "nation_team_id" DOUBLE,
  "nation_position" VARCHAR,
  "nation_jersey_number" DOUBLE,
  "preferred_foot" VARCHAR,
  "weak_foot" BIGINT,
  "skill_moves" BIGINT,
  "international_reputation" BIGINT,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "release_clause_eur" DOUBLE,
  "player_tags" VARCHAR,
  "player_traits" VARCHAR,
  "pace" DOUBLE,
  "shooting" DOUBLE,
  "passing" DOUBLE,
  "dribbling" DOUBLE,
  "defending" DOUBLE,
  "physic" DOUBLE,
  "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_awareness" BIGINT,
  "defending_standing_tackle" BIGINT,
  "defending_sliding_tackle" BIGINT,
  "goalkeeping_diving" BIGINT,
  "goalkeeping_handling" BIGINT,
  "goalkeeping_kicking" BIGINT,
  "goalkeeping_positioning" BIGINT,
  "goalkeeping_reflexes" BIGINT,
  "goalkeeping_speed" DOUBLE,
  "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
);

Players 20

@kaggle.luisfucros_fifa_players.players_20
  • 3.12 MB
  • 18,483 rows
  • 110 columns
Loading...
CREATE TABLE players_20 (
  "sofifa_id" BIGINT,
  "player_url" VARCHAR,
  "short_name" VARCHAR,
  "long_name" VARCHAR,
  "player_positions" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "value_eur" DOUBLE,
  "wage_eur" DOUBLE,
  "age" BIGINT,
  "dob" TIMESTAMP,
  "height_cm" BIGINT,
  "weight_kg" BIGINT,
  "club_team_id" DOUBLE,
  "club_name" VARCHAR,
  "league_name" VARCHAR,
  "league_level" DOUBLE,
  "club_position" VARCHAR,
  "club_jersey_number" DOUBLE,
  "club_loaned_from" VARCHAR,
  "club_joined" TIMESTAMP,
  "club_contract_valid_until" DOUBLE,
  "nationality_id" BIGINT,
  "nationality_name" VARCHAR,
  "nation_team_id" DOUBLE,
  "nation_position" VARCHAR,
  "nation_jersey_number" DOUBLE,
  "preferred_foot" VARCHAR,
  "weak_foot" BIGINT,
  "skill_moves" BIGINT,
  "international_reputation" BIGINT,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "release_clause_eur" DOUBLE,
  "player_tags" VARCHAR,
  "player_traits" VARCHAR,
  "pace" DOUBLE,
  "shooting" DOUBLE,
  "passing" DOUBLE,
  "dribbling" DOUBLE,
  "defending" DOUBLE,
  "physic" DOUBLE,
  "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_awareness" BIGINT,
  "defending_standing_tackle" BIGINT,
  "defending_sliding_tackle" BIGINT,
  "goalkeeping_diving" BIGINT,
  "goalkeeping_handling" BIGINT,
  "goalkeeping_kicking" BIGINT,
  "goalkeeping_positioning" BIGINT,
  "goalkeeping_reflexes" BIGINT,
  "goalkeeping_speed" DOUBLE,
  "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
);

Players 21

@kaggle.luisfucros_fifa_players.players_21
  • 3.21 MB
  • 18,944 rows
  • 110 columns
Loading...
CREATE TABLE players_21 (
  "sofifa_id" BIGINT,
  "player_url" VARCHAR,
  "short_name" VARCHAR,
  "long_name" VARCHAR,
  "player_positions" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "value_eur" DOUBLE,
  "wage_eur" DOUBLE,
  "age" BIGINT,
  "dob" TIMESTAMP,
  "height_cm" BIGINT,
  "weight_kg" BIGINT,
  "club_team_id" DOUBLE,
  "club_name" VARCHAR,
  "league_name" VARCHAR,
  "league_level" DOUBLE,
  "club_position" VARCHAR,
  "club_jersey_number" DOUBLE,
  "club_loaned_from" VARCHAR,
  "club_joined" TIMESTAMP,
  "club_contract_valid_until" DOUBLE,
  "nationality_id" BIGINT,
  "nationality_name" VARCHAR,
  "nation_team_id" DOUBLE,
  "nation_position" VARCHAR,
  "nation_jersey_number" DOUBLE,
  "preferred_foot" VARCHAR,
  "weak_foot" BIGINT,
  "skill_moves" BIGINT,
  "international_reputation" BIGINT,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "release_clause_eur" DOUBLE,
  "player_tags" VARCHAR,
  "player_traits" VARCHAR,
  "pace" DOUBLE,
  "shooting" DOUBLE,
  "passing" DOUBLE,
  "dribbling" DOUBLE,
  "defending" DOUBLE,
  "physic" DOUBLE,
  "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_awareness" BIGINT,
  "defending_standing_tackle" BIGINT,
  "defending_sliding_tackle" BIGINT,
  "goalkeeping_diving" BIGINT,
  "goalkeeping_handling" BIGINT,
  "goalkeeping_kicking" BIGINT,
  "goalkeeping_positioning" BIGINT,
  "goalkeeping_reflexes" BIGINT,
  "goalkeeping_speed" DOUBLE,
  "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
);

Players 22

@kaggle.luisfucros_fifa_players.players_22
  • 3.24 MB
  • 19,239 rows
  • 110 columns
Loading...
CREATE TABLE players_22 (
  "sofifa_id" BIGINT,
  "player_url" VARCHAR,
  "short_name" VARCHAR,
  "long_name" VARCHAR,
  "player_positions" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "value_eur" DOUBLE,
  "wage_eur" DOUBLE,
  "age" BIGINT,
  "dob" TIMESTAMP,
  "height_cm" BIGINT,
  "weight_kg" BIGINT,
  "club_team_id" DOUBLE,
  "club_name" VARCHAR,
  "league_name" VARCHAR,
  "league_level" DOUBLE,
  "club_position" VARCHAR,
  "club_jersey_number" DOUBLE,
  "club_loaned_from" VARCHAR,
  "club_joined" TIMESTAMP,
  "club_contract_valid_until" DOUBLE,
  "nationality_id" BIGINT,
  "nationality_name" VARCHAR,
  "nation_team_id" DOUBLE,
  "nation_position" VARCHAR,
  "nation_jersey_number" DOUBLE,
  "preferred_foot" VARCHAR,
  "weak_foot" BIGINT,
  "skill_moves" BIGINT,
  "international_reputation" BIGINT,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "release_clause_eur" DOUBLE,
  "player_tags" VARCHAR,
  "player_traits" VARCHAR,
  "pace" DOUBLE,
  "shooting" DOUBLE,
  "passing" DOUBLE,
  "dribbling" DOUBLE,
  "defending" DOUBLE,
  "physic" DOUBLE,
  "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_awareness" BIGINT,
  "defending_standing_tackle" BIGINT,
  "defending_sliding_tackle" BIGINT,
  "goalkeeping_diving" BIGINT,
  "goalkeeping_handling" BIGINT,
  "goalkeeping_kicking" BIGINT,
  "goalkeeping_positioning" BIGINT,
  "goalkeeping_reflexes" BIGINT,
  "goalkeeping_speed" DOUBLE,
  "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
);

Share link

Anyone who has the link will be able to view this.