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 19

@kaggle.stefanoleone992_fifa_20_complete_player_dataset.players_19

2.69 MB
17770 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
20801	https://sofifa.com/player/20801/c-ronaldo-dos-santos-aveiro/19/159222	Cristiano Ronaldo	Cristiano Ronaldo dos Santos Aveiro	33	Tue Feb 05 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	187	83	Portugal	Juventus	94	94	77000000	405000	ST, LW	Right	5	4	5	High/Low	C. Ronaldo	Yes	127100000	#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	81	89	35	79							Power Free-Kick, Diver, Flair, Long Shot Taker (CPU AI Only), Speed Dribbler (CPU AI Only), Through Ball	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	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
158023	https://sofifa.com/player/158023/lionel-messi/19/159222	L. Messi	Lionel Andrés Messi Cuccittini	31	Wed Jun 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	170	72	Argentina	FC Barcelona	94	94	110500000	565000	CF, RW, ST	Left	5	4	4	Medium/Medium	Messi	Yes	226500000	#Dribbler, #Distance Shooter, #FK Specialist, #Acrobat, #Clinical Finisher	RW	10	nan	Thu Jul 01 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	CF	10	88	91	88	96	32	61							Finesse Shot, Long Shot Taker (CPU AI Only), Speed Dribbler (CPU AI Only), Playmaker (CPU AI Only), One Club Player, Chip Shot (CPU AI Only)	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	88+2	88+2	88+2	92+2	93+2	93+2	93+2	92+2	93+2	93+2	93+2	90+2	84+2	84+2	84+2	90+2	63+2	61+2	61+2	61+2	63+2	58+2
190871	https://sofifa.com/player/190871/neymar-da-silva-santos-jr/19/159222	Neymar Jr	Neymar da Silva Santos Junior	26	Wed Feb 05 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	175	68	Brazil	Paris Saint-Germain	92	93	118500000	290000	LW, CAM	Right	5	5	5	High/Medium	Neymar	Yes	228100000	#Speedster, #Dribbler, #FK Specialist, #Acrobat, #Clinical Finisher, #Complete Forward	CAM	10	nan	Thu Aug 03 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2022	LW	10	92	84	83	95	32	59							Diver, Selfish, Flair, Speed Dribbler (CPU AI Only), Technical Dribbler (CPU AI Only), Takes Finesse Free Kicks	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+3	84+3	84+3	89+3	89+3	89+3	89+3	89+3	89+3	89+3	89+3	88+3	81+3	81+3	81+3	88+3	65+3	60+3	60+3	60+3	65+3	60+3
193080	https://sofifa.com/player/193080/david-de-gea-quintana/19/159222	De Gea	David De Gea Quintana	27	Wed Nov 07 1990 00:00:00 GMT+0000 (Coordinated Universal Time)	193	76	Spain	Manchester United	91	93	72000000	260000	GK	Right	4	3	1	Medium/Medium	Lean	Yes	138600000	nan	GK	1	nan	Fri Jul 01 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	2019	GK	1							90	85	87	94	58	88	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	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan
192985	https://sofifa.com/player/192985/kevin-de-bruyne/19/159222	K. De Bruyne	Kevin De Bruyne	27	Fri Jun 28 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	181	70	Belgium	Manchester City	91	92	102000000	355000	CAM, CM	Right	4	5	4	High/High	Normal	Yes	196400000	#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	77	86	92	87	60	78							Leadership, Early Crosser, Long Passer (CPU AI Only), Long Shot Taker (CPU AI Only), Playmaker (CPU AI Only)	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	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
155862	https://sofifa.com/player/155862/sergio-ramos-garcia/19/159222	Sergio Ramos	Sergio Ramos García	32	Sun Mar 30 1986 00:00:00 GMT+0000 (Coordinated Universal Time)	184	82	Spain	Real Madrid	91	91	51000000	380000	CB	Right	4	3	3	High/Medium	Normal	Yes	104600000	#Aerial Threat, #Tackling , #Tactician , #Complete Defender	LCB	4	nan	Mon Aug 01 2005 00:00:00 GMT+0000 (Coordinated Universal Time)	2020	LCB	15	75	63	71	71	91	84							Dives Into Tackles (CPU AI Only), Leadership, Power Header, Team Player	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	71+3	71+3	71+3	69+3	69+3	69+3	69+3	69+3	69+3	69+3	69+3	70+3	74+3	74+3	74+3	70+3	82+3	83+3	83+3	83+3	82+3	84+3
176580	https://sofifa.com/player/176580/luis-suarez/19/159222	L. Suárez	Luis Alberto Suárez Díaz	31	Sat Jan 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	182	86	Uruguay	FC Barcelona	91	91	80000000	455000	ST	Right	5	4	3	High/Medium	Normal	Yes	164000000	#Dribbler, #Clinical Finisher	ST	9	nan	Fri Jul 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	LS	9	80	90	79	88	52	85							Diver, Beat Offside Trap, Outside Foot Shot, Technical Dribbler (CPU AI Only)	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+5	87+5	87+5	86+5	87+5	87+5	87+5	86+5	86+5	86+5	86+5	85+5	79+5	79+5	79+5	85+5	69+5	68+5	68+5	68+5	69+5	66+5
177003	https://sofifa.com/player/177003/luka-modric/19/159222	L. Modrić	Luka Modrić	32	Mon Sep 09 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	172	66	Croatia	Real Madrid	91	91	67000000	420000	CM, CDM	Right	4	4	4	High/High	Lean	Yes	137400000	#Dribbler, #Playmaker , #Engine, #Crosser, #Acrobat, #Complete Midfielder	RCM	10	nan	Wed Aug 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2020	nan		76	76	90	91	70	67							Leadership, Long Shot Taker (CPU AI Only), Playmaker (CPU AI Only), Technical Dribbler (CPU AI Only)	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	77+3	77+3	77+3	85+3	84+3	84+3	84+3	85+3	87+3	87+3	87+3	86+3	88+3	88+3	88+3	86+3	82+3	81+3	81+3	81+3	82+3	79+3
183277	https://sofifa.com/player/183277/eden-hazard/19/159222	E. Hazard	Eden Hazard	27	Mon Jan 07 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	173	74	Belgium	Chelsea	91	91	93000000	340000	LW, CF	Right	4	4	4	High/Medium	Normal	Yes	172100000	#Speedster, #Dribbler, #Acrobat	LW	10	nan	Sun Jul 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	2020	LF	10	91	82	86	94	35	67							Beat Offside Trap, Finesse Shot, Flair, Playmaker (CPU AI Only), Technical Dribbler (CPU AI Only)	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	83+3	83+3	83+3	89+3	88+3	88+3	88+3	89+3	89+3	89+3	89+3	89+3	82+3	82+3	82+3	89+3	66+3	63+3	63+3	63+3	66+3	60+3
200389	https://sofifa.com/player/200389/jan-oblak/19/159222	J. Oblak	Jan Oblak	25	Thu Jan 07 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	188	87	Slovenia	Atlético Madrid	90	93	68000000	94000	GK	Right	3	3	1	Medium/Medium	Normal	Yes	144500000	nan	GK	13	nan	Thu Jul 17 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	2021	SUB	1							86	92	78	89	52	88	Puncher, GK Long Throw, Comes For Crosses	13	11	15	29	13	12	13	14	26	16	43	60	67	86	49	22	76	41	78	12	34	19	11	70	11	70	27	12	18	86	92	78	88	89	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan	nan


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