FIFA 2021 Team And Player Dataset

int_player_id Int Player Id	str_player_name Str Player Name	str_positions Str Positions	dt_date_of_birth Dt Date Of Birth	int_height Int Height	int_weight Int Weight	int_overall_rating Int Overall Rating	int_potential_rating Int Potential Rating	str_best_position Str Best Position	int_best_overall_rating Int Best Overall Rating	int_value Int Value	int_wage Int Wage	int_team_id Int Team Id	str_nationality Str Nationality	int_crossing Int Crossing	int_finishing Int Finishing	int_heading_accuracy Int Heading Accuracy	int_short_passing Int Short Passing	int_volleys Int Volleys	int_defensive_awareness Int Defensive Awareness	int_standing_tackle Int Standing Tackle	int_sliding_tackle Int Sliding Tackle	int_diving Int Diving	int_handling Int Handling	int_kicking Int Kicking	int_gk_positioning Int Gk Positioning	int_reflexes Int Reflexes	int_aggression Int Aggression	int_interceptions Int Interceptions	int_positioning Int Positioning	int_vision Int Vision	int_penalties Int Penalties	int_composure Int Composure	int_acceleration Int Acceleration	int_sprint_speed Int Sprint Speed	int_agility Int Agility	int_reactions Int Reactions	int_balance Int Balance	int_shot_power Int Shot Power	int_jumping Int Jumping	int_stamina Int Stamina	int_strength Int Strength	int_long_shots Int Long Shots	str_preferred_foot Str Preferred Foot	int_weak_foot Int Weak Foot	int_skill_moves Int Skill Moves	int_international_reputations Int International Reputations	str_work_rate Str Work Rate	str_body_type Str Body Type	int_dribbling Int Dribbling	int_curve Int Curve	int_fk_accuracy Int Fk Accuracy	int_long_passing Int Long Passing	int_ball_control Int Ball Control	str_player_speciality Str Player Speciality	str_trait Str Trait
1	Lionel Andrés Messi Cuccittini	RW, ST, CF	Wed Jun 24 1987 00:00:00 GMT+0000 (Coordinated Universal Time)	170	72	93	93	RW	93	103500000	560000	5	Argentina	85	95	70	91	88	32	35	24	6	11	15	14	8	44	40	93	95	75	96	91	80	91	94	95	86	68	72	69	94	Left	4	4	5	Medium/ Low	Unique	96	93	94	91	96	['Dribbler', 'Distance Shooter', 'FK Specialist', 'Acrobat', 'Clinical Finisher', 'Complete Forward']	['Finesse Shot', 'Long Shot Taker (AI)', 'Speed Dribbler (AI)', 'Playmaker (AI)', 'Outside Foot Shot', 'One Club Player', 'Team Player', 'Chip Shot (AI)']
2	Cristiano Ronaldo dos Santos Aveiro	ST, LW	Tue Feb 05 1985 00:00:00 GMT+0000 (Coordinated Universal Time)	187	83	92	92	ST	92	63000000	220000	6	Portugal	84	95	90	82	86	28	32	24	7	11	15	14	11	63	29	95	82	84	95	87	91	87	95	71	94	95	84	78	93	Right	4	5	5	High/ Low	Unique	88	81	76	77	92	['Aerial Threat', 'Dribbler', 'Distance Shooter', 'Acrobat', 'Clinical Finisher', 'Complete Forward']	['Power Free-Kick', 'Flair', 'Long Shot Taker (AI)', 'Speed Dribbler (AI)', 'Outside Foot Shot']
3	Jan Oblak	GK	Thu Jan 07 1993 00:00:00 GMT+0000 (Coordinated Universal Time)	188	87	91	93	GK	91	120000000	125000	8	Slovenia	13	11	15	43	13	27	12	18	87	92	78	90	90	34	19	11	65	11	68	43	60	67	88	49	59	78	41	78	12	Right	3	1	3	Medium/ Medium	Unique	12	13	14	40	30	nan	['GK Long Throw', 'Comes For Crosses']
4	Kevin De Bruyne	CAM, CM	Fri Jun 28 1991 00:00:00 GMT+0000 (Coordinated Universal Time)	181	70	91	91	CAM	91	129000000	370000	2	Belgium	94	82	55	94	82	68	65	53	15	13	5	10	13	76	66	88	94	84	91	77	76	78	91	76	91	63	89	74	91	Right	5	4	4	High/ High	Unique	88	85	83	93	92	['Dribbler', 'Playmaker\xa0', 'Engine', 'Distance Shooter', 'Crosser', 'Complete Midfielder']	['Injury Prone', 'Leadership', 'Early Crosser', 'Long Passer (AI)', 'Long Shot Taker (AI)', 'Playmaker (AI)', 'Outside Foot Shot']
5	Neymar da Silva Santos Júnior	LW, CAM	Wed Feb 05 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	175	68	91	91	LW	91	132000000	270000	7	Brazil	85	87	62	87	87	35	30	29	9	9	15	15	11	51	36	87	90	92	93	94	89	96	91	83	80	62	81	50	84	Right	5	5	5	High/ Medium	Unique	95	88	89	81	95	['Speedster', 'Dribbler', 'Playmaker\xa0', 'FK Specialist', 'Acrobat', 'Clinical Finisher', 'Complete Midfielder', 'Complete Forward']	['Injury Prone', 'Flair', 'Speed Dribbler (AI)', 'Outside Foot Shot', 'Technical Dribbler (AI)']
6	Robert Lewandowski	ST	Sun Aug 21 1988 00:00:00 GMT+0000 (Coordinated Universal Time)	184	80	91	91	ST	91	111000000	240000	4	Poland	71	94	87	85	89	35	42	19	15	6	12	8	10	81	49	94	81	88	88	77	78	77	93	82	89	84	76	86	85	Right	4	4	4	High/ Medium	Unique	85	79	85	70	88	['Distance Shooter', 'Clinical Finisher']	['Solid Player', 'Finesse Shot', 'Outside Foot Shot', 'Chip Shot (AI)']
7	Kylian Mbappé Lottin	ST, LW, RW	Sun Dec 20 1998 00:00:00 GMT+0000 (Coordinated Universal Time)	178	73	90	95	ST	91	185500000	160000	7	France	78	91	73	83	83	34	34	32	13	5	7	11	6	62	38	91	80	70	84	96	96	92	92	82	86	77	86	76	79	Right	4	5	3	High/ Low	Unique	92	79	63	70	90	['Speedster', 'Dribbler', 'Acrobat']	['Finesse Shot', 'Flair', 'Speed Dribbler (AI)', 'Outside Foot Shot', 'Technical Dribbler (AI)']
8	Alisson Ramsés Becker	GK	Fri Oct 02 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	191	91	90	91	GK	90	102000000	160000	1	Brazil	17	13	19	45	20	15	19	16	86	88	85	91	89	27	11	13	66	23	65	56	47	40	88	37	64	52	32	78	14	Right	3	1	3	Medium/ Medium	Unique	27	19	18	44	30	nan	['GK Long Throw', 'Rushes Out Of Goal']
9	Mohamed Salah Ghaly	RW	Mon Jun 15 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	175	71	90	90	RW	90	120500000	250000	1	Egypt	79	91	59	84	79	38	43	41	14	14	9	11	14	63	55	91	84	83	90	94	92	91	92	91	80	69	85	75	84	Left	3	4	3	High/ Medium	Unique	90	83	69	75	89	['Speedster', 'Dribbler', 'Acrobat', 'Clinical Finisher', 'Complete Forward']	['Finesse Shot', 'Long Shot Taker (AI)', 'Speed Dribbler (AI)', 'Outside Foot Shot', 'Chip Shot (AI)']
10	Sadio Mané	LW	Fri Apr 10 1992 00:00:00 GMT+0000 (Coordinated Universal Time)	175	69	90	90	LW	90	120500000	250000	1	Senegal	76	90	84	85	75	42	42	38	10	10	15	7	14	75	35	92	85	71	84	95	93	93	93	86	84	86	88	70	78	Right	4	4	3	High/ Medium	Unique	91	76	64	71	89	['Speedster', 'Dribbler', 'Acrobat']	['Flair', 'Speed Dribbler (AI)']


