FIFA Players Dataset

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

@kaggle.luisfucros_fifa_players

Table List

8 tables(22.79 MB)

Players 21

@kaggle.luisfucros_fifa_players.players_21

3.06 MB
18944 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/210002	L. Messi	Lionel Andrés Messi Cuccittini	RW, ST, CF	93	93	103500000	560000	33	Wed Jun 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	170	72	241	FC Barcelona	Spain Primera Division	1	CAM	10	nan	Thu Jul 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	52	Argentina	1369	RW	10	Left	4	4	5	Medium/Low	Unique	Yes	138400000	#Dribbler, #Distance Shooter, #FK Specialist, #Acrobat, #Clinical Finisher, #Complete Forward	Finesse Shot, Long Shot Taker (AI), Speed Dribbler (AI), Playmaker (AI), Outside Foot Shot, One Club Player, Team Player, Chip Shot (AI)	85	92	91	95	38	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	32	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	65+3	65+3	65+3	66+3	62+3
20801	https://sofifa.com/player/20801/c-ronaldo-dos-santos-aveiro/210002	Cristiano Ronaldo	Cristiano Ronaldo dos Santos Aveiro	ST, LW	92	92	63000000	220000	35	Tue Feb 05 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	187	83	45	Juventus	Italian Serie A	1	LS	7	nan	Tue Jul 10 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	38	Portugal	1354	LS	7	Right	4	5	5	High/Low	Unique	Yes	75900000	#Aerial Threat, #Dribbler, #Distance Shooter, #Acrobat, #Clinical Finisher, #Complete Forward	Power Free-Kick, Flair, Long Shot Taker (AI), Speed Dribbler (AI), Outside Foot Shot	89	93	81	89	35	77	84	95	90	82	86	88	81	76	77	92	87	91	87	95	71	94	95	84	78	93	63	29	95	82	84	95	28	32	24	7	11	15	14	11		91+1	91+1	91+1	89	91	91	91	89	88+3	88+3	88+3	88+3	81+3	81+3	81+3	88+3	65+3	61+3	61+3	61+3	65+3	61+3
188545	https://sofifa.com/player/188545/robert-lewandowski/210002	R. Lewandowski	Robert Lewandowski	ST	91	91	111000000	240000	31	Sun Aug 21 1988 00:00:00 GMT+0000 (Coordinated Universal Time)	184	80	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		nan		Right	4	4	4	High/Medium	Unique	Yes	132000000	#Distance Shooter, #Clinical Finisher	Solid Player, Finesse Shot, Outside Foot Shot, Chip Shot (AI)	78	91	78	85	43	82	71	94	85	84	89	85	79	85	70	88	77	78	77	93	82	89	84	76	86	85	81	49	94	79	88	88	35	42	19	15	6	12	8	10		89+2	89+2	89+2	85	87	87	87	85	85+3	85+3	85+3	83+3	79+3	79+3	79+3	83+3	64+3	65+3	65+3	65+3	64+3	61+3
190871	https://sofifa.com/player/190871/neymar-da-silva-santos-jr/210002	Neymar Jr	Neymar da Silva Santos Júnior	LW, CAM	91	91	132000000	270000	28	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)	2022	54	Brazil		nan		Right	5	5	5	High/Medium	Unique	Yes	166500000	#Speedster, #Dribbler, #Playmaker, #FK Specialist, #Acrobat, #Clinical Finisher, #Complete Midfielder, #Complete Forward	Injury Prone, Flair, Speed Dribbler (AI), Outside Foot Shot, Technical Dribbler (AI)	91	85	86	94	36	59	85	87	62	87	87	95	88	89	81	95	94	89	96	91	83	80	62	81	50	84	51	36	87	90	92	93	35	30	29	9	9	15	15	11		84+3	84+3	84+3	90	89	89	89	90	90+1	90+1	90+1	90+1	83+3	83+3	83+3	90+1	67+3	62+3	62+3	62+3	67+3	62+3
192985	https://sofifa.com/player/192985/kevin-de-bruyne/210002	K. De Bruyne	Kevin De Bruyne	CAM, CM	91	91	129000000	370000	29	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)	2023	7	Belgium	1325	RCM	7	Right	5	4	4	High/High	Unique	Yes	161000000	#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	92	77	76	78	91	76	91	63	89	74	91	76	66	88	94	84	91	68	65	53	15	13	5	10	13		83+3	83+3	83+3	88	88	88	88	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/210002	J. Oblak	Jan Oblak	GK	91	93	120000000	125000	27	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	1361	GK	1	Right	3	1	3	Medium/Medium	Unique	Yes	159400000	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	52	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
192448	https://sofifa.com/player/192448/marc-andre-ter-stegen/210002	M. ter Stegen	Marc-André ter Stegen	GK	90	93	110000000	260000	28	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)	2022	21	Germany	1337	SUB	22	Right	4	1	3	Medium/Medium	Unique	Yes	147700000	nan	Rushes Out Of Goal, Comes For Crosses, Saves with Feet							18	14	11	61	14	21	18	12	63	30	38	50	37	86	43	66	79	35	78	10	43	22	11	70	25	70	25	13	10	88	85	88	88	90	45	35+3	35+3	35+3	34	38	38	38	34	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
203376	https://sofifa.com/player/203376/virgil-van-dijk/210002	V. van Dijk	Virgil van Dijk	CB	90	91	113000000	210000	28	Mon Jul 08 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	193	92	9	Liverpool	English Premier League	1	LCB	4	nan	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2023	34	Netherlands	105035	LCB	4	Right	3	2	3	Medium/Medium	Unique	Yes	145300000	#Tackling, #Tactician, #Strength, #Complete Defender	Solid Player, Leadership, Long Passer (AI), Power Header	76	60	71	71	91	86	53	52	87	79	45	70	60	70	86	77	72	79	61	89	53	81	90	75	92	64	83	90	47	65	62	90	93	93	86	13	10	13	11	11		70+3	70+3	70+3	68	69	69	69	68	70+3	70+3	70+3	70+3	76+3	76+3	76+3	70+3	80+3	85+3	85+3	85+3	80+3	82+3
208722	https://sofifa.com/player/208722/sadio-mane/210002	S. Mané	Sadio Mané	LW	90	90	120500000	250000	28	Fri Apr 10 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	175	69	9	Liverpool	English Premier League	1	LW	10	nan	Fri Jul 01 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2023	136	Senegal		nan		Right	4	4	3	High/Medium	Unique	Yes	144300000	#Speedster, #Dribbler, #Acrobat	Flair, Speed Dribbler (AI)	94	85	80	90	44	76	76	90	84	85	75	91	76	64	71	89	95	93	93	93	86	84	86	88	70	78	75	35	92	85	71	84	42	42	38	10	10	15	7	14		88+2	88+2	88+2	89	89	89	89	89	88+2	88+2	88+2	88+2	81+3	81+3	81+3	88+2	69+3	65+3	65+3	65+3	69+3	66+3
209331	https://sofifa.com/player/209331/mohamed-salah/210002	M. Salah	Mohamed Salah Ghaly	RW	90	90	120500000	250000	28	Mon Jun 15 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	175	71	9	Liverpool	English Premier League	1	RW	11	nan	Sat Jul 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2023	111	Egypt	111130	RW	10	Left	3	4	3	High/Medium	Unique	Yes	144300000	#Speedster, #Dribbler, #Acrobat, #Clinical Finisher, #Complete Forward	Finesse Shot, Long Shot Taker (AI), Speed Dribbler (AI), Outside Foot Shot, Chip Shot (AI)	93	86	81	90	45	75	79	91	59	84	79	90	83	69	75	89	94	92	91	92	91	80	69	85	75	84	63	55	91	84	83	90	38	43	41	14	14	9	11	14		85+3	85+3	85+3	88	88	88	88	88	88+2	88+2	88+2	87+3	82+3	82+3	82+3	87+3	71+3	68+3	68+3	68+3	71+3	67+3


CREATE TABLE players_21 (
  "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
);