FIFA World Cup 2022 Player Data
Comprehensive player data from the FIFA World Cup 2022
@kaggle.swaptr_fifa_world_cup_2022_player_data
Comprehensive player data from the FIFA World Cup 2022
@kaggle.swaptr_fifa_world_cup_2022_player_data
  
The FIFA World Cup 2022 is here and it's bigger and better than ever! With 32 teams from around the world competing for the coveted trophy, the excitement and energy of this global event is palpable. This series of dataset captures all the action, from player statistics and team standings, to game scores and match performances.
Featuring some of the greatest players in the world, including Cristiano Ronaldo, Lionel Messi, and Neymar Jr., this series of datasets is a must-have for any die-hard soccer fan or aspiring data scientist. Use it to analyze game patterns, predict outcomes, and uncover insights into the strategies and performances of your favorite teams and players.
With this FIFA World Cup 2022 dataset, the possibilities are endless. Don't miss out on the opportunity to be a part of the action and join the ranks of the world's top data analysts. Grab your dataset today and let the games begin!
All data is downloaded from FBref and all credits for data collection and organization go to them.
CREATE TABLE player_defense (
"player" VARCHAR,
"position" VARCHAR,
"team" VARCHAR,
"age" VARCHAR,
"birth_year" BIGINT,
"minutes_90s" DOUBLE,
"tackles" DOUBLE,
"tackles_won" BIGINT,
"tackles_def_3rd" DOUBLE,
"tackles_mid_3rd" DOUBLE,
"tackles_att_3rd" DOUBLE,
"dribble_tackles" DOUBLE,
"dribbles_vs" DOUBLE,
"dribble_tackles_pct" DOUBLE,
"dribbled_past" DOUBLE,
"blocks" DOUBLE,
"blocked_shots" DOUBLE,
"blocked_passes" DOUBLE,
"interceptions" BIGINT,
"tackles_interceptions" DOUBLE,
"clearances" DOUBLE,
"errors" DOUBLE
);
CREATE TABLE player_gca (
"player" VARCHAR,
"position" VARCHAR,
"team" VARCHAR,
"age" VARCHAR,
"birth_year" BIGINT,
"minutes_90s" DOUBLE,
"sca" DOUBLE,
"sca_per90" DOUBLE,
"sca_passes_live" DOUBLE,
"sca_passes_dead" DOUBLE,
"sca_dribbles" DOUBLE,
"sca_shots" DOUBLE,
"sca_fouled" DOUBLE,
"sca_defense" DOUBLE,
"gca" DOUBLE,
"gca_per90" DOUBLE,
"gca_passes_live" DOUBLE,
"gca_passes_dead" DOUBLE,
"gca_dribbles" DOUBLE,
"gca_shots" DOUBLE,
"gca_fouled" DOUBLE,
"gca_defense" DOUBLE
);
CREATE TABLE player_keepers (
"player" VARCHAR,
"position" VARCHAR,
"team" VARCHAR,
"age" VARCHAR,
"club" VARCHAR,
"birth_year" BIGINT,
"gk_games" BIGINT,
"gk_games_starts" BIGINT,
"gk_minutes" BIGINT,
"minutes_90s" DOUBLE,
"gk_goals_against" BIGINT,
"gk_goals_against_per90" DOUBLE,
"gk_shots_on_target_against" BIGINT,
"gk_saves" BIGINT,
"gk_save_pct" DOUBLE,
"gk_wins" BIGINT,
"gk_ties" BIGINT,
"gk_losses" BIGINT,
"gk_clean_sheets" BIGINT,
"gk_clean_sheets_pct" DOUBLE,
"gk_pens_att" BIGINT,
"gk_pens_allowed" BIGINT,
"gk_pens_saved" BIGINT,
"gk_pens_missed" BIGINT,
"gk_pens_save_pct" DOUBLE
);
CREATE TABLE player_keepersadv (
"player" VARCHAR,
"position" VARCHAR,
"team" VARCHAR,
"age" VARCHAR,
"birth_year" BIGINT,
"minutes_90s" DOUBLE,
"gk_goals_against" BIGINT,
"gk_pens_allowed" BIGINT,
"gk_free_kick_goals_against" BIGINT,
"gk_corner_kick_goals_against" BIGINT,
"gk_own_goals_against" BIGINT,
"gk_psxg" DOUBLE,
"gk_psnpxg_per_shot_on_target_against" DOUBLE,
"gk_psxg_net" DOUBLE,
"gk_psxg_net_per90" DOUBLE,
"gk_passes_completed_launched" BIGINT,
"gk_passes_launched" BIGINT,
"gk_passes_pct_launched" DOUBLE,
"gk_passes" BIGINT,
"gk_passes_throws" BIGINT,
"gk_pct_passes_launched" DOUBLE,
"gk_passes_length_avg" DOUBLE,
"gk_goal_kicks" BIGINT,
"gk_pct_goal_kicks_launched" DOUBLE,
"gk_goal_kick_length_avg" DOUBLE,
"gk_crosses" BIGINT,
"gk_crosses_stopped" BIGINT,
"gk_crosses_stopped_pct" DOUBLE,
"gk_def_actions_outside_pen_area" BIGINT,
"gk_def_actions_outside_pen_area_per90" DOUBLE,
"gk_avg_distance_def_actions" DOUBLE
);
CREATE TABLE player_misc (
"player" VARCHAR,
"position" VARCHAR,
"team" VARCHAR,
"age" VARCHAR,
"birth_year" BIGINT,
"minutes_90s" DOUBLE,
"cards_yellow" BIGINT,
"cards_red" BIGINT,
"cards_yellow_red" BIGINT,
"fouls" BIGINT,
"fouled" BIGINT,
"offsides" BIGINT,
"crosses" BIGINT,
"interceptions" BIGINT,
"tackles_won" BIGINT,
"pens_won" DOUBLE,
"pens_conceded" DOUBLE,
"own_goals" BIGINT,
"ball_recoveries" DOUBLE,
"aerials_won" DOUBLE,
"aerials_lost" DOUBLE,
"aerials_won_pct" DOUBLE
);
CREATE TABLE player_passing (
"player" VARCHAR,
"position" VARCHAR,
"team" VARCHAR,
"age" VARCHAR,
"birth_year" BIGINT,
"minutes_90s" DOUBLE,
"passes_completed" DOUBLE,
"passes" DOUBLE,
"passes_pct" DOUBLE,
"passes_total_distance" DOUBLE,
"passes_progressive_distance" DOUBLE,
"passes_completed_short" DOUBLE,
"passes_short" DOUBLE,
"passes_pct_short" DOUBLE,
"passes_completed_medium" DOUBLE,
"passes_medium" DOUBLE,
"passes_pct_medium" DOUBLE,
"passes_completed_long" DOUBLE,
"passes_long" DOUBLE,
"passes_pct_long" DOUBLE,
"assists" BIGINT,
"xg_assist" DOUBLE,
"pass_xa" DOUBLE,
"xg_assist_net" DOUBLE,
"assisted_shots" DOUBLE,
"passes_into_final_third" DOUBLE,
"passes_into_penalty_area" DOUBLE,
"crosses_into_penalty_area" DOUBLE,
"progressive_passes" DOUBLE
);
CREATE TABLE player_passing_types (
"player" VARCHAR,
"position" VARCHAR,
"team" VARCHAR,
"age" VARCHAR,
"birth_year" BIGINT,
"minutes_90s" DOUBLE,
"passes" DOUBLE,
"passes_live" DOUBLE,
"passes_dead" DOUBLE,
"passes_free_kicks" DOUBLE,
"through_balls" DOUBLE,
"passes_switches" DOUBLE,
"crosses" BIGINT,
"throw_ins" DOUBLE,
"corner_kicks" DOUBLE,
"corner_kicks_in" DOUBLE,
"corner_kicks_out" DOUBLE,
"corner_kicks_straight" DOUBLE,
"passes_completed" DOUBLE,
"passes_offsides" DOUBLE,
"passes_blocked" DOUBLE
);
CREATE TABLE player_playingtime (
"player" VARCHAR,
"position" VARCHAR,
"team" VARCHAR,
"age" VARCHAR,
"birth_year" BIGINT,
"games" BIGINT,
"minutes" DOUBLE,
"minutes_per_game" DOUBLE,
"minutes_pct" DOUBLE,
"minutes_90s" DOUBLE,
"games_starts" BIGINT,
"minutes_per_start" DOUBLE,
"games_complete" BIGINT,
"games_subs" BIGINT,
"minutes_per_sub" DOUBLE,
"unused_subs" BIGINT,
"points_per_game" DOUBLE,
"on_goals_for" DOUBLE,
"on_goals_against" DOUBLE,
"plus_minus" DOUBLE,
"plus_minus_per90" DOUBLE,
"plus_minus_wowy" DOUBLE,
"on_xg_for" DOUBLE,
"on_xg_against" DOUBLE,
"xg_plus_minus" DOUBLE,
"xg_plus_minus_per90" DOUBLE,
"xg_plus_minus_wowy" DOUBLE
);
CREATE TABLE player_possession (
"player" VARCHAR,
"position" VARCHAR,
"team" VARCHAR,
"age" VARCHAR,
"birth_year" BIGINT,
"minutes_90s" DOUBLE,
"touches" DOUBLE,
"touches_def_pen_area" DOUBLE,
"touches_def_3rd" DOUBLE,
"touches_mid_3rd" DOUBLE,
"touches_att_3rd" DOUBLE,
"touches_att_pen_area" DOUBLE,
"touches_live_ball" DOUBLE,
"dribbles_completed" DOUBLE,
"dribbles" DOUBLE,
"dribbles_completed_pct" DOUBLE,
"miscontrols" DOUBLE,
"dispossessed" DOUBLE,
"passes_received" DOUBLE,
"progressive_passes_received" DOUBLE
);
CREATE TABLE player_shooting (
"player" VARCHAR,
"position" VARCHAR,
"team" VARCHAR,
"age" VARCHAR,
"birth_year" BIGINT,
"minutes_90s" DOUBLE,
"goals" BIGINT,
"shots" BIGINT,
"shots_on_target" BIGINT,
"shots_on_target_pct" DOUBLE,
"shots_per90" DOUBLE,
"shots_on_target_per90" DOUBLE,
"goals_per_shot" DOUBLE,
"goals_per_shot_on_target" DOUBLE,
"average_shot_distance" DOUBLE,
"shots_free_kicks" DOUBLE,
"pens_made" BIGINT,
"pens_att" BIGINT,
"xg" DOUBLE,
"npxg" DOUBLE,
"npxg_per_shot" DOUBLE,
"xg_net" DOUBLE,
"npxg_net" DOUBLE
);
CREATE TABLE player_stats (
"player" VARCHAR,
"position" VARCHAR,
"team" VARCHAR,
"age" VARCHAR,
"club" VARCHAR,
"birth_year" BIGINT,
"games" BIGINT,
"games_starts" BIGINT,
"minutes" BIGINT,
"minutes_90s" DOUBLE,
"goals" BIGINT,
"assists" BIGINT,
"goals_pens" BIGINT,
"pens_made" BIGINT,
"pens_att" BIGINT,
"cards_yellow" BIGINT,
"cards_red" BIGINT,
"goals_per90" DOUBLE,
"assists_per90" DOUBLE,
"goals_assists_per90" DOUBLE,
"goals_pens_per90" DOUBLE,
"goals_assists_pens_per90" DOUBLE,
"xg" DOUBLE,
"npxg" DOUBLE,
"xg_assist" DOUBLE,
"npxg_xg_assist" DOUBLE,
"xg_per90" DOUBLE,
"xg_assist_per90" DOUBLE,
"xg_xg_assist_per90" DOUBLE,
"npxg_per90" DOUBLE,
"npxg_xg_assist_per90" DOUBLE
);
Anyone who has the link will be able to view this.