UEFA Champions League Quarter Finals Since 1980

Dataset on teams that have played the UEFA Champions League quarters since 1980

@kaggle.johnharshith_uefa_champions_league_quarter_finals_since_1980

Table List

1 table(19.29 KB)

Uclquarterfinals

@kaggle.johnharshith_uefa_champions_league_quarter_finals_since_1980.uclquarterfinals

19.29 KB
328 rows
18 columns

year Year	code Code	name Name	round Round	league League	region Region	decade Decade	superliga Superliga	city City	areacode Areacode	metropol Metropol	pop Pop	gdp Gdp	country Country	eurostat Eurostat	ecb Ecb	cowc Cowc	cown Cown
1981	LIV	Liverpool FC	W	England	Big 5	1980s	Yes	Liverpool	UK006	Liverpool	1533860	50484	United Kingdom	UK	GB	UKG	200
1981	MAD	Real Madrid CF	RU	Spain	Big 5	1980s	Yes	Madrid	ES001	Madrid	6791667	342534	Spain	ES	ES	SPN	230
1981	BMN	FC Bayern	SF	Germany	Big 5	1980s	No	München	DE003	Munich	2883373	241407	Germany	DE	DE	GMY	255
1981	INT	FC Inter Milan	SF	Italy	Big 5	1980s	Yes	Milano	IT002	Milan	5145657	301366	Italy	IT	IT	ITA	325
1981	BEL	Red Star	QF	Serbia	East	1980s	No	Belgrade	Belgrade	nan			nan	nan	nan	nan
1981	SPA	Spartak Moscow	QF	Russia	East	1980s	No	Moscow	RU001	Moscow	12506468	284400	Russia	RU	RU	RUS	365
1981	OST	Baník Ostrava	QF	Czechia	East	1980s	No	Ostrava	CZ003	Ostrava	719777	22067	Czechia	CZ	CZ	CZR	316
1981	SOF	CSKA Sofia	QF	Bulgaria	East	1980s	No	Sofia	BG001	nan			Bulgaria	BG	BG	BUL	355
1982	AST	Aston Villa FC	W	England	Big 5	1980s	No	Birmingham	UK002	West Midlands urban area	3097965	112240	United Kingdom	UK	GB	UKG	200
1982	BMN	FC Bayern	RU	Germany	Big 5	1980s	No	München	DE003	Munich	2883373	241407	Germany	DE	DE	GMY	255


CREATE TABLE uclquarterfinals (
  "year" BIGINT,
  "code" VARCHAR,
  "name" VARCHAR,
  "round" VARCHAR,
  "league" VARCHAR,
  "region" VARCHAR,
  "decade" VARCHAR,
  "superliga" VARCHAR,
  "city" VARCHAR,
  "areacode" VARCHAR,
  "metropol" VARCHAR,
  "pop" DOUBLE,
  "gdp" DOUBLE,
  "country" VARCHAR,
  "eurostat" VARCHAR,
  "ecb" VARCHAR,
  "cowc" VARCHAR,
  "cown" DOUBLE
);