FIFA Players Dataset

Data from FIFA with 16k+ players and 100+ attributes

@kaggle.luisfucros_fifa_players

Table List

8 tables(22.79 MB)

Players 22

@kaggle.luisfucros_fifa_players.players_22

3.09 MB
19239 rows
110 columns
Only the first 100 columns are shown

sofifa_id Sofifa Id	player_url Player Url	short_name Short Name	long_name Long Name	player_positions Player Positions	overall Overall	potential Potential	value_eur Value Eur	wage_eur Wage Eur	age Age	dob Dob	height_cm Height Cm	weight_kg Weight Kg	club_team_id Club Team Id	club_name Club Name	league_name League Name	league_level League Level	club_position Club Position	club_jersey_number Club Jersey Number	club_loaned_from Club Loaned From	club_joined Club Joined	club_contract_valid_until Club Contract Valid Until	nationality_id Nationality Id	nationality_name Nationality Name	nation_team_id Nation Team Id	nation_position Nation Position	nation_jersey_number Nation Jersey Number	preferred_foot Preferred Foot	weak_foot Weak Foot	skill_moves Skill Moves	international_reputation International Reputation	work_rate Work Rate	body_type Body Type	real_face Real Face	release_clause_eur Release Clause Eur	player_tags Player Tags	player_traits Player Traits	pace Pace	shooting Shooting	passing Passing	dribbling Dribbling	defending Defending	physic Physic	attacking_crossing Attacking Crossing	attacking_finishing Attacking Finishing	attacking_heading_accuracy Attacking Heading Accuracy	attacking_short_passing Attacking Short Passing	attacking_volleys Attacking Volleys	skill_dribbling Skill Dribbling	skill_curve Skill Curve	skill_fk_accuracy Skill Fk Accuracy	skill_long_passing Skill Long Passing	skill_ball_control Skill Ball Control	movement_acceleration Movement Acceleration	movement_sprint_speed Movement Sprint Speed	movement_agility Movement Agility	movement_reactions Movement Reactions	movement_balance Movement Balance	power_shot_power Power Shot Power	power_jumping Power Jumping	power_stamina Power Stamina	power_strength Power Strength	power_long_shots Power Long Shots	mentality_aggression Mentality Aggression	mentality_interceptions Mentality Interceptions	mentality_positioning Mentality Positioning	mentality_vision Mentality Vision	mentality_penalties Mentality Penalties	mentality_composure Mentality Composure	defending_marking_awareness Defending Marking Awareness	defending_standing_tackle Defending Standing Tackle	defending_sliding_tackle Defending Sliding Tackle	goalkeeping_diving Goalkeeping Diving	goalkeeping_handling Goalkeeping Handling	goalkeeping_kicking Goalkeeping Kicking	goalkeeping_positioning Goalkeeping Positioning	goalkeeping_reflexes Goalkeeping Reflexes	goalkeeping_speed Goalkeeping Speed	ls Ls	st St	rs Rs	lw Lw	lf Lf	cf Cf	rf Rf	rw Rw	lam Lam	cam Cam	ram Ram	lm Lm	lcm Lcm	cm Cm	rcm Rcm	rm Rm	lwb Lwb	ldm Ldm	cdm Cdm	rdm Rdm	rwb Rwb	lb Lb
158023	https://sofifa.com/player/158023/lionel-messi/220002	L. Messi	Lionel Andrés Messi Cuccittini	RW, ST, CF	93	93	78000000	320000	34	Wed Jun 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	170	72	73	Paris Saint-Germain	French Ligue 1	1	RW	30	nan	Tue Aug 10 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2023	52	Argentina	1369	RW	10	Left	4	4	5	Medium/Low	Unique	Yes	144300000	#Dribbler, #Distance Shooter, #FK Specialist, #Acrobat, #Clinical Finisher, #Complete Forward	Finesse Shot, Long Shot Taker (AI), Playmaker (AI), Outside Foot Shot, One Club Player, Chip Shot (AI), Technical Dribbler (AI)	85	92	91	95	34	65	85	95	70	91	88	96	93	94	91	96	91	80	91	94	95	86	68	72	69	94	44	40	93	95	75	96	20	35	24	6	11	15	14	8		89+3	89+3	89+3	92	93	93	93	92	93	93	93	91+2	87+3	87+3	87+3	91+2	66+3	64+3	64+3	64+3	66+3	61+3
188545	https://sofifa.com/player/188545/robert-lewandowski/220002	R. Lewandowski	Robert Lewandowski	ST	92	92	119500000	270000	32	Sun Aug 21 1988 00:00:00 GMT+0000 (Coordinated Universal Time)	185	81	21	FC Bayern München	German 1. Bundesliga	1	ST	9	nan	Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2023	37	Poland	1353	RS	9	Right	4	4	5	High/Medium	Unique	Yes	197200000	#Aerial Threat, #Distance Shooter, #Clinical Finisher, #Complete Forward	Solid Player, Finesse Shot, Outside Foot Shot, Chip Shot (AI)	78	92	79	86	44	82	71	95	90	85	89	85	79	85	70	88	77	79	77	93	82	90	85	76	86	87	81	49	95	81	90	88	35	42	19	15	6	12	8	10		90+2	90+2	90+2	85	88	88	88	85	86+3	86+3	86+3	84+3	80+3	80+3	80+3	84+3	64+3	66+3	66+3	66+3	64+3	61+3
20801	https://sofifa.com/player/20801/c-ronaldo-dos-santos-aveiro/220002	Cristiano Ronaldo	Cristiano Ronaldo dos Santos Aveiro	ST, LW	91	91	45000000	270000	36	Tue Feb 05 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	187	83	11	Manchester United	English Premier League	1	ST	7	nan	Fri Aug 27 2021 00:00:00 GMT+0000 (Coordinated Universal Time)	2023	38	Portugal	1354	ST	7	Right	4	5	5	High/Low	Unique	Yes	83300000	#Aerial Threat, #Dribbler, #Distance Shooter, #Crosser, #Acrobat, #Clinical Finisher, #Complete Forward	Power Free-Kick, Flair, Long Shot Taker (AI), Speed Dribbler (AI), Outside Foot Shot	87	94	80	88	34	75	87	95	90	80	86	88	81	84	77	88	85	88	86	94	74	94	95	77	77	93	63	29	95	76	88	95	24	32	24	7	11	15	14	11		90+1	90+1	90+1	88	89	89	89	88	86+3	86+3	86+3	86+3	78+3	78+3	78+3	86+3	63+3	59+3	59+3	59+3	63+3	60+3
190871	https://sofifa.com/player/190871/neymar-da-silva-santos-jr/220002	Neymar Jr	Neymar da Silva Santos Júnior	LW, CAM	91	91	129000000	270000	29	Wed Feb 05 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	175	68	73	Paris Saint-Germain	French Ligue 1	1	LW	10	nan	Thu Aug 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2025	54	Brazil		nan		Right	5	5	5	High/Medium	Unique	Yes	238700000	#Speedster, #Dribbler, #Playmaker, #FK Specialist, #Acrobat, #Complete Midfielder	Injury Prone, Flair, Speed Dribbler (AI), Playmaker (AI), Outside Foot Shot, Technical Dribbler (AI)	91	83	86	94	37	63	85	83	63	86	86	95	88	87	81	95	93	89	96	89	84	80	64	81	53	81	63	37	86	90	93	93	35	32	29	9	9	15	15	11		83+3	83+3	83+3	90	88	88	88	90	89+2	89+2	89+2	89+2	82+3	82+3	82+3	89+2	67+3	63+3	63+3	63+3	67+3	62+3
192985	https://sofifa.com/player/192985/kevin-de-bruyne/220002	K. De Bruyne	Kevin De Bruyne	CM, CAM	91	91	125500000	350000	30	Fri Jun 28 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	181	70	10	Manchester City	English Premier League	1	RCM	17	nan	Sun Aug 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2025	7	Belgium	1325	RCM	7	Right	5	4	4	High/High	Unique	Yes	232200000	#Dribbler, #Playmaker, #Engine, #Distance Shooter, #Crosser, #Complete Midfielder	Injury Prone, Leadership, Early Crosser, Long Passer (AI), Long Shot Taker (AI), Playmaker (AI), Outside Foot Shot	76	86	93	88	64	78	94	82	55	94	82	88	85	83	93	91	76	76	79	91	78	91	63	89	74	91	76	66	88	94	83	89	68	65	53	15	13	5	10	13		83+3	83+3	83+3	88	87	87	87	88	89+2	89+2	89+2	89+2	89+2	89+2	89+2	89+2	79+3	80+3	80+3	80+3	79+3	75+3
200389	https://sofifa.com/player/200389/jan-oblak/220002	J. Oblak	Jan Oblak	GK	91	93	112000000	130000	28	Thu Jan 07 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	188	87	240	Atlético de Madrid	Spain Primera Division	1	GK	13	nan	Wed Jul 16 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2023	44	Slovenia		nan		Right	3	1	5	Medium/Medium	Unique	Yes	238000000	nan	GK Long Throw, Comes For Crosses							13	11	15	43	13	12	13	14	40	30	43	60	67	88	49	59	78	41	78	12	34	19	11	65	11	68	27	12	18	87	92	78	90	90	50	33+3	33+3	33+3	32	35	35	35	32	38+3	38+3	38+3	35+3	38+3	38+3	38+3	35+3	32+3	36+3	36+3	36+3	32+3	32+3
231747	https://sofifa.com/player/231747/kylian-mbappe/220002	K. Mbappé	Kylian Mbappé Lottin	ST, LW	91	95	194000000	230000	22	Sun Dec 20 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	182	73	73	Paris Saint-Germain	French Ligue 1	1	ST	7	nan	Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	18	France	1335	LW	10	Right	4	5	4	High/Low	Unique	Yes	373500000	#Speedster, #Dribbler, #Acrobat, #Clinical Finisher, #Complete Forward	Flair, Speed Dribbler (AI), Outside Foot Shot, Technical Dribbler (AI)	97	88	80	92	36	77	78	93	72	85	83	93	80	69	71	91	97	97	92	93	83	86	78	88	77	82	62	38	92	82	79	88	26	34	32	13	5	7	11	6		89+3	89+3	89+3	90	90	90	90	90	89+3	89+3	89+3	89+3	81+3	81+3	81+3	89+3	67+3	63+3	63+3	63+3	67+3	63+3
167495	https://sofifa.com/player/167495/manuel-neuer/220002	M. Neuer	Manuel Peter Neuer	GK	90	90	13500000	86000	35	Thu Mar 27 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	193	93	21	FC Bayern München	German 1. Bundesliga	1	GK	1	nan	Fri Jul 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	2023	21	Germany	1337	GK	1	Right	4	1	5	Medium/Medium	Unique	Yes	22300000	nan	Leadership, GK Long Throw, Rushes Out Of Goal, Comes For Crosses							15	13	25	60	11	30	14	11	68	46	54	60	51	87	35	68	77	43	80	16	29	30	12	70	47	70	17	10	11	88	88	91	89	88	56	40+3	40+3	40+3	40	43	43	43	40	47+3	47+3	47+3	44+3	50+3	50+3	50+3	44+3	37+3	43+3	43+3	43+3	37+3	35+3
192448	https://sofifa.com/player/192448/marc-andre-ter-stegen/220002	M. ter Stegen	Marc-André ter Stegen	GK	90	92	99000000	250000	29	Thu Apr 30 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	187	85	241	FC Barcelona	Spain Primera Division	1	GK	1	nan	Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2025	21	Germany		nan		Right	4	1	4	Medium/Medium	Unique	Yes	210400000	nan	Rushes Out Of Goal, Comes For Crosses, Saves with Feet							18	14	11	61	14	21	18	12	63	30	38	50	39	86	43	66	79	35	78	10	43	22	11	70	25	70	25	13	10	88	85	88	88	90	43	35+3	35+3	35+3	35	38	38	38	35	42+3	42+3	42+3	39+3	45+3	45+3	45+3	39+3	33+3	41+3	41+3	41+3	33+3	31+3
202126	https://sofifa.com/player/202126/harry-kane/220002	H. Kane	Harry Kane	ST	90	90	129500000	240000	27	Wed Jul 28 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	188	89	18	Tottenham Hotspur	English Premier League	1	ST	10	nan	Wed Jul 28 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	2024	14	England	1318	ST	9	Right	5	3	4	High/High	Unique	Yes	246100000	#Distance Shooter, #Clinical Finisher	Leadership, Long Passer (AI), Long Shot Taker (AI), Playmaker (AI), Outside Foot Shot	70	91	83	83	47	83	80	94	86	85	88	83	83	65	86	85	65	74	71	92	70	91	79	83	85	86	80	44	94	87	91	91	50	36	38	8	10	11	14	11		88+2	88+2	88+2	84	86	86	86	84	85+3	85+3	85+3	84+3	82+3	82+3	82+3	84+3	67+3	68+3	68+3	68+3	67+3	64+3


