Football Data From Transfermarkt

Football (Soccer) data scraped from Transfermarkt website

@kaggle.davidcariboo_player_scores

Table List

10 tables(163.99 MB)

Clubs

Games

Players

Players

@kaggle.davidcariboo_player_scores.players

3.28 MB
32471 rows
23 columns

player_id Player Id	first_name First Name	last_name Last Name	name Name	last_season Last Season	current_club_id Current Club Id	player_code Player Code	country_of_birth Country Of Birth	city_of_birth City Of Birth	country_of_citizenship Country Of Citizenship	date_of_birth Date Of Birth	sub_position Sub Position	position Position	foot Foot	height_in_cm Height In Cm	contract_expiration_date Contract Expiration Date	agent_name Agent Name	image_url Image Url	url Url	current_club_domestic_competition_id Current Club Domestic Competition Id	current_club_name Current Club Name	market_value_in_eur Market Value In Eur	highest_market_value_in_eur Highest Market Value In Eur
10	Miroslav	Klose	Miroslav Klose	2015	398	miroslav-klose	Poland	Opole	Germany	Fri Jun 09 1978 00:00:00 GMT+0000 (Coordinated Universal Time)	Centre-Forward	Attack	right	184		ASBW Sport Marketing	https://img.a.transfermarkt.technology/portrait/header/10-1448468291.jpg?lm=1	https://www.transfermarkt.co.uk/miroslav-klose/profil/spieler/10	IT1	Società Sportiva Lazio S.p.A.	1000000	30000000
26	Roman	Weidenfeller	Roman Weidenfeller	2017	16	roman-weidenfeller	Germany	Diez	Germany	Wed Aug 06 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	Goalkeeper	Goalkeeper	left	190		Neubauer 13 GmbH	https://img.a.transfermarkt.technology/portrait/header/26-1502448725.jpg?lm=1	https://www.transfermarkt.co.uk/roman-weidenfeller/profil/spieler/26	L1	Borussia Dortmund	750000	8000000
65	Dimitar	Berbatov	Dimitar Berbatov	2015	1091	dimitar-berbatov	Bulgaria	Blagoevgrad	Bulgaria	Fri Jan 30 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	Centre-Forward	Attack	nan			CSKA-AS-23 Ltd.	https://img.a.transfermarkt.technology/portrait/header/65-1683670068.jpg?lm=1	https://www.transfermarkt.co.uk/dimitar-berbatov/profil/spieler/65	GR1	Panthessalonikios Athlitikos Omilos Konstantinoupoliton	1000000	34500000
77	nan	Lúcio	Lúcio	2012	506	lucio	Brazil	Brasília	Brazil	Mon May 08 1978 00:00:00 GMT+0000 (Coordinated Universal Time)	Centre-Back	Defender	nan			nan	https://img.a.transfermarkt.technology/portrait/header/77-1458201664.jpg?lm=1	https://www.transfermarkt.co.uk/lucio/profil/spieler/77	IT1	Juventus Football Club	200000	24500000
80	Tom	Starke	Tom Starke	2017	27	tom-starke	East Germany (GDR)	Freital	Germany	Wed Mar 18 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	Goalkeeper	Goalkeeper	right	194		IFM	https://img.a.transfermarkt.technology/portrait/header/80-1471439914.JPG?lm=1	https://www.transfermarkt.co.uk/tom-starke/profil/spieler/80	L1	FC Bayern München	100000	3000000
109	nan	Dedê	Dedê	2013	825	dede	Brazil	Belo Horizonte	Brazil	Tue Apr 18 1978 00:00:00 GMT+0000 (Coordinated Universal Time)	Left-Back	Defender	nan			Football Concept	https://img.a.transfermarkt.technology/portrait/header/109-1487263703.jpg?lm=1	https://www.transfermarkt.co.uk/dede/profil/spieler/109	TR1	Eskisehirspor	400000	9500000
123	Christoph	Metzelder	Christoph Metzelder	2012	33	christoph-metzelder	Germany	Haltern	Germany	Wed Nov 05 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	Centre-Back	Defender	nan			nan	https://img.a.transfermarkt.technology/portrait/header/s_123_33_2012_1.jpg?lm=1	https://www.transfermarkt.co.uk/christoph-metzelder/profil/spieler/123	L1	FC Schalke 04	1500000	9500000
132	Tomas	Rosicky	Tomas Rosicky	2015	11	tomas-rosicky	CSSR	Praha	Czech Republic	Sat Oct 04 1980 00:00:00 GMT+0000 (Coordinated Universal Time)	Attacking Midfield	Midfield	both	179		nan	https://img.a.transfermarkt.technology/portrait/header/132-1464947592.jpg?lm=1	https://www.transfermarkt.co.uk/tomas-rosicky/profil/spieler/132	GB1	Arsenal Football Club	350000	17500000
162	Marc	Ziegler	Marc Ziegler	2012	79	marc-ziegler	Germany	Blieskastel	Germany	Sun Jun 13 1976 00:00:00 GMT+0000 (Coordinated Universal Time)	Goalkeeper	Goalkeeper	right	193		nan	https://img.a.transfermarkt.technology/portrait/header/s_162_79_2012_1.jpg?lm=1	https://www.transfermarkt.co.uk/marc-ziegler/profil/spieler/162	L1	Verein für Bewegungsspiele Stuttgart 1893	200000	1250000
215	Roque	Santa Cruz	Roque Santa Cruz	2015	1084	roque-santa-cruz	Paraguay	Asunción	Paraguay	Sun Aug 16 1981 00:00:00 GMT+0000 (Coordinated Universal Time)	Centre-Forward	Attack	right	193	Sun Dec 31 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	nan	https://img.a.transfermarkt.technology/portrait/header/215-1564992591.png?lm=1	https://www.transfermarkt.co.uk/roque-santa-cruz/profil/spieler/215	ES1	Málaga CF	250000	12000000


CREATE TABLE players (
  "player_id" BIGINT,
  "first_name" VARCHAR,
  "last_name" VARCHAR,
  "name" VARCHAR,
  "last_season" BIGINT,
  "current_club_id" BIGINT,
  "player_code" VARCHAR,
  "country_of_birth" VARCHAR,
  "city_of_birth" VARCHAR,
  "country_of_citizenship" VARCHAR,
  "date_of_birth" TIMESTAMP,
  "sub_position" VARCHAR,
  "position" VARCHAR,
  "foot" VARCHAR,
  "height_in_cm" DOUBLE,
  "contract_expiration_date" TIMESTAMP,
  "agent_name" VARCHAR,
  "image_url" VARCHAR,
  "url" VARCHAR,
  "current_club_domestic_competition_id" VARCHAR,
  "current_club_name" VARCHAR,
  "market_value_in_eur" DOUBLE,
  "highest_market_value_in_eur" DOUBLE
);