Fantasy Premier League Dataset 2024-2025

Fantasy Premier League 2024-2025 Players Dataset

@kaggle.meraxes10_fantasy_premier_league_dataset_2024_2025

Table List

1 table(200 KB)

Players

@kaggle.meraxes10_fantasy_premier_league_dataset_2024_2025.players

200 KB
723 rows
82 columns

id Id	name Name	now_cost Now Cost	position Position	team Team	selected_rank Selected Rank	influence Influence	points_per_game Points Per Game	starts Starts	form Form	goals_scored Goals Scored	expected_goals_per_90 Expected Goals Per 90	transfers_out_event Transfers Out Event	expected_goals_conceded Expected Goals Conceded	cost_change_event_fall Cost Change Event Fall	penalties_order Penalties Order	ict_index_rank_type Ict Index Rank Type	team_join_date Team Join Date	creativity Creativity	influence_rank Influence Rank	transfers_out Transfers Out	ep_next Ep Next	ep_this Ep This	cost_change_start Cost Change Start	goals_conceded Goals Conceded	expected_goal_involvements_per_90 Expected Goal Involvements Per 90	points_per_game_rank Points Per Game Rank	region Region	transfers_in Transfers In	chance_of_playing_this_round Chance Of Playing This Round	now_cost_rank Now Cost Rank	creativity_rank_type Creativity Rank Type	expected_goal_involvements Expected Goal Involvements	transfers_in_event Transfers In Event	expected_assists_per_90 Expected Assists Per 90	news News	selected_rank_type Selected Rank Type	minutes Minutes	cost_change_start_fall Cost Change Start Fall	assists Assists	ict_index Ict Index	goals_conceded_per_90 Goals Conceded Per 90	starts_per_90 Starts Per 90	threat Threat	influence_rank_type Influence Rank Type	value_form Value Form	creativity_rank Creativity Rank	now_cost_rank_type Now Cost Rank Type	news_added News Added	expected_goals_conceded_per_90 Expected Goals Conceded Per 90	total_points Total Points	threat_rank Threat Rank	can_select Can Select	web_name Web Name	threat_rank_type Threat Rank Type	points_per_game_rank_type Points Per Game Rank Type	chance_of_playing_next_round Chance Of Playing Next Round	cost_change_event Cost Change Event	form_rank Form Rank	bonus Bonus	value_season Value Season	ict_index_rank Ict Index Rank	selected_by_percent Selected By Percent	clean_sheets_per_90 Clean Sheets Per 90	expected_goals Expected Goals	yellow_cards Yellow Cards	clean_sheets Clean Sheets	form_rank_type Form Rank Type	expected_assists Expected Assists	bps Bps	dreamteam_count Dreamteam Count	status Status
1	Fábio Ferreira Vieira	54	MID	Arsenal	653							1				318			713	2790			-1			713		439		130	317				Has joined Portuguese side FC Porto on loan for the 2024/25 season	284		1						318		711	78	2024-08-29T11:06:25.241953Z			710		Fábio Vieira	316	318			697			713						310				u
2	Gabriel Fernando de Jesus	68	FWD	Arsenal	86	154.4	2.5	6	6.4	3	0.46	80238	5.82	1		23	Mon Jul 04 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	119.5	247	1041671			-2	5	0.54	192	30	1236971		32	24	3.57	63	0.08	Knee injury - Unknown return date	15	600	2	2	52.6	0.75	0.9	255	23	0.9	189	16	2025-01-12T22:00:07.802845Z	0.87	42	70	true	G.Jesus	24	26		-1	11	6	6.2	161	4.3	0.3	3.05	4	2	3	0.52	152	2	i
3	Gabriel dos Santos Magalhães	64	DEF	Arsenal	8	412.6	4.6	18	2.8	3	0.14	7347	16.15			14	Tue Sep 01 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	132.2	46	2330803	3.3	2.8	4	16	0.19	28	30	3928892	100	49	39	3.34	5449	0.05	nan	1	1538	-4	2	79.6	0.94	1.05	251	15	0.4	177	3	2024-11-27T10:30:06.325759Z	0.95	83	71	true	Gabriel	3	2	100		96	7	13	87	29	0.35	2.42	2	6	26	0.92	299	2	a
4	Kai Havertz	78	FWD	Arsenal	42	372.2	4.4	17	2.6	7	0.47	4565	15.63		3	7	Wed Jun 28 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	220.2	70	3098972	3.1	2.6	-2	16	0.55	37	80	2443194	100	13	9	9.11	2657	0.08	nan	12	1480	2	2	115.2	0.97	1.03	559	10	0.3	106	5	2025-01-02T08:00:08.350130Z	0.95	74	15	true	Havertz	8	11	100		103	10	9.5	28	8.3	0.36	7.77	3	6	15	1.34	283	1	a
5	Karl Hein	40	GKP	Arsenal	573							1				62			533	4331						538				642	43				Loaned to Real Valladolid	69								62		512	59	2024-08-14T08:31:46.556082Z			477		Hein	30	62			441			532						52				u
6	Jurriën Timber	57	DEF	Arsenal	71	236	3.8	16	2.2	1	0.05	3683	12.14			31	Fri Jul 14 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	208.3	175	727385	2.7	2.2	2	12	0.11	63	152	1164727	100	94	24	1.65	1139	0.06	nan	26	1395	-2	1	61.2	0.77	1.03	170	66	0.4	115	9	2025-01-12T22:00:07.815228Z	0.78	64	118	true	J.Timber	10	13	100		131	5	11.2	132	5.3	0.39	0.71	5	6	38	0.94	235	2	a
7	Jorge Luiz Frello Filho	47	MID	Arsenal	331	35.8	1.3	6	0.6		0.01	72	4.27			180	Tue Jan 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	64.7	389	44020	1.1	0.6	-3	5	0.1	362	106	27441	100	326	166	0.51	64	0.09	nan	104	456	3		10.4	0.99	1.18	3	179	0.1	268	210	2025-01-12T22:00:07.826638Z	0.84	13	409	true	Jorginho	217	169	100		299		2.8	369	0.2	0.2	0.04	3	1	148	0.47	82		a
8	Jakub Kiwior	48	DEF	Arsenal	366	49.2	1.6	2				48	4.45			135	Mon Jan 23 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	13.7	370	33452	0.5		-2	5	0.01	327	172	24401		313	131	0.03	16	0.01	nan	130	323	2		6.3	1.39	0.56		129		381	38	nan	1.24	13	671	true	Kiwior	244	113			644		2.7	402	0.2	0.28			1	238	0.03	39		a
9	Gabriel Martinelli Silva	68	MID	Arsenal	84	324	4.1	13	4	5	0.26	3352	11.88			29	Mon Jul 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	304.6	104	918353	4.5	4	-2	12	0.47	49	30	1042953	100	35	48	6.05	1496	0.21	nan	28	1166	2	2	107.4	0.93	1	446	36	0.6	63	17	2024-10-18T16:00:06.884775Z	0.92	73	29	true	Martinelli	15	22	100		44	6	10.7	43	4.4	0.46	3.36	1	6	19	2.69	236	1	a
12	Ethan Nwaneri	45	MID	Arsenal	260	97	1.9	2	1.8	2	0.12	1489	1.59			153	Sat Sep 17 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	66.8	314	88234				1	0.28	275	241	114376		421	162	0.71	48	0.16	Muscle injury - Unknown return date	81	230			23.3	0.39	0.78	69	144	0.4	263	259	2025-01-04T22:00:06.872110Z	0.62	23	235	true	Nwaneri	132	121			158	1	5.1	301	0.5		0.3	1		67	0.41	84		i


