Name: FIFA23 OFFICIAL DATASET(CLEAN DATA)
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

FIFA23 OFFICIAL DATASET(CLEAN DATA)

CONTEXT

The Football Player Dataset from 2017 to 2023 provides comprehensive information about professional football players. The dataset contains a wide range of attributes, including player demographics, physical characteristics, playing statistics, contract details, and club affiliations. With over 17,000 records, this dataset offers a valuable resource for football analysts, researchers, and enthusiasts interested in exploring various aspects of the footballing world, as it allows for studying player attributes, performance metrics, market valuation, club analysis, player positioning, and player development over time.

COLUMNS

ID: A unique identifier for each player.
Name: The name of the player.
Age: The age of the player at the time of data collection.
Photo: A link or reference to the player's photograph.
Nationality: The nationality of the player.
Flag: The national flag associated with the player's nationality.
Overall: The overall rating of the player's skills and abilities.
Potential: The potential rating representing the player's future development.
Club: The current club affiliation of the player.
Club Logo: A link or reference to the logo of the player's club.
Value (£): The estimated market value of the player in pounds (£).
Wage (£): The player's weekly wage in pounds (£).
Special: A numerical value representing the player's special abilities.
Preferred Foot: The player's preferred foot for playing.
International Reputation: A rating indicating the player's international reputation.
Weak Foot: A rating representing the player's weaker foot abilities.
Skill Moves: The number of skill moves the player possesses.
Work Rate: The work rate of the player.
Body Type: The physical build or body type of the player.
Real Face: Indicates whether the player has a real face representation.
Position: The player's preferred playing position.
Joined: The date when the player joined the current club.
Loaned From: The club from which the player is currently on loan.
Contract Valid Until: The date until which the player's contract is valid.
Height (cm.): The height of the player in centimeters.
Weight (lbs.): The weight of the player in pounds.
Release Clause (£): The release clause value of the player in pounds (£).
Kit Number: The player's kit number.
Best Overall Rating: The player's highest overall rating.
Year Joined: The year when the player joined the current club.

ACKNOWLEDGEMENT
We would like to acknowledge the original contributor https://www.kaggle.com/bryanb of this football dataset for providing the foundation upon which our cleaned and uploaded dataset is built.

Check out the link below for original dataset!
https://www.kaggle.com/datasets/bryanb/fifa-player-stats-database?rvi=1

Tables

Clean Fifa17 Official Data

@kaggle.kevwesophia_fifa23_official_datasetclean_data.clean_fifa17_official_data

1.51 MB
17,560 rows
65 columns

CREATE TABLE clean_fifa17_official_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" BIGINT,
  "name" VARCHAR,
  "age" BIGINT,
  "photo" VARCHAR,
  "nationality" VARCHAR,
  "flag" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "club" VARCHAR,
  "club_logo" VARCHAR,
  "value" DOUBLE  -- Value(£),
  "wage" DOUBLE  -- Wage(£),
  "special" BIGINT,
  "preferred_foot" VARCHAR,
  "international_reputation" DOUBLE,
  "weak_foot" DOUBLE,
  "skill_moves" DOUBLE,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "position" VARCHAR,
  "jersey_number" DOUBLE,
  "joined" TIMESTAMP,
  "loaned_from" VARCHAR,
  "contract_valid_until" DOUBLE,
  "height_cm" DOUBLE  -- Height(cm.),
  "weight_lbs" BIGINT  -- Weight(lbs.),
  "crossing" DOUBLE,
  "finishing" DOUBLE,
  "headingaccuracy" DOUBLE,
  "shortpassing" DOUBLE,
  "volleys" DOUBLE,
  "dribbling" DOUBLE,
  "curve" DOUBLE,
  "fkaccuracy" DOUBLE,
  "longpassing" DOUBLE,
  "ballcontrol" DOUBLE,
  "acceleration" DOUBLE,
  "sprintspeed" DOUBLE,
  "agility" DOUBLE,
  "reactions" DOUBLE,
  "balance" DOUBLE,
  "shotpower" DOUBLE,
  "jumping" DOUBLE,
  "stamina" DOUBLE,
  "strength" DOUBLE,
  "longshots" DOUBLE,
  "aggression" DOUBLE,
  "interceptions" DOUBLE,
  "positioning" DOUBLE,
  "vision" DOUBLE,
  "penalties" DOUBLE,
  "composure" DOUBLE,
  "marking" DOUBLE,
  "standingtackle" DOUBLE,
  "slidingtackle" DOUBLE,
  "gkdiving" DOUBLE,
  "gkhandling" DOUBLE,
  "gkkicking" DOUBLE,
  "gkpositioning" DOUBLE,
  "gkreflexes" DOUBLE,
  "best_position" VARCHAR,
  "best_overall_rating" DOUBLE,
  "year_joined" BIGINT
);