CREATE TABLE players (
  "int_player_id" BIGINT,
  "str_player_name" VARCHAR,
  "str_positions" VARCHAR,
  "dt_date_of_birth" TIMESTAMP,
  "int_height" BIGINT,
  "int_weight" BIGINT,
  "int_overall_rating" BIGINT,
  "int_potential_rating" BIGINT,
  "str_best_position" VARCHAR,
  "int_best_overall_rating" BIGINT,
  "int_value" BIGINT,
  "int_wage" BIGINT,
  "int_team_id" DOUBLE,
  "str_nationality" VARCHAR,
  "int_crossing" BIGINT,
  "int_finishing" BIGINT,
  "int_heading_accuracy" BIGINT,
  "int_short_passing" BIGINT,
  "int_volleys" BIGINT,
  "int_defensive_awareness" BIGINT,
  "int_standing_tackle" BIGINT,
  "int_sliding_tackle" BIGINT,
  "int_diving" BIGINT,
  "int_handling" BIGINT,
  "int_kicking" BIGINT,
  "int_gk_positioning" BIGINT,
  "int_reflexes" BIGINT,
  "int_aggression" BIGINT,
  "int_interceptions" BIGINT,
  "int_positioning" BIGINT,
  "int_vision" BIGINT,
  "int_penalties" BIGINT,
  "int_composure" BIGINT,
  "int_acceleration" BIGINT,
  "int_sprint_speed" BIGINT,
  "int_agility" BIGINT,
  "int_reactions" BIGINT,
  "int_balance" BIGINT,
  "int_shot_power" BIGINT,
  "int_jumping" BIGINT,
  "int_stamina" BIGINT,
  "int_strength" BIGINT,
  "int_long_shots" BIGINT,
  "str_preferred_foot" VARCHAR,
  "int_weak_foot" BIGINT,
  "int_skill_moves" BIGINT,
  "int_international_reputations" BIGINT,
  "str_work_rate" VARCHAR,
  "str_body_type" VARCHAR,
  "int_dribbling" BIGINT,
  "int_curve" BIGINT,
  "int_fk_accuracy" BIGINT,
  "int_long_passing" BIGINT,
  "int_ball_control" BIGINT,
  "str_player_speciality" VARCHAR,
  "str_trait" VARCHAR
);