Football - Coaching

Coaching Dataset focused on Football

@kaggle.frtgnn_football_coaching

Table List

1 table(81.11 KB)

Football

@kaggle.frtgnn_football_coaching.football

81.11 KB
380 rows
65 columns

div Div	date Date	hometeam HomeTeam	awayteam AwayTeam	fthg FTHG	ftag FTAG	ftr FTR	hthg HTHG	htag HTAG	htr HTR	referee Referee	hs HS	as AS	hst HST	ast AST	hf HF	af AF	hc HC	ac AC	hy HY	ay AY	ar AR	b365h B365H	b365d B365D	b365a B365A	bwh BWH	bwd BWD	bwa BWA	iwh IWH	iwd IWD	iwa IWA	lbh LBH	lbd LBD	lba LBA	psh PSH	psd PSD	psa PSA	whh WHH	whd WHD	wha WHA	vch VCH	vcd VCD	vca VCA	bb1x2 Bb1X2	bbmxh BbMxH	bbavh BbAvH	bbmxd BbMxD	bbavd BbAvD	bbmxa BbMxA	bbava BbAvA	bbou BbOU	bbmx_2_5 BbMx\u003e2.5	bbav_2_5 BbAv\u003e2.5	bbmx_2_5_994fdb BbMx\u003c2.5	bbav_2_5_b3ab09 BbAv\u003c2.5	bbah BbAH	bbahh BbAHh	bbmxahh BbMxAHH	bbavahh BbAvAHH	bbmxaha BbMxAHA	bbavaha BbAvAHA	psch PSCH	pscd PSCD	psca PSCA
E0	13/08/16	Burnley	Swansea		1	A			D	J Moss	10	17	3	9	10	14	7	4	3	2		2.4	3.3	3.25	2.45	3.1	2.95	2.5	3.3	2.65	2.45	3.25	3.1	2.47	3.32	3.19	2.5	3.2	2.9	2.5	3.2	3.25	55	2.55	2.43	3.35	3.21	3.3	3.1	40	2.4	2.3	1.68	1.61	32	-0.25	2.13	2.06	1.86	1.81	2.79	3.16	2.89
E0	13/08/16	Crystal Palace	West Brom		1	A			D	C Pawson	14	13	4	3	12	15	3	6	2	2		2	3.3	4.5	2	3.2	3.9	2.1	3.3	3.3	2	3.25	4.33	2.06	3.29	4.32	2.05	3.1	4	2	3.3	4.4	56	2.1	2.01	3.4	3.23	4.5	4.16	38	2.68	2.5	1.6	1.52	33	-0.5	2.07	2	1.9	1.85	2.25	3.15	3.86
E0	13/08/16	Everton	Tottenham	1	1	D	1		H	M Atkinson	12	13	6	4	10	14	5	6				3.2	3.4	2.4	2.95	3.2	2.4	2.65	3.3	2.5	3.1	3.4	2.4	3.25	3.43	2.37	3.1	3.1	2.4	3.25	3.4	2.38	55	3.3	3.12	3.45	3.32	2.5	2.36	41	2.12	2.05	1.87	1.77	32	0.25	1.91	1.85	2.09	2	3.64	3.54	2.16
E0	13/08/16	Hull	Leicester	2	1	H	1		H	M Dean	14	18	5	5	8	17	5	3	2	2		4.5	3.6	1.91	4.33	3.4	1.9	3.3	3.3	2.1	4.5	3.5	1.91	4.43	3.55	1.95	4.2	3.25	1.95	4.4	3.5	1.95	55	4.5	4.17	3.6	3.43	2.33	1.95	40	2.3	2.19	1.74	1.67	31	0.25	2.35	2.26	2.03	1.67	4.68	3.5	1.92
E0	13/08/16	Man City	Sunderland	2	1	H	1		H	R Madley	16	7	4	3	11	14	9	6	1	2		1.25	6.5	15	1.22	6	11.5	1.25	5.5	10.3	1.25	6.5	13	1.27	6.48	13.15	1.25	5.5	13	1.25	6.5	15	56	1.3	1.25	6.8	6.11	15	12.55	39	1.56	1.53	2.67	2.48	34	-1.5	1.81	1.73	2.2	2.14	1.25	6.5	14.5
E0	13/08/16	Middlesbrough	Stoke	1	1	D	1		H	K Friend	12	12	2	1	18	14	9	6	3	5		2.38	3.2	3.4	2.25	3.1	3.25	2.3	3.3	2.9	2.3	3.2	3.4	2.33	3.24	3.53	2.4	3.1	3.1	2.38	3.2	3.4	56	2.4	2.31	3.3	3.16	3.65	3.38	38	2.61	2.46	1.57	1.53	32	-0.25	1.99	1.93	1.97	1.92	2.2	3.38	3.7
E0	13/08/16	Southampton	Watford	1	1	D		1	A	R East	24	5	6	1	8	12	6	2	1	2	1	1.8	3.75	5	1.8	3.4	4.5	1.8	3.5	4.2	1.8	3.6	5	1.88	3.68	4.64	1.83	3.4	4.5	1.83	3.6	5	56	1.88	1.82	3.8	3.56	5	4.62	42	2.13	2.06	1.83	1.75	33	-0.75	2.16	2.07	1.89	1.8	1.8	3.83	4.91
E0	14/08/16	Arsenal	Liverpool	3	4	A	1	1	D	M Oliver	9	16	5	7	13	17	5	4	3	3		2.4	3.5	3.1	2.35	3.3	2.9	2.3	3.3	2.9	2.38	3.4	3.1	2.41	3.53	3.1	2.5	3.1	3	2.4	3.5	3.1	55	2.5	2.36	3.55	3.42	3.2	3.04	42	1.98	1.81	2.09	1.99	31	-0.5	2.41	2.31	1.81	1.64	2.8	3.44	2.68
E0	14/08/16	Bournemouth	Man United	1	3	A		1	A	A Marriner	9	11	3	7	7	10	4	2		1		4.75	3.6	1.85	4.6	3.5	1.75	4.5	3.5	1.75	4.8	3.6	1.8	4.7	3.62	1.88	4.5	3.4	1.85	4.75	3.6	1.87	55	5	4.5	3.75	3.51	1.95	1.86	42	2.11	2.05	1.87	1.76	33	0.75	1.8	1.76	2.17	2.11	5.4	3.65	1.78
E0	15/08/16	Chelsea	West Ham	2	1	H			D	A Taylor	16	7	6	3	16	16	7	1	5	2		1.65	4	6	1.6	3.75	5.5	1.65	3.6	5.1	1.62	4	6	1.68	4.16	5.48	1.67	3.6	5.5	1.65	4.1	5.75	52	1.71	1.64	4.25	3.97	6	5.46	40	1.97	1.8	2.09	2.01	33	-1	2.2	2.1	1.8	1.76	1.52	4.38	7.45


