La Liga Stats 2022-2023

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

@kaggle.sdelquin_laliga_data2

Table List

1 table(208.26 KB)

S2223 Laliga Players

@kaggle.sdelquin_laliga_data2.s2223_laliga_players

208.26 KB
1957 rows
26 columns

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
Primera División	https://www.laliga.com/en-ES/player/abdellah-raihani	32823	abdellah-raihani	Abde Raihani	Abde	Abde	Raihani	male	2004-02-03T00:00:00+00:00	Barcelona				nan	nan	MA	Atlético de Madrid	ATM	1903-04-26T00:00:00+0000	https://assets.laliga.com/assets/2019/06/07/medium/atletico.png	34	Forward	nan	Civitas Metropolitano	https://assets.laliga.com/assets/2019/06/17/medium/935f92c15c4d3442ef3f6d843beba0e1.png
Primera División	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	72	177		nan	nan	MA	CA Osasuna	OSA	1920-11-17T00:00:00+0000	https://assets.laliga.com/assets/2019/06/07/medium/osasuna.png	12	Forward	https://assets.laliga.com/squad/2023/t450/p500745/512x556/p500745_t450_2023_0_001_000.png	Estadio El Sadar	https://assets.laliga.com/assets/2021/01/20/medium/c1b35f03ff875a4a12c7dcbd477d964a.png
Primera División	https://www.laliga.com/en-ES/player/abdul-mumin	27064	abdul-mumin	Abdul Mumin	A. Mumin	Abdul	Mumin	male	1998-06-06T00:00:00+00:00	nan	79	188		nan	nan	GH	Rayo Vallecano	RAY	1924-05-20T00:00:00+0000	https://assets.laliga.com/assets/2023/04/27/medium/57d9950a8745ead226c04d37235c0786.png	16	Defender	https://assets.laliga.com/squad/2023/t184/p232016/512x556/p232016_t184_2023_0_001_000.png	Estadio de Vallecas	https://assets.laliga.com/assets/2019/08/12/medium/b86a37d70be8931c079066cc8c48817f.png
Primera División	https://www.laliga.com/en-ES/player/abdon	200	abdon	Abdón Prats	Abdón	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/2023/03/22/medium/013ae97735bc8e519dcf30f6826168ca.png	9	Forward	https://assets.laliga.com/squad/2023/t181/p92187/512x556/p92187_t181_2023_0_001_000.png	Estadi Mallorca Son Moix	https://assets.laliga.com/assets/2019/08/07/medium/6f67f604b5025b10ef0dc14d700586ae.png
Primera División	https://www.laliga.com/en-ES/player/abner	32224	abner	Abner Vinícius da Silva Santos	Abner	Abner Vinícius	da Silva Santos	male	2000-05-27T00:00:00+00:00	nan	75	182		nan	nan	BR	Real Betis	BET	1907-09-12T00:00:00+0000	https://assets.laliga.com/assets/2022/09/15/medium/e4a09419d3bd115b8f3dab73d480e146.png	20	Defender	nan	Estadio Benito Villamarín	https://assets.laliga.com/assets/2019/06/17/medium/f211dabccff68741a75d175307d78f59.png
Primera División	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	nan	nan	nan	nan		nan	nan	nan	nan
Primera División	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	nan	RCDE Stadium	https://assets.laliga.com/assets/2019/06/17/medium/306cc02af120e092849ddf38954bcb3e.png
Primera División	https://www.laliga.com/en-ES/player/a-corral	16960	a-corral	Adrián Corral Alciturri	A.corral	Adrián	Corral Alciturri	male	2003-01-05T00:00:00+00:00	Santander		183		nan	nan	ES	Atlético de Madrid	ATM	1903-04-26T00:00:00+0000	https://assets.laliga.com/assets/2019/06/07/medium/atletico.png	48	Defender	nan	Civitas Metropolitano	https://assets.laliga.com/assets/2019/06/17/medium/935f92c15c4d3442ef3f6d843beba0e1.png
Primera División	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	UD Almería	ALM	1989-07-17T00:00:00+0000	https://assets.laliga.com/assets/2019/06/07/medium/almeria.png	10	Forward	https://assets.laliga.com/squad/2023/t1564/p132161/512x556/p132161_t1564_2023_0_001_000.png	Power Horse Stadium	https://assets.laliga.com/assets/2019/08/12/medium/4b6ebed43e0c33b78228581b6eed6824.png
Primera División	https://www.laliga.com/en-ES/player/agustin-marchesin	7627	agustin-marchesin	Agustín Marchesín	Marchesin	Agustín	Marchesín	male	1988-03-16T00:00:00+00:00	San Cayetano	82	188	true	nan	nan	AR	RC Celta	CEL	1923-08-23T00:00:00+0000	https://assets.laliga.com/assets/2019/06/07/medium/celta.png	1	Goalkeeper	https://assets.laliga.com/squad/2023/t176/p59891/512x556/p59891_t176_2023_0_001_000.png	Estadio ABANCA Balaídos	https://assets.laliga.com/assets/2019/06/17/medium/0aef263ef366bd0b81369408adb27cd6.png


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