CREATE TABLE players (
  "id" BIGINT,
  "name" VARCHAR,
  "now_cost" BIGINT,
  "position" VARCHAR,
  "team" VARCHAR,
  "selected_rank" BIGINT,
  "influence" DOUBLE,
  "points_per_game" DOUBLE,
  "starts" BIGINT,
  "form" DOUBLE,
  "goals_scored" BIGINT,
  "expected_goals_per_90" DOUBLE,
  "transfers_out_event" BIGINT,
  "expected_goals_conceded" DOUBLE,
  "cost_change_event_fall" BIGINT,
  "penalties_order" DOUBLE,
  "ict_index_rank_type" BIGINT,
  "team_join_date" TIMESTAMP,
  "creativity" DOUBLE,
  "influence_rank" BIGINT,
  "transfers_out" BIGINT,
  "ep_next" DOUBLE,
  "saves_per_90" DOUBLE,
  "ep_this" DOUBLE,
  "cost_change_start" BIGINT,
  "goals_conceded" BIGINT,
  "expected_goal_involvements_per_90" DOUBLE,
  "points_per_game_rank" BIGINT,
  "region" DOUBLE,
  "transfers_in" BIGINT,
  "chance_of_playing_this_round" DOUBLE,
  "direct_freekicks_order" DOUBLE,
  "penalties_saved" BIGINT,
  "now_cost_rank" BIGINT,
  "creativity_rank_type" BIGINT,
  "expected_goal_involvements" DOUBLE,
  "transfers_in_event" BIGINT,
  "expected_assists_per_90" DOUBLE,
  "news" VARCHAR,
  "selected_rank_type" BIGINT,
  "minutes" BIGINT,
  "cost_change_start_fall" BIGINT,
  "assists" BIGINT,
  "ict_index" DOUBLE,
  "goals_conceded_per_90" DOUBLE,
  "starts_per_90" DOUBLE,
  "threat" DOUBLE,
  "influence_rank_type" BIGINT,
  "value_form" DOUBLE,
  "creativity_rank" BIGINT,
  "now_cost_rank_type" BIGINT,
  "red_cards" BIGINT,
  "news_added" VARCHAR,
  "corners_and_indirect_freekicks_order" DOUBLE,
  "expected_goals_conceded_per_90" DOUBLE,
  "event_points" BIGINT,
  "total_points" BIGINT,
  "threat_rank" BIGINT,
  "can_select" BOOLEAN,
  "web_name" VARCHAR,
  "threat_rank_type" BIGINT,
  "points_per_game_rank_type" BIGINT,
  "chance_of_playing_next_round" DOUBLE,
  "cost_change_event" BIGINT,
  "form_rank" BIGINT,
  "bonus" BIGINT,
  "value_season" DOUBLE,
  "ict_index_rank" BIGINT,
  "selected_by_percent" DOUBLE,
  "in_dreamteam" BOOLEAN,
  "clean_sheets_per_90" DOUBLE,
  "expected_goals" DOUBLE,
  "penalties_missed" BIGINT,
  "own_goals" BIGINT,
  "yellow_cards" BIGINT,
  "clean_sheets" BIGINT,
  "form_rank_type" BIGINT,
  "expected_assists" DOUBLE,
  "bps" BIGINT,
  "dreamteam_count" BIGINT,
  "status" VARCHAR,
  "saves" BIGINT
);