UCL | Matches & Players Data

Goals, Assists, Attack, Defence, Passing, Field Control, GK Data of UCL 2021-22

@kaggle.azminetoushikwasi_ucl_202122_uefa_champions_league

Table List

8 tables(128.22 KB)

Goals

Disciplinary

@kaggle.azminetoushikwasi_ucl_202122_uefa_champions_league.disciplinary

17.79 KB
584 rows
10 columns

serial Serial	player_name Player Name	club Club	position Position	fouls_committed Fouls Committed	fouls_suffered Fouls Suffered	red Red	yellow Yellow	minutes_played Minutes Played	match_played Match Played
1	João Palhinha	Sporting CP	Midfielder	23	17	2		534	6
2	Capoue	Villarreal	Midfielder	19	17	3	1	1046	12
2	Rodri	Man. City	Midfielder	19	4	2		842	10
2	Seiwald	Salzburg	Midfielder	19	3	2		649	8
5	Balanta	Club Brugge	Midfielder	18	3	4		407	5
6	Casemiro	Real Madrid	Midfielder	17	18	3		914	11
6	Éder Militão	Real Madrid	Defender	17	16	4		1076	12
6	Otamendi	Benfica	Defender	17	11	2		810	9
6	Gravenberch	Ajax	Midfielder	17	11	1		703	8
6	Haller	Ajax	Forward	17	11	1		668	8


CREATE TABLE disciplinary (
  "serial" BIGINT,
  "player_name" VARCHAR,
  "club" VARCHAR,
  "position" VARCHAR,
  "fouls_committed" BIGINT,
  "fouls_suffered" BIGINT,
  "red" BIGINT,
  "yellow" BIGINT,
  "minutes_played" BIGINT,
  "match_played" BIGINT
);