League Of Legends: World Championship 2019
A collection of data from the World Championship 2019
@kaggle.ilyadziamidovich_league_of_legends_world_championship_2019
A collection of data from the World Championship 2019
@kaggle.ilyadziamidovich_league_of_legends_world_championship_2019
Context
The 2019 League of Legends World Championship was the ninth world championship for League of Legends, an esports tournament for the video game developed by Riot Games. It was held from October 2, 2019, to November 10, 2019, in Berlin, Madrid and Paris. Twenty four teams from 13 regions qualified for the tournament based on their placement in regional circuits such as those in China, Europe, North America, South Korea and Taiwan/Hong Kong/Macau with twelve of those teams having to reach the main event via a play-in stage.
Content
wc_matches.csv - documents all the world championship games.
wc_players.csv - documents all the data of each individual player.
wc_champions.csv - documents all the champion data, showing the in-game champions played and various performance stats.
Sources
Data is sourced from the following sites:
Match data: Gamepedia (Main Event/Play-In)
Player data: Oracle's Elixir
Champion data: Liquipedia
CREATE TABLE wc_champions (
"unnamed_0" BIGINT -- Unnamed: 0,
"champion" VARCHAR,
"sum_total" BIGINT,
"win_total" BIGINT,
"lose_total" BIGINT,
"winrate_total" 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,
"matches_less_25_min" BIGINT,
"win_lose_less_25_min" VARCHAR,
"winrate_less_25_min" VARCHAR,
"matches_25_to_30_min" BIGINT,
"win_lose_25_to_30_min" VARCHAR,
"winrate_25_30_min" VARCHAR,
"matches_30_35_min" BIGINT,
"win_lose_30_35_min" VARCHAR,
"winrate_30_35_min" VARCHAR,
"matches_35_40_min" BIGINT,
"win_lose_35_40_min" VARCHAR,
"winrate_35_40_min" VARCHAR,
"matches_40_45_min" BIGINT,
"win_lose_40_45_min" VARCHAR,
"winrate_40_45_min" VARCHAR,
"matches_more_45_min" BIGINT,
"win_lose_more_45_min" VARCHAR,
"winrate_more_45_min" VARCHAR
);
CREATE TABLE wc_matches (
"unnamed_0" BIGINT -- Unnamed: 0,
"team1" VARCHAR,
"team2" VARCHAR,
"winner" VARCHAR,
"date" TIMESTAMP,
"pbp_caster" VARCHAR,
"color_caster" VARCHAR,
"mvp" VARCHAR,
"blue" VARCHAR,
"red" VARCHAR
);
CREATE TABLE wc_players (
"unnamed_0" BIGINT -- Unnamed: 0,
"date" DOUBLE,
"side" VARCHAR,
"position" VARCHAR,
"player" VARCHAR,
"team" VARCHAR,
"champion" VARCHAR,
"ban1" VARCHAR,
"ban2" VARCHAR,
"ban3" VARCHAR,
"ban4" VARCHAR,
"ban5" VARCHAR,
"gamelength" DOUBLE,
"result" BIGINT,
"k" BIGINT,
"d" BIGINT,
"a" BIGINT,
"teamkills" BIGINT,
"teamdeaths" BIGINT,
"doubles" BIGINT,
"triples" BIGINT,
"quadras" BIGINT,
"pentas" BIGINT,
"fb" BIGINT,
"fbassist" BIGINT,
"fbvictim" BIGINT,
"fbtime" DOUBLE,
"kpm" DOUBLE,
"okpm" DOUBLE,
"ckpm" DOUBLE,
"fd" BIGINT,
"fdtime" DOUBLE,
"teamdragkills" BIGINT,
"oppdragkills" BIGINT,
"elementals" BIGINT,
"oppelementals" BIGINT,
"firedrakes" BIGINT,
"waterdrakes" BIGINT,
"earthdrakes" BIGINT,
"airdrakes" BIGINT,
"elders" BIGINT,
"oppelders" BIGINT,
"herald" BIGINT,
"heraldtime" VARCHAR,
"ft" BIGINT,
"fttime" DOUBLE,
"firstmidouter" BIGINT,
"firsttothreetowers" BIGINT,
"teamtowerkills" BIGINT,
"opptowerkills" BIGINT,
"fbaron" DOUBLE,
"fbarontime" DOUBLE,
"teambaronkills" BIGINT,
"oppbaronkills" BIGINT,
"dmgtochamps" BIGINT,
"dmgtochampsperminute" DOUBLE,
"dmgshare" DOUBLE,
"earnedgoldshare" DOUBLE,
"wards" BIGINT,
"wpm" DOUBLE,
"wardshare" DOUBLE,
"wardkills" BIGINT,
"wcpm" DOUBLE,
"visionwards" BIGINT,
"visionwardbuys" BIGINT,
"visiblewardclearrate" VARCHAR,
"invisiblewardclearrate" VARCHAR,
"totalgold" BIGINT,
"earnedgpm" DOUBLE,
"goldspent" BIGINT,
"gspd" DOUBLE,
"minionkills" BIGINT,
"monsterkills" BIGINT,
"monsterkillsownjungle" BIGINT,
"monsterkillsenemyjungle" BIGINT,
"cspm" DOUBLE,
"goldat10" BIGINT,
"oppgoldat10" BIGINT,
"gdat10" BIGINT,
"goldat15" BIGINT,
"oppgoldat15" BIGINT,
"gdat15" BIGINT,
"xpat10" BIGINT,
"oppxpat10" BIGINT,
"xpdat10" BIGINT,
"csat10" BIGINT,
"oppcsat10" BIGINT,
"csdat10" BIGINT,
"csat15" BIGINT,
"oppcsat15" BIGINT,
"csdat15" BIGINT
);
Anyone who has the link will be able to view this.