Name: FIFA 2021 Team And Player Dataset
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

FIFA 2021 Team And Player Dataset

Context

Dataset for football enthusiasts!
Also if you into scraping you can find the project at here

Content

In this dataset, you will find,

19.002 player & 56 player feature
681 team & 17 team feature

Each .csv file contains specific features of the teams and players. So if you don't want to include some of the features within your analyses you can easily discard them.

Acknowledgements

The data has been scraped from sofifa.com.

Inspiration

If you are passionate about football (soccer) you must have a lot of questions to answer. Such as,

What makes a player "great"?
How is the value of the player determined?
Which player should your favorite team transfer?
Which team will most likely win the game X vs Y?

And much more... You can try to find some of the answers using this dataset.

Tables

Players

@kaggle.batuhandemirci_fifa_2021_team_and_player_dataset.players

1.42 MB
19,002 rows
56 columns

CREATE TABLE players (
  "int_player_id" BIGINT,
  "str_player_name" VARCHAR,
  "str_positions" VARCHAR,
  "dt_date_of_birth" TIMESTAMP,
  "int_height" BIGINT,
  "int_weight" BIGINT,
  "int_overall_rating" BIGINT,
  "int_potential_rating" BIGINT,
  "str_best_position" VARCHAR,
  "int_best_overall_rating" BIGINT,
  "int_value" BIGINT,
  "int_wage" BIGINT,
  "int_team_id" DOUBLE,
  "str_nationality" VARCHAR,
  "int_crossing" BIGINT,
  "int_finishing" BIGINT,
  "int_heading_accuracy" BIGINT,
  "int_short_passing" BIGINT,
  "int_volleys" BIGINT,
  "int_defensive_awareness" BIGINT,
  "int_standing_tackle" BIGINT,
  "int_sliding_tackle" BIGINT,
  "int_diving" BIGINT,
  "int_handling" BIGINT,
  "int_kicking" BIGINT,
  "int_gk_positioning" BIGINT,
  "int_reflexes" BIGINT,
  "int_aggression" BIGINT,
  "int_interceptions" BIGINT,
  "int_positioning" BIGINT,
  "int_vision" BIGINT,
  "int_penalties" BIGINT,
  "int_composure" BIGINT,
  "int_acceleration" BIGINT,
  "int_sprint_speed" BIGINT,
  "int_agility" BIGINT,
  "int_reactions" BIGINT,
  "int_balance" BIGINT,
  "int_shot_power" BIGINT,
  "int_jumping" BIGINT,
  "int_stamina" BIGINT,
  "int_strength" BIGINT,
  "int_long_shots" BIGINT,
  "str_preferred_foot" VARCHAR,
  "int_weak_foot" BIGINT,
  "int_skill_moves" BIGINT,
  "int_international_reputations" BIGINT,
  "str_work_rate" VARCHAR,
  "str_body_type" VARCHAR,
  "int_dribbling" BIGINT,
  "int_curve" BIGINT,
  "int_fk_accuracy" BIGINT,
  "int_long_passing" BIGINT,
  "int_ball_control" BIGINT,
  "str_player_speciality" VARCHAR,
  "str_trait" VARCHAR
);

Tbl Player

@kaggle.batuhandemirci_fifa_2021_team_and_player_dataset.tbl_player

901.51 kB
19,002 rows
15 columns

CREATE TABLE tbl_player (
  "int_player_id" BIGINT,
  "str_player_name" VARCHAR,
  "str_positions" VARCHAR,
  "dt_date_of_birth" TIMESTAMP,
  "int_height" BIGINT,
  "int_weight" BIGINT,
  "int_overall_rating" BIGINT,
  "int_potential_rating" BIGINT,
  "str_best_position" VARCHAR,
  "int_best_overall_rating" BIGINT,
  "int_value" BIGINT,
  "int_wage" BIGINT,
  "str_player_image_url" VARCHAR,
  "int_team_id" DOUBLE,
  "str_nationality" VARCHAR
);

Tbl Player Attacking

@kaggle.batuhandemirci_fifa_2021_team_and_player_dataset.tbl_player_attacking

314.72 kB
19,002 rows
7 columns

CREATE TABLE tbl_player_attacking (
  "int_attacking_id" BIGINT,
  "int_player_id" BIGINT,
  "int_crossing" BIGINT,
  "int_finishing" BIGINT,
  "int_heading_accuracy" BIGINT,
  "int_short_passing" BIGINT,
  "int_volleys" BIGINT
);

Tbl Player Defending

@kaggle.batuhandemirci_fifa_2021_team_and_player_dataset.tbl_player_defending

279.3 kB
19,002 rows
5 columns

CREATE TABLE tbl_player_defending (
  "int_defending_id" BIGINT,
  "int_player_id" BIGINT,
  "int_defensive_awareness" BIGINT,
  "int_standing_tackle" BIGINT,
  "int_sliding_tackle" BIGINT
);

Tbl Player Goalkeeping

@kaggle.batuhandemirci_fifa_2021_team_and_player_dataset.tbl_player_goalkeeping

314.28 kB
19,002 rows
7 columns

CREATE TABLE tbl_player_goalkeeping (
  "int_goalkeeping_id" BIGINT,
  "int_player_id" BIGINT,
  "int_diving" BIGINT,
  "int_handling" BIGINT,
  "int_kicking" BIGINT,
  "int_positioning" BIGINT,
  "int_reflexes" BIGINT
);

Tbl Player Mentality

@kaggle.batuhandemirci_fifa_2021_team_and_player_dataset.tbl_player_mentality

332.41 kB
19,002 rows
8 columns

