AFL Fantasy Points - 2022 Season

key stats, game by game, player by player

@kaggle.iampunitkmryh_afl_fantasy_points_2022_season

Table List

1 table(323.33 KB)

Playerdata

@kaggle.iampunitkmryh_afl_fantasy_points_2022_season.playerdata

323.33 KB
811 rows
150 columns
Only the first 100 columns are shown

unnamed_0 Unnamed: 0	playerid PlayerId	gamesplayed GamesPlayed	playerdetails_givenname PlayerDetails.givenName	playerdetails_surname PlayerDetails.surname	playerdetails_age PlayerDetails.age	playerdetails_heightcm PlayerDetails.heightCm	playerdetails_weightkg PlayerDetails.weightKg	playerdetails_jumpernumber PlayerDetails.jumperNumber	playerdetails_kickingfoot PlayerDetails.kickingFoot	playerdetails_stateoforigin PlayerDetails.stateOfOrigin	playerdetails_draftyear PlayerDetails.draftYear	playerdetails_debutyear PlayerDetails.debutYear	playerdetails_recruitedfrom PlayerDetails.recruitedFrom	playerdetails_draftposition PlayerDetails.draftPosition	playerdetails_drafttype PlayerDetails.draftType	playerdetails_position PlayerDetails.position	playerdetails_photourl PlayerDetails.photoURL	playerdetails_dateofbirth PlayerDetails.dateOfBirth	team_teamid Team.teamId	team_teamabbr Team.teamAbbr	team_teamname Team.teamName	team_teamnickname Team.teamNickname	totals_matchesplayed Totals.matchesPlayed	totals_timeongroundpercentage Totals.timeOnGroundPercentage	totals_behinds Totals.behinds	totals_bounces Totals.bounces	totals_centrebounceattendances Totals.centreBounceAttendances	totals_centreclearances Totals.centreClearances	totals_clangers Totals.clangers	totals_contestdeflosses Totals.contestDefLosses	totals_contestdeflosspercentage Totals.contestDefLossPercentage	totals_contestdefoneonones Totals.contestDefOneOnOnes	totals_contestedmarks Totals.contestedMarks	totals_contestedpossessionrate Totals.contestedPossessionRate	totals_contestedpossessions Totals.contestedPossessions	totals_contestoffoneonones Totals.contestOffOneOnOnes	totals_contestoffwins Totals.contestOffWins	totals_contestoffwinspercentage Totals.contestOffWinsPercentage	totals_defhalfpressureacts Totals.defHalfPressureActs	totals_disposalefficiency Totals.disposalEfficiency	totals_disposals Totals.disposals	totals_dreamteampoints Totals.dreamTeamPoints	totals_effectivedisposals Totals.effectiveDisposals	totals_effectivekicks Totals.effectiveKicks	totals_f50groundballgets Totals.f50GroundBallGets	totals_freesagainst Totals.freesAgainst	totals_freesfor Totals.freesFor	totals_goalaccuracy Totals.goalAccuracy	totals_goalassists Totals.goalAssists	totals_goals Totals.goals	totals_groundballgets Totals.groundBallGets	totals_handballs Totals.handballs	totals_hitouts Totals.hitouts	totals_hitoutstoadvantage Totals.hitoutsToAdvantage	totals_hitouttoadvantagerate Totals.hitoutToAdvantageRate	totals_hitoutwinpercentage Totals.hitoutWinPercentage	totals_inside50s Totals.inside50s	totals_interceptmarks Totals.interceptMarks	totals_intercepts Totals.intercepts	totals_kickefficiency Totals.kickEfficiency	totals_kickins Totals.kickins	totals_kickinsplayon Totals.kickinsPlayon	totals_kicks Totals.kicks	totals_kicktohandballratio Totals.kickToHandballRatio	totals_marks Totals.marks	totals_marksinside50 Totals.marksInside50	totals_marksonlead Totals.marksOnLead	totals_metresgained Totals.metresGained	totals_onepercenters Totals.onePercenters	totals_pressureacts Totals.pressureActs	totals_ranking Totals.ranking	totals_ratingpoints Totals.ratingPoints	totals_rebound50s Totals.rebound50s	totals_ruckcontests Totals.ruckContests	totals_scoreinvolvements Totals.scoreInvolvements	totals_scorelaunches Totals.scoreLaunches	totals_shotsatgoal Totals.shotsAtGoal	totals_spoils Totals.spoils	totals_stoppageclearances Totals.stoppageClearances	totals_tackles Totals.tackles	totals_tacklesinside50 Totals.tacklesInside50	totals_totalclearances Totals.totalClearances	totals_totalpossessions Totals.totalPossessions	totals_turnovers Totals.turnovers	totals_uncontestedpossessions Totals.uncontestedPossessions	averages_matchesplayed Averages.matchesPlayed	averages_timeongroundpercentage Averages.timeOnGroundPercentage	averages_behinds Averages.behinds	averages_bounces Averages.bounces	averages_centrebounceattendances Averages.centreBounceAttendances	averages_centreclearances Averages.centreClearances	averages_clangers Averages.clangers	averages_contestdeflosses Averages.contestDefLosses	averages_contestdeflosspercentage Averages.contestDefLossPercentage	averages_contestdefoneonones Averages.contestDefOneOnOnes	averages_contestedmarks Averages.contestedMarks	averages_contestedpossessionrate Averages.contestedPossessionRate
	CD_I1000044		Jez	McLennan	21	185	85	43	RIGHT	SA	2021		Tanunda (SA)/Central District (SANFL)	21	rookieElevation	MEDIUM_DEFENDER	https://s.afl.com.au/staticfile/AFL Tenant/AFL/Players/ChampIDImages/XLarge2022/1000044.png?i10c=img.resize(scale_height:0.6)	Thu Sep 07 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	CD_T1000	GCFC	Gold Coast Suns	Suns