Clean Fifa18 Official Data

@kaggle.kevwesophia_fifa23_official_datasetclean_data.clean_fifa18_official_data

1.57 MB
17,927 rows
66 columns

CREATE TABLE clean_fifa18_official_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" BIGINT,
  "name" VARCHAR,
  "age" BIGINT,
  "photo" VARCHAR,
  "nationality" VARCHAR,
  "flag" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "club" VARCHAR,
  "club_logo" VARCHAR,
  "value" DOUBLE  -- Value(£),
  "wage" DOUBLE  -- Wage(£),
  "special" BIGINT,
  "preferred_foot" VARCHAR,
  "international_reputation" DOUBLE,
  "weak_foot" DOUBLE,
  "skill_moves" DOUBLE,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "position" VARCHAR,
  "jersey_number" DOUBLE,
  "joined" TIMESTAMP,
  "loaned_from" VARCHAR,
  "contract_valid_until" DOUBLE,
  "height_cm" DOUBLE  -- Height(cm.),
  "weight_lbs" BIGINT  -- Weight(lbs.),
  "crossing" DOUBLE,
  "finishing" DOUBLE,
  "headingaccuracy" DOUBLE,
  "shortpassing" DOUBLE,
  "volleys" DOUBLE,
  "dribbling" DOUBLE,
  "curve" DOUBLE,
  "fkaccuracy" DOUBLE,
  "longpassing" DOUBLE,
  "ballcontrol" DOUBLE,
  "acceleration" DOUBLE,
  "sprintspeed" DOUBLE,
  "agility" DOUBLE,
  "reactions" DOUBLE,
  "balance" DOUBLE,
  "shotpower" DOUBLE,
  "jumping" DOUBLE,
  "stamina" DOUBLE,
  "strength" DOUBLE,
  "longshots" DOUBLE,
  "aggression" DOUBLE,
  "interceptions" DOUBLE,
  "positioning" DOUBLE,
  "vision" DOUBLE,
  "penalties" DOUBLE,
  "composure" DOUBLE,
  "marking" DOUBLE,
  "standingtackle" DOUBLE,
  "slidingtackle" DOUBLE,
  "gkdiving" DOUBLE,
  "gkhandling" DOUBLE,
  "gkkicking" DOUBLE,
  "gkpositioning" DOUBLE,
  "gkreflexes" DOUBLE,
  "best_position" VARCHAR,
  "best_overall_rating" DOUBLE,
  "release_clause" DOUBLE  -- Release Clause(£),
  "year_joined" BIGINT
);

Clean Fifa19 Official Data

@kaggle.kevwesophia_fifa23_official_datasetclean_data.clean_fifa19_official_data

1.58 MB
17,943 rows
66 columns

CREATE TABLE clean_fifa19_official_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" BIGINT,
  "name" VARCHAR,
  "age" BIGINT,
  "photo" VARCHAR,
  "nationality" VARCHAR,
  "flag" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "club" VARCHAR,
  "club_logo" VARCHAR,
  "value" DOUBLE  -- Value(£),
  "wage" DOUBLE  -- Wage(£),
  "special" BIGINT,
  "preferred_foot" VARCHAR,
  "international_reputation" DOUBLE,
  "weak_foot" DOUBLE,
  "skill_moves" DOUBLE,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "position" VARCHAR,
  "jersey_number" DOUBLE,
  "joined" TIMESTAMP,
  "loaned_from" VARCHAR,
  "contract_valid_until" DOUBLE,
  "height_cm" DOUBLE  -- Height(cm.),
  "weight_lbs" BIGINT  -- Weight(lbs.),
  "crossing" DOUBLE,
  "finishing" DOUBLE,
  "headingaccuracy" DOUBLE,
  "shortpassing" DOUBLE,
  "volleys" DOUBLE,
  "dribbling" DOUBLE,
  "curve" DOUBLE,
  "fkaccuracy" DOUBLE,
  "longpassing" DOUBLE,
  "ballcontrol" DOUBLE,
  "acceleration" DOUBLE,
  "sprintspeed" DOUBLE,
  "agility" DOUBLE,
  "reactions" DOUBLE,
  "balance" DOUBLE,
  "shotpower" DOUBLE,
  "jumping" DOUBLE,
  "stamina" DOUBLE,
  "strength" DOUBLE,
  "longshots" DOUBLE,
  "aggression" DOUBLE,
  "interceptions" DOUBLE,
  "positioning" DOUBLE,
  "vision" DOUBLE,
  "penalties" DOUBLE,
  "composure" DOUBLE,
  "marking" DOUBLE,
  "standingtackle" DOUBLE,
  "slidingtackle" DOUBLE,
  "gkdiving" DOUBLE,
  "gkhandling" DOUBLE,
  "gkkicking" DOUBLE,
  "gkpositioning" DOUBLE,
  "gkreflexes" DOUBLE,
  "best_position" VARCHAR,
  "best_overall_rating" DOUBLE,
  "release_clause" DOUBLE  -- Release Clause(£),
  "year_joined" BIGINT
);

