FIFA23 OFFICIAL DATASET

From FIFA17 to FIFA23 statistics for each football player

@kaggle.bryanb_fifa_player_stats_database

Table List

7 tables(9.07 MB)

Fifa20 Official Data

@kaggle.bryanb_fifa_player_stats_database.fifa20_official_data

1.37 MB
17104 rows
65 columns

id ID	name Name	age Age	photo Photo	nationality Nationality	flag Flag	overall Overall	potential Potential	club Club	club_logo Club Logo	value Value	wage Wage	special Special	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	position Position	jersey_number Jersey Number	joined Joined	loaned_from Loaned From	contract_valid_until Contract Valid Until	height Height	weight Weight	crossing Crossing	finishing Finishing	headingaccuracy HeadingAccuracy	shortpassing ShortPassing	volleys Volleys	dribbling Dribbling	curve Curve	fkaccuracy FKAccuracy	longpassing LongPassing	ballcontrol BallControl	acceleration Acceleration	sprintspeed SprintSpeed	agility Agility	reactions Reactions	balance Balance	shotpower ShotPower	jumping Jumping	stamina Stamina	strength Strength	longshots LongShots	aggression Aggression	interceptions Interceptions	positioning Positioning	vision Vision	penalties Penalties	composure Composure	standingtackle StandingTackle	slidingtackle SlidingTackle	gkdiving GKDiving	gkhandling GKHandling	gkkicking GKKicking	gkpositioning GKPositioning	gkreflexes GKReflexes	best_position Best Position	best_overall_rating Best Overall Rating	release_clause Release Clause	defensiveawareness DefensiveAwareness
176580	L. Suárez	32	https://cdn.sofifa.com/players/176/580/20_60.png	Uruguay	https://cdn.sofifa.com/flags/uy.png	89	89	FC Barcelona	https://cdn.sofifa.com/teams/241/light_30.png	€53M	€350K	2327	Right	5	4	3	High/ Medium	Normal (170-185)	Yes	<span class="pos pos25">ST	9	Fri Jul 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	6'0	190lbs	80	91	83	82	90	85	86	82	77	84	76	70	79	92	79	88	69	82	86	86	87	41	92	84	83	85	45	38	27	25	31	33	37	ST	89	€108.7M	57
194765	A. Griezmann	28	https://cdn.sofifa.com/players/194/765/20_60.png	France	https://cdn.sofifa.com/flags/fr.png	89	89	FC Barcelona	https://cdn.sofifa.com/teams/241/light_30.png	€69M	€370K	2299	Left	4	3	4	High/ High	Normal (170-185)	Yes	<span class="pos pos27">LW	17	Fri Jul 12 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2024	5'9	161lbs	83	89	84	85	87	88	86	85	82	90	82	79	90	92	83	82	90	87	63	83	73	49	90	86	86	89	54	49	14	8	14	13	14	CF	89	€141.5M	59
212198	Bruno Fernandes	24	https://cdn.sofifa.com/players/212/198/20_60.png	Portugal	https://cdn.sofifa.com/flags/pt.png	86	89	Manchester United	https://cdn.sofifa.com/teams/11/light_30.png	€56.5M	€165K	2299	Right	2	4	4	High/ High	Lean (170-185)	No	<span class="pos pos18">CAM	18	Thu Jan 30 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2025	5'10	152lbs	87	77	58	86	86	85	86	87	87	87	79	77	80	84	79	89	72	94	67	89	70	74	83	88	90	86	68	55	12	14	15	8	14	CAM	87	€111.6M	72
192985	K. De Bruyne	28	https://cdn.sofifa.com/players/192/985/20_60.png	Belgium	https://cdn.sofifa.com/flags/be.png	91	91	Manchester City	https://cdn.sofifa.com/teams/10/light_30.png	€90M	€370K	2289	Right	4	5	4	High/ High	Normal (170-185)	Yes	<span class="pos pos13">RCM	17	Sun Aug 30 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2023	5'11	154lbs	94	82	55	92	82	87	85	83	91	91	77	76	78	91	76	91	63	89	74	90	76	63	88	94	82	91	62	53	15	13	5	10	13	CAM	91	€166.5M	68
224334	M. Acuña	27	https://cdn.sofifa.com/players/224/334/20_60.png	Argentina	https://cdn.sofifa.com/flags/ar.png	82	82	Sporting CP	https://cdn.sofifa.com/teams/237/light_30.png	€20M	€19K	2285	Left	2	3	4	High/ High	Stocky (170-185)	No	<span class="pos pos15">LCM	8		nan	nan	5'8	152lbs	87	66	57	81	68	87	88	78	78	87	78	75	83	83	90	82	63	90	80	81	84	78	81	82	76	87	82	79	8	14	13	13	14	LB	82	€40M	79
212462	Alex Telles	26	https://cdn.sofifa.com/players/212/462/20_60.png	Brazil	https://cdn.sofifa.com/flags/br.png	84	85	FC Porto	https://cdn.sofifa.com/teams/236/light_30.png	€31.5M	€23K	2283	Left	3	2	3	High/ High	Lean (170-185)	Yes	<span class="pos pos7">LB	13	Wed Jul 13 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	5'11	157lbs	90	65	67	84	67	82	87	79	87	83	84	85	73	83	70	87	80	91	68	83	78	80	75	76	81	78	81	79	13	8	12	11	14	LWB	85	€65.4M	80
187961	Paulinho	30	https://cdn.sofifa.com/players/187/961/20_60.png	Brazil	https://cdn.sofifa.com/flags/br.png	85	85	Guangzhou Evergrande Taobao FC	https://cdn.sofifa.com/teams/111839/light_30.png	€35.5M	€47K	2278	Right	3	4	4	High/ High	Normal (170-185)	Yes	<span class="pos pos11">LDM	8	Tue Jan 15 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2023	6'0	176lbs	67	85	85	83	75	83	66	75	77	84	74	71	70	82	81	83	92	92	82	80	81	80	84	84	71	81	79	75	16	16	11	6	8	CM	85	€56.8M	80
178518	R. Nainggolan	31	https://cdn.sofifa.com/players/178/518/20_60.png	Belgium	https://cdn.sofifa.com/flags/be.png	84	84	Cagliari	https://cdn.sofifa.com/teams/1842/light_30.png	€27.5M	€57K	2271	Right	3	3	3	High/ High	Stocky (170-185)	Yes	<span class="pos pos20">RF	4		<a href="/team/44/inter/">Inter</a>	Jun 30, 2020	5'9	143lbs	73	75	59	85	75	83	73	68	82	84	72	72	75	85	83	84	75	89	76	88	88	86	84	80	63	84	86	90	11	11	14	8	11	CDM	85	nan	83
197445	D. Alaba	27	https://cdn.sofifa.com/players/197/445/20_60.png	Austria	https://cdn.sofifa.com/flags/at.png	83	84	FC Bayern München	https://cdn.sofifa.com/teams/21/light_30.png	€26M	€110K	2266	Left	4	4	3	Medium/ Medium	Lean (170-185)	Yes	<span class="pos pos6">LCB	27	Wed Feb 10 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	5'11	172lbs	82	63	76	82	68	79	78	85	79	82	79	85	78	84	78	85	83	85	75	80	69	82	76	77	79	80	82	82	5	7	14	15	9	CB	83	€44.9M	83
181872	A. Vidal	32	https://cdn.sofifa.com/players/181/872/20_60.png	Chile	https://cdn.sofifa.com/flags/cl.png	84	84	FC Barcelona	https://cdn.sofifa.com/teams/241/light_30.png	€23.5M	€200K	2264	Right	4	4	3	High/ High	Normal (170-185)	Yes	<span class="pos pos28">SUB	22	Mon Aug 06 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	5'11	165lbs	76	75	82	82	78	76	76	68	81	82	68	67	73	86	77	84	85	86	83	82	93	85	83	82	81	83	87	88	4	2	4	2	4	CB	85	€48.2M	82


