Baselight
Sign In

Football Data From Transfermarkt

Football (Soccer) data scraped from Transfermarkt website

@kaggle.davidcariboo_player_scores

Clubs
@kaggle.davidcariboo_player_scores.clubs

  • 55.22 KB
  • 439 rows
  • 17 columns
club_id

Club Id

club_code

Club Code

name

Name

domestic_competition_id

Domestic Competition Id

total_market_value

Total Market Value

squad_size

Squad Size

average_age

Average Age

foreigners_number

Foreigners Number

foreigners_percentage

Foreigners Percentage

national_team_players

National Team Players

stadium_name

Stadium Name

stadium_seats

Stadium Seats

net_transfer_record

Net Transfer Record

coach_name

Coach Name

last_season

Last Season

filename

Filename

url

Url

105sv-darmstadt-98SV Darmstadt 98L12725.61348.11Merck-Stadion am Böllenfalltor17810+€3.05m2023../data/raw/transfermarkt-scraper/2023/clubs.json.gzhttps://www.transfermarkt.co.uk/sv-darmstadt-98/startseite/verein/105
11127ural-ekaterinburgUral YekaterinburgRU13026.51136.73Yekaterinburg Arena23000+€880k2023../data/raw/transfermarkt-scraper/2023/clubs.json.gzhttps://www.transfermarkt.co.uk/ural-ekaterinburg/startseite/verein/11127
114besiktas-istanbulBeşiktaş Jimnastik KulübüTR13126.51651.67Tüpraş Stadyumu42445€-18.65m2024../data/raw/transfermarkt-scraper/2024/clubs.json.gzhttps://www.transfermarkt.co.uk/besiktas-istanbul/startseite/verein/114
12as-romAssociazione Sportiva RomaIT12526.5187218Olimpico di Roma70634€-65.60m2024../data/raw/transfermarkt-scraper/2024/clubs.json.gzhttps://www.transfermarkt.co.uk/as-rom/startseite/verein/12
148tottenham-hotspurTottenham Hotspur Football ClubGB12925.2206919Tottenham Hotspur Stadium62850€-110.05m2024../data/raw/transfermarkt-scraper/2024/clubs.json.gzhttps://www.transfermarkt.co.uk/tottenham-hotspur/startseite/verein/148
157kaa-gentKoninklijke Atletiek Associatie GentBE12925.21965.57Planet Group Arena20185+€10.18m2024../data/raw/transfermarkt-scraper/2024/clubs.json.gzhttps://www.transfermarkt.co.uk/kaa-gent/startseite/verein/157
1894hvidovre-ifHvidovre IFDK12526.43122PRO VENTILATION Arena12000+€225k2023../data/raw/transfermarkt-scraper/2023/clubs.json.gzhttps://www.transfermarkt.co.uk/hvidovre-if/startseite/verein/1894
190fc-kopenhagenFootball Club KøbenhavnDK12925.91862.19Parken38065+€37.06m2024../data/raw/transfermarkt-scraper/2024/clubs.json.gzhttps://www.transfermarkt.co.uk/fc-kopenhagen/startseite/verein/190
192roda-jc-kerkradeRoda JC KerkradeNL12524936Parkstad Limburg Stadion19979+€1.30m2017../data/raw/transfermarkt-scraper/2017/clubs.json.gzhttps://www.transfermarkt.co.uk/roda-jc-kerkrade/startseite/verein/192
19789yeni-malatyasporYeni MalatyasporTR11022.9110Yeni Malatya Stadyumu25745+€778k2021../data/raw/transfermarkt-scraper/2021/clubs.json.gzhttps://www.transfermarkt.co.uk/yeni-malatyaspor/startseite/verein/19789

CREATE TABLE clubs (
  "club_id" BIGINT,
  "club_code" VARCHAR,
  "name" VARCHAR,
  "domestic_competition_id" VARCHAR,
  "total_market_value" VARCHAR,
  "squad_size" BIGINT,
  "average_age" DOUBLE,
  "foreigners_number" BIGINT,
  "foreigners_percentage" DOUBLE,
  "national_team_players" BIGINT,
  "stadium_name" VARCHAR,
  "stadium_seats" BIGINT,
  "net_transfer_record" VARCHAR,
  "coach_name" VARCHAR,
  "last_season" BIGINT,
  "filename" VARCHAR,
  "url" VARCHAR
);

Share link

Anyone who has the link will be able to view this.