FIFA Players Dataset

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

@kaggle.luisfucros_fifa_players

Table List

8 tables(22.79 MB)

Players 16

@kaggle.luisfucros_fifa_players.players_16

2.48 MB
15623 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	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	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/160002	L. Messi	Lionel Andrés Messi Cuccittini	RW, CF	94	95	111000000	550000	28	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/Low	Unique	Yes	#Speedster, #Dribbler, #FK Specialist, #Acrobat, #Clinical Finisher, #Complete Forward	Finesse Shot, Speed Dribbler (AI), One Club Player, Team Player	92	88	86	95	24	62	80	93	71	88	85	96	89	90	79	96	95	90	92	92	95	80	68	76	59	88	48	22	90	90	74	13	23	21	6	11	15	14	8		87+3	87+3	87+3	91+3	91+3	91+3	91+3	91+3	91+3	91+3	91+3	90+3	82+3	82+3	82+3	90+3	62+3	57+3	57+3	57+3	62+3	57+3
20801	https://sofifa.com/player/20801/c-ronaldo-dos-santos-aveiro/160002	Cristiano Ronaldo	Cristiano Ronaldo dos Santos Aveiro	LW, LM	93	93	85500000	475000	30	Tue Feb 05 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	185	80	243	Real Madrid CF	Spain Primera Division	1	LM	7	nan	Wed Jul 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	2018	38	Portugal	1354	ST	7	Right	4	5	5	High/Low	Unique	Yes	#Speedster, #Dribbler, #Distance Shooter, #Acrobat, #Clinical Finisher, #Complete Forward	Power Free-Kick, Flair, Long Shot Taker (AI), Speed Dribbler (AI)	92	93	80	91	33	78	82	95	86	81	87	93	88	77	72	91	91	93	90	92	62	94	94	87	79	93	62	29	93	81	85	22	31	23	7	11	15	14	11		91+2	91+2	91+2	90+3	91+2	91+2	91+2	90+3	88+3	88+3	88+3	88+3	80+3	80+3	80+3	88+3	64+3	60+3	60+3	60+3	64+3	60+3
9014	https://sofifa.com/player/9014/arjen-robben/160002	A. Robben	Arjen Robben	RM, LM, RW	90	90	56000000	250000	31	Mon Jan 23 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	180	80	21	FC Bayern München	German 1. Bundesliga	1	SUB	10	nan	Fri Aug 28 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	2017	34	Netherlands	105035	RW	11	Left	2	4	5	High/Low	Normal (170-185)	Yes	#Speedster, #Dribbler, #Distance Shooter, #Acrobat	Diver, Injury Prone, Avoids Using Weaker Foot, Selfish, Long Shot Taker (AI), Speed Dribbler (AI), Chip Shot (AI)	92	86	82	92	32	64	80	85	51	85	86	93	86	83	74	90	92	92	91	91	91	86	61	76	65	90	47	39	89	84	80	29	26	26	10	8	11	5	15		84+3	84+3	84+3	89+1	88+2	88+2	88+2	89+1	88+2	88+2	88+2	87+3	80+3	80+3	80+3	87+3	65+3	60+3	60+3	60+3	65+3	59+3
167495	https://sofifa.com/player/167495/manuel-neuer/160002	M. Neuer	Manuel Peter Neuer	GK	90	90	58000000	250000	29	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)	2019	21	Germany	1337	GK	1	Right	4	1	5	Medium/Medium	Normal (185+)	Yes	nan	GK Long Throw, 1-on-1 Rush							15	13	25	48	11	16	14	11	47	31	58	61	43	88	35	25	78	44	83	16	29	30	12	70	37	10	10	11	85	87	91	90	86	60	33+3	33+3	33+3	35+3	36+3	36+3	36+3	35+3	40+3	40+3	40+3	38+3	42+3	42+3	42+3	38+3	33+3	38+3	38+3	38+3	33+3	33+3
176580	https://sofifa.com/player/176580/luis-suarez/160002	L. Suárez	Luis Alberto Suárez Díaz	ST	90	90	69000000	300000	28	Sat Jan 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	182	85	241	FC Barcelona	Spain Primera Division	1	ST	9	nan	Fri Jul 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2019	60	Uruguay		nan		Right	4	4	5	High/Medium	Normal (170-185)	Yes	#Acrobat, #Clinical Finisher	Diver, Beat Offside Trap, Flair, Technical Dribbler (AI)	83	88	79	87	42	79	77	90	77	82	87	88	86	84	64	91	88	78	86	91	60	88	69	86	76	85	78	41	91	84	85	30	45	38	27	25	31	33	37		87+3	87+3	87+3	87+3	88+2	88+2	88+2	87+3	86+3	86+3	86+3	85+3	79+3	79+3	79+3	85+3	67+3	65+3	65+3	65+3	67+3	64+3
41236	https://sofifa.com/player/41236/zlatan-ibrahimovic/160002	Z. Ibrahimović	Zlatan Ibrahimović	ST	89	89	40500000	220000	33	Sat Oct 03 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	195	95	73	Paris Saint-Germain	French Ligue 1	1	ST	10	nan	Sun Jul 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2016	46	Sweden	1363	LS	10	Right	4	4	5	Medium/Low	Normal (185+)	Yes	#Poacher, #Aerial Threat, #Distance Shooter, #Acrobat, #Strength, #Clinical Finisher, #Complete Forward	Power Free-Kick, Leadership, Flair, Long Shot Taker (AI), Technical Dribbler (AI)	73	90	81	85	31	86	76	90	76	84	92	87	80	80	76	90	72	74	86	85	41	93	72	75	93	88	84	20	86	83	91	15	41	27	13	15	10	9	12		86+3	86+3	86+3	84+3	86+3	86+3	86+3	84+3	85+3	85+3	85+3	83+3	78+3	78+3	78+3	83+3	60+3	60+3	60+3	60+3	60+3	56+3
183277	https://sofifa.com/player/183277/eden-hazard/160002	E. Hazard	Eden Hazard	LM	89	91	74000000	240000	24	Mon Jan 07 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	173	74	5	Chelsea	English Premier League	1	LM	10	nan	Sun Jul 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2020	7	Belgium	1325	LM	10	Right	4	4	4	High/Medium	Normal (170-185)	Yes	#Speedster, #Dribbler, #Acrobat	Injury Free, Finesse Shot, Flair, Playmaker (AI), Technical Dribbler (AI)	90	82	84	92	32	64	80	83	57	86	79	94	82	79	82	90	93	87	92	86	90	79	59	74	63	82	54	41	86	86	86	25	27	22	11	12	6	8	8		82+2	82+2	82+2	88+2	87+2	87+2	87+2	88+2	88+2	88+2	88+2	87+2	80+2	80+2	80+2	87+2	64+2	61+2	61+2	61+2	64+2	58+2
41	https://sofifa.com/player/41/andres-iniesta-lujan/160002	Iniesta	Andrés Iniesta Luján	CM	88	88	43000000	220000	31	Fri May 11 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	171	68	241	FC Barcelona	Spain Primera Division	1	LCM	8	nan	Mon Jul 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	2018	45	Spain	1362	LCM	6	Right	4	4	5	High/Medium	Normal (170-)	Yes	#Dribbler, #Playmaker	Finesse Shot, Playmaker (AI), Technical Dribbler (AI)	75	72	87	90	59	60	79	73	54	92	74	90	80	70	86	92	76	75	83	88	86	65	54	64	59	74	58	68	85	92	71	57	57	56	6	13	6	13	7		77+3	77+3	77+3	85+3	84+3	84+3	84+3	85+3	87+1	87+1	87+1	85+3	85+3	85+3	85+3	85+3	73+3	74+3	74+3	74+3	73+3	70+3
164240	https://sofifa.com/player/164240/thiago-emiliano-da-silva/160002	Thiago Silva	Thiago Emiliano da Silva	CB	88	88	38000000	200000	30	Sat Sep 22 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	183	79	73	Paris Saint-Germain	French Ligue 1	1	RCB	2	nan	Sun Jul 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2018	54	Brazil	1370	SUB	14	Right	3	3	4	High/High	Normal (170-185)	Yes	#Tackling, #Tactician	Leadership, Long Passer (AI), Power Header	74	57	73	73	90	79	60	38	82	79	63	68	61	73	81	80	72	76	75	84	68	78	93	74	81	71	77	91	59	74	71	90	91	89	9	12	5	9	10		68+2	68+2	68+2	69+2	70+2	70+2	70+2	69+2	72+2	72+2	72+2	71+2	77+2	77+2	77+2	71+2	80+2	84+2	84+2	84+2	80+2	82+2
168542	https://sofifa.com/player/168542/david-josue-jimenez-silva/160002	David Silva	David Josué Jiménez Silva	CAM, LM	88	88	50500000	210000	29	Wed Jan 08 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	170	67	10	Manchester City	English Premier League	1	SUB	21	nan	Wed Jul 14 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	2019	45	Spain	1362	RM	21	Left	2	4	4	High/Low	Normal (170-185)	Yes	#Dribbler, #Playmaker, #Acrobat	Avoids Using Weaker Foot, Flair, Playmaker (AI)	73	74	89	89	32	59	85	72	54	92	80	87	83	77	85	91	79	68	93	84	88	71	66	68	56	79	51	41	83	93	77	23	30	29	1	1	1	1	1		76+2	76+2	76+2	84+2	83+2	83+2	83+2	84+2	86+2	86+2	86+2	84+2	82+2	82+2	82+2	84+2	63+2	62+2	62+2	62+2	63+2	58+2


CREATE TABLE players_16 (
  "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" VARCHAR,
  "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" VARCHAR,
  "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
);