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 20

@kaggle.stefanoleone992_fifa_20_complete_player_dataset.players_20

2.57 MB
18278 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	value_eur Value Eur	wage_eur Wage Eur	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	release_clause_eur Release Clause Eur	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	mentality_composure Mentality Composure	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/20/159586	L. Messi	Lionel Andrés Messi Cuccittini	32	Wed Jun 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	170	72	Argentina	FC Barcelona	94	94	95500000	565000	RW, CF, ST	Left	5	4	4	Medium/Low	Messi	Yes	195800000	#Dribbler, #Distance Shooter, #Crosser, #FK Specialist, #Acrobat, #Clinical Finisher, #Complete Forward	RW	10	nan	Thu Jul 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	nan		87	92	92	96	39	66							Beat Offside Trap, Argues with Officials, Early Crosser, Finesse Shot, Speed Dribbler (CPU AI Only), 1-on-1 Rush, Giant Throw-in, Outside Foot Shot	88	95	70	92	88	97	93	94	92	96	91	84	93	95	95	86	68	75	68	94	48	40	94	94	75	96	33	37	26	6	11	15	14	8	89+2	89+2	89+2	93+2	93+2	93+2	93+2	93+2	93+2	93+2	93+2	92+2	87+2	87+2	87+2	92+2	68+2	66+2	66+2	66+2	68+2	63+2
20801	https://sofifa.com/player/20801/c-ronaldo-dos-santos-aveiro/20/159586	Cristiano Ronaldo	Cristiano Ronaldo dos Santos Aveiro	34	Tue Feb 05 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	187	83	Portugal	Juventus	93	93	58500000	405000	ST, LW	Right	5	4	5	High/Low	C. Ronaldo	Yes	96500000	#Speedster, #Dribbler, #Distance Shooter, #Acrobat, #Clinical Finisher, #Complete Forward	LW	7	nan	Tue Jul 10 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	LS	7	90	93	82	89	35	78							Long Throw-in, Selfish, Argues with Officials, Early Crosser, Speed Dribbler (CPU AI Only), Skilled Dribbling	84	94	89	83	87	89	81	76	77	92	89	91	87	96	71	95	95	85	78	93	63	29	95	82	85	95	28	32	24	7	11	15	14	11	91+3	91+3	91+3	89+3	90+3	90+3	90+3	89+3	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
190871	https://sofifa.com/player/190871/neymar-da-silva-santos-jr/20/159586	Neymar Jr	Neymar da Silva Santos Junior	27	Wed Feb 05 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	175	68	Brazil	Paris Saint-Germain	92	92	105500000	290000	LW, CAM	Right	5	5	5	High/Medium	Neymar	Yes	195200000	#Speedster, #Dribbler, #Playmaker , #Crosser, #FK Specialist, #Acrobat, #Clinical Finisher, #Complete Midfielder, #Complete Forward	CAM	10	nan	Thu Aug 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	LW	10	91	85	87	95	32	58							Power Free-Kick, Injury Free, Selfish, Early Crosser, Speed Dribbler (CPU AI Only), Crowd Favourite	87	87	62	87	87	96	88	87	81	95	94	89	96	92	84	80	61	81	49	84	51	36	87	90	90	94	27	26	29	9	9	15	15	11	84+3	84+3	84+3	90+3	89+3	89+3	89+3	90+3	90+3	90+3	90+3	89+3	82+3	82+3	82+3	89+3	66+3	61+3	61+3	61+3	66+3	61+3
200389	https://sofifa.com/player/200389/jan-oblak/20/159586	J. Oblak	Jan Oblak	26	Thu Jan 07 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	188	87	Slovenia	Atlético Madrid	91	93	77500000	125000	GK	Right	3	3	1	Medium/Medium	Normal	Yes	164700000	nan	GK	13	nan	Wed Jul 16 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2023	GK	1							87	92	78	89	52	90	Flair, Acrobatic Clearance	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	89	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
183277	https://sofifa.com/player/183277/eden-hazard/20/159586	E. Hazard	Eden Hazard	28	Mon Jan 07 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	175	74	Belgium	Real Madrid	91	91	90000000	470000	LW, CF	Right	4	4	4	High/Medium	Normal	Yes	184500000	#Speedster, #Dribbler, #Acrobat	LW	7	nan	Mon Jul 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	2024	LF	10	91	83	86	94	35	66							Beat Offside Trap, Selfish, Finesse Shot, Speed Dribbler (CPU AI Only), Crowd Favourite	81	84	61	89	83	95	83	79	83	94	94	88	95	90	94	82	56	84	63	80	54	41	87	89	88	91	34	27	22	11	12	6	8	8	83+3	83+3	83+3	89+3	88+3	88+3	88+3	89+3	89+3	89+3	89+3	89+3	83+3	83+3	83+3	89+3	66+3	63+3	63+3	63+3	66+3	61+3
192985	https://sofifa.com/player/192985/kevin-de-bruyne/20/159586	K. De Bruyne	Kevin De Bruyne	28	Fri Jun 28 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	181	70	Belgium	Manchester City	91	91	90000000	370000	CAM, CM	Right	4	5	4	High/High	Normal	Yes	166500000	#Dribbler, #Playmaker , #Engine, #Distance Shooter, #Crosser, #Complete Midfielder	RCM	17	nan	Sun Aug 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	2023	RCM	7	76	86	92	86	61	78							Power Free-Kick, Avoids Using Weaker Foot, Dives Into Tackles (CPU AI Only), Leadership, Argues with Officials, Finesse Shot	93	82	55	92	82	86	85	83	91	91	77	76	78	91	76	91	63	89	74	90	76	61	88	94	79	91	68	58	51	15	13	5	10	13	82+3	82+3	82+3	87+3	87+3	87+3	87+3	87+3	88+3	88+3	88+3	88+3	87+3	87+3	87+3	88+3	77+3	77+3	77+3	77+3	77+3	73+3
192448	https://sofifa.com/player/192448/marc-andre-ter-stegen/20/159586	M. ter Stegen	Marc-André ter Stegen	27	Thu Apr 30 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	187	85	Germany	FC Barcelona	90	93	67500000	250000	GK	Right	3	4	1	Medium/Medium	Normal	Yes	143400000	nan	GK	1	nan	Tue Jul 01 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	SUB	22							88	85	88	90	45	88	Swerve Pass, Acrobatic Clearance, Flair Passes	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	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
203376	https://sofifa.com/player/203376/virgil-van-dijk/20/159586	V. van Dijk	Virgil van Dijk	27	Mon Jul 08 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	193	92	Netherlands	Liverpool	90	91	78000000	200000	CB	Right	3	3	2	Medium/Medium	Normal	Yes	150200000	#Tackling , #Tactician , #Strength, #Complete Defender	LCB	4	nan	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	2023	LCB	4	77	60	70	71	90	86							Diver, Avoids Using Weaker Foot, Leadership, Long Passer (CPU AI Only)	53	52	86	78	45	70	60	70	81	76	74	79	61	88	53	81	90	75	92	64	82	89	47	65	62	89	91	92	85	13	10	13	11	11	69+3	69+3	69+3	67+3	69+3	69+3	69+3	67+3	69+3	69+3	69+3	69+3	74+3	74+3	74+3	69+3	79+3	83+3	83+3	83+3	79+3	81+3
177003	https://sofifa.com/player/177003/luka-modric/20/159586	L. Modrić	Luka Modrić	33	Mon Sep 09 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	172	66	Croatia	Real Madrid	90	90	45000000	340000	CM	Right	4	4	4	High/High	Lean	Yes	92300000	#Dribbler, #Playmaker , #Crosser, #Acrobat, #Complete Midfielder	RCM	10	nan	Wed Aug 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2020	nan		74	76	89	89	72	66							Argues with Officials, Finesse Shot, Speed Dribbler (CPU AI Only), Crowd Favourite	86	72	55	92	76	87	85	78	88	92	77	71	92	89	93	79	68	85	58	82	62	82	79	91	82	92	68	76	71	13	9	7	14	9	77+3	77+3	77+3	84+3	83+3	83+3	83+3	84+3	86+3	86+3	86+3	85+3	87+3	87+3	87+3	85+3	81+3	81+3	81+3	81+3	81+3	79+3
209331	https://sofifa.com/player/209331/mohamed-salah/20/159586	M. Salah	Mohamed Salah Ghaly	27	Mon Jun 15 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	175	71	Egypt	Liverpool	90	90	80500000	240000	RW, ST	Left	3	3	4	High/Medium	PLAYER_BODY_TYPE_25	Yes	148900000	#Speedster, #Dribbler, #Acrobat, #Clinical Finisher, #Complete Forward	RW	11	nan	Sat Jul 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2023	RW	10	93	86	81	89	45	74							Beat Offside Trap, Argues with Officials, Early Crosser, Speed Dribbler (CPU AI Only), Outside Foot Shot	79	90	59	84	79	89	83	69	75	89	94	92	91	92	88	80	69	85	73	84	63	55	92	84	77	91	38	43	41	14	14	9	11	14	84+3	84+3	84+3	88+3	88+3	88+3	88+3	88+3	87+3	87+3	87+3	87+3	81+3	81+3	81+3	87+3	70+3	67+3	67+3	67+3	70+3	66+3


CREATE TABLE players_20 (
  "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" DOUBLE,
  "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" 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" BIGINT,
  "defending_standing_tackle" BIGINT,
  "defending_sliding_tackle" BIGINT,
  "goalkeeping_diving" BIGINT,
  "goalkeeping_handling" BIGINT,
  "goalkeeping_kicking" BIGINT,
  "goalkeeping_positioning" BIGINT,
  "goalkeeping_reflexes" BIGINT,
  "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
);