Name: Australian Football League (AFL) Database
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Australian Football League (AFL) Database

Context

I wanted to study player stats for Australian Rules Football (AFL), using Machine Learning to identify who the key players are, predict performance and results. My aim is to create the Ultimate Tipping predictor or maybe a Fantasy League tool. I couldn't find a dataset anywhere so I created my own GCD project and am sharing the database for anybody to explore.

Content

Every key stat from Kicks to Clangers to Bounces. Every player, game by game.

Updates in the latest version:

Seasons 2012 to 2024
Progress scores at quarter time, half time and 3 quarter time breaks
Max & Min temperature on game day

Joining Data

Primary Keys are unique values in 'PlayerId' and 'GameId'. Do not join by 'DisplayName' as these are not guaranteed to be unique. 'Year' and 'Round' columns are duplicated across stats.csv and games.csv for convenience when reading.

AFL Domain Notes

Docklands is the only stadium with a roof that might be closed on game day
Season 2024 onwards has 'Opening Round' (OR) as the first round of the regular season, with only some teams scheduled to play. This is like a 'Round 0' as the AFL calls the following week Round 1.

Future Versions

If you have any further suggestions please Comment below.

Acknowledgements

Data is taken with thanks from afltables.com and www.footywire.com

Inspiration

I want to see key insights into the players' performance that nobody has realised before. With tipping contests in the AFL as popular as any other sport, surely this is just waiting for Data Science to take over and pick winners like never before!!

Tables

Games

@kaggle.stoney71_aflstats.games

112.51 kB
2,663 rows
22 columns

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
);

Players

@kaggle.stoney71_aflstats.players

55.45 kB
1,725 rows
7 columns

CREATE TABLE players (
  "playerid" BIGINT,
  "displayname" VARCHAR,
  "height" BIGINT,
  "weight" BIGINT,
  "dob" VARCHAR,
  "position" VARCHAR,
  "origin" VARCHAR
);

Stats

@kaggle.stoney71_aflstats.stats

1.93 MB
118,864 rows
31 columns

CREATE TABLE stats (
  "gameid" VARCHAR,
  "team" VARCHAR,
  "year" BIGINT,
  "round" VARCHAR,
  "playerid" BIGINT,
  "displayname" VARCHAR,
  "gamenumber" BIGINT,
  "disposals" BIGINT,
  "kicks" BIGINT,
  "marks" BIGINT,
  "handballs" BIGINT,
  "goals" BIGINT,
  "behinds" BIGINT,
  "hitouts" BIGINT,
  "tackles" BIGINT,
  "rebounds" BIGINT,
  "inside50s" BIGINT,
  "clearances" BIGINT,
  "clangers" BIGINT,
  "frees" BIGINT,
  "freesagainst" BIGINT,
  "brownlowvotes" BIGINT,
  "contestedpossessions" BIGINT,
  "uncontestedpossessions" BIGINT,
  "contestedmarks" BIGINT,
  "marksinside50" BIGINT,
  "onepercenters" BIGINT,
  "bounces" BIGINT,
  "goalassists" BIGINT,
  "n__played" BIGINT  -- %Played,
  "subs" VARCHAR
);