CBLOL Dataset

Players stats and match history of CBLOL

@kaggle.arthur1511_cblol_2021_dataset

Table List

6 tables(2.44 MB)

Players Data 2022

@kaggle.arthur1511_cblol_2021_dataset.players_data_2022

467.6 KB
2430 rows
71 columns

unnamed_0 Unnamed: 0	gameid Gameid	teamname Teamname	gamelength Gamelength	result Result	game Game	patch Patch	ckpm Ckpm	position Position	playername Playername	champion Champion	kills Kills	deaths Deaths	assists Assists	firstbloodkill Firstbloodkill	firstbloodassist Firstbloodassist	firstbloodvictim Firstbloodvictim	damagetochampions Damagetochampions	dpm Dpm	damageshare Damageshare	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	earnedgoldshare Earnedgoldshare	goldspent Goldspent	total_cs Total Cs	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
6264	ESPORTSTMNT01_2695708	LOUD	2320	1	1	12.01	0.931	top	Robo	Renekton	3	6	5				14668	379.3448	0.150466	1076.069	1067.8448	14	0.3621	6	0.1552	8	37	0.9569	14737	9729	251.6121	0.210721	13300	286	267	19	7.3966	4382	4924	87	3075	4171	72	1307	753	15	2		1		1	1	6286	7367	131	4711	6976	116	1575	391	15	2	1	2		2	1
6265	ESPORTSTMNT01_2695708	LOUD	2320	1	1	12.01	0.931	jng	Tay	Viego	4	3	4			1	8730	225.7759	0.0895532	648.0259	415.9914	16	0.4138	18	0.4655	20	68	1.7586	13744	8736	225.931	0.189214	12825	211	46	165	5.4569	3173	3310	63	3322	2895	48	-149	415	15		1	1	2		1	5191	5497	88	4812	5285	82	379	212	6	1	1	1	2		1
6266	ESPORTSTMNT01_2695708	LOUD	2320	1	1	12.01	0.931	mid	tinowns	Corki	2	2	10				40339	1043.25	0.413801	338.3534	229.9655	23	0.5948	9	0.2328	12	54	1.3966	15930	10922	282.4655	0.236561	14100	320	274	46	8.2759	3392	4836	93	3772	4899	92	-380	-63	1				1			5725	7482	149	6305	8281	153	-580	-799	-4				2		1
6267	ESPORTSTMNT01_2695708	LOUD	2320	1	1	12.01	0.931	bot	DudsTheBoy	Aphelios	9	2	3				28089	726.4397	0.28814	291.2069	464.8966	38	0.9828	13	0.3362	10	66	1.7069	17903	12895	333.4914	0.279294	15000	347	320	27	8.9741	3195	3655	85	3254	3372	83	-59	283	2					2		5438	6228	133	5077	5516	133	361	712		1				2	1
6268	ESPORTSTMNT01_2695708	LOUD	2320	1	1	12.01	0.931	sup	Ceos	Nautilus	1	4	9				5658	146.3276	0.0580403	345.7759	575.2241	76	1.9655	18	0.4655	25	132	3.4138	8896	3888	100.5517	0.0842105	7675	39	39		1.0086	2147	1987	14	2218	2115	15	-71	-128	-1		1	1		2		3307	3331	21	3383	3298	27	-76	33	-6		2	1		2
6269	ESPORTSTMNT01_2695708	FURIA	2320		1	12.01	0.931	top	fNb	Akali	4	4	5				17524	453.2069	0.238276	731.0431	565.9138	15	0.3879	11	0.2845	5	47	1.2155	13666	8658	223.9138	0.218791	12325	253	252	1	6.5431	3075	4171	72	4382	4924	87	-1307	-753	-15		1	1	2		1	4711	6976	116	6286	7367	131	-1575	-391	-15		2	1	2	1	2
6270	ESPORTSTMNT01_2695708	FURIA	2320		1	12.01	0.931	jng	Ranger	Xin Zhao	5	3	8				15336	396.6207	0.208525	1248.4914	902.3793	15	0.3879	16	0.4138	16	62	1.6034	12657	7649	197.819	0.193293	12575	191	52	139	4.9397	3322	2895	48	3173	3310	63	149	-415	-15	2		1		1	1	4812	5285	82	5191	5497	88	-379	-212	-6	2		1	1	1	1
6271	ESPORTSTMNT01_2695708	FURIA	2320		1	12.01	0.931	mid	Envy	Orianna	4	4	8	1			16558	428.2241	0.225141	478.6034	253.0603	18	0.4655	8	0.2069	6	55	1.4224	14776	9768	252.6207	0.246841	14160	306	254	52	7.9138	3772	4899	92	3392	4836	93	380	63	-1	1						6305	8281	153	5725	7482	149	580	799	4	2		1
6272	ESPORTSTMNT01_2695708	FURIA	2320		1	12.01	0.931	bot	Netuno	Jhin	3	4	7		1		19553	505.681	0.265864	539.0431	222.8276	14	0.3621	12	0.3103	6	44	1.1379	15105	10097	261.1293	0.255155	13550	329	279	50	8.5086	3254	3372	83	3195	3655	85	59	-283	-2		2					5077	5516	133	5438	6228	133	-361	-712			2	1	1
6273	ESPORTSTMNT01_2695708	FURIA	2320		1	12.01	0.931	sup	RedBert	Leona	1	4	9		1		4574	118.2931	0.0621932	440.6638	608.9741	76	1.9655	22	0.569	24	122	3.1552	8408	3400	87.931	0.0859193	8250	46	46		1.1897	2218	2115	15	2147	1987	14	71	128	1		2			1	1	3383	3298	27	3307	3331	21	76	-33	6		2			2	1


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