Fifa 23 Players Dataset

Official Fifa 23 Player Stats

@kaggle.sanjeetsinghnaik_fifa_23_players_dataset

Table List

1 table(1.95 MB)

Fifa 23 Players Data

@kaggle.sanjeetsinghnaik_fifa_23_players_dataset.fifa_23_players_data

1.95 MB
18539 rows
89 columns

known_as Known As	full_name Full Name	overall Overall	potential Potential	value_in_euro Value(in Euro)	positions_played Positions Played	best_position Best Position	nationality Nationality	image_link Image Link	age Age	height_in_cm Height(in Cm)	weight_in_kg Weight(in Kg)	totalstats TotalStats	basestats BaseStats	club_name Club Name	wage_in_euro Wage(in Euro)	release_clause Release Clause	club_position Club Position	contract_until Contract Until	club_jersey_number Club Jersey Number	joined_on Joined On	on_loan On Loan	preferred_foot Preferred Foot	weak_foot_rating Weak Foot Rating	skill_moves Skill Moves	international_reputation International Reputation	national_team_name National Team Name	national_team_image_link National Team Image Link	national_team_position National Team Position	national_team_jersey_number National Team Jersey Number	attacking_work_rate Attacking Work Rate	defensive_work_rate Defensive Work Rate	pace_total Pace Total	shooting_total Shooting Total	passing_total Passing Total	dribbling_total Dribbling Total	defending_total Defending Total	physicality_total Physicality Total	crossing Crossing	finishing Finishing	heading_accuracy Heading Accuracy	short_passing Short Passing	volleys Volleys	dribbling Dribbling	curve Curve	freekick_accuracy Freekick Accuracy	longpassing LongPassing	ballcontrol BallControl	acceleration Acceleration	sprint_speed Sprint Speed	agility Agility	reactions Reactions	balance Balance	shot_power Shot Power	jumping Jumping	stamina Stamina	strength Strength	long_shots Long Shots	aggression Aggression	interceptions Interceptions	positioning Positioning	vision Vision	penalties Penalties	composure Composure	marking Marking	standing_tackle Standing Tackle	sliding_tackle Sliding Tackle	goalkeeper_diving Goalkeeper Diving	goalkeeper_handling Goalkeeper Handling	n__goalkeeperkicking GoalkeeperKicking	goalkeeper_positioning Goalkeeper Positioning	goalkeeper_reflexes Goalkeeper Reflexes	st_rating ST Rating	lw_rating LW Rating	lf_rating LF Rating	cf_rating CF Rating	rf_rating RF Rating	rw_rating RW Rating	cam_rating CAM Rating	lm_rating LM Rating	cm_rating CM Rating	rm_rating RM Rating	lwb_rating LWB Rating	cdm_rating CDM Rating	rwb_rating RWB Rating	lb_rating LB Rating	cb_rating CB Rating	rb_rating RB Rating	gk_rating GK Rating
L. Messi	Lionel Messi	91	91	54000000	RW	CAM	Argentina	https://cdn.sofifa.net/players/158/023/23_60.png	35	169	67	2190	452	Paris Saint-Germain	195000	99900000	RW	2023	30	2021	-	Left	4	4	5	Argentina	https://cdn.sofifa.net/flags/ar.png	RW	10	Low	Low	81	89	90	94	34	64	84	90	70	91	88	95	93	93	90	93	87	76	91	92	95	86	68	70	68	91	44	40	93	94	75	96	20	35	24	6	11	15	14	8	90	90	91	91	91	90	91	91	88	91	67	66	67	62	53	62	22
K. Benzema	Karim Benzema	91	91	64000000	CF,ST	CF	France	https://cdn.sofifa.net/players/165/153/23_60.png	34	185	81	2147	455	Real Madrid CF	450000	131199999	CF	2023	9	2009	-	Right	4	4	4	France	https://cdn.sofifa.net/flags/fr.png	ST	19	Medium	Medium	80	88	83	87	39	78	75	92	90	89	88	87	82	73	76	91	79	80	78	92	72	87	79	82	82	80	63	39	92	89	84	90	43	24	18	13	11	5	5	7	91	87	89	89	89	87	91	89	84	89	67	67	67	63	58	63	21
R. Lewandowski	Robert Lewandowski	91	91	84000000	ST	ST	Poland	https://cdn.sofifa.net/players/188/545/23_60.png	33	185	81	2205	458	FC Barcelona	420000	172200000	ST	2025	9	2022	-	Right	4	4	5	Poland	https://cdn.sofifa.net/flags/pl.png	ST	9	High	Medium	75	91	79	86	44	83	71	94	91	84	89	85	79	85	70	89	76	75	77	93	82	91	85	76	87	84	81	49	94	81	90	88	35	42	19	15	6	12	8	10	91	85	88	88	88	85	88	86	83	86	67	69	67	64	63	64	22
K. De Bruyne	Kevin De Bruyne	91	91	107500000	CM,CAM	CM	Belgium	https://cdn.sofifa.net/players/192/985/23_60.png	31	181	70	2303	483	Manchester City	350000	198900000	CM	2025	17	2015	-	Right	5	4	4	Belgium	https://cdn.sofifa.net/flags/be.png	RF	7	High	High	74	88	93	87	64	77	94	85	55	93	83	88	89	83	93	90	76	73	76	91	78	92	63	88	74	91	75	66	88	94	83	89	68	65	53	15	13	5	10	13	86	88	87	87	87	88	91	91	91	91	82	82	82	78	72	78	24
K. Mbappé	Kylian Mbappé	91	95	190500000	ST,LW	ST	France	https://cdn.sofifa.net/players/231/747/23_60.png	23	182	73	2177	470	Paris Saint-Germain	230000	366700000	ST	2024	7	2018	-	Right	4	5	4	France	https://cdn.sofifa.net/flags/fr.png	ST	10	High	Low	97	89	80	92	36	76	78	93	72	85	83	93	80	69	71	91	97	97	93	93	81	88	77	87	76	82	64	38	92	83	80	88	26	34	32	13	5	7	11	6	92	90	90	90	90	90	92	92	84	92	70	66	70	66	57	66	21
M. Salah	Mohamed Salah	90	90	115500000	RW	RW	Egypt	https://cdn.sofifa.net/players/209/331/23_60.png	30	175	71	2226	471	Liverpool	270000	213700000	RW	2023	11	2017	-	Left	3	4	4	-	-	-	-	High	Medium	90	89	82	90	45	75	80	93	59	84	84	90	84	69	77	88	89	91	90	93	91	83	69	87	75	85	63	55	92	85	86	92	38	43	41	14	14	9	11	14	89	88	88	88	88	88	90	90	85	90	74	71	74	70	61	70	25
T. Courtois	Thibaut Courtois	90	91	90000000	GK	GK	Belgium	https://cdn.sofifa.net/players/192/119/23_60.png	30	199	96	1334	473	Real Madrid CF	250000	191300000	GK	2026	1	2018	-	Left	3	1	4	Belgium	https://cdn.sofifa.net/flags/be.png	GK	1	Medium	Medium	84	89	75	90	46	89	14	14	13	33	12	13	19	20	35	23	42	52	63	84	45	56	68	38	70	17	23	15	13	44	27	66	20	18	16	84	89	75	89	90	34	29	31	31	31	29	35	34	35	34	32	34	32	32	32	32	90
M. Neuer	Manuel Neuer	90	90	13500000	GK	GK	Germany	https://cdn.sofifa.net/players/167/495/23_60.png	36	193	93	1535	501	FC Bayern München	72000	22300000	GK	2024	1	2011	-	Right	4	1	5	Germany	https://cdn.sofifa.net/flags/de.png	GK	1	Medium	Medium	87	88	91	88	56	91	15	13	25	60	11	30	14	11	68	46	54	60	51	87	35	68	77	43	80	16	29	30	12	70	47	70	17	10	11	87	88	91	91	88	43	40	43	43	43	40	50	47	53	47	39	46	39	38	37	38	90
Cristiano Ronaldo	C. Ronaldo dos Santos Aveiro	90	90	41000000	ST	ST	Portugal	https://cdn.sofifa.net/players/020/801/23_60.png	37	187	83	2159	445	Manchester United	220000	77900000	SUB	2023	7	2021	-	Right	4	5	5	Portugal	https://cdn.sofifa.net/flags/pt.png	ST	7	High	Low	81	92	78	85	34	75	80	93	90	80	86	85	81	79	75	88	79	83	77	94	67	93	95	76	77	90	63	29	95	76	90	95	24	32	24	7	11	15	14	11	90	86	88	88	88	86	88	87	81	87	65	62	65	61	56	61	23
V. van Dijk	Virgil van Dijk	90	90	98000000	CB	CB	Netherlands	https://cdn.sofifa.net/players/203/376/23_60.png	30	193	92	2117	461	Liverpool	230000	181300000	CB	2025	4	2018	-	Right	3	2	4	Netherlands	https://cdn.sofifa.net/flags/nl.png	CB	4	Medium	High	81	60	71	72	91	86	53	52	87	79	45	70	60	70	86	76	68	91	61	89	53	81	88	74	93	64	85	90	47	65	62	90	92	92	86	13	10	13	11	11	74	68	70	70	70	68	73	73	79	73	83	88	83	85	90	85	23