CREATE TABLE players_22 (
  "sofifa_id" BIGINT,
  "player_url" VARCHAR,
  "short_name" VARCHAR,
  "long_name" VARCHAR,
  "player_positions" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "value_eur" DOUBLE,
  "wage_eur" DOUBLE,
  "age" BIGINT,
  "dob" TIMESTAMP,
  "height_cm" BIGINT,
  "weight_kg" BIGINT,
  "club_team_id" DOUBLE,
  "club_name" VARCHAR,
  "league_name" VARCHAR,
  "league_level" DOUBLE,
  "club_position" VARCHAR,
  "club_jersey_number" DOUBLE,
  "club_loaned_from" VARCHAR,
  "club_joined" TIMESTAMP,
  "club_contract_valid_until" DOUBLE,
  "nationality_id" BIGINT,
  "nationality_name" VARCHAR,
  "nation_team_id" DOUBLE,
  "nation_position" VARCHAR,
  "nation_jersey_number" DOUBLE,
  "preferred_foot" VARCHAR,
  "weak_foot" BIGINT,
  "skill_moves" BIGINT,
  "international_reputation" BIGINT,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "release_clause_eur" DOUBLE,
  "player_tags" VARCHAR,
  "player_traits" VARCHAR,
  "pace" DOUBLE,
  "shooting" DOUBLE,
  "passing" DOUBLE,
  "dribbling" DOUBLE,
  "defending" DOUBLE,
  "physic" DOUBLE,
  "attacking_crossing" BIGINT,
  "attacking_finishing" BIGINT,
  "attacking_heading_accuracy" BIGINT,
  "attacking_short_passing" BIGINT,
  "attacking_volleys" BIGINT,
  "skill_dribbling" BIGINT,
  "skill_curve" BIGINT,
  "skill_fk_accuracy" BIGINT,
  "skill_long_passing" BIGINT,
  "skill_ball_control" BIGINT,
  "movement_acceleration" BIGINT,
  "movement_sprint_speed" BIGINT,
  "movement_agility" BIGINT,
  "movement_reactions" BIGINT,
  "movement_balance" BIGINT,
  "power_shot_power" BIGINT,
  "power_jumping" BIGINT,
  "power_stamina" BIGINT,
  "power_strength" BIGINT,
  "power_long_shots" BIGINT,
  "mentality_aggression" BIGINT,
  "mentality_interceptions" BIGINT,
  "mentality_positioning" BIGINT,
  "mentality_vision" BIGINT,
  "mentality_penalties" BIGINT,
  "mentality_composure" BIGINT,
  "defending_marking_awareness" BIGINT,
  "defending_standing_tackle" BIGINT,
  "defending_sliding_tackle" BIGINT,
  "goalkeeping_diving" BIGINT,
  "goalkeeping_handling" BIGINT,
  "goalkeeping_kicking" BIGINT,
  "goalkeeping_positioning" BIGINT,
  "goalkeeping_reflexes" BIGINT,
  "goalkeeping_speed" DOUBLE,
  "ls" VARCHAR,
  "st" VARCHAR,
  "rs" VARCHAR,
  "lw" VARCHAR,
  "lf" VARCHAR,
  "cf" VARCHAR,
  "rf" VARCHAR,
  "rw" VARCHAR,
  "lam" VARCHAR,
  "cam" VARCHAR,
  "ram" VARCHAR,
  "lm" VARCHAR,
  "lcm" VARCHAR,
  "cm" VARCHAR,
  "rcm" VARCHAR,
  "rm" VARCHAR,
  "lwb" VARCHAR,
  "ldm" VARCHAR,
  "cdm" VARCHAR,
  "rdm" VARCHAR,
  "rwb" VARCHAR,
  "lb" VARCHAR
);