Japanese J1 League Results

J1 League Results (2012 to 2022)

@kaggle.irkaal_japanese_j1_league

Results

@kaggle.irkaal_japanese_j1_league.results

season Season	datetime DateTime	home Home	away Away	hg HG	ag AG	res Res
2012	2012-03-10T05:00:00Z	Gamba Osaka	Vissel Kobe	2	3	A
2012	2012-03-10T05:00:00Z	Sanfrecce Hiroshima	Urawa Reds	1		H
2012	2012-03-10T05:00:00Z	Nagoya Grampus	Shimizu S-Pulse	1		H
2012	2012-03-10T05:00:00Z	Sagan Tosu	Cerezo Osaka			D
2012	2012-03-10T05:00:00Z	Hokkaido Consadole Sapporo	Iwata			D
2012	2012-03-10T05:00:00Z	Vegalta Sendai	Kashima Antlers	1		H
2012	2012-03-10T08:00:00Z	Kawasaki Frontale	Albirex Niigata	1		H
2012	2012-03-10T10:00:00Z	Omiya Ardija	FC Tokyo		1	A
2012	2012-03-11T05:00:00Z	Kashiwa Reysol	Yokohama F. Marinos	3	3	D
2012	2012-03-17T05:00:00Z	Albirex Niigata	Omiya Ardija	1	2	A


CREATE TABLE results (
  "season" BIGINT,
  "datetime" VARCHAR,
  "home" VARCHAR,
  "away" VARCHAR,
  "hg" BIGINT,
  "ag" BIGINT,
  "res" VARCHAR
);