CBLOL Dataset
Players stats and match history of CBLOL
@kaggle.arthur1511_cblol_2021_dataset
Players stats and match history of CBLOL
@kaggle.arthur1511_cblol_2021_dataset
CREATE TABLE match_data_2021 (
"gameid" VARCHAR,
"teamname" VARCHAR,
"top_playername" VARCHAR,
"top_champion" VARCHAR,
"top_kills" BIGINT,
"top_deaths" BIGINT,
"top_assists" BIGINT,
"top_firstbloodkill" DOUBLE,
"top_firstbloodassist" DOUBLE,
"top_firstbloodvictim" DOUBLE,
"top_damagetochampions" DOUBLE,
"top_dpm" DOUBLE,
"top_damageshare" DOUBLE,
"top_damagetakenperminute" DOUBLE,
"top_damagemitigatedperminute" DOUBLE,
"top_wardsplaced" DOUBLE,
"top_wpm" DOUBLE,
"top_wardskilled" DOUBLE,
"top_wcpm" DOUBLE,
"top_controlwardsbought" DOUBLE,
"top_visionscore" DOUBLE,
"top_vspm" DOUBLE,
"top_totalgold" BIGINT,
"top_earnedgold" DOUBLE,
"top_earned_gpm" DOUBLE,
"top_earnedgoldshare" DOUBLE,
"top_goldspent" DOUBLE,
"top_total_cs" DOUBLE,
"top_minionkills" DOUBLE,
"top_monsterkills" DOUBLE,
"top_monsterkillsownjungle" DOUBLE,
"top_monsterkillsenemyjungle" DOUBLE,
"top_cspm" DOUBLE,
"top_goldat10" DOUBLE,
"top_xpat10" DOUBLE,
"top_csat10" DOUBLE,
"top_opp_goldat10" DOUBLE,
"top_opp_xpat10" DOUBLE,
"top_opp_csat10" DOUBLE,
"top_golddiffat10" DOUBLE,
"top_xpdiffat10" DOUBLE,
"top_csdiffat10" DOUBLE,
"top_killsat10" DOUBLE,
"top_assistsat10" DOUBLE,
"top_deathsat10" DOUBLE,
"top_opp_killsat10" DOUBLE,
"top_opp_assistsat10" DOUBLE,
"top_opp_deathsat10" DOUBLE,
"top_goldat15" DOUBLE,
"top_xpat15" DOUBLE,
"top_csat15" DOUBLE,
"top_opp_goldat15" DOUBLE,
"top_opp_xpat15" DOUBLE,
"top_opp_csat15" DOUBLE,
"top_golddiffat15" DOUBLE,
"top_xpdiffat15" DOUBLE,
"top_csdiffat15" DOUBLE,
"top_killsat15" DOUBLE,
"top_assistsat15" DOUBLE,
"top_deathsat15" DOUBLE,
"top_opp_killsat15" DOUBLE,
"top_opp_assistsat15" DOUBLE,
"top_opp_deathsat15" DOUBLE,
"jng_playername" VARCHAR,
"jng_champion" VARCHAR,
"jng_kills" BIGINT,
"jng_deaths" BIGINT,
"jng_assists" BIGINT,
"jng_firstbloodkill" DOUBLE,
"jng_firstbloodassist" DOUBLE,
"jng_firstbloodvictim" DOUBLE,
"jng_damagetochampions" DOUBLE,
"jng_dpm" DOUBLE,
"jng_damageshare" DOUBLE,
"jng_damagetakenperminute" DOUBLE,
"jng_damagemitigatedperminute" DOUBLE,
"jng_wardsplaced" DOUBLE,
"jng_wpm" DOUBLE,
"jng_wardskilled" DOUBLE,
"jng_wcpm" DOUBLE,
"jng_controlwardsbought" DOUBLE,
"jng_visionscore" DOUBLE,
"jng_vspm" DOUBLE,
"jng_totalgold" BIGINT,
"jng_earnedgold" DOUBLE,
"jng_earned_gpm" DOUBLE,
"jng_earnedgoldshare" DOUBLE,
"jng_goldspent" DOUBLE,
"jng_total_cs" DOUBLE,
"jng_minionkills" DOUBLE,
"jng_monsterkills" DOUBLE,
"jng_monsterkillsownjungle" DOUBLE,
"jng_monsterkillsenemyjungle" DOUBLE,
"jng_cspm" DOUBLE,
"jng_goldat10" DOUBLE,
"jng_xpat10" DOUBLE,
"jng_csat10" DOUBLE,
"jng_opp_goldat10" DOUBLE,
"jng_opp_xpat10" DOUBLE,
"jng_opp_csat10" DOUBLE
);
CREATE TABLE match_data_2022 (
"gameid" VARCHAR,
"teamname" VARCHAR,
"top_playername" VARCHAR,
"top_champion" VARCHAR,
"top_kills" BIGINT,
"top_deaths" BIGINT,
"top_assists" BIGINT,
"top_firstbloodkill" DOUBLE,
"top_firstbloodassist" DOUBLE,
"top_firstbloodvictim" DOUBLE,
"top_damagetochampions" DOUBLE,
"top_dpm" DOUBLE,
"top_damageshare" DOUBLE,
"top_damagetakenperminute" DOUBLE,
"top_damagemitigatedperminute" DOUBLE,
"top_wardsplaced" DOUBLE,
"top_wpm" DOUBLE,
"top_wardskilled" DOUBLE,
"top_wcpm" DOUBLE,
"top_controlwardsbought" DOUBLE,
"top_visionscore" DOUBLE,
"top_vspm" DOUBLE,
"top_totalgold" BIGINT,
"top_earnedgold" DOUBLE,
"top_earned_gpm" DOUBLE,
"top_earnedgoldshare" DOUBLE,
"top_goldspent" DOUBLE,
"top_total_cs" DOUBLE,
"top_minionkills" DOUBLE,
"top_monsterkills" DOUBLE,
"top_monsterkillsownjungle" VARCHAR,
"top_monsterkillsenemyjungle" VARCHAR,
"top_cspm" DOUBLE,
"top_goldat10" DOUBLE,
"top_xpat10" DOUBLE,
"top_csat10" DOUBLE,
"top_opp_goldat10" DOUBLE,
"top_opp_xpat10" DOUBLE,
"top_opp_csat10" DOUBLE,
"top_golddiffat10" DOUBLE,
"top_xpdiffat10" DOUBLE,
"top_csdiffat10" DOUBLE,
"top_killsat10" DOUBLE,
"top_assistsat10" DOUBLE,
"top_deathsat10" DOUBLE,
"top_opp_killsat10" DOUBLE,
"top_opp_assistsat10" DOUBLE,
"top_opp_deathsat10" DOUBLE,
"top_goldat15" DOUBLE,
"top_xpat15" DOUBLE,
"top_csat15" DOUBLE,
"top_opp_goldat15" DOUBLE,
"top_opp_xpat15" DOUBLE,
"top_opp_csat15" DOUBLE,
"top_golddiffat15" DOUBLE,
"top_xpdiffat15" DOUBLE,
"top_csdiffat15" DOUBLE,
"top_killsat15" DOUBLE,
"top_assistsat15" DOUBLE,
"top_deathsat15" DOUBLE,
"top_opp_killsat15" DOUBLE,
"top_opp_assistsat15" DOUBLE,
"top_opp_deathsat15" DOUBLE,
"jng_playername" VARCHAR,
"jng_champion" VARCHAR,
"jng_kills" BIGINT,
"jng_deaths" BIGINT,
"jng_assists" BIGINT,
"jng_firstbloodkill" DOUBLE,
"jng_firstbloodassist" DOUBLE,
"jng_firstbloodvictim" DOUBLE,
"jng_damagetochampions" DOUBLE,
"jng_dpm" DOUBLE,
"jng_damageshare" DOUBLE,
"jng_damagetakenperminute" DOUBLE,
"jng_damagemitigatedperminute" DOUBLE,
"jng_wardsplaced" DOUBLE,
"jng_wpm" DOUBLE,
"jng_wardskilled" DOUBLE,
"jng_wcpm" DOUBLE,
"jng_controlwardsbought" DOUBLE,
"jng_visionscore" DOUBLE,
"jng_vspm" DOUBLE,
"jng_totalgold" BIGINT,
"jng_earnedgold" DOUBLE,
"jng_earned_gpm" DOUBLE,
"jng_earnedgoldshare" DOUBLE,
"jng_goldspent" DOUBLE,
"jng_total_cs" DOUBLE,
"jng_minionkills" DOUBLE,
"jng_monsterkills" DOUBLE,
"jng_monsterkillsownjungle" VARCHAR,
"jng_monsterkillsenemyjungle" VARCHAR,
"jng_cspm" DOUBLE,
"jng_goldat10" DOUBLE,
"jng_xpat10" DOUBLE,
"jng_csat10" DOUBLE,
"jng_opp_goldat10" DOUBLE,
"jng_opp_xpat10" DOUBLE,
"jng_opp_csat10" DOUBLE
);
CREATE TABLE players_data_2021 (
"unnamed_0" BIGINT,
"gameid" VARCHAR,
"teamname" VARCHAR,
"gamelength" BIGINT,
"result" BIGINT,
"game" BIGINT,
"patch" DOUBLE,
"playoffs" BIGINT,
"ckpm" DOUBLE,
"position" VARCHAR,
"playername" VARCHAR,
"champion" VARCHAR,
"kills" BIGINT,
"deaths" BIGINT,
"assists" BIGINT,
"firstbloodkill" DOUBLE,
"firstbloodassist" DOUBLE,
"firstbloodvictim" 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,
"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,
"xpdiffat10" DOUBLE,
"csdiffat10" DOUBLE,
"killsat10" DOUBLE,
"assistsat10" DOUBLE,
"deathsat10" DOUBLE,
"opp_killsat10" DOUBLE,
"opp_assistsat10" DOUBLE,
"opp_deathsat10" DOUBLE,
"goldat15" DOUBLE,
"xpat15" DOUBLE,
"csat15" DOUBLE,
"opp_goldat15" DOUBLE,
"opp_xpat15" DOUBLE,
"opp_csat15" DOUBLE,
"golddiffat15" DOUBLE,
"xpdiffat15" DOUBLE,
"csdiffat15" DOUBLE,
"killsat15" DOUBLE,
"assistsat15" DOUBLE,
"deathsat15" DOUBLE,
"opp_killsat15" DOUBLE,
"opp_assistsat15" DOUBLE,
"opp_deathsat15" DOUBLE
);
CREATE TABLE players_data_2022 (
"unnamed_0" BIGINT,
"gameid" VARCHAR,
"teamname" VARCHAR,
"gamelength" BIGINT,
"result" BIGINT,
"game" BIGINT,
"patch" DOUBLE,
"playoffs" BIGINT,
"ckpm" DOUBLE,
"position" VARCHAR,
"playername" VARCHAR,
"champion" VARCHAR,
"kills" BIGINT,
"deaths" BIGINT,
"assists" BIGINT,
"firstbloodkill" DOUBLE,
"firstbloodassist" DOUBLE,
"firstbloodvictim" 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,
"total_cs" DOUBLE,
"minionkills" DOUBLE,
"monsterkills" DOUBLE,
"monsterkillsownjungle" VARCHAR,
"monsterkillsenemyjungle" VARCHAR,
"cspm" DOUBLE,
"goldat10" DOUBLE,
"xpat10" DOUBLE,
"csat10" DOUBLE,
"opp_goldat10" DOUBLE,
"opp_xpat10" DOUBLE,
"opp_csat10" DOUBLE,
"golddiffat10" DOUBLE,
"xpdiffat10" DOUBLE,
"csdiffat10" DOUBLE,
"killsat10" DOUBLE,
"assistsat10" DOUBLE,
"deathsat10" DOUBLE,
"opp_killsat10" DOUBLE,
"opp_assistsat10" DOUBLE,
"opp_deathsat10" DOUBLE,
"goldat15" DOUBLE,
"xpat15" DOUBLE,
"csat15" DOUBLE,
"opp_goldat15" DOUBLE,
"opp_xpat15" DOUBLE,
"opp_csat15" DOUBLE,
"golddiffat15" DOUBLE,
"xpdiffat15" DOUBLE,
"csdiffat15" DOUBLE,
"killsat15" DOUBLE,
"assistsat15" DOUBLE,
"deathsat15" DOUBLE,
"opp_killsat15" DOUBLE,
"opp_assistsat15" DOUBLE,
"opp_deathsat15" DOUBLE
);
CREATE TABLE team_data_2021 (
"unnamed_0" BIGINT,
"gameid" VARCHAR,
"teamname" VARCHAR,
"gamelength" BIGINT,
"result" BIGINT,
"game" BIGINT,
"patch" DOUBLE,
"playoffs" BIGINT,
"ckpm" DOUBLE,
"side" VARCHAR,
"ban1" VARCHAR,
"ban2" VARCHAR,
"ban3" VARCHAR,
"ban4" VARCHAR,
"ban5" VARCHAR,
"teamkills" BIGINT,
"teamdeaths" BIGINT,
"firstblood" DOUBLE,
"team_kpm" 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,
"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,
"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,
"goldspent" DOUBLE,
"gspd" DOUBLE,
"total_cs" VARCHAR,
"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,
"xpdiffat10" DOUBLE,
"csdiffat10" DOUBLE,
"killsat10" DOUBLE,
"assistsat10" DOUBLE,
"deathsat10" DOUBLE,
"opp_killsat10" DOUBLE,
"opp_assistsat10" DOUBLE,
"opp_deathsat10" DOUBLE,
"goldat15" DOUBLE,
"xpat15" DOUBLE,
"csat15" DOUBLE,
"opp_goldat15" DOUBLE,
"opp_xpat15" DOUBLE,
"opp_csat15" DOUBLE,
"golddiffat15" DOUBLE,
"xpdiffat15" DOUBLE,
"csdiffat15" DOUBLE,
"killsat15" DOUBLE,
"assistsat15" DOUBLE,
"deathsat15" DOUBLE,
"opp_killsat15" DOUBLE,
"opp_assistsat15" DOUBLE,
"opp_deathsat15" DOUBLE
);
CREATE TABLE team_data_2022 (
"unnamed_0" BIGINT,
"gameid" VARCHAR,
"teamname" VARCHAR,
"gamelength" BIGINT,
"result" BIGINT,
"game" BIGINT,
"patch" DOUBLE,
"playoffs" BIGINT,
"ckpm" DOUBLE,
"side" VARCHAR,
"ban1" VARCHAR,
"ban2" VARCHAR,
"ban3" VARCHAR,
"ban4" VARCHAR,
"ban5" VARCHAR,
"teamkills" BIGINT,
"teamdeaths" BIGINT,
"firstblood" DOUBLE,
"team_kpm" 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,
"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,
"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,
"goldspent" DOUBLE,
"gspd" DOUBLE,
"total_cs" VARCHAR,
"minionkills" DOUBLE,
"monsterkills" DOUBLE,
"monsterkillsownjungle" VARCHAR,
"monsterkillsenemyjungle" VARCHAR,
"cspm" DOUBLE,
"goldat10" DOUBLE,
"xpat10" DOUBLE,
"csat10" DOUBLE,
"opp_goldat10" DOUBLE,
"opp_xpat10" DOUBLE,
"opp_csat10" DOUBLE,
"golddiffat10" DOUBLE,
"xpdiffat10" DOUBLE,
"csdiffat10" DOUBLE,
"killsat10" DOUBLE,
"assistsat10" DOUBLE,
"deathsat10" DOUBLE,
"opp_killsat10" DOUBLE,
"opp_assistsat10" DOUBLE,
"opp_deathsat10" DOUBLE,
"goldat15" DOUBLE,
"xpat15" DOUBLE,
"csat15" DOUBLE,
"opp_goldat15" DOUBLE,
"opp_xpat15" DOUBLE,
"opp_csat15" DOUBLE,
"golddiffat15" DOUBLE,
"xpdiffat15" DOUBLE,
"csdiffat15" DOUBLE,
"killsat15" DOUBLE,
"assistsat15" DOUBLE,
"deathsat15" DOUBLE,
"opp_killsat15" DOUBLE,
"opp_assistsat15" DOUBLE,
"opp_deathsat15" DOUBLE
);
Anyone who has the link will be able to view this.