Australian Football League (AFL) Database

All of the key stats, game by game, player by player

@kaggle.stoney71_aflstats

Table List

3 tables(2 MB)

Games

Players

Stats

Games

@kaggle.stoney71_aflstats.games

109.87 KB
2663 rows
22 columns

gameid GameId	year Year	round Round	date Date	maxtemp MaxTemp	mintemp MinTemp	rainfall Rainfall	venue Venue	starttime StartTime	attendance Attendance	hometeam HomeTeam	hometeamscoreqt HomeTeamScoreQT	hometeamscoreht HomeTeamScoreHT	hometeamscore3qt HomeTeamScore3QT	hometeamscoreft HomeTeamScoreFT	hometeamscore HomeTeamScore	awayteam AwayTeam	awayteamscoreqt AwayTeamScoreQT	awayteamscoreht AwayTeamScoreHT	awayteamscore3qt AwayTeamScore3QT	awayteamscoreft AwayTeamScoreFT	awayteamscore AwayTeamScore
2012R0101	2012	R1	Sat Mar 24 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	24	12.2		Stadium Australia	7:20 PM	38203	Greater Western Sydney	1.2	3.3	3.4	5.7	37	Sydney	4.1	8.4	13.8	14.16	100
2012R0102	2012	R1	Thu Mar 29 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	25.7	9.7		M.C.G.	7:45 PM	78285	Richmond	3.4	5.6	10.7	12.9	81	Carlton	3.2	8.7	11.13	18.17	125
2012R0103	2012	R1	Fri Mar 30 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	27.4	9.7		M.C.G.	7:50 PM	78466	Hawthorn	2.1	10.6	14.1	20.17	137	Collingwood	2.7	7.9	12.16	16.19	115
2012R0104	2012	R1	Sat Mar 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	29.1	15.1	0.6	M.C.G.	1:45 PM	33473	Melbourne	3.3	7.4	8.8	11.12	78	Brisbane Lions	1.4	7.8	13.13	17.17	119
2012R0105	2012	R1	Sat Mar 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	28.2	19.7		Carrara	3:45 PM	12790	Gold Coast	3.1	5.3	8.6	10.8	68	Adelaide	7.8	11.1	15.16	19.23	137
2012R0106	2012	R1	Sat Mar 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	24	9		Subiaco	4:45 PM	34601	Fremantle	6	8.3	12.8	16.9	105	Geelong	4	9.2	12.7	15.11	101
2012R0107	2012	R1	Sat Mar 31 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	29.1	15.1	0.6	Docklands	7:45 PM	45818	North Melbourne	4.3	8.5	10.1	15.12	102	Essendon	3.2	9.8	13.14	14.2	104
2012R0108	2012	R1	Sun Apr 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	20.4	14.3		Docklands	1:10 PM	24977	Western Bulldogs	4.3	8.5	10.11	12.15	87	West Coast	6.2	10.6	16.9	21.1	136
2012R0109	2012	R1	Sun Apr 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	24.3	11.8		Football Park	4:10 PM	21179	Port Adelaide	5.2	8.6	11.9	13.11	89	St Kilda	2.1	9.3	11.4	13.7	85
2012R0201	2012	R2	Thu Apr 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	28.4	17.9		Gabba	7:40 PM	25913	Brisbane Lions	6.1	7.6	7.7	9.9	63	Carlton	5.5	10.9	16.1	23.16	154


CREATE TABLE games (
  "gameid" VARCHAR,
  "year" BIGINT,
  "round" VARCHAR,
  "date" TIMESTAMP,
  "maxtemp" DOUBLE,
  "mintemp" DOUBLE,
  "rainfall" DOUBLE,
  "venue" VARCHAR,
  "starttime" VARCHAR,
  "attendance" BIGINT,
  "hometeam" VARCHAR,
  "hometeamscoreqt" DOUBLE,
  "hometeamscoreht" DOUBLE,
  "hometeamscore3qt" DOUBLE,
  "hometeamscoreft" DOUBLE,
  "hometeamscore" BIGINT,
  "awayteam" VARCHAR,
  "awayteamscoreqt" DOUBLE,
  "awayteamscoreht" DOUBLE,
  "awayteamscore3qt" DOUBLE,
  "awayteamscoreft" DOUBLE,
  "awayteamscore" BIGINT
);