Clean Fifa20 Official Data

@kaggle.kevwesophia_fifa23_official_datasetclean_data.clean_fifa20_official_data

1.54 MB
17,104 rows
67 columns

CREATE TABLE clean_fifa20_official_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" BIGINT,
  "name" VARCHAR,
  "age" BIGINT,
  "photo" VARCHAR,
  "nationality" VARCHAR,
  "flag" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "club" VARCHAR,
  "club_logo" VARCHAR,
  "value" DOUBLE  -- Value(£),
  "wage" DOUBLE  -- Wage(£),
  "special" BIGINT,
  "preferred_foot" VARCHAR,
  "international_reputation" DOUBLE,
  "weak_foot" DOUBLE,
  "skill_moves" DOUBLE,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "position" VARCHAR,
  "jersey_number" DOUBLE,
  "joined" TIMESTAMP,
  "loaned_from" VARCHAR,
  "contract_valid_until" DOUBLE,
  "height_cm" DOUBLE  -- Height(cm.),
  "weight_lbs" BIGINT  -- Weight(lbs.),
  "crossing" DOUBLE,
  "finishing" DOUBLE,
  "headingaccuracy" DOUBLE,
  "shortpassing" DOUBLE,
  "volleys" DOUBLE,
  "dribbling" DOUBLE,
  "curve" DOUBLE,
  "fkaccuracy" DOUBLE,
  "longpassing" DOUBLE,
  "ballcontrol" DOUBLE,
  "acceleration" DOUBLE,
  "sprintspeed" DOUBLE,
  "agility" DOUBLE,
  "reactions" DOUBLE,
  "balance" DOUBLE,
  "shotpower" DOUBLE,
  "jumping" DOUBLE,
  "stamina" DOUBLE,
  "strength" DOUBLE,
  "longshots" DOUBLE,
  "aggression" DOUBLE,
  "interceptions" DOUBLE,
  "positioning" DOUBLE,
  "vision" DOUBLE,
  "penalties" DOUBLE,
  "composure" DOUBLE,
  "marking" DOUBLE,
  "standingtackle" DOUBLE,
  "slidingtackle" DOUBLE,
  "gkdiving" DOUBLE,
  "gkhandling" DOUBLE,
  "gkkicking" DOUBLE,
  "gkpositioning" DOUBLE,
  "gkreflexes" DOUBLE,
  "best_position" VARCHAR,
  "best_overall_rating" DOUBLE,
  "release_clause" DOUBLE  -- Release Clause(£),
  "defensiveawareness" DOUBLE,
  "year_joined" BIGINT
);

Clean Fifa21 Official Data

@kaggle.kevwesophia_fifa23_official_datasetclean_data.clean_fifa21_official_data

1.54 MB
17,108 rows
67 columns

CREATE TABLE clean_fifa21_official_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" BIGINT,
  "name" VARCHAR,
  "age" BIGINT,
  "photo" VARCHAR,
  "nationality" VARCHAR,
  "flag" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "club" VARCHAR,
  "club_logo" VARCHAR,
  "value" DOUBLE  -- Value(£),
  "wage" DOUBLE  -- Wage(£),
  "special" BIGINT,
  "preferred_foot" VARCHAR,
  "international_reputation" DOUBLE,
  "weak_foot" DOUBLE,
  "skill_moves" DOUBLE,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "position" VARCHAR,
  "jersey_number" DOUBLE,
  "joined" TIMESTAMP,
  "loaned_from" VARCHAR,
  "contract_valid_until" DOUBLE,
  "height_cm" DOUBLE  -- Height(cm.),
  "weight_lbs" BIGINT  -- Weight(lbs.),
  "crossing" DOUBLE,
  "finishing" DOUBLE,
  "headingaccuracy" DOUBLE,
  "shortpassing" DOUBLE,
  "volleys" DOUBLE,
  "dribbling" DOUBLE,
  "curve" DOUBLE,
  "fkaccuracy" DOUBLE,
  "longpassing" DOUBLE,
  "ballcontrol" DOUBLE,
  "acceleration" DOUBLE,
  "sprintspeed" DOUBLE,
  "agility" DOUBLE,
  "reactions" DOUBLE,
  "balance" DOUBLE,
  "shotpower" DOUBLE,
  "jumping" DOUBLE,
  "stamina" DOUBLE,
  "strength" DOUBLE,
  "longshots" DOUBLE,
  "aggression" DOUBLE,
  "interceptions" DOUBLE,
  "positioning" DOUBLE,
  "vision" DOUBLE,
  "penalties" DOUBLE,
  "composure" DOUBLE,
  "marking" DOUBLE,
  "standingtackle" DOUBLE,
  "slidingtackle" DOUBLE,
  "gkdiving" DOUBLE,
  "gkhandling" DOUBLE,
  "gkkicking" DOUBLE,
  "gkpositioning" DOUBLE,
  "gkreflexes" DOUBLE,
  "best_position" VARCHAR,
  "best_overall_rating" DOUBLE,
  "release_clause" DOUBLE  -- Release Clause(£),
  "defensiveawareness" DOUBLE,
  "year_joined" BIGINT
);

