Turkish Super League Matches (1959-2021)

All matches played in Turkish Super League history

@kaggle.faruky_turkish_super_league_matches_19592020

Table List

1 table(202.68 KB)

Tsl Dataset

@kaggle.faruky_turkish_super_league_matches_19592020.tsl_dataset

202.68 KB
18079 rows
23 columns

date Date	season Season	week Week	home Home	visitor Visitor	ft FT	hgoal Hgoal	vgoal Vgoal	division Division	tier Tier	totgoal Totgoal	goaldiff Goaldiff	result Result	ht HT	hgoal_half Hgoal Half	vgoal_half Vgoal Half	half_totgoal Half Totgoal	half_goaldiff Half Goaldiff	result_half Result Half	fans Fans
1959-02-21	1958	1	Genclerbirligi	Adalet	1-1	1	1	T1	1	2		D	0-1		1	1	-1	A	1
1959-02-21	1958	1	Izmirspor	Beykoz 1908	2-1	2	1	T1	1	3	1	H	2-0	2		2	2	H	1
1959-02-21	1958	1	Ankara Demirspor	Galatasaray	0-2		2	T1	1	2	-2	A	0-1		1	1	-1	A	1
1959-02-21	1958	1	Fenerbahce	MKE Ankaragucu	3-1	3	1	T1	1	4	2	H	1-1	1	1	2		D	1
1959-02-21	1958	1	Altay	Besiktas	1-2	1	2	T1	1	3	-1	A	0-1		1	1	-1	A	1
1959-02-21	1958	1	Istanbulspor	Ankara Keciorengucu	0-2		2	T1	1	2	-2	A	0-0					D	1
1959-02-22	1958	1	Altay	Beykoz 1908	2-2	2	2	T1	1	4		D	0-1		1	1	-1	A	1
1959-02-22	1958	1	Istanbulspor	MKE Ankaragucu	1-1	1	1	T1	1	2		D	0-0					D	1
1959-02-22	1958	1	Fenerbahce	Ankara Keciorengucu	2-1	2	1	T1	1	3	1	H	1-0	1		1	1	H	1
1959-02-22	1958	1	Genclerbirligi	Galatasaray	0-0			T1	1			D	0-0					D	1


CREATE TABLE tsl_dataset (
  "date" VARCHAR,
  "season" BIGINT,
  "week" BIGINT,
  "home" VARCHAR,
  "visitor" VARCHAR,
  "ft" VARCHAR,
  "hgoal" BIGINT,
  "vgoal" BIGINT,
  "division" VARCHAR,
  "tier" BIGINT,
  "totgoal" BIGINT,
  "goaldiff" BIGINT,
  "result" VARCHAR,
  "ht" VARCHAR,
  "hgoal_half" BIGINT,
  "vgoal_half" BIGINT,
  "half_totgoal" BIGINT,
  "half_goaldiff" BIGINT,
  "result_half" VARCHAR,
  "fans" BIGINT,
  "neutral" BIGINT,
  "home_red_card" BIGINT,
  "visitor_red_card" BIGINT
);