Soccer Universe

Football Dataset: Insights, Structure, and Analysis Guide

@kaggle.willianoliveiragibin_soccer_universe

Table List

7 tables(33.83 MB)

Player Valuations New

Clubs New

@kaggle.willianoliveiragibin_soccer_universe.clubs_new

34.71 KB
411 rows
2 columns

club_id_club_code_name_domestic_competition_id_total_m_94fe1a60 Club Id,club Code,name,domestic Competition Id,total Market Value,squad Size,average Age,foreigners Number,foreigners Percentage,national Team Players,stadium Name,stadium Seats,net Transfer Record,coach Name,last Season,url	unnamed_1 Unnamed: 1
127,sc-paderborn-07,null,L1,,26,25.7,5,19.2,1,Home Deluxe Arena,15000,€-450k,null,2019,https://www.transfermarkt.co.uk/sc-paderborn-07/startseite/verein/127
192,roda-jc-kerkrade,null,NL1,,25,23.9,9,36.0,0,Parkstad Limburg Stadion,19979,+€1.30m,null,2017,https://www.transfermarkt.co.uk/roda-jc-kerkrade/startseite/verein/192
2239,us-cremonese,US Cremonese,IT1,,26,26.0,12,46.2,7,Giovanni Zini,16003,€-33.80m,null,2022,https://www.transfermarkt.co.uk/us-cremonese/startseite/verein/2239
2423,cd-santa-clara,CD Santa Clara,PO1,,31,25.8,20,64.5,2,Estádio de São Miguel,15000,+€5.85m,null,2022,https://www.transfermarkt.co.uk/cd-santa-clara/startseite/verein/2423
24245,umraniyespor,Ümraniyespor,TR1,,24,28.4,10,41.7,3,Ümraniye Belediyesi Şehir Stadı,3513,+-0,null,2022,https://www.transfermarkt.co.uk/umraniyespor/startseite/verein/24245
2553,kilmarnock-fc,Kilmarnock FC,SC1,,27,25.7,16,59.3,1,"BBSP Stadium, Rugby Park",18128,+-0,null,2022,https://www.transfermarkt.co.uk/kilmarnock-fc/startseite/verein/2553
26459,nk-veres-rivne,null,UKR1,,22,27.1,0,,0,Stadion Avangard (2022),10000,+€170k,null,2022,https://www.transfermarkt.co.uk/nk-veres-rivne/startseite/verein/26459
2671,pas-giannina,PAS Giannina,GR1,,31,25.4,14,45.2,0,Stadio Zosimades,7652,+€2.68m,null,2022,https://www.transfermarkt.co.uk/pas-giannina/startseite/verein/2671
2919,ac-monza,AC Monza,IT1,,30,26.8,9,30.0,4,U-Power Stadium - Brianteo,15039,€-46.48m,null,2022,https://www.transfermarkt.co.uk/ac-monza/startseite/verein/2919
3205,kayserispor,Kayserispor,TR1,,28,25.6,13,46.4,3,RHG Enertürk Enerji Stadyumu,32864,+€3.00m,null,2022,https://www.transfermarkt.co.uk/kayserispor/startseite/verein/3205


CREATE TABLE clubs_new (
  "club_id_club_code_name_domestic_competition_id_total_m_94fe1a60" VARCHAR,
  "unnamed_1" VARCHAR
);