LigaMX

Matches of the Liga MX of the 2016-2023 season

@kaggle.gerardojaimeescareo_ligamx_matches_2016_2022

Table List

2 tables(136.03 KB)

N 2016–2022 Liga Mx

N 2016–2023 Liga Mx

N 2016–2022 Liga Mx

@kaggle.gerardojaimeescareo_ligamx_matches_2016_2022.n_2016_2022_liga_mx

64.58 KB
2366 rows
23 columns

id Id	referee Referee	timezone Timezone	date Date	venue_id Venue Id	venue_name Venue Name	venue_city Venue City	season Season	round Round	home_team Home Team	away_team Away Team	home_win Home Win	away_win Away Win	home_goals Home Goals	away_goals Away Goals	home_goals_half_time Home Goals Half Time	away_goals_half_time Away Goals Half Time	home_goals_fulltime Home Goals Fulltime	away_goals_fulltime Away Goals Fulltime
864094	L. Santander	UTC	2022-07-02T22:00:00+00:00	1080	Estadio Victoria de Aguascalientes	Aguascalientes	2022	Apertura - 1	Necaxa	Toluca	False	True	1	3	1	2	1	3
864095	D. Quintero	UTC	2022-07-02T02:05:00+00:00	10546	Estadio de Mazatlán	Mazatlán	2022	Apertura - 1	Mazatlán	Puebla	False	True	2	4		2	2	4
864096	I. Lopez	UTC	2022-07-02T22:00:00+00:00	1076	Estadio AKRON	Zapopan	2022	Apertura - 1	Guadalajara Chivas	FC Juarez	nan	nan
864097	Ó. Mejía	UTC	2022-07-03T00:05:00+00:00	1087	Estadio Universitario de Nuevo León	San Nicolás de los Garza	2022	Apertura - 1	Tigres UANL	Cruz Azul	False	True	2	3		1	2	3
864098	F. Guerrero	UTC	2022-07-03T02:05:00+00:00	7182	Estadio Azteca	D.F.	2022	Apertura - 1	Club America	Atlas	nan	nan
864099	A. Escobedo	UTC	2022-07-03T17:00:00+00:00	1083	Estadio Olímpico de Universitario	D.F.	2022	Apertura - 1	U.N.A.M. - Pumas	Club Tijuana	nan	nan	1	1		1	1	1
864100	F. Hernández	UTC	2022-07-03T22:00:00+00:00	1795	Estadio Alfonso Lastras Ramírez	San Luis Potosí	2022	Apertura - 1	Atletico San Luis	Leon	False	True	1	2		1	1	2
864101	J. Pérez	UTC	2022-07-04T00:05:00+00:00	1085	Estadio Nuevo Corona	Torreón	2022	Apertura - 1	Santos Laguna	Monterrey	True	False	4	3	2	2	4	3
864102	C. Ramos	UTC	2022-07-05T02:00:00+00:00	1081	Estadio Hidalgo	Pachuca de Soto	2022	Apertura - 1	Pachuca	Club Queretaro	True	False	2		1		2
864103	A. Escobedo	UTC	2022-07-09T00:00:00+00:00	10546	Estadio de Mazatlán	Mazatlán	2022	Apertura - 2	Mazatlán	Tigres UANL	False	True		1		1		1


CREATE 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
);