Baselight

Football Matches, European Big Five (2021-2022)

1800+ football matches data with 68 columns of crucial event's statistics.

@kaggle.tobi303x_football_matches_european_big_five_2021_2022

Loading...
Loading...

About this Dataset

Football Matches, European Big Five (2021-2022)

This dataset can be used for a variety of purposes, including match analysis, player performance evaluation, and predictive modeling.

I strongly encourage you to check my notebook with data preprocesing and database that I created from this Dataset.

I must insist that you do not make any commercial use of the data.

Tables

Big Five 2021–2022 Merged

@kaggle.tobi303x_football_matches_european_big_five_2021_2022.big_five_2021_2022_merged
  • 643.12 KB
  • 1825 rows
  • 68 columns
Loading...

CREATE TABLE big_five_2021_2022_merged (
  "league" VARCHAR,
  "home" VARCHAR,
  "away" VARCHAR,
  "home_score" BIGINT,
  "away_score" BIGINT,
  "home_xg" DOUBLE,
  "away_xg" DOUBLE,
  "home_league_score" VARCHAR,
  "away_league_score" VARCHAR,
  "home_scorers" VARCHAR,
  "away_scorers" VARCHAR,
  "home_penalty_scorers" VARCHAR,
  "away_penalty_scorers" VARCHAR,
  "home_own_goal_scorers" VARCHAR,
  "away_own_goal_scorers" VARCHAR,
  "home_goals_minutes" VARCHAR,
  "away_goals_minutes" VARCHAR,
  "home_penalty_goals_minutes" VARCHAR,
  "away_penalty_goals_minutes" VARCHAR,
  "home_own_goal_minutes" VARCHAR,
  "away_own_goal_minutes" VARCHAR,
  "home_manager" VARCHAR,
  "away_manager" VARCHAR,
  "home_captain" VARCHAR,
  "away_captain" VARCHAR,
  "date" TIMESTAMP,
  "venue_time" VARCHAR,
  "attendance" DOUBLE,
  "venue" VARCHAR,
  "referee" VARCHAR,
  "ar1" VARCHAR,
  "ar2" VARCHAR,
  "fourth_official" VARCHAR,
  "var" VARCHAR,
  "home_formation" VARCHAR,
  "away_formation" VARCHAR,
  "home_first_squad" VARCHAR,
  "away_first_squad" VARCHAR,
  "home_bench" VARCHAR,
  "away_bench" VARCHAR,
  "home_fouls" BIGINT,
  "away_fouls" BIGINT,
  "home_corners" BIGINT,
  "away_corners" BIGINT,
  "home_crosses" BIGINT,
  "away_crosses" BIGINT,
  "home_touches" BIGINT,
  "away_touches" BIGINT,
  "home_tackles" BIGINT,
  "away_tackles" BIGINT,
  "home_interceptions" BIGINT,
  "away_interceptions" BIGINT,
  "home_aerials_won" BIGINT,
  "away_aerials_won" BIGINT,
  "home_clearances" BIGINT,
  "away_clearances" BIGINT,
  "home_offsides" BIGINT,
  "away_offsides" BIGINT,
  "home_goal_kicks" BIGINT,
  "away_goal_kicks" BIGINT,
  "home_throw_ins" BIGINT,
  "away_throw_ins" BIGINT,
  "home_long_balls" BIGINT,
  "away_long_balls" BIGINT,
  "home_yellow_cards" BIGINT,
  "home_red_cards" BIGINT,
  "away_yellow_cards" BIGINT,
  "away_red_cards" BIGINT
);

Share link

Anyone who has the link will be able to view this.