FIFA World Cup 2022 Team Data
Comprehensive team data from the FIFA World Cup 2022
@kaggle.swaptr_fifa_world_cup_2022_statistics
Comprehensive team data from the FIFA World Cup 2022
@kaggle.swaptr_fifa_world_cup_2022_statistics
CREATE TABLE group_stats (
"unnamed_0" BIGINT,
"group" BIGINT,
"rank" BIGINT,
"team" VARCHAR,
"matches_played" BIGINT,
"wins" BIGINT,
"draws" BIGINT,
"losses" BIGINT,
"goals_scored" BIGINT,
"goals_against" BIGINT,
"goal_difference" BIGINT,
"points" BIGINT,
"expected_goal_scored" DOUBLE,
"exp_goal_conceded" DOUBLE,
"exp_goal_difference" DOUBLE,
"exp_goal_difference_per_90" DOUBLE
);
CREATE TABLE team_data (
"team" VARCHAR,
"players_used" BIGINT,
"avg_age" DOUBLE,
"possession" DOUBLE,
"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,
"gk_games" BIGINT,
"gk_games_starts" BIGINT,
"gk_minutes" BIGINT,
"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,
"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,
"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" BIGINT,
"npxg_per_shot" DOUBLE,
"xg_net" DOUBLE,
"npxg_net" DOUBLE,
"passes_completed" BIGINT,
"passes" BIGINT,
"passes_pct" DOUBLE,
"passes_total_distance" BIGINT,
"passes_progressive_distance" BIGINT,
"passes_completed_short" BIGINT,
"passes_short" BIGINT,
"passes_pct_short" DOUBLE,
"passes_completed_medium" BIGINT,
"passes_medium" BIGINT,
"passes_pct_medium" DOUBLE,
"passes_completed_long" BIGINT,
"passes_long" BIGINT,
"passes_pct_long" DOUBLE,
"pass_xa" DOUBLE,
"xg_assist_net" DOUBLE,
"assisted_shots" BIGINT,
"passes_into_final_third" BIGINT
);
Anyone who has the link will be able to view this.