Clean Fifa22 Official Data

@kaggle.kevwesophia_fifa23_official_datasetclean_data.clean_fifa22_official_data

1.51 MB
16,710 rows
67 columns

CREATE TABLE clean_fifa22_official_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" BIGINT,
  "name" VARCHAR,
  "age" BIGINT,
  "photo" VARCHAR,
  "nationality" VARCHAR,
  "flag" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "club" VARCHAR,
  "club_logo" VARCHAR,
  "value" DOUBLE  -- Value(£),
  "wage" DOUBLE  -- Wage(£),
  "special" BIGINT,
  "preferred_foot" VARCHAR,
  "international_reputation" DOUBLE,
  "weak_foot" DOUBLE,
  "skill_moves" DOUBLE,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "position" VARCHAR,
  "jersey_number" DOUBLE,
  "joined" TIMESTAMP,
  "loaned_from" VARCHAR,
  "contract_valid_until" DOUBLE,
  "height_cm" BIGINT  -- Height(cm.),
  "weight_lbs" DOUBLE  -- Weight(lbs.),
  "crossing" DOUBLE,
  "finishing" DOUBLE,
  "headingaccuracy" DOUBLE,
  "shortpassing" DOUBLE,
  "volleys" DOUBLE,
  "dribbling" DOUBLE,
  "curve" DOUBLE,
  "fkaccuracy" DOUBLE,
  "longpassing" DOUBLE,
  "ballcontrol" DOUBLE,
  "acceleration" DOUBLE,
  "sprintspeed" DOUBLE,
  "agility" DOUBLE,
  "reactions" DOUBLE,
  "balance" DOUBLE,
  "shotpower" DOUBLE,
  "jumping" DOUBLE,
  "stamina" DOUBLE,
  "strength" DOUBLE,
  "longshots" DOUBLE,
  "aggression" DOUBLE,
  "interceptions" DOUBLE,
  "positioning" DOUBLE,
  "vision" DOUBLE,
  "penalties" DOUBLE,
  "composure" DOUBLE,
  "marking" DOUBLE,
  "standingtackle" DOUBLE,
  "slidingtackle" DOUBLE,
  "gkdiving" DOUBLE,
  "gkhandling" DOUBLE,
  "gkkicking" DOUBLE,
  "gkpositioning" DOUBLE,
  "gkreflexes" DOUBLE,
  "best_position" VARCHAR,
  "best_overall_rating" DOUBLE,
  "release_clause" DOUBLE  -- Release Clause(£),
  "defensiveawareness" DOUBLE,
  "year_joined" BIGINT
);

Clean Fifa23 Official Data

@kaggle.kevwesophia_fifa23_official_datasetclean_data.clean_fifa23_official_data

1.01 MB
17,660 rows
31 columns

CREATE TABLE clean_fifa23_official_data (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "id" BIGINT,
  "name" VARCHAR,
  "age" BIGINT,
  "photo" VARCHAR,
  "nationality" VARCHAR,
  "flag" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "club" VARCHAR,
  "club_logo" VARCHAR,
  "value" DOUBLE  -- Value(£),
  "wage" DOUBLE  -- Wage(£),
  "special" BIGINT,
  "preferred_foot" VARCHAR,
  "international_reputation" DOUBLE,
  "weak_foot" DOUBLE,
  "skill_moves" DOUBLE,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "position" VARCHAR,
  "joined" TIMESTAMP,
  "loaned_from" VARCHAR,
  "contract_valid_until" DOUBLE,
  "height_cm" DOUBLE  -- Height(cm.),
  "weight_lbs" DOUBLE  -- Weight(lbs.),
  "release_clause" DOUBLE  -- Release Clause(£),
  "kit_number" DOUBLE,
  "best_overall_rating" DOUBLE,
  "year_joined" BIGINT
);