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)

Fifa18 Official Data

@kaggle.bryanb_fifa_player_stats_database.fifa18_official_data

1.39 MB
17927 rows
64 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	marking Marking	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
176580	L. Suárez	30	https://cdn.sofifa.com/players/176/580/18_60.png	Uruguay	https://cdn.sofifa.com/flags/uy.png	92	92	FC Barcelona	https://cdn.sofifa.com/teams/241/light_30.png	€97M	€500K	2321	Right	5	4	4	High/ Medium	Normal (170-185)	Yes	<span class="pos pos26">LS	9	Fri Jul 11 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	6'0	190lbs	77	94	77	83	88	86	86	84	64	91	88	77	86	93	78	87	69	89	83	86	87	41	92	84	85	85	30	45	38	27	25	31	33	37	CF	88	€198.9M
178518	R. Nainggolan	29	https://cdn.sofifa.com/players/178/518/18_60.png	Belgium	https://cdn.sofifa.com/flags/be.png	86	86	Roma	https://cdn.sofifa.com/teams/52/light_30.png	€42.5M	€130K	2286	Right	3	3	3	High/ High	Stocky (170-185)	Yes	<span class="pos pos13">RCM	4	Tue Jan 07 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	5'9	170lbs	73	76	59	84	75	80	73	68	81	85	80	76	81	87	84	84	76	94	76	86	88	86	88	76	63	84	78	86	88	11	11	14	8	11	CDM	84	€72.3M
203551	A. Florenzi	26	https://cdn.sofifa.com/players/203/551/18_60.png	Italy	https://cdn.sofifa.com/flags/it.png	82	83	Roma	https://cdn.sofifa.com/teams/52/light_30.png	€21M	€70K	2267	Right	3	3	3	High/ Medium	Lean (170-185)	Yes	<span class="pos pos3">RB	24	Thu Jul 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2023	5'8	148lbs	77	76	70	82	87	79	73	79	75	84	86	84	87	79	84	82	74	90	68	82	79	77	82	76	76	80	74	79	78	9	8	10	11	10	CF	81	€37.3M
197445	D. Alaba	25	https://cdn.sofifa.com/players/197/445/18_60.png	Austria	https://cdn.sofifa.com/flags/at.png	85	87	FC Bayern München	https://cdn.sofifa.com/teams/21/light_30.png	€38.5M	€130K	2263	Left	4	4	3	High/ Medium	Lean (170-185)	Yes	<span class="pos pos7">LB	27	Wed Feb 10 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	5'11	168lbs	81	63	75	82	68	79	78	85	80	83	86	81	79	84	77	83	82	87	69	83	69	84	77	78	80	79	78	82	80	5	7	14	15	9	LB	82	€66.4M
195864	P. Pogba	24	https://cdn.sofifa.com/players/195/864/18_60.png	France	https://cdn.sofifa.com/flags/fr.png	88	92	Manchester United	https://cdn.sofifa.com/teams/11/light_30.png	€76M	€250K	2262	Right	4	4	5	High/ Low	Lean (185+)	Yes	<span class="pos pos15">LCM	6	Tue Aug 09 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2021	6'3	185lbs	80	73	75	87	85	87	84	82	88	89	75	78	76	84	63	90	85	91	91	82	78	70	83	88	76	87	64	70	68	5	6	2	4	3	CM	85	€146.3M
173731	G. Bale	27	https://cdn.sofifa.com/players/173/731/18_60.png	Wales	https://cdn.sofifa.com/flags/gb-wls.png	88	88	Real Madrid	https://cdn.sofifa.com/teams/243/light_30.png	€62M	€375K	2260	Left	4	3	4	High/ Medium	Lean (170-185)	Yes	<span class="pos pos23">RW	11	Mon Sep 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2022	6'1	179lbs	86	87	86	85	80	87	86	85	80	85	93	95	78	85	65	91	85	76	80	90	65	59	86	79	76	85	51	55	52	15	15	11	5	6	ST	87	€127.1M
181872	A. Vidal	30	https://cdn.sofifa.com/players/181/872/18_60.png	Chile	https://cdn.sofifa.com/flags/cl.png	86	86	FC Bayern München	https://cdn.sofifa.com/teams/21/light_30.png	€33M	€160K	2253	Right	4	4	3	High/ High	Normal (170-185)	Yes	<span class="pos pos28">SUB	23	Tue Jul 28 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2019	5'11	165lbs	76	77	82	84	78	76	76	68	81	83	65	60	75	87	77	86	85	88	77	85	93	85	81	80	81	86	76	89	86	4	2	4	2	4	CDM	84	€54.5M
192985	K. De Bruyne	26	https://cdn.sofifa.com/players/192/985/18_60.png	Belgium	https://cdn.sofifa.com/flags/be.png	91	92	Manchester City	https://cdn.sofifa.com/teams/10/light_30.png	€104.5M	€400K	2234	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	150lbs	92	83	54	91	82	86	85	83	87	90	78	76	82	90	79	89	65	88	73	88	73	60	86	92	77	86	40	58	51	15	13	5	10	13	CAM	88	€201.2M
189332	Jordi Alba	28	https://cdn.sofifa.com/players/189/332/18_60.png	Spain	https://cdn.sofifa.com/flags/es.png	87	87	FC Barcelona	https://cdn.sofifa.com/teams/241/light_30.png	€40M	€250K	2231	Left	3	3	3	High/ Medium	Normal (170-)	Yes	<span class="pos pos7">LB	18	Sun Jul 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2020	5'7	150lbs	85	73	69	83	60	80	77	64	74	83	93	93	90	82	86	64	81	90	60	66	75	85	78	70	59	76	83	84	84	13	15	13	6	13	LWB	85	€82M
185103	A. Kolarov	31	https://cdn.sofifa.com/players/185/103/18_60.png	Serbia	https://cdn.sofifa.com/flags/rs.png	81	81	Roma	https://cdn.sofifa.com/teams/52/light_30.png	€11.5M	€70K	2231	Left	2	3	2	High/ Medium	Normal (185+)	Yes	<span class="pos pos7">LB	11	Sat Jul 22 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2020	6'2	183lbs	90	55	80	77	64	79	85	86	77	76	74	73	63	84	58	91	81	85	78	83	85	80	75	77	74	87	77	82	81	16	15	8	16	6	LB	81	€19.6M


CREATE TABLE fifa18_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
);