Fifa World Cup 2022
This is complete dataset of all the matches that took place in Fifa WC 2022.
@kaggle.ashishmotwani_fifa_world_cup_2022
This is complete dataset of all the matches that took place in Fifa WC 2022.
@kaggle.ashishmotwani_fifa_world_cup_2022
CREATE TABLE world_cup_data (
"match" BIGINT,
"team1" VARCHAR,
"team2" VARCHAR,
"team1_xg" DOUBLE,
"team2_xg" DOUBLE,
"score" VARCHAR,
"xg_score" VARCHAR,
"date" VARCHAR,
"attendance" DOUBLE,
"venue" VARCHAR,
"referee" VARCHAR,
"team1_captain" VARCHAR,
"team2_captain" VARCHAR,
"team1_manager" VARCHAR,
"team2_manager" VARCHAR,
"team1_possession" DOUBLE,
"team2_possession" DOUBLE,
"team1_completed_passes" DOUBLE,
"team1_attempted_pases" DOUBLE,
"team2_completed_passes" DOUBLE,
"team2_attempted_pases" DOUBLE,
"team1_shots_on_target" DOUBLE,
"team2_shots_on_target" DOUBLE,
"team1_total_shots" DOUBLE,
"team2_total_shots" DOUBLE,
"team1_saves" DOUBLE,
"team2_saves" DOUBLE,
"team1_fouls" DOUBLE,
"team2_fouls" DOUBLE,
"team1_corners" DOUBLE,
"team2_corners" DOUBLE,
"team1_crosses" DOUBLE,
"team2_crosses" DOUBLE,
"team1_tackles" DOUBLE,
"team2_tackles" DOUBLE,
"team1_interceptions" DOUBLE,
"team2_interceptions" DOUBLE,
"team1_aerials_won" DOUBLE,
"team2_aerials_won" DOUBLE,
"team1_clearances" DOUBLE,
"team2_clearances" DOUBLE,
"team1_offsides" DOUBLE,
"team2_offsides" DOUBLE,
"penalties_scored_team1" DOUBLE,
"penalties_scored_team2" DOUBLE,
"free_kicks_team1" DOUBLE,
"free_kicks_team2" DOUBLE,
"yellow_cards_team1" DOUBLE,
"yellow_cards_team2" DOUBLE,
"red_cards_team1" DOUBLE,
"red_cards_team2" DOUBLE
);
Anyone who has the link will be able to view this.