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
1800+ football matches data with 68 columns of crucial event's statistics.
@kaggle.tobi303x_football_matches_european_big_five_2021_2022
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
);
Anyone who has the link will be able to view this.