1	CD_I1000061	7	Callum	Coleman-Jones	23	200	105	21	RIGHT	SA	2017	2019	Unley (SA)/Scotch College (SA)/Sturt (SANFL)/Richmond	20	nationalDraft	RUCK	https://s.afl.com.au/staticfile/AFL Tenant/AFL/Players/ChampIDImages/XLarge2022/1000061.png?i10c=img.resize(scale_height:0.6)	Sun Jun 13 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	CD_T100	NMFC	North Melbourne	Kangaroos	7	72.4	3		67	7	19			1	8	53.8	42	14	2	14.3	34	58.7	75	362	44	19	7	11	9	25	4	2	22	36	74	25	33.8	33.9	9	5	13	48.7			39	1.1	20	3	1	798	12	65	468	109.2	3	218	23	9	8	8	3	12	1	10	78	20	36	7	72.4	0.4		67	1	2.7			0.1	1.1	53.8
2	CD_I1000068	2	Chris	Burgess	26	191	94	29	RIGHT	SA	2018	2019	Flinders Park (SA)/West Adelaide (SANFL)		other	KEY_FORWARD	https://s.afl.com.au/staticfile/AFL Tenant/AFL/Players/ChampIDImages/XLarge2022/1000068.png?i10c=img.resize(scale_height:0.6)	Sun Nov 26 1995 00:00:00 GMT+0000 (Coordinated Universal Time)	CD_T1000	GCFC	Gold Coast Suns	Suns	2	87.6	1				2	2	50	4	5	72.7	8	5	2	40	3	81.8	11	57	9	3	2				1		3	6					2	1	2	60			5	0.8	7	1		207	9	11	421	137.9	1		6		1	9		2	2		11	2	3	2	87.6	0.5				1	1	50	2	2.5	72.7
3	CD_I1000072	17	John	Noble	25	180	75	9	RIGHT	SA	2019	2019	Plympton (SA)/West Adelaide (SANFL)	14	other	MEDIUM_DEFENDER	https://s.afl.com.au/staticfile/AFL Tenant/AFL/Players/ChampIDImages/XLarge2022/1000072.png?i10c=img.resize(scale_height:0.6)	Tue Mar 25 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	CD_T40	COLL	Collingwood	Magpies	17	76.6		13		2	33	5	31.3	16	2	25.1	76				141	80.5	303	1179	244	144		12	19		5		61	111					45	16	88	75	6	6	192	1.7	78	1		5779	26	198	237	261.2	37		56	19	1	18	6	41	2	8	303	54	227	17	76.6		0.8		0.1	1.9	0.3	31.3	0.9	0.1	25.1
4	CD_I1000223	18	Liam	Baker	24	173	72	7	RIGHT	WA	2017	2018	Lake Grace (WA)/West Perth (WAFL)/Subiaco (WAFL)	18	rookieElevation	MEDIUM_DEFENDER	https://s.afl.com.au/staticfile/AFL Tenant/AFL/Players/ChampIDImages/XLarge2022/1000223.png?i10c=img.resize(scale_height:0.6)	Tue Jan 27 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	CD_T120	RICH	Richmond	Tigers	18	83.1	7	1	49	8	61	3	42.9	7	2	37.6	126	10	3	30	145	72.5	345	1262	250	120	15	23	17	52.4	5	11	96	158					57	12	71	64.2	5	4	187	1.2	60	8	4	5714	39	316	77	383.1	35		91	24	21	12	21	46	9	29	335	63	209	18	83.1	0.4	0.1	49	0.4	3.4	0.2	42.9	0.4	0.1	37.6
5	CD_I1000267	5	Matthew	Parker	26	188	80	37	RIGHT	WA	2018	2019	Melville (WA)/South Frem (WAFL)/St Kilda/South Frem (WAFL)	47	nationalDraft	MEDIUM_FORWARD	https://s.afl.com.au/staticfile/AFL Tenant/AFL/Players/ChampIDImages/XLarge2022/1000267.png?i10c=img.resize(scale_height:0.6)	Thu Jan 25 1996 00:00:00 GMT+0000 (Coordinated Universal Time)	CD_T120	RICH	Richmond	Tigers	5	71.4	3	1		1	16				3	49.2	30	2			34	66.1	59	276	39	25	7	6	7	44.4	4	4	20	19					16	1	10	62.5			40	2.1	22	3	3	1425	5	93	523	76.1	3		17	2	9	2	2	9	4	3	61	21	31	5	71.4	0.6	0.2		0.2	3.2				0.6	49.2
6	CD_I1000860	17	Lachie	Schultz	24	178	84	5	RIGHT	VIC	2018	2019	Moama (NSW)/Bendigo U18/Williamstown (VFL)	57	nationalDraft	MEDIUM_FORWARD	https://s.afl.com.au/staticfile/AFL Tenant/AFL/Players/ChampIDImages/XLarge2022/1000860.png?i10c=img.resize(scale_height:0.6)	Sun Nov 30 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	CD_T60	FRE	Fremantle	Freo	17	83.1	15				52				3	39	89	16	2	12.5	78	69.6	224	1105	156	88	29	26	17	48.1	15	25	62	84					35	6	31	62.9			140	1.7	67	17	11	3679	22	307	250	244.7	8		88	13	52	12	8	53	30	8	228	61	139	17	83.1	0.9				3.1				0.2	39
7	CD_I1000864	9	Lachlan	Bramble	24	181	80	16	RIGHT	VIC	2020	2021	Williamstown (VFL)		preseason	MEDIUM_DEFENDER	https://s.afl.com.au/staticfile/AFL Tenant/AFL/Players/ChampIDImages/XLarge2022/1000864.png?i10c=img.resize(scale_height:0.6)	Sun Apr 19 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	CD_T80	HAW	Hawthorn	Hawks	9	82	3	3	5	1	15			3	1	33.1	41				79	78.3	138	520	108	64	1	4	7		5		31	51					12	8	43	73.6	20	15	87	1.7	25	1		3032	14	100	374	163.8	28		28	8	5	11	7	21		8	124	22	83	9	82	0.3	0.3	5	0.1	1.7			0.3	0.1	33.1
8	CD_I1000887	14	Mitch	Lewis	23	199	101	2	RIGHT	VIC	2016	2018	Wallan (Vic)/Whittlesea (Vic)/Calder U18	76	nationalDraft	KEY_FORWARD	https://s.afl.com.au/staticfile/AFL Tenant/AFL/Players/ChampIDImages/XLarge2022/1000887.png?i10c=img.resize(scale_height:0.6)	Wed Oct 14 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	CD_T80	HAW	Hawthorn	Hawks	14	95.3	14	1			31			1	22	49.1	81	51	10	19.6	23	69.7	165	934	115	80	22	14	17	67.3	7	37	38	52	3	1	33.3	20	20	2	17	70.8			113	2.2	71	35	17	2840	31	164	225	270.3	1	15	88	8	55	24	3	16	11	3	165	27	84	14	95.3	1	0.1			2.2			0.1	1.6	49.1
9	CD_I1000932	18	Tom	Doedee	25	187	90	39	RIGHT	VIC	2015	2018	St Joseph's, Geel (Vic)/St Joseph's College, Geel (Vic)/Geel U18	17	nationalDraft	KEY_DEFENDER	https://s.afl.com.au/staticfile/AFL Tenant/AFL/Players/ChampIDImages/XLarge2022/1000932.png?i10c=img.resize(scale_height:0.6)	Sat Mar 01 1997 00:00:00 GMT+0000 (Coordinated Universal Time)	CD_T10	ADEL	Adelaide Crows	Crows	18	94		2			35	12	25	48	12	39.1	106				125	79.8	297	1084	237	126		11	18				76	135					20	37	141	77.8	18	16	162	1.2	77			4356	113	155	98	363.5	55		30	15		95	6	28		6	271	46	165	18	94		0.1			1.9	0.7	25	2.7	0.7	39.1


CREATE TABLE playerdata (
  "unnamed_0" BIGINT,
  "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
);