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