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

Attempts

@kaggle.azminetoushikwasi_ucl_202122_uefa_champions_league.attempts

14.64 KB
546 rows
9 columns

serial Serial	player_name Player Name	club Club	position Position	total_attempts Total Attempts	on_target On Target	off_target Off Target	blocked Blocked	match_played Match Played
1	Benzema	Real Madrid	Forward	45	23	13	9	12
2	Salah	Liverpool	Forward	42	22	11	9	13
3	Mahrez	Man. City	Midfielder	37	18	8	11	12
4	Sané	Bayern	Midfielder	33	13	12	8	10
5	Lewandowski	Bayern	Forward	31	19	8	4	10
6	Luis Díaz	Porto	Forward	29	11	7	11	13
7	Martínez	Inter	Forward	28	7	10	11	8
8	Mbappé	Paris	Forward	27	16	6	5	8
8	Vinícius Júnior	Real Madrid	Forward	27	8	10	9	13
10	Havertz	Chelsea	Midfielder	26	11	9	6	9


CREATE TABLE attempts (
  "serial" BIGINT,
  "player_name" VARCHAR,
  "club" VARCHAR,
  "position" VARCHAR,
  "total_attempts" BIGINT,
  "on_target" BIGINT,
  "off_target" BIGINT,
  "blocked" BIGINT,
  "match_played" BIGINT
);