CREATE TABLE tbl_player_mentality (
  "int_mentality_id" BIGINT,
  "int_player_id" BIGINT,
  "int_aggression" BIGINT,
  "int_interceptions" BIGINT,
  "int_positioning" BIGINT,
  "int_vision" BIGINT,
  "int_penalties" BIGINT,
  "int_composure" BIGINT
);

Tbl Player Movement

@kaggle.batuhandemirci_fifa_2021_team_and_player_dataset.tbl_player_movement

314.46 kB
19,002 rows
7 columns

CREATE TABLE tbl_player_movement (
  "int_movement_id" BIGINT,
  "int_player_id" BIGINT,
  "int_acceleration" BIGINT,
  "int_sprint_speed" BIGINT,
  "int_agility" BIGINT,
  "int_reactions" BIGINT,
  "int_balance" BIGINT
);

Tbl Player Power

@kaggle.batuhandemirci_fifa_2021_team_and_player_dataset.tbl_player_power

314.4 kB
19,002 rows
7 columns

CREATE TABLE tbl_player_power (
  "int_power_id" BIGINT,
  "int_player_id" BIGINT,
  "int_shot_power" BIGINT,
  "int_jumping" BIGINT,
  "int_stamina" BIGINT,
  "int_strength" BIGINT,
  "int_long_shots" BIGINT
);

Tbl Player Profile

@kaggle.batuhandemirci_fifa_2021_team_and_player_dataset.tbl_player_profile

268.24 kB
19,002 rows
8 columns

CREATE TABLE tbl_player_profile (
  "int_profile_id" BIGINT,
  "int_player_id" BIGINT,
  "str_preferred_foot" VARCHAR,
  "int_weak_foot" BIGINT,
  "int_skill_moves" BIGINT,
  "int_international_reputations" BIGINT,
  "str_work_rate" VARCHAR,
  "str_body_type" VARCHAR
);

Tbl Player Skill

@kaggle.batuhandemirci_fifa_2021_team_and_player_dataset.tbl_player_skill

314.66 kB
19,002 rows
7 columns

CREATE TABLE tbl_player_skill (
  "int_skill_id" BIGINT,
  "int_player_id" BIGINT,
  "int_dribbling" BIGINT,
  "int_curve" BIGINT,
  "int_fk_accuracy" BIGINT,
  "int_long_passing" BIGINT,
  "int_ball_control" BIGINT
);

Tbl Player Specialities

@kaggle.batuhandemirci_fifa_2021_team_and_player_dataset.tbl_player_specialities

22.26 kB
1,786 rows
3 columns

CREATE TABLE tbl_player_specialities (
  "int_speciality_id" BIGINT,
  "int_player_id" BIGINT,
  "str_player_speciality" VARCHAR
);

Tbl Player Traits

@kaggle.batuhandemirci_fifa_2021_team_and_player_dataset.tbl_player_traits

157.06 kB
14,742 rows
3 columns

CREATE TABLE tbl_player_traits (
  "int_player_id" BIGINT,
  "str_trait" VARCHAR,
  "int_trait_id" BIGINT
);

Tbl Player Urls

@kaggle.batuhandemirci_fifa_2021_team_and_player_dataset.tbl_player_urls

730.25 kB
19,002 rows
3 columns

CREATE TABLE tbl_player_urls (
  "int_player_id" BIGINT,
  "str_url" VARCHAR,
  "dt_crawled" TIMESTAMP
);

Tbl Team

@kaggle.batuhandemirci_fifa_2021_team_and_player_dataset.tbl_team

28.25 kB
681 rows
10 columns

CREATE TABLE tbl_team (
  "int_team_id" BIGINT,
  "str_team_name" VARCHAR,
  "str_league" VARCHAR,
  "int_overall" BIGINT,
  "int_attack" BIGINT,
  "int_midfield" BIGINT,
  "int_defence" BIGINT,
  "int_international_prestige" BIGINT,
  "int_domestic_prestige" BIGINT,
  "int_transfer_budget" BIGINT
);

Tbl Team Tactics

@kaggle.batuhandemirci_fifa_2021_team_and_player_dataset.tbl_team_tactics

16.76 kB
681 rows
10 columns

CREATE TABLE tbl_team_tactics (
  "int_tactic_id" BIGINT,
  "int_team_id" BIGINT,
  "str_defensive_style" VARCHAR,
  "int_team_width" BIGINT,
  "int_depth" BIGINT,
  "str_offensive_style" VARCHAR,
  "int_width" BIGINT,
  "int_players_in_box" BIGINT,
  "int_corners" BIGINT,
  "int_freekicks" BIGINT
);

Tbl Team Urls

@kaggle.batuhandemirci_fifa_2021_team_and_player_dataset.tbl_team_urls

25.58 kB
681 rows
3 columns

CREATE TABLE tbl_team_urls (
  "int_team_id" BIGINT,
  "str_url" VARCHAR,
  "dt_crawled" TIMESTAMP
);

Teams

@kaggle.batuhandemirci_fifa_2021_team_and_player_dataset.teams

35.54 kB
681 rows
18 columns

CREATE TABLE teams (
  "int_team_id" BIGINT,
  "str_team_name" VARCHAR,
  "str_league" VARCHAR,
  "int_overall" BIGINT,
  "int_attack" BIGINT,
  "int_midfield" BIGINT,
  "int_defence" BIGINT,
  "int_international_prestige" BIGINT,
  "int_domestic_prestige" BIGINT,
  "int_transfer_budget" BIGINT,
  "str_defensive_style" VARCHAR,
  "int_team_width" BIGINT,
  "int_depth" BIGINT,
  "str_offensive_style" VARCHAR,
  "int_width" BIGINT,
  "int_players_in_box" BIGINT,
  "int_corners" BIGINT,
  "int_freekicks" BIGINT
);