CBLOL Dataset

Players stats and match history of CBLOL

@kaggle.arthur1511_cblol_2021_dataset

Table List

6 tables(2.44 MB)

Team Data 2022

@kaggle.arthur1511_cblol_2021_dataset.team_data_2022

182.16 KB
486 rows
99 columns

unnamed_0 Unnamed: 0	gameid Gameid	teamname Teamname	gamelength Gamelength	result Result	game Game	patch Patch	ckpm Ckpm	side Side	ban1 Ban1	ban2 Ban2	ban3 Ban3	ban4 Ban4	ban5 Ban5	teamkills Teamkills	teamdeaths Teamdeaths	firstblood Firstblood	team_kpm Team Kpm	firstdragon Firstdragon	dragons Dragons	opp_dragons Opp Dragons	elementaldrakes Elementaldrakes	opp_elementaldrakes Opp Elementaldrakes	infernals Infernals	mountains Mountains	clouds Clouds	oceans Oceans	chemtechs Chemtechs	hextechs Hextechs	elders Elders	opp_elders Opp Elders	firstherald Firstherald	heralds Heralds	opp_heralds Opp Heralds	firstbaron Firstbaron	barons Barons	opp_barons Opp Barons	firsttower Firsttower	towers Towers	opp_towers Opp Towers	firstmidtower Firstmidtower	firsttothreetowers Firsttothreetowers	turretplates Turretplates	opp_turretplates Opp Turretplates	inhibitors Inhibitors	opp_inhibitors Opp Inhibitors	damagetochampions Damagetochampions	dpm Dpm	damagetakenperminute Damagetakenperminute	damagemitigatedperminute Damagemitigatedperminute	wardsplaced Wardsplaced	wpm Wpm	wardskilled Wardskilled	wcpm Wcpm	controlwardsbought Controlwardsbought	visionscore Visionscore	vspm Vspm	totalgold Totalgold	earnedgold Earnedgold	earned_gpm Earned Gpm	goldspent Goldspent	gspd Gspd	minionkills Minionkills	monsterkills Monsterkills	cspm Cspm	goldat10 Goldat10	xpat10 Xpat10	csat10 Csat10	opp_goldat10 Opp Goldat10	opp_xpat10 Opp Xpat10	opp_csat10 Opp Csat10	golddiffat10 Golddiffat10	xpdiffat10 Xpdiffat10	csdiffat10 Csdiffat10	killsat10 Killsat10	assistsat10 Assistsat10	deathsat10 Deathsat10	opp_killsat10 Opp Killsat10	opp_assistsat10 Opp Assistsat10	opp_deathsat10 Opp Deathsat10	goldat15 Goldat15	xpat15 Xpat15	csat15 Csat15	opp_goldat15 Opp Goldat15	opp_xpat15 Opp Xpat15	opp_csat15 Opp Csat15	golddiffat15 Golddiffat15	xpdiffat15 Xpdiffat15	csdiffat15 Csdiffat15	killsat15 Killsat15	assistsat15 Assistsat15	deathsat15 Deathsat15	opp_killsat15 Opp Killsat15	opp_assistsat15 Opp Assistsat15	opp_deathsat15 Opp Deathsat15
6274	ESPORTSTMNT01_2695708	LOUD	2320	1	1	12.01	0.931	Blue	Gwen	Diana	Jinx	Vex	Tryndamere	19	17		0.4914		3	2	3	2	3								1	1	1		1	1	1	9	3	1	1	6	3	1		97484	2521.1379	2699.431	2753.9224	167	4.319	64	1.6552	75	357	9.2328	71210	46170	1194.0517	62900	0.032967	946	257	31.1121	16289	18712	342	15641	17452	310	648	1260	32	2	2	3	3	5	2	25947	29905	522	24288	29356	511	1659	549	11	4	4	4	4	6	4
6275	ESPORTSTMNT01_2695708	FURIA	2320		1	12.01	0.931	Red	Lee Sin	Thresh	Twisted Fate	Kai'Sa	Caitlyn	17	19	1	0.4397	1	2	3	2	3			1	1						1	1	1	1	1		3	9			3	6		1	73545	1902.0259	3437.8448	2553.1552	138	3.569	69	1.7845	57	330	8.5345	64612	39572	1023.4138	60860	-0.032967	883	242	29.0948	15641	17452	310	16289	18712	342	-648	-1260	-32	3	5	2	2	2	3	24288	29356	511	25947	29905	522	-1659	-549	-11	4	6	4	4	4	4
6310	ESPORTSTMNT01_2695774	Netshoes Miners	2152	1	1	12.01	0.7807	Blue	Jinx	Twisted Fate	Caitlyn	Viktor	Syndra	21	7		0.5855	1	3	1	3	1	2		1						1	2		1	2		1	10	2	1	1	2	3	2		77102	2149.684	2806.6171	2277.7695	136	3.7918	51	1.4219	57	287	8.0019	72544	49215	1372.1654	67825	0.157798	1003	266	35.381	15057	18713	341	16449	19211	380	-1392	-498	-39			1	1	1		24237	30459	526	24766	30058	589	-529	401	-63	3	11	2	2	4	3
6311	ESPORTSTMNT01_2695774	Flamengo Esports	2152		1	12.01	0.7807	Red	Nidalee	Corki	Diana	Lee Sin	Jayce	7	21	1	0.1952		1	3	1	3						1					2			2		2	10			3	2		2	53023	1478.3364	2856.3011	2499.4238	117	3.2621	63	1.7565	51	288	8.0297	59163	35834	999.0892	57905	-0.157798	1064	207	35.4368	16449	19211	380	15057	18713	341	1392	498	39	1	1				1	24766	30058	589	24237	30459	526	529	-401	63	2	4	3	3	11	2
6334	ESPORTSTMNT01_2695807	KaBuM! e-Sports	1587	1	1	12.01	0.8318	Blue	Ziggs	Renekton	Twisted Fate	Jhin	Ezreal	15	8		0.5671	1	3	1	3	1		1	1		1					1	1	1	1			8	1	1	1	6		1		65965	2493.9509	2833.8752	2803.327	84	3.1758	35	1.3233	37	169	6.3894	51114	33545	1268.242	43250	0.133827	729	176	34.2155	15328	18545	322	16012	18632	314	-684	-87	8	2	3	3	3	6	2	24028	29997	531	23282	28656	494	746	1341	37	2	3	3	3	6	2
6335	ESPORTSTMNT01_2695807	INTZ	1587		1	12.01	0.8318	Red	Corki	Jayce	Akali	Kennen	Jax	7	15	1	0.2647		1	3	1	3					1				1	1	1			1	1	1	8				6		1	46843	1771.0019	3258.7902	2061.9282	81	3.0624	35	1.3233	37	190	7.1834	40224	22655	856.5217	37825	-0.133827	661	144	30.4348	16012	18632	314	15328	18545	322	684	87	-8	3	6	2	2	3	3	23282	28656	494	24028	29997	531	-746	-1341	-37	3	6	2	2	3	3
6358	ESPORTSTMNT01_2695835	Rensga eSports	2336		1	12.01	0.7962	Blue	Lee Sin	Leona	Twisted Fate	Nautilus	Rakan	14	17		0.3596		2	4	1	4	1						1				2		1	1		6	8			2	8	1	1	100827	2589.7346	2808.75	2805.7705	130	3.339	69	1.7723	62	329	8.4503	71641	46440	1192.8082	64350	-0.0362388	969	234	30.899	14505	16690	284	17115	18397	321	-2610	-1707	-37	1	2	5	5	16	1	23079	28883	487	25992	28800	510	-2913	83	-23	2	4	5	5	16	2
6359	ESPORTSTMNT01_2695835	RED Canids	2336	1	1	12.01	0.7962	Red	Thresh	Caitlyn	Jinx	Braum	Karma	17	14	1	0.4366	1	4	2	4	1	2		1	1				1	1	2		1	1	1	1	8	6	1	1	8	2	1	1	76641	1968.5188	3702.5342	2786.661	138	3.5445	51	1.3099	72	321	8.2449	71408	46207	1186.8236	66725	0.0362388	977	287	32.4658	17115	18397	321	14505	16690	284	2610	1707	37	5	16	1	1	2	5	25992	28800	510	23079	28883	487	2913	-83	23	5	16	2	2	4	5
6610	ESPORTSTMNT01_2696159	Liberty	1655	1	1	12.01	0.6888	Blue	Twisted Fate	Leona	Vex	LeBlanc	Akali	16	3	1	0.5801		3	1	3	1			2			1			1	2		1	1		1	11	1	1	1	12	3	3		48273	1750.0785	2080.568	1862.9003	90	3.2628	42	1.5227	32	210	7.6133	54937	36680	1329.7885	48350	0.130895	718	200	33.281	18959	19983	314	14903	18382	318	4056	1601	-4	6	9	1	1	1	6	29765	30371	512	22488	28671	503	7277	1700	9	7	11	1	1	1	7
6611	ESPORTSTMNT01_2696159	Rensga eSports	1655		1	12.01	0.6888	Red	Gwen	Corki	Thresh	Camille	Renekton	3	16		0.1088	1	1	3	1	3	1										2			1		1	11			3	12		3	37477	1358.6828	2461.3414	1476.5076	70	2.5378	35	1.2689	34	167	6.0544	43579	25322	918.0181	42410	-0.130895	792	144	33.9335	14903	18382	318	18959	19983	314	-4056	-1601	4	1	1	6	6	9	1	22488	28671	503	29765	30371	512	-7277	-1700	-9	1	1	7	7	11	1


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
);