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

Goals

@kaggle.azminetoushikwasi_ucl_202122_uefa_champions_league.goals

12.19 KB
183 rows
13 columns

serial Serial	player_name Player Name	club Club	position Position	goals Goals	right_foot Right Foot	left_foot Left Foot	headers Headers	others Others	inside_area Inside Area	outside_areas Outside Areas	penalties Penalties	match_played Match Played
1	Benzema	Real Madrid	Forward	15	11	1	3		13	2	3	12
2	Lewandowski	Bayern	Forward	13	8	3	1	1	13		3	10
3	Haller	Ajax	Forward	11	3	4	3	1	11		1	8
4	Salah	Liverpool	Forward	8		8			7	1	1	13
5	Nkunku	Leipzig	Midfielder	7	3	1	3		7			6
5	Mahrez	Man. City	Midfielder	7	1	4	2		7		2	12
7	Mbappé	Paris	Forward	6	6				6			8
7	Núñez	Benfica	Forward	6	5		1		6		1	10
7	Ronaldo	Man. United	Forward	6	5		1		4	2		7
7	Danjuma	Villarreal	Midfielder	6	3	3			6		1	11


CREATE TABLE goals (
  "serial" BIGINT,
  "player_name" VARCHAR,
  "club" VARCHAR,
  "position" VARCHAR,
  "goals" BIGINT,
  "right_foot" BIGINT,
  "left_foot" BIGINT,
  "headers" BIGINT,
  "others" BIGINT,
  "inside_area" BIGINT,
  "outside_areas" BIGINT,
  "penalties" BIGINT,
  "match_played" BIGINT
);