CREATE TABLE football (
  "div" VARCHAR,
  "date" VARCHAR,
  "hometeam" VARCHAR,
  "awayteam" VARCHAR,
  "fthg" BIGINT,
  "ftag" BIGINT,
  "ftr" VARCHAR,
  "hthg" BIGINT,
  "htag" BIGINT,
  "htr" VARCHAR,
  "referee" VARCHAR,
  "hs" BIGINT,
  "as" BIGINT,
  "hst" BIGINT,
  "ast" BIGINT,
  "hf" BIGINT,
  "af" BIGINT,
  "hc" BIGINT,
  "ac" BIGINT,
  "hy" BIGINT,
  "ay" BIGINT,
  "hr" BIGINT,
  "ar" BIGINT,
  "b365h" DOUBLE,
  "b365d" DOUBLE,
  "b365a" DOUBLE,
  "bwh" DOUBLE,
  "bwd" DOUBLE,
  "bwa" DOUBLE,
  "iwh" DOUBLE,
  "iwd" DOUBLE,
  "iwa" DOUBLE,
  "lbh" DOUBLE,
  "lbd" DOUBLE,
  "lba" DOUBLE,
  "psh" DOUBLE,
  "psd" DOUBLE,
  "psa" DOUBLE,
  "whh" DOUBLE,
  "whd" DOUBLE,
  "wha" DOUBLE,
  "vch" DOUBLE,
  "vcd" DOUBLE,
  "vca" DOUBLE,
  "bb1x2" BIGINT,
  "bbmxh" DOUBLE,
  "bbavh" DOUBLE,
  "bbmxd" DOUBLE,
  "bbavd" DOUBLE,
  "bbmxa" DOUBLE,
  "bbava" DOUBLE,
  "bbou" BIGINT,
  "bbmx_2_5" DOUBLE,
  "bbav_2_5" DOUBLE,
  "bbmx_2_5_994fdb" DOUBLE,
  "bbav_2_5_b3ab09" DOUBLE,
  "bbah" BIGINT,
  "bbahh" DOUBLE,
  "bbmxahh" DOUBLE,
  "bbavahh" DOUBLE,
  "bbmxaha" DOUBLE,
  "bbavaha" DOUBLE,
  "psch" DOUBLE,
  "pscd" DOUBLE,
  "psca" DOUBLE
);