Dataset: Champions League Era Stats

About this Dataset

Champions League Era Stats

Version-info

This data includes statistics up to the final of the 2022/23 season.

Context

The UEFA Champions League (abbreviated as UCL) is an annual club football competition organized by the Union of European Football Associations (UEFA) and contested by top-division European clubs, deciding the competition winners through a group and knockout format. It is one of the most prestigious football tournaments in the world and the most prestigious club competition in European football, played by the national league champions (and, for some nations, one or more runners-up) of their national associations. (*** From wikipidea)

Note: This doesn't have any information about the European cup competition (1950-1992). It starts with the beginning of the Champions league (1992/93) season.

Content

So far this data has the following:
1- Each club's participation record in the competition
2- Each country's clubs participation records in the competition (summary of #1)
3- Top Player Appearances by club (i.e. number of times played for a club in the competition)
4- Top Player Appearances Total games (summary of #3)
5- Top Goal scorer by club (i.e. number of goals scored by a player for a club in the competition)
6- Top Goal scorer Totals (summary of #5)
7- Top Coach Appearances by club (i.e. number of times coached for a club in the competition)
8- Top Coach Appearances Total games (summary of #7)
9- Top Goal Scorer for each season in the competition with # of appearances
10- Number of goals scored per round per group in each season

Acknowledgements

All this data was provided by UEFA.com. All I did was download the PDF and then scrape the data and put it in csv format.

Tables

Alltimerankingbycountry

@kaggle.basharalkuwaiti_champions_league_era_stats.alltimerankingbycountry

11.37 KB
54 rows
12 columns


CREATE TABLE alltimerankingbycountry (
  "unnamed_0" BIGINT,
  "country" VARCHAR,
  "participated" BIGINT,
  "titles" BIGINT,
  "played" BIGINT,
  "win" BIGINT,
  "draw" BIGINT,
  "loss" BIGINT,
  "goals_for" BIGINT,
  "goals_against" BIGINT,
  "pts" BIGINT,
  "goal_diff" BIGINT
);

Coachesappeardetails

@kaggle.basharalkuwaiti_champions_league_era_stats.coachesappeardetails

5.13 KB
81 rows
4 columns


CREATE TABLE coachesappeardetails (
  "unnamed_0" BIGINT,
  "coach" VARCHAR,
  "club" VARCHAR,
  "appearance" BIGINT
);

Coachesappeartotals

@kaggle.basharalkuwaiti_champions_league_era_stats.coachesappeartotals

3.49 KB
26 rows
3 columns


CREATE TABLE coachesappeartotals (
  "unnamed_0" BIGINT,
  "coach" VARCHAR,
  "appearance" BIGINT
);

Goalstatspergroupround

@kaggle.basharalkuwaiti_champions_league_era_stats.goalstatspergroupround

11.52 KB
35 rows
17 columns


CREATE TABLE goalstatspergroupround (
  "unnamed_0" BIGINT,
  "season" VARCHAR,
  "games" VARCHAR,
  "gls" VARCHAR,
  "av" VARCHAR,
  "a" BIGINT,
  "b" BIGINT,
  "c" VARCHAR,
  "d" VARCHAR,
  "e" VARCHAR,
  "f" VARCHAR,
  "g" VARCHAR,
  "h" VARCHAR,
  "r16" VARCHAR,
  "qf" VARCHAR,
  "sf" VARCHAR,
  "final" VARCHAR
);

Playerappeardetails

@kaggle.basharalkuwaiti_champions_league_era_stats.playerappeardetails

13.14 KB
608 rows
4 columns


CREATE TABLE playerappeardetails (
  "unnamed_0" BIGINT,
  "player" VARCHAR,
  "club" VARCHAR,
  "appearances" BIGINT
);

Playerappeartotals

@kaggle.basharalkuwaiti_champions_league_era_stats.playerappeartotals

8.19 KB
247 rows
3 columns


CREATE TABLE playerappeartotals (
  "unnamed_0" BIGINT,
  "player" VARCHAR,
  "appearances" BIGINT
);

Playergoaldetails

@kaggle.basharalkuwaiti_champions_league_era_stats.playergoaldetails

7.64 KB
234 rows
4 columns


CREATE TABLE playergoaldetails (
  "unnamed_0" BIGINT,
  "player" VARCHAR,
  "club" VARCHAR,
  "goals" BIGINT
);

Playergoaltotals

@kaggle.basharalkuwaiti_champions_league_era_stats.playergoaltotals

5.19 KB
109 rows
3 columns


CREATE TABLE playergoaltotals (
  "unnamed_0" BIGINT,
  "player" VARCHAR,
  "goals" BIGINT
);

Topgoalscorer

@kaggle.basharalkuwaiti_champions_league_era_stats.topgoalscorer

6.67 KB
180 rows
7 columns


CREATE TABLE topgoalscorer (
  "unnamed_0" BIGINT,
  "year" VARCHAR,
  "player" VARCHAR,
  "club" VARCHAR,
  "goals" VARCHAR,
  "appearances" VARCHAR,
  "n_0" VARCHAR
);