FIFA Players Dataset

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

@kaggle.luisfucros_fifa_players

Table List

8 tables(22.79 MB)

Players 19

@kaggle.luisfucros_fifa_players.players_19

2.93 MB
18085 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/190002	Cristiano Ronaldo	Cristiano Ronaldo dos Santos Aveiro	ST, LW	94	94	77000000	400000	33	Tue Feb 05 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	187	83	45	Juventus	Italian Serie A	1	ST	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	127100000	#Speedster, #Dribbler, #Distance Shooter, #Acrobat, #Clinical Finisher, #Complete Forward	Power Free-Kick, Diver, Flair, Long Shot Taker (AI), Speed Dribbler (AI), Through Ball	90	93	81	89	35	79	84	94	89	81	87	88	81	76	77	94	89	91	87	96	70	95	95	88	79	93	63	29	95	82	85	95	28	31	23	7	11	15	14	11		92+2	92+2	92+2	90	91	91	91	90	88+4	88+4	88+4	88+4	81+4	81+4	81+4	88+4	65+4	61+4	61+4	61+4	65+4	61+4
158023	https://sofifa.com/player/158023/lionel-messi/190002	L. Messi	Lionel Andrés Messi Cuccittini	CF, RW, ST	94	94	110500000	575000	31	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)	2021	52	Argentina	1369	CF	10	Left	4	4	5	Medium/Medium	Unique	Yes	226500000	#Dribbler, #Distance Shooter, #FK Specialist, #Acrobat, #Clinical Finisher	Finesse Shot, Long Shot Taker (AI), Speed Dribbler (AI), Playmaker (AI), One Club Player, Chip Shot (AI)	88	91	88	96	32	61	77	95	70	90	86	97	93	94	87	96	91	86	91	95	95	85	68	72	59	94	48	22	94	94	75	96	33	28	26	6	11	15	14	8		89+5	89+5	89+5	92+2	93+1	93+1	93+1	92+2	93+1	93+1	93+1	91+3	85+7	85+7	85+7	91+3	63+7	61+7	61+7	61+7	63+7	59+7
190871	https://sofifa.com/player/190871/neymar-da-silva-santos-jr/190002	Neymar	Neymar da Silva Santos Júnior	LW	92	93	118500000	300000	26	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	228100000	#Speedster, #Dribbler, #FK Specialist, #Acrobat, #Clinical Finisher, #Complete Forward	Diver, Selfish, Flair, Speed Dribbler (AI), Technical Dribbler (AI), Takes Finesse Free Kicks	92	84	83	95	32	59	79	87	62	84	84	96	88	87	78	95	94	90	96	94	84	80	61	81	49	82	56	36	89	87	81	94	27	24	33	9	9	15	15	11		84+7	84+7	84+7	90+3	90+3	90+3	90+3	90+3	90+3	90+3	90+3	89+4	81+7	81+7	81+7	89+4	66+7	61+7	61+7	61+7	66+7	61+7
155862	https://sofifa.com/player/155862/sergio-ramos-garcia/190002	Sergio Ramos	Sergio Ramos García	CB	91	91	51000000	375000	32	Sun Mar 30 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	184	82	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	104600000	#Aerial Threat, #Tackling, #Tactician, #Complete Defender	Dives Into Tackles (AI), Leadership, Power Header, Team Player	75	63	71	71	91	84	66	60	91	78	66	61	73	67	72	84	76	75	78	85	66	79	93	84	83	55	84	90	52	63	68	80	89	92	91	11	8	9	7	11		72+3	72+3	72+3	69	70	70	70	69	70+3	70+3	70+3	71+3	74+3	74+3	74+3	71+3	82+3	84+3	84+3	84+3	82+3	84+3
176580	https://sofifa.com/player/176580/luis-suarez/190002	L. Suárez	Luis Alberto Suárez Díaz	ST	91	91	80000000	450000	31	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	3	5	High/Medium	Normal (170-185)	Yes	164000000	#Dribbler, #Clinical Finisher	Diver, Beat Offside Trap, Outside Foot Shot, Technical Dribbler (AI)	80	90	79	88	52	85	77	94	77	82	88	87	86	84	64	90	86	75	82	93	83	86	69	90	83	85	87	41	92	84	85	85	62	45	38	27	25	31	33	37		87+4	87+4	87+4	86	88	88	88	86	86+4	86+4	86+4	85+4	80+4	80+4	80+4	85+4	70+4	68+4	68+4	68+4	70+4	66+4
177003	https://sofifa.com/player/177003/luka-modric/190002	L. Modrić	Luka Modrić	CM, CDM	91	91	67000000	425000	32	Mon Sep 09 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	172	66	243	Real Madrid CF	Spain Primera Division	1	RCM	10	nan	Wed Aug 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2020	10	Croatia		nan		Right	4	4	4	High/High	Lean (170-185)	Yes	137400000	#Dribbler, #Playmaker, #Engine, #Crosser, #Acrobat, #Complete Midfielder	Leadership, Long Passer (AI), Long Shot Taker (AI), Playmaker (AI), Technical Dribbler (AI)	76	76	90	91	70	67	86	72	55	93	76	90	85	78	88	93	80	72	93	90	94	79	68	89	58	82	62	83	79	92	82	84	60	76	73	13	9	7	14	9		78+3	78+3	78+3	86	85	85	85	86	88+3	88+3	88+3	87+3	88+3	88+3	88+3	87+3	83+3	82+3	82+3	82+3	83+3	80+3
183277	https://sofifa.com/player/183277/eden-hazard/190002	E. Hazard	Eden Hazard	LW, CF	91	91	93000000	325000	27	Mon Jan 07 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	173	74	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	172100000	#Speedster, #Dribbler, #Acrobat	Beat Offside Trap, Finesse Shot, Flair, Playmaker (AI), Technical Dribbler (AI)	91	82	86	94	35	67	81	84	61	89	80	95	83	79	83	94	93	89	95	90	94	80	56	83	66	80	54	41	87	89	86	91	34	27	22	11	12	6	8	8		84+6	84+6	84+6	89+2	89+2	89+2	89+2	89+2	90+1	90+1	90+1	89+2	83+6	83+6	83+6	89+2	66+6	63+6	63+6	63+6	66+6	61+6
192985	https://sofifa.com/player/192985/kevin-de-bruyne/190002	K. De Bruyne	Kevin De Bruyne	CAM, CM	91	92	102000000	350000	27	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	Normal (170-185)	Yes	196400000	#Dribbler, #Playmaker, #Engine, #Distance Shooter, #Crosser, #Complete Midfielder	Leadership, Early Crosser, Long Passer (AI), Long Shot Taker (AI), Playmaker (AI)	77	86	92	87	60	78	93	83	55	92	82	86	85	83	91	91	78	76	79	91	77	91	63	90	75	91	76	60	87	94	79	88	67	58	51	15	13	5	10	13		83+3	83+3	83+3	87	87	87	87	87	89+3	89+3	89+3	88+3	88+3	88+3	88+3	88+3	77+3	77+3	77+3	77+3	77+3	73+3
193080	https://sofifa.com/player/193080/david-de-gea-quintana/190002	De Gea	David De Gea Quintana	GK	91	93	72000000	250000	27	Wed Nov 07 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	193	76	11	Manchester United	English Premier League	1	GK	1	nan	Fri Jul 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	2019	45	Spain	1362	GK	1	Right	3	1	4	Medium/Medium	Lean (185+)	Yes	138600000	nan	GK Long Throw, Saves with Feet							17	13	21	50	13	18	21	19	51	42	57	58	60	90	43	31	67	43	64	12	38	30	12	68	40	68	15	21	13	90	85	87	88	94	58	33+2	33+2	33+2	37-1	38-1	38-1	38-1	37-1	43+2	43+2	43+2	40+2	45+2	45+2	45+2	40+2	36+2	41+2	41+2	41+2	36+2	35+2
167495	https://sofifa.com/player/167495/manuel-neuer/190002	M. Neuer	Manuel Peter Neuer	GK	90	90	44000000	130000	32	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	72600000	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	54	60	51	84	35	25	77	43	80	16	29	30	12	70	47	70	17	10	11	91	88	91	88	88	57	35+4	35+4	35+4	40	41	41	41	40	46+4	46+4	46+4	43+4	48+4	48+4	48+4	43+4	36+4	42+4	42+4	42+4	36+4	34+4


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