Name: UCL All Seasons
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

UCL All Seasons

This dataset contains information of all the UCL Final matches along with the season wise top scorer's details scraped from Transfermarkt and Wikipedia.
The dataset has been cleaned and engineered to facilitate in-depth analysis, such as examining the correlation between top scorer's performance and club success in UCL finals or just a deep-dive into analysis of the final matches throughout the seasons.

Features:

Season: (Object) The UEFA Champions League season in which the final match took place.
Home Team: (Object) The designated home team for the final match.
FT Score: (Object) Full-time score of the final match.(includes instances of extra-time/ penalties)
Away Team: (Object) The designated away team for the final match.
Winning Team: (Object) The club that won the UEFA Champions League final.
Winners' Country: (Object) The country where the winning club is based.
Runner-up's Country: (Object) The country where the runner-up club is based.
Host Country: (Object) The country in which the UEFA Champions League final was hosted.
Finals Stadium: (Object) The stadium where the UEFA Champions League final was held.
Top Scorer: (Object) The top scorer(s) of the respective UEFA Champions League season.
Top Scorer's Club: (Object) The club for which the top scorer played during that season.
Top Scorer's Country: (Object) The country of origin of the top scorer.
Top Scorer Goals: (Int) Total number of goals scored by the top scorer(s) during the respective season.
Top Scorer's Position: (Object) The position (Centre-Forward, Midfielder etc) of the top scorer during the respective season.

Tables

Main Ucl

@kaggle.syedfathaullah_ucl_all_seasons.main_ucl

16.06 kB
69 rows
14 columns

CREATE TABLE main_ucl (
  "season" VARCHAR,
  "home_team" VARCHAR,
  "ft_score" VARCHAR,
  "away_team" VARCHAR,
  "winning_team" VARCHAR,
  "winners_country" VARCHAR,
  "runner_ups_country" VARCHAR,
  "host_country" VARCHAR,
  "finals_stadium" VARCHAR,
  "top_scorer" VARCHAR,
  "top_scorer_club" VARCHAR,
  "top_scorer_country" VARCHAR,
  "top_scorer_goals" BIGINT,
  "top_scorer_position" VARCHAR
);