CREATE TABLE fifa_23_players_data (
  "known_as" VARCHAR,
  "full_name" VARCHAR,
  "overall" BIGINT,
  "potential" BIGINT,
  "value_in_euro" BIGINT,
  "positions_played" VARCHAR,
  "best_position" VARCHAR,
  "nationality" VARCHAR,
  "image_link" VARCHAR,
  "age" BIGINT,
  "height_in_cm" BIGINT,
  "weight_in_kg" BIGINT,
  "totalstats" BIGINT,
  "basestats" BIGINT,
  "club_name" VARCHAR,
  "wage_in_euro" BIGINT,
  "release_clause" BIGINT,
  "club_position" VARCHAR,
  "contract_until" VARCHAR,
  "club_jersey_number" VARCHAR,
  "joined_on" BIGINT,
  "on_loan" VARCHAR,
  "preferred_foot" VARCHAR,
  "weak_foot_rating" BIGINT,
  "skill_moves" BIGINT,
  "international_reputation" BIGINT,
  "national_team_name" VARCHAR,
  "national_team_image_link" VARCHAR,
  "national_team_position" VARCHAR,
  "national_team_jersey_number" VARCHAR,
  "attacking_work_rate" VARCHAR,
  "defensive_work_rate" VARCHAR,
  "pace_total" BIGINT,
  "shooting_total" BIGINT,
  "passing_total" BIGINT,
  "dribbling_total" BIGINT,
  "defending_total" BIGINT,
  "physicality_total" BIGINT,
  "crossing" BIGINT,
  "finishing" BIGINT,
  "heading_accuracy" BIGINT,
  "short_passing" BIGINT,
  "volleys" BIGINT,
  "dribbling" BIGINT,
  "curve" BIGINT,
  "freekick_accuracy" BIGINT,
  "longpassing" BIGINT,
  "ballcontrol" BIGINT,
  "acceleration" BIGINT,
  "sprint_speed" BIGINT,
  "agility" BIGINT,
  "reactions" BIGINT,
  "balance" BIGINT,
  "shot_power" BIGINT,
  "jumping" BIGINT,
  "stamina" BIGINT,
  "strength" BIGINT,
  "long_shots" BIGINT,
  "aggression" BIGINT,
  "interceptions" BIGINT,
  "positioning" BIGINT,
  "vision" BIGINT,
  "penalties" BIGINT,
  "composure" BIGINT,
  "marking" BIGINT,
  "standing_tackle" BIGINT,
  "sliding_tackle" BIGINT,
  "goalkeeper_diving" BIGINT,
  "goalkeeper_handling" BIGINT,
  "n__goalkeeperkicking" BIGINT,
  "goalkeeper_positioning" BIGINT,
  "goalkeeper_reflexes" BIGINT,
  "st_rating" BIGINT,
  "lw_rating" BIGINT,
  "lf_rating" BIGINT,
  "cf_rating" BIGINT,
  "rf_rating" BIGINT,
  "rw_rating" BIGINT,
  "cam_rating" BIGINT,
  "lm_rating" BIGINT,
  "cm_rating" BIGINT,
  "rm_rating" BIGINT,
  "lwb_rating" BIGINT,
  "cdm_rating" BIGINT,
  "rwb_rating" BIGINT,
  "lb_rating" BIGINT,
  "cb_rating" BIGINT,
  "rb_rating" BIGINT,
  "gk_rating" BIGINT
);