La Liga Stats 2021-2022

Player stats from La Liga (spanish football league) - Season 2021-2022

@kaggle.sdelquin_laliga_data

Table List

1 table(498.44 KB)

S2122 Laliga Players

@kaggle.sdelquin_laliga_data.s2122_laliga_players

498.44 KB
1994 rows
150 columns
Only the first 100 columns are shown

competition Competition	player_url Player.url	id Id	slug Slug	name Name	nickname Nickname	firstname Firstname	lastname Lastname	gender Gender	date_of_birth Date Of Birth	place_of_birth Place Of Birth	weight Weight	height Height	international International	twitter Twitter	instagram Instagram	country Country	team Team	team_shortname Team.shortname	team_foundation Team.foundation	team_shield Team.shield	shirt_number Shirt Number	position Position	photo Photo	stadium Stadium	stadium_image Stadium.image	aerial_duels Aerial Duels	aerial_duels_lost Aerial Duels Lost	aerial_duels_won Aerial Duels Won	appearances Appearances	assists_intentional Assists Intentional	attempts_from_set_pieces Attempts From Set Pieces	away_goals Away Goals	backward_passes Backward Passes	blocked_shots Blocked Shots	blocks Blocks	catches Catches	clean_sheets Clean Sheets	corners_taken_incl_short_corners Corners Taken Incl Short Corners	corners_won Corners Won	duels Duels	duels_lost Duels Lost	duels_won Duels Won	fifty_fifty Fifty Fifty	forward_passes Forward Passes	foul_attempted_tackle Foul Attempted Tackle	foul_won_penalty Foul Won Penalty	games_played Games Played	gk_successful_distribution Gk Successful Distribution	gk_unsuccessful_distribution Gk Unsuccessful Distribution	goal_assists Goal Assists	goals Goals	goals_conceded Goals Conceded	goals_conceded_inside_box Goals Conceded Inside Box	goals_conceded_outside_box Goals Conceded Outside Box	goals_from_inside_box Goals From Inside Box	goals_from_outside_box Goals From Outside Box	ground_duels Ground Duels	ground_duels_lost Ground Duels Lost	ground_duels_won Ground Duels Won	handballs_conceded Handballs Conceded	hit_woodwork Hit Woodwork	home_goals Home Goals	index Index	interceptions Interceptions	key_passes_attempt_assists Key Passes Attempt Assists	left_foot_goals Left Foot Goals	leftside_passes Leftside Passes	offsides Offsides	open_play_passes Open Play Passes	own_goal_scored Own Goal Scored	penalties_faced Penalties Faced	penalties_taken Penalties Taken	penalty_goals Penalty Goals	penalty_goals_conceded Penalty Goals Conceded	punches Punches	putthrough_blocked_distribution Putthrough Blocked Distribution	putthrough_blocked_distribution_won Putthrough Blocked Distribution Won	recoveries Recoveries	right_foot_goals Right Foot Goals	rightside_passes Rightside Passes	saves_made Saves Made	saves_made_caught Saves Made Caught	saves_made_from_inside_box Saves Made From Inside Box	saves_made_from_outside_box Saves Made From Outside Box	saves_made_parried Saves Made Parried	second_goal_assists Second Goal Assists
LaLiga Santander	https://www.laliga.com/en-ES/player/aaron	1307	aaron	Aarón Escandell	Aarón	Aarón	Escandell	male	1995-09-27T00:00:00+00:00	Carcagente	71	185		https://twitter.com/pipa_aaron	https://instagram.com/_aaronescandell/	ES	Granada CF	GRA	1931-01-01T00:00:00+0000	https://assets.laliga.com/assets/2019/06/07/medium/granada.png	13	Goalkeeper	https://assets.laliga.com/squad/2021/t5683/p176278/512x556/p176278_t5683_2021_1_001_000.png	Nuevo Los Cármenes	https://assets.laliga.com/assets/2019/08/07/medium/4de53714b029bf44d86c53bd0d6835d3.png				4							3	1			2	1	1	1	99			4	34	16			6	6				2	1	1				50				6		45		2			2	1			38		10	10	1	5	5	1
LaLiga Santander	https://www.laliga.com/en-ES/player/abqar	8715	abqar	Abdelkabir Abqar	Abqar	Abdelkabir	Abqar	male	1999-03-10T00:00:00+00:00	Settat	80	188		nan	nan	MA	Deportivo Alavés	ALA	1921-01-23T00:00:00+0000	https://assets.laliga.com/assets/2020/09/01/medium/27002754a98bf535807fe49a24cc63ea.png	26	Defender	https://assets.laliga.com/squad/2021/t173/p463001/512x556/p463001_t173_2021_1_001_000.png	Mendizorroza	https://assets.laliga.com/assets/2019/06/17/medium/6b906780ba96aa6689192fb9afcaac6b.png
LaLiga Santander	https://www.laliga.com/en-ES/player/abdessamad-ezzalzouli	13770	abdessamad-ezzalzouli	Abdessamad Ezzalzouli	Abde	Abdessamad	Ezzalzouli	male	2001-12-17T00:00:00+00:00	Beni Melal				nan	nan	MA	FC Barcelona	BAR	1899-11-29T00:00:00+0000	https://assets.laliga.com/assets/2019/06/07/medium/barcelona.png	33	Forward	nan	Camp Nou	https://assets.laliga.com/assets/2019/06/17/medium/0623ce55ec3ee4e439ed6d24fe2ba77b.png	10	7	3	10			1	70	6				1	12	130	61	69	16	14	7		10				1	8	6	2	1		120	54	66	2	1		35	9	6		38	2	167							11	3	29	1	46
LaLiga Santander	https://www.laliga.com/en-ES/player/abdon	200	abdon	Abdón Prats	Abdon	Abdón	Prats	male	1992-12-07T00:00:00+00:00	Artá	81	181		nan	nan	ES	RCD Mallorca	MLL	1916-03-06T00:00:00+0000	https://assets.laliga.com/assets/2019/06/07/medium/mallorca.png	9	Forward	https://assets.laliga.com/squad/2021/t181/p92187/512x556/p92187_t181_2021_1_001_000.png	Visit Mallorca Estadi	https://assets.laliga.com/assets/2019/08/07/medium/6f67f604b5025b10ef0dc14d700586ae.png	62	31	31	23		2	1	41	4					2	121	66	55	12	45	4		23				3	14	13	1	3		59	35	24	1	2	2	22	1	10	3	35	2	137					1		10	5	21		33
LaLiga Santander	https://www.laliga.com/en-ES/player/adama	536	adama	Adama Traoré	Adama	Adama	Traoré	male	1996-01-25T00:00:00+00:00	L'Hospitalet de Llobregat	86	178		nan	nan	ES	FC Barcelona	BAR	1899-11-29T00:00:00+0000	https://assets.laliga.com/assets/2019/06/07/medium/barcelona.png	11	Forward	https://assets.laliga.com/squad/2021/t178/p159533/512x556/p159533_t178_2021_1_001_000.png	Camp Nou	https://assets.laliga.com/assets/2019/06/17/medium/0623ce55ec3ee4e439ed6d24fe2ba77b.png	7	2	5	11	2			54	2					6	66	26	40	11	20	1		11			2		7	6	1			59	24	35	1			87	4	5		47	2	128							8	2	20		7
LaLiga Santander	https://www.laliga.com/en-ES/player/januzaj	3314	januzaj	Adnan Januzaj	Januzaj	Adnan	Januzaj	male	1995-02-05T00:00:00+00:00	Brussels	76	186		nan	nan	BE	Real Sociedad	RSO	1909-09-07T00:00:00+0000	https://assets.laliga.com/assets/2019/06/07/medium/real-sociedad.png	11	Midfielder	https://assets.laliga.com/squad/2021/t188/p154976/512x556/p154976_t188_2021_1_001_000.png	Reale Arena	https://assets.laliga.com/assets/2019/10/03/medium/b20727f80d7b4c9d5ad18acec9b663c5.png	29	19	10	33		9	2	135	17	3			82	19	259	135	124	49	155	9	1	33				3	14	14		3		230	116	114	4	1	1	56	12	34	2	184	4	554			2	2	3		39	12	93	1	113
LaLiga Santander	https://www.laliga.com/en-ES/player/pedrosa-1	9223	pedrosa-1	Adrià Pedrosa	Pedrosa	Adrià	Pedrosa	male	1998-05-13T00:00:00+00:00	Barcelona	69	176		nan	nan	ES	RCD Espanyol de Barcelona	ESP	1900-10-23T00:00:00+0000	https://assets.laliga.com/assets/2019/06/07/medium/espanyol.png	3	Defender	https://assets.laliga.com/squad/2021/t177/p446990/512x556/p446990_t177_2021_1_001_000.png	RCDE Stadium	https://assets.laliga.com/assets/2019/06/17/medium/306cc02af120e092849ddf38954bcb3e.png	37	20	17	31	1			171	7	7		8	1	31	298	130	168	55	357	13		31			1	1	40	39	1		1	261	110	151			1	48	25	22	1	61		909	1				3		55	18	163		344
LaLiga Santander	https://www.laliga.com/en-ES/player/butzke	14400	butzke	Adrián Butzke	A. Butzke	Adrián	Butzke	male	1999-03-30T00:00:00+00:00	Monachil	72	193		nan	nan	ES	nan	nan	nan	nan		nan	nan	nan	nan
LaLiga Santander	https://www.laliga.com/en-ES/player/de-la-fuente	9395	de-la-fuente	Adrián De la Fuente	De La Fuente	Adrián	De la Fuente	male	1999-02-26T00:00:00+00:00	El Escorial	77	179		nan	nan	ES	Villarreal CF	VIL	1923-03-10T00:00:00+0000	https://assets.laliga.com/assets/2019/06/07/medium/villarreal.png	27	Defender	nan	Estadio de la Cerámica	https://assets.laliga.com/assets/2019/10/03/medium/ac940b8f6681d614e337d20d5bf7f0a8.png
LaLiga Santander	https://www.laliga.com/en-ES/player/embarba	1092	embarba	Adrián Embarba	Embarba	Adrián	Embarba	male	1992-05-07T00:00:00+00:00	Madrid	66	173	true	https://twitter.com/Adri_e7	nan	ES	RCD Espanyol de Barcelona	ESP	1900-10-23T00:00:00+0000	https://assets.laliga.com/assets/2019/06/07/medium/espanyol.png	23	Forward	https://assets.laliga.com/squad/2021/t177/p132161/512x556/p132161_t177_2021_1_001_000.png	RCDE Stadium	https://assets.laliga.com/assets/2019/06/17/medium/306cc02af120e092849ddf38954bcb3e.png	48	31	17	32	2	15		158	13	3		3	109	37	324	179	145	69	161	19		32			2		23	22	1			276	148	128	2	2		36	19	35		139	7	534					1		52	32	108		118						1


