FIFA Players Dataset

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

@kaggle.luisfucros_fifa_players

Table List

8 tables(22.79 MB)

Players 18

@kaggle.luisfucros_fifa_players.players_18

2.9 MB
17954 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
20801	https://sofifa.com/player/20801/c-ronaldo-dos-santos-aveiro/180002	Cristiano Ronaldo	Cristiano Ronaldo dos Santos Aveiro	LW, ST	94	94	95500000	575000	32	Tue Feb 05 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	185	80	243	Real Madrid CF	Spain Primera Division	1	LW	7	nan	Wed Jul 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	38	Portugal	1354	LS	7	Right	4	5	5	High/Low	Unique	Yes	195800000	#Speedster, #Dribbler, #Distance Shooter, #Acrobat, #Clinical Finisher, #Complete Forward	Power Free-Kick, Flair, Long Shot Taker (AI), Speed Dribbler (AI), Through Ball	90	93	82	90	33	80	85	94	88	83	88	91	81	76	77	93	89	91	89	96	63	94	95	92	80	92	63	29	95	85	85	95	22	31	23	7	11	15	14	11		92+2	92+2	92+2	91+3	91+3	91+3	91+3	91+3	89+4	89+4	89+4	89+4	82+4	82+4	82+4	89+4	66+4	62+4	62+4	62+4	66+4	61+4
158023	https://sofifa.com/player/158023/lionel-messi/180002	L. Messi	Lionel Andrés Messi Cuccittini	RW	93	93	105000000	575000	30	Wed Jun 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	170	72	241	FC Barcelona	Spain Primera Division	1	RW	10	nan	Thu Jul 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	2018	52	Argentina	1369	RW	10	Left	4	4	5	Medium/Medium	Unique	Yes	215300000	#Dribbler, #FK Specialist, #Acrobat, #Clinical Finisher	Finesse Shot, Long Shot Taker (AI), Speed Dribbler (AI), Playmaker (AI), One Club Player, Chip Shot (AI)	89	90	86	96	26	61	77	95	71	88	85	97	89	90	87	95	92	87	90	95	95	85	68	73	59	88	48	22	93	90	74	96	13	28	26	6	11	15	14	8		88+4	88+4	88+4	91+2	92+1	92+1	92+1	91+2	92+1	92+1	92+1	90+3	84+4	84+4	84+4	90+3	62+4	59+4	59+4	59+4	62+4	57+4
167495	https://sofifa.com/player/167495/manuel-neuer/180002	M. Neuer	Manuel Peter Neuer	GK	92	92	61000000	225000	31	Thu Mar 27 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	193	92	21	FC Bayern München	German 1. Bundesliga	1	GK	1	nan	Fri Jul 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	21	Germany	1337	GK	1	Right	4	1	5	Medium/Medium	Normal (185+)	Yes	100700000	nan	GK Long Throw, 1-on-1 Rush, Rushes Out Of Goal, Comes For Crosses							15	13	25	55	11	30	14	11	59	48	58	61	52	85	35	25	78	44	83	16	29	30	12	70	47	70	10	10	11	91	90	95	91	89	60	36+4	36+4	36+4	40+3	41+3	41+3	41+3	40+3	47+4	47+4	47+4	44+4	48+4	48+4	48+4	44+4	36+4	41+4	41+4	41+4	36+4	34+4
176580	https://sofifa.com/player/176580/luis-suarez/180002	L. Suárez	Luis Alberto Suárez Díaz	ST	92	92	97000000	500000	30	Sat Jan 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	182	86	241	FC Barcelona	Spain Primera Division	1	ST	9	nan	Fri Jul 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	60	Uruguay	1377	LS	9	Right	4	4	5	High/Medium	Normal (170-185)	Yes	198900000	#Acrobat, #Clinical Finisher	Diver, Beat Offside Trap, Technical Dribbler (AI)	82	90	79	87	42	81	77	94	77	83	88	86	86	84	64	91	88	77	86	93	60	87	69	89	80	86	78	41	92	84	85	83	30	45	38	27	25	31	33	37		88+4	88+4	88+4	87+3	88+3	88+3	88+3	87+3	87+4	87+4	87+4	85+4	80+4	80+4	80+4	85+4	68+4	65+4	65+4	65+4	68+4	64+4
190871	https://sofifa.com/player/190871/neymar-da-silva-santos-jr/180002	Neymar	Neymar da Silva Santos Júnior	LW	92	94	123000000	275000	25	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	1370	LW	10	Right	5	5	5	High/Medium	Unique	Yes	236800000	#Speedster, #Dribbler, #Acrobat	Diver, Flair, Speed Dribbler (AI), Technical Dribbler (AI), Takes Finesse Free Kicks	92	84	79	95	30	60	75	89	62	81	83	96	81	84	75	95	94	90	96	88	82	80	61	78	53	77	56	36	90	80	81	92	21	24	33	9	9	15	15	11		84+4	84+4	84+4	89+3	88+3	88+3	88+3	89+3	88+4	88+4	88+4	87+4	79+4	79+4	79+4	87+4	64+4	59+4	59+4	59+4	64+4	59+4
188545	https://sofifa.com/player/188545/robert-lewandowski/180002	R. Lewandowski	Robert Lewandowski	ST	91	91	92000000	350000	28	Sun Aug 21 1988 00:00:00 GMT+0000 (Coordinated Universal Time)	185	79	21	FC Bayern München	German 1. Bundesliga	1	ST	9	nan	Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	37	Poland	1353	ST	9	Right	4	3	4	High/Medium	Normal (170-185)	Yes	151800000	#Clinical Finisher	Injury Free, Finesse Shot, Chip Shot (AI)	81	88	75	86	38	82	62	91	85	83	87	85	77	84	65	89	79	83	78	91	80	88	84	79	84	83	80	39	91	78	81	87	25	42	19	15	6	12	8	10		88+3	88+3	88+3	84+2	87+2	87+2	87+2	84+2	84+3	84+3	84+3	82+3	78+3	78+3	78+3	82+3	61+3	62+3	62+3	62+3	61+3	58+3
155862	https://sofifa.com/player/155862/sergio-ramos-garcia/180002	Sergio Ramos	Sergio Ramos García	CB	90	90	52000000	300000	31	Sun Mar 30 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	183	75	243	Real Madrid CF	Spain Primera Division	1	LCB	4	nan	Mon Aug 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	2020	45	Spain	1362	LCB	15	Right	3	3	4	High/Medium	Normal (170-185)	Yes	106600000	#Aerial Threat, #Tackling, #Tactician, #Complete Defender	Dives Into Tackles (AI), Leadership, Power Header	76	63	71	71	88	83	66	60	91	78	66	61	73	67	72	84	75	77	79	85	60	79	93	84	81	55	84	88	52	63	68	80	86	89	91	11	8	9	7	11		72+3	72+3	72+3	69+2	70+2	70+2	70+2	69+2	70+3	70+3	70+3	71+3	74+3	74+3	74+3	71+3	81+3	83+3	83+3	83+3	81+3	84+3
167664	https://sofifa.com/player/167664/gonzalo-higuain/180002	G. Higuaín	Gonzalo Gerardo Higuaín	ST	90	90	77000000	275000	29	Thu Dec 10 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	184	87	45	Juventus	Italian Serie A	1	ST	9	nan	Tue Jul 26 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	52	Argentina		nan		Right	4	3	4	High/Medium	Normal (170-185)	Yes	127100000	#Clinical Finisher	Outside Foot Shot, Through Ball	79	87	70	83	25	74	68	91	86	75	88	84	74	62	59	85	78	80	75	88	69	88	79	72	85	82	50	20	92	70	70	86	12	22	18	5	12	7	5	10		87+3	87+3	87+3	82+2	84+2	84+2	84+2	82+2	81+3	81+3	81+3	79+3	71+3	71+3	71+3	79+3	55+3	52+3	52+3	52+3	55+3	51+3
182521	https://sofifa.com/player/182521/toni-kroos/180002	T. Kroos	Toni Kroos	CM, CDM	90	90	79000000	325000	27	Thu Jan 04 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	182	78	243	Real Madrid CF	Spain Primera Division	1	LCM	8	nan	Thu Jul 17 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	21	Germany	1337	LDM	8	Right	5	3	4	Medium/Medium	Normal (170-185)	Yes	162000000	#Playmaker, #Distance Shooter	Long Shot Taker (AI), Playmaker (AI), Technical Dribbler (AI), Set Play Specialist	56	81	89	81	73	70	85	76	54	90	82	79	85	84	93	89	60	52	71	86	69	87	32	77	74	90	60	85	79	88	73	85	63	82	69	10	11	13	7	10		77+3	77+3	77+3	80+2	81+2	81+2	81+2	80+2	83+3	83+3	83+3	81+3	87+3	87+3	87+3	81+3	78+3	82+3	82+3	82+3	78+3	76+3
183277	https://sofifa.com/player/183277/eden-hazard/180002	E. Hazard	Eden Hazard	LW	90	91	90500000	300000	26	Mon Jan 07 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	173	76	5	Chelsea	English Premier League	1	LW	10	nan	Sun Jul 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2020	7	Belgium	1325	LF	10	Right	4	4	4	High/Medium	Normal (170-185)	Yes	174200000	#Speedster, #Dribbler, #Acrobat	Beat Offside Trap, Finesse Shot, Flair, Playmaker (AI), Technical Dribbler (AI)	90	82	84	92	32	66	80	83	57	86	79	93	82	79	81	92	93	87	93	85	91	79	59	79	65	82	54	41	85	86	86	87	25	27	22	11	12	6	8	8		82+3	82+3	82+3	88+2	87+2	87+2	87+2	88+2	88+3	88+3	88+3	87+3	81+3	81+3	81+3	87+3	64+3	61+3	61+3	61+3	64+3	59+3


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