Comprehensive Football Dataset

Detailed dataset for football events and Europe's top 5 leagues

@kaggle.prathamsharma123_comprehensive_football_dataset

Table List

7 tables(28.73 MB)

Bundesliga Points

Events

Ginf

Ginf

@kaggle.prathamsharma123_comprehensive_football_dataset.ginf

450.91 KB
10112 rows
18 columns

id_odsp Id Odsp	link_odsp Link Odsp	adv_stats Adv Stats	date Date	league League	season Season	country Country	ht Ht	at At	fthg Fthg	ftag Ftag	odd_h Odd H	odd_d Odd D	odd_a Odd A
UFot0hit/	/soccer/germany/bundesliga-2011-2012/dortmund-hamburger-UFot0hit/	true	Fri Aug 05 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	D1	2012	germany	Borussia Dortmund	Hamburg SV	3	1	1.56	4.41	7.42
Aw5DflLH/	/soccer/germany/bundesliga-2011-2012/augsburg-freiburg-Aw5DflLH/	true	Sat Aug 06 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	D1	2012	germany	FC Augsburg	SC Freiburg	2	2	2.36	3.6	3.4
bkjpaC6n/	/soccer/germany/bundesliga-2011-2012/werder-bremen-kaiserslautern-bkjpaC6n/	true	Sat Aug 06 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	D1	2012	germany	Werder Bremen	Kaiserslautern	2		1.83	4.2	4.8
CzPV312a/	/soccer/france/ligue-1-2011-2012/paris-sg-lorient-CzPV312a/	true	Sat Aug 06 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	F1	2012	france	Paris Saint-Germain	Lorient		1	1.55	4.5	9.4
GUOdmtII/	/soccer/france/ligue-1-2011-2012/caen-valenciennes-GUOdmtII/	true	Sat Aug 06 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	F1	2012	france	Caen	Valenciennes	1		2.5	3.4	3.45
lOpzwMkp/	/soccer/germany/bundesliga-2011-2012/hertha-berlin-nurnberg-lOpzwMkp/	true	Sat Aug 06 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	D1	2012	germany	Hertha Berlin	Nurnberg		1	2.06	3.75	3.95
M7PhlM2C/	/soccer/france/ligue-1-2011-2012/brest-evian-tg-M7PhlM2C/	true	Sat Aug 06 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	F1	2012	france	Brest	Evian Thonon Gaillard	2	2	2.29	3.25	3.85
QuWqjrYa/	/soccer/france/ligue-1-2011-2012/ac-ajaccio-toulouse-QuWqjrYa/	true	Sat Aug 06 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	F1	2012	france	AC Ajaccio	Toulouse		2	2.8	3.1	3.05
UBZQ4smg/	/soccer/france/ligue-1-2011-2012/nice-lyon-UBZQ4smg/	true	Sat Aug 06 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	F1	2012	france	Nice	Lyon	1	3	4.5	3.55	2
Wn69eU5B/	/soccer/germany/bundesliga-2011-2012/koln-wolfsburg-Wn69eU5B/	true	Sat Aug 06 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	D1	2012	germany	FC Cologne	VfL Wolfsburg		3	3	3.8	2.54


CREATE TABLE ginf (
  "id_odsp" VARCHAR,
  "link_odsp" VARCHAR,
  "adv_stats" BOOLEAN,
  "date" TIMESTAMP,
  "league" VARCHAR,
  "season" BIGINT,
  "country" VARCHAR,
  "ht" VARCHAR,
  "at" VARCHAR,
  "fthg" BIGINT,
  "ftag" BIGINT,
  "odd_h" DOUBLE,
  "odd_d" DOUBLE,
  "odd_a" DOUBLE,
  "odd_over" DOUBLE,
  "odd_under" DOUBLE,
  "odd_bts" DOUBLE,
  "odd_bts_n" DOUBLE
);