Dataset: European Football Market Dataset

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

119.83 KB
5962 rows
12 columns


CREATE TABLE capital_gains (
  "unnamed_0" BIGINT,
  "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

213.87 KB
257 rows
76 columns


CREATE TABLE champ_performances_with_metrics (
  "team_id" BIGINT,
  "team_name" VARCHAR,
  "n_09_10" VARCHAR,
  "n_10_11" VARCHAR,
  "n_11_12" VARCHAR,
  "n_12_13" VARCHAR,
  "n_13_14" VARCHAR,
  "n_14_15" VARCHAR,
  "n_15_16" VARCHAR,
  "n_16_17" VARCHAR,
  "n_17_18" VARCHAR,
  "n_18_19" VARCHAR,
  "n_19_20" VARCHAR,
  "n_20_21" VARCHAR,
  "n_21_22" VARCHAR,
  "n_22_23" VARCHAR,
  "n_23_24" VARCHAR,
  "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

842.29 KB
26867 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
);