Name: European Football Market Dataset
Creator: Kaggle
License: https://opensource.org/licenses/MIT

About this Dataset

European Football Market Dataset

We provide a collection of 4 datasets in csv format containing information about the football market transactions from 2009 summer session to 2024 winter session. All data have been collected from transfermarkt.

For many details about the scraping techniques and the usages, check this repositorty.

Tables

Capital Gains

@kaggle.firefly55lm_european_football_market_dataset.capital_gains

122.7 kB
5,962 rows
12 columns

CREATE TABLE capital_gains (
  "unnamed_0" BIGINT  -- Unnamed: 0,
  "team_name" VARCHAR,
  "player_id" BIGINT,
  "transfer_fee_amnt" DOUBLE,
  "season_left" BIGINT,
  "season_ord_left" DOUBLE,
  "window_left" VARCHAR,
  "arrival_fee_amnt" DOUBLE,
  "season_in" DOUBLE,
  "season_ord_in" DOUBLE,
  "window_in" VARCHAR,
  "gain" DOUBLE
);

Champ Performances With Metrics

@kaggle.firefly55lm_european_football_market_dataset.champ_performances_with_metrics

219 kB
257 rows
76 columns

CREATE TABLE champ_performances_with_metrics (
  "team_id" BIGINT,
  "team_name" VARCHAR,
  "n_09_10" VARCHAR  -- 09/10,
  "n_10_11" VARCHAR  -- 10/11,
  "n_11_12" VARCHAR  -- 11/12,
  "n_12_13" VARCHAR  -- 12/13,
  "n_13_14" VARCHAR  -- 13/14,
  "n_14_15" VARCHAR  -- 14/15,
  "n_15_16" VARCHAR  -- 15/16,
  "n_16_17" VARCHAR  -- 16/17,
  "n_17_18" VARCHAR  -- 17/18,
  "n_18_19" VARCHAR  -- 18/19,
  "n_19_20" VARCHAR  -- 19/20,
  "n_20_21" VARCHAR  -- 20/21,
  "n_21_22" VARCHAR  -- 21/22,
  "n_22_23" VARCHAR  -- 22/23,
  "n_23_24" VARCHAR  -- 23/24,
  "performance_09_10" DOUBLE,
  "performance_10_11" DOUBLE,
  "performance_11_12" DOUBLE,
  "performance_12_13" DOUBLE,
  "performance_13_14" DOUBLE,
  "performance_14_15" DOUBLE,
  "performance_15_16" DOUBLE,
  "performance_16_17" DOUBLE,
  "performance_17_18" DOUBLE,
  "performance_18_19" DOUBLE,
  "performance_19_20" DOUBLE,
  "performance_20_21" DOUBLE,
  "performance_21_22" DOUBLE,
  "performance_22_23" DOUBLE,
  "performance_23_24" DOUBLE,
  "gain_09_10" DOUBLE,
  "tier_09_10" BIGINT,
  "gain_10_11" DOUBLE,
  "tier_10_11" BIGINT,
  "gain_11_12" DOUBLE,
  "tier_11_12" BIGINT,
  "gain_12_13" DOUBLE,
  "tier_12_13" BIGINT,
  "gain_13_14" DOUBLE,
  "tier_13_14" BIGINT,
  "gain_14_15" DOUBLE,
  "tier_14_15" BIGINT,
  "gain_15_16" DOUBLE,
  "tier_15_16" BIGINT,
  "gain_16_17" DOUBLE,
  "tier_16_17" BIGINT,
  "gain_17_18" DOUBLE,
  "tier_17_18" BIGINT,
  "gain_18_19" DOUBLE,
  "tier_18_19" BIGINT,
  "gain_19_20" DOUBLE,
  "tier_19_20" BIGINT,
  "gain_20_21" DOUBLE,
  "tier_20_21" BIGINT,
  "gain_21_22" DOUBLE,
  "tier_21_22" BIGINT,
  "gain_22_23" DOUBLE,
  "tier_22_23" BIGINT,
  "gain_23_24" DOUBLE,
  "tier_23_24" BIGINT,
  "jump_09_10" BIGINT,
  "jump_10_11" BIGINT,
  "jump_11_12" BIGINT,
  "jump_12_13" BIGINT,
  "jump_13_14" BIGINT,
  "jump_14_15" BIGINT,
  "jump_15_16" BIGINT,
  "jump_16_17" BIGINT,
  "jump_17_18" BIGINT,
  "jump_18_19" BIGINT,
  "jump_19_20" BIGINT,
  "jump_20_21" BIGINT,
  "jump_21_22" BIGINT,
  "jump_22_23" BIGINT
);

Transfers With Agents

@kaggle.firefly55lm_european_football_market_dataset.transfers_with_agents

862.5 kB
26,867 rows
24 columns

CREATE TABLE transfers_with_agents (
  "league" VARCHAR,
  "season" BIGINT,
  "window" VARCHAR,
  "team_id" BIGINT,
  "team_name" VARCHAR,
  "team_country" VARCHAR,
  "dir" VARCHAR,
  "player_id" BIGINT,
  "player_name" VARCHAR,
  "player_age" DOUBLE,
  "player_nation" VARCHAR,
  "player_nation2" VARCHAR,
  "player_pos" VARCHAR,
  "counter_team_id" VARCHAR,
  "counter_team_name" VARCHAR,
  "counter_team_country" VARCHAR,
  "transfer_fee_amnt" DOUBLE,
  "market_val_amnt" DOUBLE,
  "is_free" BOOLEAN,
  "is_loan" BOOLEAN,
  "is_loan_end" BOOLEAN,
  "is_retired" BOOLEAN,
  "transfer_id" BIGINT,
  "agent" VARCHAR
);