FIFA 20 Complete Player Dataset

18k+ players, 100+ attributes extracted from the latest edition of FIFA

@kaggle.stefanoleone992_fifa_20_complete_player_dataset

Table List

7 tables(15.7 MB)

Players 15

@kaggle.stefanoleone992_fifa_20_complete_player_dataset.players_15

2.42 MB
15465 rows
104 columns
Only the first 100 columns are shown

sofifa_id Sofifa Id	player_url Player Url	short_name Short Name	long_name Long Name	age Age	dob Dob	height_cm Height Cm	weight_kg Weight Kg	nationality Nationality	club Club	overall Overall	potential Potential	player_positions Player Positions	preferred_foot Preferred Foot	international_reputation International Reputation	weak_foot Weak Foot	skill_moves Skill Moves	work_rate Work Rate	body_type Body Type	real_face Real Face	player_tags Player Tags	team_position Team Position	team_jersey_number Team Jersey Number	loaned_from Loaned From	joined Joined	contract_valid_until Contract Valid Until	nation_position Nation Position	nation_jersey_number Nation Jersey Number	pace Pace	shooting Shooting	passing Passing	dribbling Dribbling	defending Defending	physic Physic	gk_diving Gk Diving	gk_handling Gk Handling	gk_kicking Gk Kicking	gk_reflexes Gk Reflexes	gk_speed Gk Speed	gk_positioning Gk Positioning	player_traits Player Traits	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 Defending Marking	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	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/15/157759	L. Messi	Lionel Andrés Messi Cuccittini	27	Wed Jun 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	169	67	Argentina	FC Barcelona	93	95	CF	Left	5	3	4	Medium/Low	Normal	Yes	#Speedster, #Dribbler, #FK Specialist, #Acrobat, #Clinical Finisher, #Complete Forward	CF	10	nan	Thu Jul 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	2018	CF	10	93	89	86	96	27	63							Finesse Shot, Speed Dribbler (CPU AI Only), One Club Player, Team Player	84	94-3	71	89	85-5	96-1	89+2	90+4	76	96	96	90+2	94	94-2	95	80-1	73	77-1	60	88	48	22	92-1	90	76	25	21	20	6	11	15	14	8	89+3	89+3	89+3	92+3	90+3	90+3	90+3	92+3	92+3	92+3	92+3	90+3	79+3	79+3	79+3	90+3	62+3	62+3	62+3	62+3	62+3	54+3
20801	https://sofifa.com/player/20801/c-ronaldo-dos-santos-aveiro/15/157759	Cristiano Ronaldo	Cristiano Ronaldo dos Santos Aveiro	29	Tue Feb 05 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	185	80	Portugal	Real Madrid	92	92	LW, LM	Right	5	4	5	High/Low	Normal	Yes	#Speedster, #Dribbler, #Distance Shooter, #Acrobat, #Clinical Finisher, #Complete Forward	LW	7	nan	Wed Jul 01 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	2018	LW	7	93	93	81	91	32	79							Power Free-Kick, Flair, Long Shot Taker (CPU AI Only), Speed Dribbler (CPU AI Only)	83	95+3	86	82	87+2	93+3	88	79	72	92-3	91	94	93	90	63-12	94	94	89	79	93	63	24	91+2	81	85	22	31	23	7	11	15	14	11	91+3	91+3	91+3	89+3	91+3	91+3	91+3	89+3	89+3	89+3	89+3	87+3	77+3	77+3	77+3	87+3	63+3	63+3	63+3	63+3	63+3	57+3
9014	https://sofifa.com/player/9014/arjen-robben/15/157759	A. Robben	Arjen Robben	30	Mon Jan 23 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	180	80	Netherlands	FC Bayern München	90	90	RM, LM, RW	Left	5	2	4	High/Low	Normal	Yes	#Speedster, #Dribbler, #Distance Shooter, #Acrobat	SUB	10	nan	Fri Aug 28 2009 00:00:00 GMT+0000 (Coordinated Universal Time)	2017	RS	11	93	86	83	92	32	64							Diver, Injury Prone, Avoids Using Weaker Foot, Selfish, Long Shot Taker (CPU AI Only), Speed Dribbler (CPU AI Only), Chip Shot (CPU AI Only)	80	85+2	50	86+2	86+2	93	85	83-1	76+3	90+1	93	93+2	93+1	89+2	91	86	61	78+11	65	90+1	47+9	39+1	89+2	84+2	80+1	29	26+2	26+1	10	8	11	5	15	84+3	84+3	84+3	88+3	87+3	87+3	87+3	88+3	88+3	88+3	88+3	87+3	78+3	78+3	78+3	87+3	64+3	64+3	64+3	64+3	64+3	55+3
41236	https://sofifa.com/player/41236/zlatan-ibrahimovic/15/157759	Z. Ibrahimović	Zlatan Ibrahimović	32	Sat Oct 03 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	195	95	Sweden	Paris Saint-Germain	90	90	ST	Right	5	4	4	Medium/Low	Normal	Yes	#Poacher, #Aerial Threat, #Distance Shooter, #Acrobat, #Strength, #Clinical Finisher, #Complete Forward	ST	10	nan	Sun Jul 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2016	ST	10	76	91	81	86	34	86							Power Free-Kick, Leadership, Flair, Long Shot Taker (CPU AI Only), Technical Dribbler (CPU AI Only)	76	91	76	84-2	92+3	88	80	80	76+4	90	74+2	77-1	86	85	41	93	72	78	93	88	84	20	86	83-1	91	25	41-8	27	13	15	10	9	12	87+3	87+3	87+3	84+3	86+3	86+3	86+3	84+3	86+3	86+3	86+3	83+3	76+3	76+3	76+3	83+3	61+3	65+3	65+3	65+3	61+3	56+3
167495	https://sofifa.com/player/167495/manuel-neuer/15/157759	M. Neuer	Manuel Neuer	28	Thu Mar 27 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	193	92	Germany	FC Bayern München	90	90	GK	Right	5	4	1	Medium/Medium	Normal	Yes	nan	GK	1	nan	Fri Jul 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	2019	GK	1							87	85	92	86	60	90	GK Up for Corners, GK Long Throw, 1-on-1 Rush	25	25	25	42	25	25	25	25	41	31	58+8	61+7	43+4	89+3	35	42	78	44+9	83+5	25	29+3	30+8	25	20	37	25	25	25	87	85+3	92	90+6	86	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
176580	https://sofifa.com/player/176580/luis-suarez/15/157759	L. Suárez	Luis Alberto Suárez Díaz	27	Sat Jan 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	181	81	Uruguay	FC Barcelona	89	91	ST, CF	Right	5	4	4	High/Medium	Normal	Yes	#Acrobat, #Clinical Finisher	RES	9	nan	Fri Jul 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2019	nan		83	87	79	88	42	79							Diver, Beat Offside Trap, Selfish, Flair, Technical Dribbler (CPU AI Only)	77	91+2	75	82	85	90-2	86	84	64	89	88	79	86	91+2	60-25	84	69	86	76	82-2	78	41	88+2	84	85	30	45	38	27	25	31	33	37	86+3	86+3	86+3	85+3	86+3	86+3	86+3	85+3	87+3	87+3	87+3	84+3	77+3	77+3	77+3	84+3	67+3	67+3	67+3	67+3	67+3	62+3
183277	https://sofifa.com/player/183277/eden-hazard/15/157759	E. Hazard	Eden Hazard	23	Mon Jan 07 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	173	74	Belgium	Chelsea	88	90	LM, RM	Right	4	4	4	High/Medium	Normal	Yes	#Speedster, #Dribbler, #Acrobat	LM	10	nan	Sun Jul 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2017	LM	10	90	82	84	91	32	64							Injury Free, Selfish, Finesse Shot, Flair, Playmaker (CPU AI Only), Technical Dribbler (CPU AI Only)	78-4	83	57	87+1	79	92+2	82	79	82	89	93+2	87	92	85+1	90	79	59	74+1	63	82	54	41	84	86+1	86+1	25	27	22	11	12	6	8	8	81+2	81+2	81+2	86+2	84+2	84+2	84+2	86+2	87+2	87+2	87+2	86+2	78+2	78+2	78+2	86+2	62+2	64+2	64+2	64+2	62+2	54+2
7826	https://sofifa.com/player/7826/robin-van-persie/15/157759	R. van Persie	Robin van Persie	30	Sat Aug 06 1983 00:00:00 GMT+0000 (Coordinated Universal Time)	187	71	Netherlands	Manchester United	88	88	ST	Left	5	3	4	Medium/Low	Normal	Yes	#Distance Shooter, #Clinical Finisher	RS	20	nan	Fri Aug 17 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2016	LS	9	74	90	82	83	33	68							Injury Prone, Flair, Long Shot Taker (CPU AI Only), Technical Dribbler (CPU AI Only)	81	91	73	85	92	84	86	81	75	87-1	73-1	74-1	80-1	88+1	59	90	59	72	72	86-1	55	34	90	82	86	23	32	21	9	10	5	7	8	85+3	85+3	85+3	84+3	86+3	86+3	86+3	84+3	85+3	85+3	85+3	82+3	76+3	76+3	76+3	82+3	60+3	63+3	63+3	63+3	60+3	54+3
121944	https://sofifa.com/player/121944/bastian-schweinsteiger/15/157759	B. Schweinsteiger	Bastian Schweinsteiger	29	Wed Aug 01 1984 00:00:00 GMT+0000 (Coordinated Universal Time)	183	79	Germany	FC Bayern München	88	88	CM, CDM	Right	4	3	3	High/High	Normal	Yes	#Playmaker , #Engine, #Tactician	SUB	31	nan	Mon Jul 01 2002 00:00:00 GMT+0000 (Coordinated Universal Time)	2016	SUB	7	61	81	85	82	78	80							Injury Prone, Leadership, Playmaker (CPU AI Only), One Club Player	81	76+2	79+1	88-1	83-1	81-1	82-1	78	87	86	58-1	64	74-1	90	75-1	86	82+7	86	77+1	86	80+1	86	82	86	81	69+1	80+1	77	14	14	13	13	11	80+2	80+2	80+2	80+2	82+2	82+2	82+2	80+2	84+2	84+2	84+2	82+2	86+2	86+2	86+2	82+2	81+2	84+2	84+2	84+2	81+2	81+2
156616	https://sofifa.com/player/156616/franck-ribery/15/157759	F. Ribéry	Franck Bilal Ribéry	31	Thu Apr 07 1983 00:00:00 GMT+0000 (Coordinated Universal Time)	170	72	France	FC Bayern München	88	88	LM	Right	4	4	5	High/Medium	Normal	Yes	#Dribbler, #Acrobat	SUB	7	nan	Sun Jul 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	2017	nan		89	78	85	92	29	62							Injury Prone, Flair, Speed Dribbler (CPU AI Only)	83	79	41	89	81	92	84-2	81	74+2	91-1	91-1	87-1	92	89-1	92	76	51-2	72	62-2	73-1	52	36	83	88	80	25	25	26	15	6	9	7	10	79+2	79+2	79+2	87+2	82+2	82+2	82+2	87+2	87+2	87+2	87+2	86+2	77+2	77+2	77+2	86+2	63+2	63+2	63+2	63+2	63+2	53+2


