Dataset: FIFA 2021 Team And Player Dataset

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.35 MB
19002 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

880.38 KB
19002 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

307.34 KB
19002 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

272.75 KB
19002 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

306.92 KB
19002 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

324.62 KB
19002 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

307.09 KB
19002 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

307.03 KB
19002 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

261.95 KB
19002 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

307.29 KB
19002 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

21.74 KB
1786 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

153.38 KB
14742 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

713.13 KB
19002 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

27.59 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.37 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

24.98 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

34.71 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
);