CREATE TABLE s2122_laliga_players (
  "competition" VARCHAR,
  "player_url" VARCHAR,
  "id" BIGINT,
  "slug" VARCHAR,
  "name" VARCHAR,
  "nickname" VARCHAR,
  "firstname" VARCHAR,
  "lastname" VARCHAR,
  "gender" VARCHAR,
  "date_of_birth" VARCHAR,
  "place_of_birth" VARCHAR,
  "weight" DOUBLE,
  "height" DOUBLE,
  "international" BOOLEAN,
  "twitter" VARCHAR,
  "instagram" VARCHAR,
  "country" VARCHAR,
  "team" VARCHAR,
  "team_shortname" VARCHAR,
  "team_foundation" VARCHAR,
  "team_shield" VARCHAR,
  "shirt_number" DOUBLE,
  "position" VARCHAR,
  "photo" VARCHAR,
  "stadium" VARCHAR,
  "stadium_image" VARCHAR,
  "aerial_duels" DOUBLE,
  "aerial_duels_lost" DOUBLE,
  "aerial_duels_won" DOUBLE,
  "appearances" DOUBLE,
  "assists_intentional" DOUBLE,
  "attempts_from_set_pieces" DOUBLE,
  "away_goals" DOUBLE,
  "backward_passes" DOUBLE,
  "blocked_shots" DOUBLE,
  "blocks" DOUBLE,
  "catches" DOUBLE,
  "clean_sheets" DOUBLE,
  "clearances_off_the_line" DOUBLE,
  "corners_taken_incl_short_corners" DOUBLE,
  "corners_won" DOUBLE,
  "crosses_not_claimed" DOUBLE,
  "drops" DOUBLE,
  "duels" DOUBLE,
  "duels_lost" DOUBLE,
  "duels_won" DOUBLE,
  "fifty_fifty" DOUBLE,
  "forward_passes" DOUBLE,
  "foul_attempted_tackle" DOUBLE,
  "foul_won_penalty" DOUBLE,
  "games_played" DOUBLE,
  "gk_successful_distribution" DOUBLE,
  "gk_unsuccessful_distribution" DOUBLE,
  "goal_assists" DOUBLE,
  "goalkeeper_smother" DOUBLE,
  "goals" DOUBLE,
  "goals_conceded" DOUBLE,
  "goals_conceded_inside_box" DOUBLE,
  "goals_conceded_outside_box" DOUBLE,
  "goals_from_inside_box" DOUBLE,
  "goals_from_outside_box" DOUBLE,
  "ground_duels" DOUBLE,
  "ground_duels_lost" DOUBLE,
  "ground_duels_won" DOUBLE,
  "handballs_conceded" DOUBLE,
  "headed_goals" DOUBLE,
  "hit_woodwork" DOUBLE,
  "home_goals" DOUBLE,
  "index" DOUBLE,
  "interceptions" DOUBLE,
  "key_passes_attempt_assists" DOUBLE,
  "last_man_tackle" DOUBLE,
  "left_foot_goals" DOUBLE,
  "leftside_passes" DOUBLE,
  "offsides" DOUBLE,
  "open_play_passes" DOUBLE,
  "other_goals" DOUBLE,
  "own_goal_scored" DOUBLE,
  "penalties_conceded" DOUBLE,
  "penalties_faced" DOUBLE,
  "penalties_off_target" DOUBLE,
  "penalties_saved" DOUBLE,
  "penalties_taken" DOUBLE,
  "penalty_goals" DOUBLE,
  "penalty_goals_conceded" DOUBLE,
  "punches" DOUBLE,
  "putthrough_blocked_distribution" DOUBLE,
  "putthrough_blocked_distribution_won" DOUBLE,
  "recoveries" DOUBLE,
  "red_cards_2nd_yellow" DOUBLE,
  "right_foot_goals" DOUBLE,
  "rightside_passes" DOUBLE,
  "saves_from_penalty" DOUBLE,
  "saves_made" DOUBLE,
  "saves_made_caught" DOUBLE,
  "saves_made_from_inside_box" DOUBLE,
  "saves_made_from_outside_box" DOUBLE,
  "saves_made_parried" DOUBLE,
  "second_goal_assists" DOUBLE,
  "set_pieces_goals" DOUBLE
);