Football Database

Football and Betting Statistics of the European Top5 Leagues

@kaggle.technika148_football_database

Table List

6 tables(15.71 MB)

Appearances

Games

Leagues

Shots

Teams

Teamstats

Games

@kaggle.technika148_football_database.games

660.19 KB
12680 rows
34 columns

gameid GameID	leagueid LeagueID	season Season	date Date	hometeamid HomeTeamID	awayteamid AwayTeamID	homegoals HomeGoals	awaygoals AwayGoals	homeprobability HomeProbability	drawprobability DrawProbability	awayprobability AwayProbability	homegoalshalftime HomeGoalsHalfTime	awaygoalshalftime AwayGoalsHalfTime	b365h B365H	b365d B365D	b365a B365A	bwh BWH	bwd BWD	bwa BWA	iwh IWH	iwd IWD	iwa IWA	psh PSH	psd PSD	psa PSA	whh WHH	whd WHD	wha WHA	vch VCH	vcd VCD	vca VCA	psch PSCH	pscd PSCD	psca PSCA
81	1	2015	Sat Aug 08 2015 15:45:00 GMT+0000 (Coordinated Universal Time)	89	82	1		0.2843	0.3999	0.3158	1		1.65	4	6	1.65	4	5.5	1.65	3.6	5.1	1.65	4.09	5.9	1.62	3.6	6	1.67	4	5.75	1.64	4.07	6.04
82	1	2015	Sat Aug 08 2015 18:00:00 GMT+0000 (Coordinated Universal Time)	73	71		1	0.3574	0.35	0.2926			2	3.6	4	2	3.3	3.7	2.1	3.3	3.3	1.95	3.65	4.27	1.91	3.5	4	2	3.5	4.2	1.82	3.88	4.7
83	1	2015	Sat Aug 08 2015 18:00:00 GMT+0000 (Coordinated Universal Time)	72	90	2	2	0.2988	0.4337	0.2675		1	1.7	3.9	5.5	1.7	3.5	5	1.7	3.6	4.7	1.7	3.95	5.62	1.73	3.5	5	1.73	3.9	5.4	1.75	3.76	5.44
84	1	2015	Sat Aug 08 2015 18:00:00 GMT+0000 (Coordinated Universal Time)	75	77	4	2	0.6422	0.2057	0.1521	3		1.95	3.5	4.33	2	3.3	3.75	2	3.3	3.6	1.99	3.48	4.34	2	3.1	2.7	2	3.4	4.33	1.79	3.74	5.1
85	1	2015	Sat Aug 08 2015 18:00:00 GMT+0000 (Coordinated Universal Time)	79	78	1	3	0.1461	0.2159	0.638		1	2.55	3.3	3	2.6	3.2	2.7	2.4	3.2	2.85	2.52	3.35	3.08	2.6	3.1	2.88	2.6	3.25	3	2.46	3.39	3.14
86	1	2015	Sat Aug 08 2015 20:30:00 GMT+0000 (Coordinated Universal Time)	80	84	2	2	0.0304	0.0924	0.8772	2	1	1.36	5	11	1.4	4.75	9	1.33	4.8	8.3	1.39	4.92	10.39	1.4	4	10	1.4	5	9.5	1.37	5.04	10.88
87	1	2015	Sun Aug 09 2015 16:30:00 GMT+0000 (Coordinated Universal Time)	86	74	2	2	0.4386	0.3165	0.2449	1	1	2.88	3.3	2.7	2.8	3.1	2.75	2.65	3.3	2.5	2.88	3.33	2.69	2.7	3.1	2.7	2.88	3.25	2.7	3.09	3.28	2.55
88	1	2015	Sun Aug 09 2015 16:30:00 GMT+0000 (Coordinated Universal Time)	83	81		2	0.5751	0.2826	0.1423		1	1.29	6	12	1.28	5.75	10.5	1.33	4.8	8.3	1.31	5.75	12	1.3	5	11	1.3	5.75	12	1.24	6.75	15
89	1	2015	Sun Aug 09 2015 19:00:00 GMT+0000 (Coordinated Universal Time)	85	87		1	0.2482	0.5454	0.2064			3.4	3.4	2.3	3.2	3.4	2.3	2.9	3.3	2.3	3.48	3.46	2.25	3.3	3.1	2.3	3.4	3.4	2.3	3.89	3.51	2.09
90	1	2015	Mon Aug 10 2015 23:00:00 GMT+0000 (Coordinated Universal Time)	76	88		3	0.0615	0.1698	0.7687		2	5.75	4	1.67	4.75	4	1.65	5.1	3.6	1.65	5.75	3.98	1.68	5.5	3.5	1.7	5.5	4	1.7	6.46	4.08	1.61


CREATE TABLE games (
  "gameid" BIGINT,
  "leagueid" BIGINT,
  "season" BIGINT,
  "date" TIMESTAMP,
  "hometeamid" BIGINT,
  "awayteamid" BIGINT,
  "homegoals" BIGINT,
  "awaygoals" BIGINT,
  "homeprobability" DOUBLE,
  "drawprobability" DOUBLE,
  "awayprobability" DOUBLE,
  "homegoalshalftime" BIGINT,
  "awaygoalshalftime" BIGINT,
  "b365h" DOUBLE,
  "b365d" DOUBLE,
  "b365a" DOUBLE,
  "bwh" DOUBLE,
  "bwd" DOUBLE,
  "bwa" DOUBLE,
  "iwh" DOUBLE,
  "iwd" DOUBLE,
  "iwa" DOUBLE,
  "psh" DOUBLE,
  "psd" DOUBLE,
  "psa" DOUBLE,
  "whh" DOUBLE,
  "whd" DOUBLE,
  "wha" DOUBLE,
  "vch" DOUBLE,
  "vcd" DOUBLE,
  "vca" DOUBLE,
  "psch" DOUBLE,
  "pscd" DOUBLE,
  "psca" DOUBLE
);