Context

This dataset contains comprehensive data related to the Euro 2024 football tournament, scraped from FotMob, a popular platform for football statistics and updates. The data includes match details, team information, player statistics, and other relevant metrics that are essential for in-depth analysis of the tournament.

Updates

Update 1: Fixing cards mistakes

Update 2: Adding Semi-final

Update 3: Adding Final

Tables

Euro 2024 Matches

@kaggle.thamersekhri_euro_2024_matches.euro_2024_matches

76.67 KB
51 rows
86 columns


CREATE TABLE euro_2024_matches (
  "stadium" VARCHAR,
  "attendance" BIGINT,
  "home_team" VARCHAR,
  "away_team" VARCHAR,
  "home_goals" BIGINT,
  "away_goals" BIGINT,
  "home_expected_goals_xg" DOUBLE,
  "home_total_shots" BIGINT,
  "home_shots_on_target" BIGINT,
  "home_big_chances" BIGINT,
  "home_big_chances_missed" BIGINT,
  "home_accurate_passes" VARCHAR,
  "home_fouls_committed" BIGINT,
  "home_corners" BIGINT,
  "home_total_shots_f642c2" BIGINT,
  "home_shots_off_target" BIGINT,
  "home_shots_on_target_152386" BIGINT,
  "home_blocked_shots" BIGINT,
  "home_hit_woodwork" BIGINT,
  "home_shots_inside_box" BIGINT,
  "home_shots_outside_box" BIGINT,
  "home_expected_goals_xg_4507de" DOUBLE,
  "home_xg_open_play" DOUBLE,
  "home_xg_set_play" DOUBLE,
  "home_non_penalty_xg" DOUBLE,
  "home_xg_on_target_xgot" DOUBLE,
  "home_passes" BIGINT,
  "home_accurate_passes_1" VARCHAR,
  "home_own_half" BIGINT,
  "home_opposition_half" BIGINT,
  "home_accurate_long_balls" VARCHAR,
  "home_accurate_crosses" VARCHAR,
  "home_throws" BIGINT,
  "home_touches_in_opposition_box" BIGINT,
  "home_offsides" BIGINT,
  "home_yellow_cards" BIGINT,
  "home_red_cards" BIGINT,
  "home_tackles_won" VARCHAR,
  "home_interceptions" BIGINT,
  "home_blocks" BIGINT,
  "home_clearances" BIGINT,
  "home_keeper_saves" BIGINT,
  "home_duels_won" BIGINT,
  "home_ground_duels_won" VARCHAR,
  "home_aerial_duels_won" VARCHAR,
  "home_successful_dribbles" VARCHAR,
  "away_expected_goals_xg" DOUBLE,
  "away_total_shots" BIGINT,
  "away_shots_on_target" BIGINT,
  "away_big_chances" BIGINT,
  "away_big_chances_missed" BIGINT,
  "away_accurate_passes" VARCHAR,
  "away_fouls_committed" BIGINT,
  "away_corners" BIGINT,
  "away_total_shots_c48adb" BIGINT,
  "away_shots_off_target" BIGINT,
  "away_shots_on_target_c45d6d" BIGINT,
  "away_blocked_shots" BIGINT,
  "away_hit_woodwork" BIGINT,
  "away_shots_inside_box" BIGINT,
  "away_shots_outside_box" BIGINT,
  "away_expected_goals_xg_beb5ec" DOUBLE,
  "away_xg_open_play" DOUBLE,
  "away_xg_set_play" DOUBLE,
  "away_non_penalty_xg" DOUBLE,
  "away_xg_on_target_xgot" DOUBLE,
  "away_passes" BIGINT,
  "away_accurate_passes_1" VARCHAR,
  "away_own_half" BIGINT,
  "away_opposition_half" BIGINT,
  "away_accurate_long_balls" VARCHAR,
  "away_accurate_crosses" VARCHAR,
  "away_throws" BIGINT,
  "away_touches_in_opposition_box" BIGINT,
  "away_offsides" BIGINT,
  "away_yellow_cards" BIGINT,
  "away_red_cards" BIGINT,
  "away_tackles_won" VARCHAR,
  "away_interceptions" BIGINT,
  "away_blocks" BIGINT,
  "away_clearances" BIGINT,
  "away_keeper_saves" BIGINT,
  "away_duels_won" BIGINT,
  "away_ground_duels_won" VARCHAR,
  "away_aerial_duels_won" VARCHAR,
  "away_successful_dribbles" VARCHAR
);