Football Summer Market 2022

Transfermarkt Scraping

@kaggle.davidmolina_football_summer_market_2022

Table List

1 table(1020.93 KB)

Summer22 Footballtransfers

@kaggle.davidmolina_football_summer_market_2022.summer22_footballtransfers

1020.93 KB
33825 rows
12 columns

name Name	position Position	age Age	origin_club Origin Club	league_origin_club League Origin Club	country_origin_club Country Origin Club	new_club New Club	league_new_club League New Club	country_new_club Country New Club	player_valuje Player Valuje	cost Cost	date_of_transfer Date Of Transfer
Amine Gouiri	Centre-Forward	22	OGC Nice	Ligue 1	France	Stade Rennais FC	Ligue 1	France	€42.00m	€28.00m	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
Umar Sadiq	Centre-Forward	25	UD Almería	LaLiga	Spain	Real Sociedad	LaLiga	Spain	€18.00m	€20.00m	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
Carlos Soler	Central Midfield	25	Valencia CF	LaLiga	Spain	Paris Saint-Germain	Ligue 1	France	€50.00m	€18.00m	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
Manuel Akanji	Centre-Back	27	Borussia Dortmund	Bundesliga	Germany	Manchester City	Premier League	England	€30.00m	€17.50m	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
Wout Faes	Centre-Back	24	Stade Reims	Ligue 1	France	Leicester City	Premier League	England	€10.00m	€17.00m	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
Leander Dendoncker	Defensive Midfield	27	Wolverhampton Wanderers	Premier League	England	Aston Villa	Premier League	England	€28.00m	€15.00m	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
Gaëtan Laborde	Centre-Forward	28	Stade Rennais FC	Ligue 1	France	OGC Nice	Ligue 1	France	€18.00m	€15.00m	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
Pierre-Emerick Aubameyang	Centre-Forward	33	FC Barcelona	LaLiga	Spain	Chelsea FC	Premier League	England	€15.00m	€12.00m	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
Jörgen Strand Larsen	Centre-Forward	22	FC Groningen	Eredivisie	Netherlands	Celta de Vigo	LaLiga	Spain	€6.00m	€11.00m	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)
Billy Gilmour	Central Midfield	21	Chelsea FC	Premier League	England	Brighton & Hove Albion	Premier League	England	€12.00m	€10.40m	Thu Sep 01 2022 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE summer22_footballtransfers (
  "name" VARCHAR,
  "position" VARCHAR,
  "age" DOUBLE,
  "origin_club" VARCHAR,
  "league_origin_club" VARCHAR,
  "country_origin_club" VARCHAR,
  "new_club" VARCHAR,
  "league_new_club" VARCHAR,
  "country_new_club" VARCHAR,
  "player_valuje" VARCHAR,
  "cost" VARCHAR,
  "date_of_transfer" TIMESTAMP
);