UCL | Matches & Players Data
Goals, Assists, Attack, Defence, Passing, Field Control, GK Data of UCL 2021-22
@kaggle.azminetoushikwasi_ucl_202122_uefa_champions_league
Goals, Assists, Attack, Defence, Passing, Field Control, GK Data of UCL 2021-22
@kaggle.azminetoushikwasi_ucl_202122_uefa_champions_league
CREATE TABLE attacking (
"serial" BIGINT,
"player_name" VARCHAR,
"club" VARCHAR,
"position" VARCHAR,
"assists" BIGINT,
"corner_taken" BIGINT,
"offsides" BIGINT,
"dribbles" BIGINT,
"match_played" BIGINT
);
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
);
CREATE TABLE defending (
"serial" BIGINT,
"player_name" VARCHAR,
"club" VARCHAR,
"position" VARCHAR,
"balls_recoverd" BIGINT,
"tackles" BIGINT,
"t_won" BIGINT,
"t_lost" BIGINT,
"clearance_attempted" BIGINT,
"match_played" BIGINT
);
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
);
CREATE TABLE distributon (
"serial" BIGINT,
"player_name" VARCHAR,
"club" VARCHAR,
"position" VARCHAR,
"pass_accuracy" DOUBLE,
"pass_attempted" BIGINT,
"pass_completed" BIGINT,
"cross_accuracy" BIGINT,
"cross_attempted" BIGINT,
"cross_complted" BIGINT,
"freekicks_taken" BIGINT,
"match_played" BIGINT
);
CREATE TABLE goalkeeping (
"serial" BIGINT,
"player_name" VARCHAR,
"club" VARCHAR,
"position" VARCHAR,
"saved" BIGINT,
"conceded" BIGINT,
"saved_penalties" BIGINT,
"cleansheets" BIGINT,
"punches_made" BIGINT,
"match_played" BIGINT
);
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
);
CREATE TABLE key_stats (
"player_name" VARCHAR,
"club" VARCHAR,
"position" VARCHAR,
"minutes_played" BIGINT,
"match_played" BIGINT,
"goals" BIGINT,
"assists" BIGINT,
"distance_covered" VARCHAR
);
Anyone who has the link will be able to view this.