Name: AFL Fantasy Points - 2022 Season
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

AFL Fantasy Points - 2022 Season

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.

Tables

Playerdata

@kaggle.iampunitkmryh_afl_fantasy_points_2022_season.playerdata

331.09 kB
811 rows
150 columns

CREATE TABLE playerdata (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "playerid" VARCHAR,
  "gamesplayed" DOUBLE,
  "playerdetails_givenname" VARCHAR,
  "playerdetails_surname" VARCHAR,
  "playerdetails_age" BIGINT,
  "playerdetails_heightcm" BIGINT,
  "playerdetails_weightkg" BIGINT,
  "playerdetails_jumpernumber" BIGINT,
  "playerdetails_kickingfoot" VARCHAR,
  "playerdetails_stateoforigin" VARCHAR,
  "playerdetails_draftyear" BIGINT,
  "playerdetails_debutyear" DOUBLE,
  "playerdetails_recruitedfrom" VARCHAR,
  "playerdetails_draftposition" DOUBLE,
  "playerdetails_drafttype" VARCHAR,
  "playerdetails_position" VARCHAR,
  "playerdetails_bio" VARCHAR,
  "playerdetails_aflawards" VARCHAR,
  "playerdetails_photourl" VARCHAR,
  "playerdetails_dateofbirth" TIMESTAMP,
  "team_teamid" VARCHAR,
  "team_teamabbr" VARCHAR,
  "team_teamname" VARCHAR,
  "team_teamnickname" VARCHAR,
  "totals_matchesplayed" DOUBLE,
  "totals_timeongroundpercentage" DOUBLE,
  "totals_behinds" DOUBLE,
  "totals_bounces" DOUBLE,
  "totals_centrebounceattendances" DOUBLE,
  "totals_centreclearances" DOUBLE,
  "totals_clangers" DOUBLE,
  "totals_contestdeflosses" DOUBLE,
  "totals_contestdeflosspercentage" DOUBLE,
  "totals_contestdefoneonones" DOUBLE,
  "totals_contestedmarks" DOUBLE,
  "totals_contestedpossessionrate" DOUBLE,
  "totals_contestedpossessions" DOUBLE,
  "totals_contestoffoneonones" DOUBLE,
  "totals_contestoffwins" DOUBLE,
  "totals_contestoffwinspercentage" DOUBLE,
  "totals_defhalfpressureacts" DOUBLE,
  "totals_disposalefficiency" DOUBLE,
  "totals_disposals" DOUBLE,
  "totals_dreamteampoints" DOUBLE,
  "totals_effectivedisposals" DOUBLE,
  "totals_effectivekicks" DOUBLE,
  "totals_f50groundballgets" DOUBLE,
  "totals_freesagainst" DOUBLE,
  "totals_freesfor" DOUBLE,
  "totals_goalaccuracy" DOUBLE,
  "totals_goalassists" DOUBLE,
  "totals_goals" DOUBLE,
  "totals_groundballgets" DOUBLE,
  "totals_handballs" DOUBLE,
  "totals_hitouts" DOUBLE,
  "totals_hitoutstoadvantage" DOUBLE,
  "totals_hitouttoadvantagerate" DOUBLE,
  "totals_hitoutwinpercentage" DOUBLE,
  "totals_inside50s" DOUBLE,
  "totals_interceptmarks" DOUBLE,
  "totals_intercepts" DOUBLE,
  "totals_kickefficiency" DOUBLE,
  "totals_kickins" DOUBLE,
  "totals_kickinsplayon" DOUBLE,
  "totals_kicks" DOUBLE,
  "totals_kicktohandballratio" DOUBLE,
  "totals_marks" DOUBLE,
  "totals_marksinside50" DOUBLE,
  "totals_marksonlead" DOUBLE,
  "totals_metresgained" DOUBLE,
  "totals_onepercenters" DOUBLE,
  "totals_pressureacts" DOUBLE,
  "totals_ranking" DOUBLE,
  "totals_ratingpoints" DOUBLE,
  "totals_rebound50s" DOUBLE,
  "totals_ruckcontests" DOUBLE,
  "totals_scoreinvolvements" DOUBLE,
  "totals_scorelaunches" DOUBLE,
  "totals_shotsatgoal" DOUBLE,
  "totals_spoils" DOUBLE,
  "totals_stoppageclearances" DOUBLE,
  "totals_tackles" DOUBLE,
  "totals_tacklesinside50" DOUBLE,
  "totals_totalclearances" DOUBLE,
  "totals_totalpossessions" DOUBLE,
  "totals_turnovers" DOUBLE,
  "totals_uncontestedpossessions" DOUBLE,
  "averages_matchesplayed" DOUBLE,
  "averages_timeongroundpercentage" DOUBLE,
  "averages_behinds" DOUBLE,
  "averages_bounces" DOUBLE,
  "averages_centrebounceattendances" DOUBLE,
  "averages_centreclearances" DOUBLE,
  "averages_clangers" DOUBLE,
  "averages_contestdeflosses" DOUBLE,
  "averages_contestdeflosspercentage" DOUBLE,
  "averages_contestdefoneonones" DOUBLE,
  "averages_contestedmarks" DOUBLE,
  "averages_contestedpossessionrate" DOUBLE
);