CREATE TABLE players_15 (
  "sofifa_id" BIGINT,
  "player_url" VARCHAR,
  "short_name" VARCHAR,
  "long_name" VARCHAR,
  "age" BIGINT,
  "dob" TIMESTAMP,
  "height_cm" BIGINT,
  "weight_kg" BIGINT,
  "nationality" VARCHAR,
  "club" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "value_eur" BIGINT,
  "wage_eur" BIGINT,
  "player_positions" VARCHAR,
  "preferred_foot" VARCHAR,
  "international_reputation" BIGINT,
  "weak_foot" BIGINT,
  "skill_moves" BIGINT,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "release_clause_eur" VARCHAR,
  "player_tags" VARCHAR,
  "team_position" VARCHAR,
  "team_jersey_number" DOUBLE,
  "loaned_from" VARCHAR,
  "joined" TIMESTAMP,
  "contract_valid_until" DOUBLE,
  "nation_position" VARCHAR,
  "nation_jersey_number" DOUBLE,
  "pace" DOUBLE,
  "shooting" DOUBLE,
  "passing" DOUBLE,
  "dribbling" DOUBLE,
  "defending" DOUBLE,
  "physic" DOUBLE,
  "gk_diving" DOUBLE,
  "gk_handling" DOUBLE,
  "gk_kicking" DOUBLE,
  "gk_reflexes" DOUBLE,
  "gk_speed" DOUBLE,
  "gk_positioning" DOUBLE,
  "player_traits" VARCHAR,
  "attacking_crossing" VARCHAR,
  "attacking_finishing" VARCHAR,
  "attacking_heading_accuracy" VARCHAR,
  "attacking_short_passing" VARCHAR,
  "attacking_volleys" VARCHAR,
  "skill_dribbling" VARCHAR,
  "skill_curve" VARCHAR,
  "skill_fk_accuracy" VARCHAR,
  "skill_long_passing" VARCHAR,
  "skill_ball_control" VARCHAR,
  "movement_acceleration" VARCHAR,
  "movement_sprint_speed" VARCHAR,
  "movement_agility" VARCHAR,
  "movement_reactions" VARCHAR,
  "movement_balance" VARCHAR,
  "power_shot_power" VARCHAR,
  "power_jumping" VARCHAR,
  "power_stamina" VARCHAR,
  "power_strength" VARCHAR,
  "power_long_shots" VARCHAR,
  "mentality_aggression" VARCHAR,
  "mentality_interceptions" VARCHAR,
  "mentality_positioning" VARCHAR,
  "mentality_vision" VARCHAR,
  "mentality_penalties" VARCHAR,
  "mentality_composure" VARCHAR,
  "defending_marking" VARCHAR,
  "defending_standing_tackle" VARCHAR,
  "defending_sliding_tackle" VARCHAR,
  "goalkeeping_diving" VARCHAR,
  "goalkeeping_handling" VARCHAR,
  "goalkeeping_kicking" VARCHAR,
  "goalkeeping_positioning" VARCHAR,
  "goalkeeping_reflexes" VARCHAR,
  "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
);