Baselight

Australian Football League (AFL) Database

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

@kaggle.stoney71_aflstats

Stats
@kaggle.stoney71_aflstats.stats

  • 1.84 MB
  • 118864 rows
  • 31 columns
gameid

GameId

team

Team

year

Year

round

Round

playerid

PlayerId

displayname

DisplayName

gamenumber

GameNumber

disposals

Disposals

kicks

Kicks

marks

Marks

handballs

Handballs

goals

Goals

behinds

Behinds

hitouts

HitOuts

tackles

Tackles

rebounds

Rebounds

inside50s

Inside50s

clearances

Clearances

clangers

Clangers

frees

Frees

freesagainst

FreesAgainst

brownlowvotes

BrownlowVotes

contestedpossessions

ContestedPossessions

uncontestedpossessions

UncontestedPossessions

contestedmarks

ContestedMarks

marksinside50

MarksInside50

onepercenters

OnePercenters

bounces

Bounces

goalassists

GoalAssists

n__played

%Played

subs

Subs

2012R0105Adelaide2012R12011675768Callinan, Ian4181454255214199384-
2012R0105Adelaide2012R12008681760Dangerfield, Patrick652513312226941141111192-
2012R0105Adelaide2012R12000686938Doughty, Michael208175412312288281-
2012R0105Adelaide2012R12006687579Douglas, Richard96191465137153261615283-
2012R0105Adelaide2012R12010728130Henderson, Ricky318513111251136Off
2012R0105Adelaide2012R12009748959Jacobs, Sam371895928321311612487-
2012R0105Adelaide2012R12002744632Johncock, Graham207181672281211114388-
2012R0105Adelaide2012R12010763943Lynch, Tom777212151321341142On
2012R0105Adelaide2012R12008774238Mackay, David6421931215121117141186-
2012R0105Adelaide2012R12008795429Otten, Andy4217107743223145189-

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,
  "subs" VARCHAR
);

Share link

Anyone who has the link will be able to view this.