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)

Fifa19 Official Data

@kaggle.bryanb_fifa_player_stats_database.fifa19_official_data

1.4 MB
17943 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	31	https://cdn.sofifa.com/players/176/580/19_60.png	Uruguay	https://cdn.sofifa.com/flags/uy.png	91	91	FC Barcelona	https://cdn.sofifa.com/teams/241/light_30.png	€80M	€450K	2349	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	77	92	82	82	90	86	86	84	69	88	83	73	82	92	83	86	69	90	83	85	87	41	92	84	85	85	62	45	38	27	25	31	33	37	ST	87	€164M
194765	A. Griezmann	27	https://cdn.sofifa.com/players/194/765/19_60.png	France	https://cdn.sofifa.com/flags/fr.png	89	89	Atlético Madrid	https://cdn.sofifa.com/teams/240/light_30.png	€71M	€140K	2293	Left	4	3	4	High/ High	Lean (170-185)	Yes	<span class="pos pos24">RS	7	Mon Jul 28 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2023	5'9	161lbs	82	89	84	84	87	87	86	84	78	90	88	85	90	90	82	82	90	86	62	82	73	49	91	85	83	89	59	54	48	14	8	14	13	14	LW	87	€145.6M
177003	L. Modrić	32	https://cdn.sofifa.com/players/177/003/19_60.png	Croatia	https://cdn.sofifa.com/flags/hr.png	91	91	Real Madrid	https://cdn.sofifa.com/teams/243/light_30.png	€67M	€425K	2284	Right	4	4	4	High/ High	Lean (170-185)	Yes	<span class="pos pos13">RCM	10	Wed Aug 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2020	5'8	146lbs	86	72	55	93	76	90	85	78	88	92	78	72	92	90	94	79	68	89	58	82	62	83	79	92	82	92	68	76	73	13	9	7	14	9	CM	88	€137.4M
224334	M. Acuña	26	https://cdn.sofifa.com/players/224/334/19_60.png	Argentina	https://cdn.sofifa.com/flags/ar.png	81	81	Sporting CP	https://cdn.sofifa.com/teams/237/light_30.png	€19M	€20K	2281	Left	2	3	4	High/ High	Stocky (170-185)	No	<span class="pos pos28">SUB	8		nan	nan	5'8	152lbs	87	66	63	78	68	87	87	78	76	85	79	75	84	80	86	83	69	90	84	84	88	76	77	82	74	88	78	80	75	8	14	13	13	14	LM	81	€38M
192985	K. De Bruyne	27	https://cdn.sofifa.com/players/192/985/19_60.png	Belgium	https://cdn.sofifa.com/flags/be.png	91	91	Manchester City	https://cdn.sofifa.com/teams/10/light_30.png	€93M	€350K	2279	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	93	82	55	92	82	86	85	83	91	91	78	76	79	91	77	91	63	89	75	90	76	61	87	94	79	90	68	58	51	15	13	5	10	13	CAM	89	€172.1M
178518	R. Nainggolan	30	https://cdn.sofifa.com/players/178/518/19_60.png	Belgium	https://cdn.sofifa.com/flags/be.png	85	85	Inter	https://cdn.sofifa.com/teams/44/light_30.png	€35.5M	€100K	2278	Right	3	3	3	High/ High	Stocky (170-185)	Yes	<span class="pos pos18">CAM	14	Sun Jul 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2022	5'9	170lbs	73	75	59	84	75	80	73	68	81	85	78	73	76	87	82	84	76	93	77	86	88	86	86	76	63	84	83	86	90	11	11	14	8	11	CDM	85	€60.4M
212198	Bruno Fernandes	23	https://cdn.sofifa.com/players/212/198/19_60.png	Portugal	https://cdn.sofifa.com/flags/pt.png	85	89	Sporting CP	https://cdn.sofifa.com/teams/237/light_30.png	€50M	€20K	2277	Right	2	4	4	High/ High	Lean (170-185)	No	<span class="pos pos28">SUB	10		nan	nan	5'10	152lbs	85	78	58	85	86	85	86	87	86	87	79	76	78	84	79	89	72	91	67	88	70	74	81	88	86	86	68	64	57	12	14	15	8	14	CAM	84	€103.8M
176676	Marcelo	30	https://cdn.sofifa.com/players/176/676/19_60.png	Brazil	https://cdn.sofifa.com/flags/br.png	86	86	Real Madrid	https://cdn.sofifa.com/teams/243/light_30.png	€32M	€225K	2272	Left	4	4	5	High/ Low	Normal (170-185)	Yes	<span class="pos pos7">LB	12	Mon Jan 01 2007 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2022	5'9	176lbs	89	73	75	84	61	90	85	67	78	92	83	82	86	85	86	83	76	87	78	70	84	82	85	82	59	86	71	81	82	12	5	5	5	9	LM	85	€65.6M
212462	Alex Telles	25	https://cdn.sofifa.com/players/212/462/19_60.png	Brazil	https://cdn.sofifa.com/flags/br.png	84	86	FC Porto	https://cdn.sofifa.com/teams/236/light_30.png	€31M	€20K	2267	Left	3	2	3	High/ Medium	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	89	65	74	83	67	82	87	79	86	82	84	85	73	83	70	80	81	92	68	75	78	80	76	74	76	80	80	81	79	13	8	12	11	14	LWB	83	€64.3M
173731	G. Bale	28	https://cdn.sofifa.com/players/173/731/19_60.png	Wales	https://cdn.sofifa.com/flags/gb-wls.png	86	86	Real Madrid	https://cdn.sofifa.com/teams/243/light_30.png	€45M	€275K	2266	Left	4	3	4	Medium/ Medium	Lean (170-185)	Yes	<span class="pos pos28">SUB	11	Mon Sep 02 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	2022	6'1	181lbs	87	85	84	82	85	84	90	87	80	85	92	94	80	85	65	92	87	75	80	90	65	59	85	79	76	86	54	55	52	15	15	11	5	6	ST	86	€92.3M


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