League Of Legends: World Championship 2022
A collection of data from the World Championship 2022
@kaggle.ilyadziamidovich_league_of_legends_world_championship_2022
A collection of data from the World Championship 2022
@kaggle.ilyadziamidovich_league_of_legends_world_championship_2022
CREATE TABLE wc_champions (
"unnamed_0" BIGINT,
"champion" VARCHAR,
"sum_total" BIGINT,
"win_total" BIGINT,
"lose_total" BIGINT,
"winrate_total" VARCHAR,
"pick_rate" VARCHAR,
"sum_blue_side" BIGINT,
"win_blue_side" BIGINT,
"lose_blue_side" BIGINT,
"winrate_blue_side" VARCHAR,
"sum_red_side" BIGINT,
"win_red_side" BIGINT,
"lose_red_side" BIGINT,
"winrate_red_side" VARCHAR,
"sum_bans" BIGINT,
"ban_rate" VARCHAR,
"sum_pick_ban" BIGINT,
"pick_ban_rate" VARCHAR
);
CREATE TABLE wc_players_main (
"player" VARCHAR,
"team" VARCHAR,
"position" VARCHAR,
"gold_per_minute" BIGINT,
"winrate" VARCHAR,
"counter_pickrate" VARCHAR,
"kills" BIGINT,
"deaths" BIGINT,
"assists" BIGINT,
"kda" DOUBLE,
"kp" VARCHAR,
"kill_share" VARCHAR,
"share_team_deaths" VARCHAR,
"first_blood_rate" VARCHAR,
"gold_diff_10" BIGINT,
"xp_diff_10" BIGINT,
"cs_diff_10" DOUBLE,
"cspm" DOUBLE,
"share_team_deaths_15" VARCHAR,
"damage_per_minute" BIGINT,
"share_damage" VARCHAR,
"share_team_damage_15" VARCHAR,
"average_gold_per_minute" BIGINT,
"gold_share" VARCHAR,
"neutral_objectives_stolen" BIGINT,
"wards_per_minute" DOUBLE,
"control_wards_per_minute" DOUBLE,
"wards_cleared_per_minute" DOUBLE
);
CREATE TABLE wc_players_play_in (
"player" VARCHAR,
"team" VARCHAR,
"position" VARCHAR,
"gold_per_minute" BIGINT,
"winrate" VARCHAR,
"counter_pickrate" VARCHAR,
"kills" BIGINT,
"deaths" BIGINT,
"assists" BIGINT,
"kda" DOUBLE,
"kp" VARCHAR,
"kill_share" VARCHAR,
"share_team_deaths" VARCHAR,
"first_blood_rate" VARCHAR,
"gold_diff_10" BIGINT,
"xp_diff_10" BIGINT,
"cs_diff_10" DOUBLE,
"cspm" DOUBLE,
"share_team_deaths_15" VARCHAR,
"damage_per_minute" BIGINT,
"share_damage" VARCHAR,
"share_team_damage_15" VARCHAR,
"average_gold_per_minute" BIGINT,
"gold_share" VARCHAR,
"neutral_objectives_stolen" BIGINT,
"wards_per_minute" DOUBLE,
"control_wards_per_minute" DOUBLE,
"wards_cleared_per_minute" DOUBLE
);
CREATE TABLE wc_teams_main (
"team" VARCHAR,
"games_played" BIGINT,
"wins" BIGINT,
"loses" BIGINT,
"average_game_duration" DOUBLE,
"kills" BIGINT,
"deaths" BIGINT,
"kd" DOUBLE,
"combined_kills_per_minute" DOUBLE,
"gold_percent_rating" DOUBLE,
"gold_spent_difference" VARCHAR,
"early_game_rating" DOUBLE,
"mid_late_rating" DOUBLE,
"gold_diff_15" BIGINT,
"first_blood_rate" VARCHAR,
"first_tower_rate" VARCHAR,
"first_to_three_towers_rate" VARCHAR,
"turrent_plates_destroyed" DOUBLE,
"rift_herald_rate" VARCHAR,
"first_dragon_rate" VARCHAR,
"dragon_control_rate" VARCHAR,
"elder_dragon_rate" VARCHAR,
"first_baron_rate" VARCHAR,
"baron_control_rate" VARCHAR,
"lane_control" VARCHAR,
"jungle_control" VARCHAR,
"wards_per_minute" DOUBLE,
"control_wards_per_minute" DOUBLE,
"wards_cleared_per_minute" DOUBLE
);
CREATE TABLE wc_teams_play_in (
"team" VARCHAR,
"games_played" BIGINT,
"wins" BIGINT,
"loses" BIGINT,
"average_game_duration" DOUBLE,
"kills" BIGINT,
"deaths" BIGINT,
"kd" DOUBLE,
"combined_kills_per_minute" DOUBLE,
"gold_percent_rating" DOUBLE,
"gold_spent_difference" VARCHAR,
"early_game_rating" DOUBLE,
"mid_late_rating" DOUBLE,
"gold_diff_15" BIGINT,
"first_blood_rate" VARCHAR,
"first_tower_rate" VARCHAR,
"first_to_three_towers_rate" VARCHAR,
"turrent_plates_destroyed" DOUBLE,
"rift_herald_rate" VARCHAR,
"first_dragon_rate" VARCHAR,
"dragon_control_rate" VARCHAR,
"elder_dragon_rate" VARCHAR,
"first_baron_rate" VARCHAR,
"baron_control_rate" VARCHAR,
"lane_control" VARCHAR,
"jungle_control" VARCHAR,
"wards_per_minute" DOUBLE,
"control_wards_per_minute" DOUBLE,
"wards_cleared_per_minute" DOUBLE
);
Anyone who has the link will be able to view this.