Champions League Era Stats

UEFA Champions League satistics

@kaggle.basharalkuwaiti_champions_league_era_stats

Table List

9 tables(72.33 KB)

Alltimerankingbycountry

Coachesappeardetails

Coachesappeartotals

Goalstatspergroupround

Alltimerankingbycountry

@kaggle.basharalkuwaiti_champions_league_era_stats.alltimerankingbycountry

11.37 KB
54 rows
12 columns

unnamed_0 Unnamed: 0	country Country	participated Participated	titles Titles	played Played	win Win	draw Draw	loss Loss	goals_for Goals For	goals_against Goals Against	pts Pts	goal_diff Goal Diff
1	Spain	152	19	1379	717	313	349	2476	1492	1747	984
2	England	140	15	1278	676	280	322	2289	1299	1632	990
3	Germany	171	8	1216	573	250	393	2128	1589	1396	539
4	Italy	142	12	1127	528	285	314	1731	1219	1341	512
5	France	118	1	810	337	178	295	1214	1003	852	211
6	Portugal	109	4	708	296	161	251	1064	889	753	175
7	Netherlands	99	6	577	228	147	202	864	723	603	141
8	Scotland	80	1	443	186	89	168	648	582	461	66
9	Ukraine	68		430	171	98	161	589	571	440	18
10	Belguim	89		460	155	100	205	602	722	410	-120


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
);