Global Lol Sports 2022
All data of League of Legends Matches of 2022 (25/07/2022)
@kaggle.jordipompas_lolesports
All data of League of Legends Matches of 2022 (25/07/2022)
@kaggle.jordipompas_lolesports
CREATE TABLE n_2022_lol_esports_match_data_2022_07_25 (
"gameid" VARCHAR,
"datacompleteness" VARCHAR,
"url" VARCHAR,
"league" VARCHAR,
"year" BIGINT,
"split" VARCHAR,
"playoffs" BIGINT,
"date" TIMESTAMP,
"game" BIGINT,
"patch" DOUBLE,
"participantid" BIGINT,
"side" VARCHAR,
"position" VARCHAR,
"playername" VARCHAR,
"playerid" VARCHAR,
"teamname" VARCHAR,
"teamid" VARCHAR,
"champion" VARCHAR,
"ban1" VARCHAR,
"ban2" VARCHAR,
"ban3" VARCHAR,
"ban4" VARCHAR,
"ban5" VARCHAR,
"gamelength" BIGINT,
"result" BIGINT,
"kills" BIGINT,
"deaths" BIGINT,
"assists" BIGINT,
"teamkills" BIGINT,
"teamdeaths" BIGINT,
"doublekills" DOUBLE,
"triplekills" DOUBLE,
"quadrakills" DOUBLE,
"pentakills" DOUBLE,
"firstblood" DOUBLE,
"firstbloodkill" DOUBLE,
"firstbloodassist" DOUBLE,
"firstbloodvictim" DOUBLE,
"team_kpm" DOUBLE,
"ckpm" DOUBLE,
"firstdragon" DOUBLE,
"dragons" DOUBLE,
"opp_dragons" DOUBLE,
"elementaldrakes" DOUBLE,
"opp_elementaldrakes" DOUBLE,
"infernals" DOUBLE,
"mountains" DOUBLE,
"clouds" DOUBLE,
"oceans" DOUBLE,
"chemtechs" DOUBLE,
"hextechs" DOUBLE,
"dragons_type_unknown" DOUBLE,
"elders" DOUBLE,
"opp_elders" DOUBLE,
"firstherald" DOUBLE,
"heralds" DOUBLE,
"opp_heralds" DOUBLE,
"firstbaron" DOUBLE,
"barons" DOUBLE,
"opp_barons" DOUBLE,
"firsttower" DOUBLE,
"towers" DOUBLE,
"opp_towers" DOUBLE,
"firstmidtower" DOUBLE,
"firsttothreetowers" DOUBLE,
"turretplates" DOUBLE,
"opp_turretplates" DOUBLE,
"inhibitors" DOUBLE,
"opp_inhibitors" DOUBLE,
"damagetochampions" DOUBLE,
"dpm" DOUBLE,
"damageshare" DOUBLE,
"damagetakenperminute" DOUBLE,
"damagemitigatedperminute" DOUBLE,
"wardsplaced" DOUBLE,
"wpm" DOUBLE,
"wardskilled" DOUBLE,
"wcpm" DOUBLE,
"controlwardsbought" DOUBLE,
"visionscore" DOUBLE,
"vspm" DOUBLE,
"totalgold" BIGINT,
"earnedgold" DOUBLE,
"earned_gpm" DOUBLE,
"earnedgoldshare" DOUBLE,
"goldspent" DOUBLE,
"gspd" DOUBLE,
"total_cs" DOUBLE,
"minionkills" DOUBLE,
"monsterkills" DOUBLE,
"monsterkillsownjungle" DOUBLE,
"monsterkillsenemyjungle" DOUBLE,
"cspm" DOUBLE,
"goldat10" DOUBLE,
"xpat10" DOUBLE,
"csat10" DOUBLE,
"opp_goldat10" DOUBLE,
"opp_xpat10" DOUBLE,
"opp_csat10" DOUBLE,
"golddiffat10" DOUBLE
);
Anyone who has the link will be able to view this.