CREATE TABLE fifa20_official_data (
  "id" BIGINT,
  "name" VARCHAR,
  "age" BIGINT,
  "photo" VARCHAR,
  "nationality" VARCHAR,
  "flag" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "club" VARCHAR,
  "club_logo" VARCHAR,
  "value" VARCHAR,
  "wage" VARCHAR,
  "special" BIGINT,
  "preferred_foot" VARCHAR,
  "international_reputation" DOUBLE,
  "weak_foot" DOUBLE,
  "skill_moves" DOUBLE,
  "work_rate" VARCHAR,
  "body_type" VARCHAR,
  "real_face" VARCHAR,
  "position" VARCHAR,
  "jersey_number" DOUBLE,
  "joined" TIMESTAMP,
  "loaned_from" VARCHAR,
  "contract_valid_until" VARCHAR,
  "height" VARCHAR,
  "weight" VARCHAR,
  "crossing" DOUBLE,
  "finishing" DOUBLE,
  "headingaccuracy" DOUBLE,
  "shortpassing" DOUBLE,
  "volleys" DOUBLE,
  "dribbling" DOUBLE,
  "curve" DOUBLE,
  "fkaccuracy" DOUBLE,
  "longpassing" DOUBLE,
  "ballcontrol" DOUBLE,
  "acceleration" DOUBLE,
  "sprintspeed" DOUBLE,
  "agility" DOUBLE,
  "reactions" DOUBLE,
  "balance" DOUBLE,
  "shotpower" DOUBLE,
  "jumping" DOUBLE,
  "stamina" DOUBLE,
  "strength" DOUBLE,
  "longshots" DOUBLE,
  "aggression" DOUBLE,
  "interceptions" DOUBLE,
  "positioning" DOUBLE,
  "vision" DOUBLE,
  "penalties" DOUBLE,
  "composure" DOUBLE,
  "marking" DOUBLE,
  "standingtackle" DOUBLE,
  "slidingtackle" DOUBLE,
  "gkdiving" DOUBLE,
  "gkhandling" DOUBLE,
  "gkkicking" DOUBLE,
  "gkpositioning" DOUBLE,
  "gkreflexes" DOUBLE,
  "best_position" VARCHAR,
  "best_overall_rating" DOUBLE,
  "release_clause" VARCHAR,
  "defensiveawareness" DOUBLE
);