LigaMX
Matches of the Liga MX of the 2016-2023 season
@kaggle.gerardojaimeescareo_ligamx_matches_2016_2022
Matches of the Liga MX of the 2016-2023 season
@kaggle.gerardojaimeescareo_ligamx_matches_2016_2022
Liga MX dataset (Mexico) matches from 2016 to 2022.
id - match idreferee - referee nametimezone - date timezonedate - datevenue_id - venue idvenue_name - venue namevenue_city - venue cityseason - year seasonround - round typehome_team - home team nameaway_team - away team namehome_win - true if home winaway_win - true if away winhome_goals - home goalsaway_goals - away goalshome_goals_half_time - home half time goalsaway_goals_half_time - away half time goalshome_goals_fulltime - home total goalsaway_goals_fulltime - away total goalshome_goals_extra_time - home extra time goalsaway_goals_extratime - away extra time goalshome_goals_penalty - home penalty goalsaway_goals_penalty - away penalty goalsCREATE TABLE n_2016_2022_liga_mx (
"id" BIGINT,
"referee" VARCHAR,
"timezone" VARCHAR,
"date" VARCHAR,
"venue_id" DOUBLE,
"venue_name" VARCHAR,
"venue_city" VARCHAR,
"season" BIGINT,
"round" VARCHAR,
"home_team" VARCHAR,
"away_team" VARCHAR,
"home_win" VARCHAR,
"away_win" VARCHAR,
"home_goals" DOUBLE,
"away_goals" DOUBLE,
"home_goals_half_time" DOUBLE,
"away_goals_half_time" DOUBLE,
"home_goals_fulltime" DOUBLE,
"away_goals_fulltime" DOUBLE,
"home_goals_extra_time" DOUBLE,
"away_goals_extratime" DOUBLE,
"home_goals_penalty" DOUBLE,
"away_goals_penalty" DOUBLE
);CREATE TABLE n_2016_2023_liga_mx (
"id" BIGINT,
"referee" VARCHAR,
"timezone" VARCHAR,
"date" VARCHAR,
"venue_id" DOUBLE,
"venue_name" VARCHAR,
"venue_city" VARCHAR,
"season" BIGINT,
"round" VARCHAR,
"home_team" VARCHAR,
"away_team" VARCHAR,
"home_win" VARCHAR,
"away_win" VARCHAR,
"home_goals" DOUBLE,
"away_goals" DOUBLE,
"home_goals_half_time" DOUBLE,
"away_goals_half_time" DOUBLE,
"home_goals_fulltime" DOUBLE,
"away_goals_fulltime" DOUBLE,
"home_goals_extra_time" DOUBLE,
"away_goals_extratime" DOUBLE,
"home_goals_penalty" DOUBLE,
"away_goals_penalty" DOUBLE
);Anyone who has the link will be able to view this.