CBLOL Dataset

Players stats and match history of CBLOL

@kaggle.arthur1511_cblol_2021_dataset

Table List

6 tables(2.44 MB)

Match Data 2022

@kaggle.arthur1511_cblol_2021_dataset.match_data_2022

841.98 KB
486 rows
403 columns
Only the first 100 columns are shown

gameid Gameid	teamname Teamname	top_playername Top Playername	top_champion Top Champion	top_kills Top Kills	top_deaths Top Deaths	top_assists Top Assists	top_firstbloodkill Top Firstbloodkill	top_firstbloodassist Top Firstbloodassist	top_damagetochampions Top Damagetochampions	top_dpm Top Dpm	top_damageshare Top Damageshare	top_damagetakenperminute Top Damagetakenperminute	top_damagemitigatedperminute Top Damagemitigatedperminute	top_wardsplaced Top Wardsplaced	top_wpm Top Wpm	top_wardskilled Top Wardskilled	top_wcpm Top Wcpm	top_controlwardsbought Top Controlwardsbought	top_visionscore Top Visionscore	top_vspm Top Vspm	top_totalgold Top Totalgold	top_earnedgold Top Earnedgold	top_earned_gpm Top Earned Gpm	top_earnedgoldshare Top Earnedgoldshare	top_goldspent Top Goldspent	top_total_cs Top Total Cs	top_minionkills Top Minionkills	top_monsterkills Top Monsterkills	top_cspm Top Cspm	top_goldat10 Top Goldat10	top_xpat10 Top Xpat10	top_csat10 Top Csat10	top_opp_goldat10 Top Opp Goldat10	top_opp_xpat10 Top Opp Xpat10	top_opp_csat10 Top Opp Csat10	top_golddiffat10 Top Golddiffat10	top_xpdiffat10 Top Xpdiffat10	top_csdiffat10 Top Csdiffat10	top_killsat10 Top Killsat10	top_assistsat10 Top Assistsat10	top_deathsat10 Top Deathsat10	top_opp_killsat10 Top Opp Killsat10	top_opp_assistsat10 Top Opp Assistsat10	top_opp_deathsat10 Top Opp Deathsat10	top_goldat15 Top Goldat15	top_xpat15 Top Xpat15	top_csat15 Top Csat15	top_opp_goldat15 Top Opp Goldat15	top_opp_xpat15 Top Opp Xpat15	top_opp_csat15 Top Opp Csat15	top_golddiffat15 Top Golddiffat15	top_xpdiffat15 Top Xpdiffat15	top_csdiffat15 Top Csdiffat15	top_killsat15 Top Killsat15	top_assistsat15 Top Assistsat15	top_deathsat15 Top Deathsat15	top_opp_killsat15 Top Opp Killsat15	top_opp_assistsat15 Top Opp Assistsat15	top_opp_deathsat15 Top Opp Deathsat15	jng_playername Jng Playername	jng_champion Jng Champion	jng_kills Jng Kills	jng_deaths Jng Deaths	jng_assists Jng Assists	jng_firstbloodkill Jng Firstbloodkill	jng_firstbloodassist Jng Firstbloodassist	jng_firstbloodvictim Jng Firstbloodvictim	jng_damagetochampions Jng Damagetochampions	jng_dpm Jng Dpm	jng_damageshare Jng Damageshare	jng_damagetakenperminute Jng Damagetakenperminute	jng_damagemitigatedperminute Jng Damagemitigatedperminute	jng_wardsplaced Jng Wardsplaced	jng_wpm Jng Wpm	jng_wardskilled Jng Wardskilled	jng_wcpm Jng Wcpm	jng_controlwardsbought Jng Controlwardsbought	jng_visionscore Jng Visionscore	jng_vspm Jng Vspm	jng_totalgold Jng Totalgold	jng_earnedgold Jng Earnedgold	jng_earned_gpm Jng Earned Gpm	jng_earnedgoldshare Jng Earnedgoldshare	jng_goldspent Jng Goldspent	jng_total_cs Jng Total Cs	jng_minionkills Jng Minionkills	jng_monsterkills Jng Monsterkills	jng_cspm Jng Cspm	jng_goldat10 Jng Goldat10	jng_xpat10 Jng Xpat10	jng_csat10 Jng Csat10	jng_opp_goldat10 Jng Opp Goldat10	jng_opp_xpat10 Jng Opp Xpat10	jng_opp_csat10 Jng Opp Csat10
ESPORTSTMNT01_2695708	LOUD	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	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
ESPORTSTMNT01_2695708	FURIA	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	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
ESPORTSTMNT01_2695774	Netshoes Miners	DoRun	Tryndamere	6		7			16632	463.7175	0.215714	773.0855	677.5929	13	0.3625	11	0.3067	8	46	1.2825	16682	12016	335.0186	0.244158	15900	335	304	31	9.3401	3190	4711	82	3630	4901	88	-440	-190	-6				1			5106	7335	121	5485	7442	139	-379	-107	-18	1	2		1			Croc	Viego	9	2	6			1	14997	418.132	0.194509	869.9164	578.2249	16	0.4461	14	0.3903	20	59	1.645	14921	10255	285.9201	0.208376	13050	205	30	175	5.7156	3163	3669	65	3377	3675	70
ESPORTSTMNT01_2695774	Flamengo Esports	Boal	Gwen	2	3	2	1		16705	465.7528	0.315052	622.4721	844.1822	17	0.474	6	0.1673	5	37	1.0316	14294	9628	268.4387	0.26869	14225	342	334	8	9.5353	3630	4901	88	3190	4711	82	440	190	6	1						5485	7442	139	5106	7335	121	379	107	18	1			1	2		asta	Xin Zhao	1	5	3		1		8724	243.2342	0.164532	992.0353	718.2435	12	0.3346	15	0.4182	13	50	1.3941	10584	5918	165	0.165156	11225	203	32	171	5.6599	3377	3675	70	3163	3669	65
ESPORTSTMNT01_2695807	KaBuM! e-Sports	Parang	Graves	4	2	6			21982	831.0775	0.333237	740.8318	762.0416	13	0.4915	2	0.0756	5	24	0.9074	11485	7971	301.3611	0.237627	9800	234	206	28	8.8469	3638	5043	82	3255	4685	80	383	358	2	1	1	1		1	1	5178	7754	129	4894	7403	128	284	351	1	1	1	1		1	1	Wiz	Lee Sin	2	2	11			1	10075	380.9074	0.152733	1019.8866	910.4348	13	0.4915	7	0.2647	6	25	0.9452	8938	5424	205.0662	0.161699	7700	146	20	126	5.5198	2776	3190	54	3139	3240	62
ESPORTSTMNT01_2695807	INTZ	Tyrin	Gwen	1	2	2		1	12651	478.2987	0.270072	688.3932	649.9811	13	0.4915	4	0.1512	5	29	1.0964	9169	5655	213.7996	0.249623	8275	229	228	1	8.6578	3255	4685	80	3638	5043	82	-383	-358	-2		1	1	1	1	1	4894	7403	128	5178	7754	129	-284	-351	-1		1	1	1	1	1	Yampi	Xin Zhao	1	4	4		1		5787	218.7902	0.12354	1064.3856	621.7769	8	0.3025	10	0.3781	8	38	1.4367	7912	4398	166.276	0.194138	7575	148	21	127	5.5955	3139	3240	62	2776	3190	54
ESPORTSTMNT01_2695835	Rensga eSports	Ayel	Gragas	1	3	9			16083	413.0908	0.159511	892.3202	1500.2825	13	0.3339	19	0.488	9	66	1.6952	13903	8863	227.6455	0.190844	12875	264	249	15	6.7808	2901	4213	65	3667	4302	80	-766	-89	-15		1	1	1	2		4700	6812	110	5552	7449	136	-852	-637	-26		1	1	1	2		Minerva	Viego	5	2	6				14479	371.8921	0.143602	971.5068	754.5462	15	0.3853	22	0.5651	20	70	1.7979	14506	9466	243.1336	0.203829	13450	229	48	181	5.8818	3549	3352	70	3826	3724	70
ESPORTSTMNT01_2695835	RED Canids	Guigo	Gwen	7	3	3			33088	849.863	0.431727	813.0565	632.6199	20	0.5137	14	0.3596	7	86	2.2089	17637	12597	323.5531	0.272617	14925	343	323	20	8.8099	3667	4302	80	2901	4213	65	766	89	15	1	2			1	1	5552	7449	136	4700	6812	110	852	637	26	1	2			1	1	Aegis	Xin Zhao	1	3	12	1			10379	266.5839	0.135424	1230.2568	888.5445	14	0.3596	6	0.1541	14	44	1.1301	13327	8287	212.851	0.179341	12800	248	28	220	6.3699	3826	3724	70	3549	3352	70
ESPORTSTMNT01_2696159	Liberty	Kiari	Graves	1		2		1	9140	331.3595	0.18934	451.5045	595.142	12	0.435	6	0.2175	3	26	0.9426	12284	8633	312.9789	0.235349	10175	271	235	36	9.8248	4491	5141	83	2952	4134	75	1539	1007	8	1	1				2	6598	7410	130	4994	7197	134	1604	213	-4	1	1				2	Disamis	Jarvan IV	1	1	8		1		5308	192.435	0.109958	830.4653	650.429	4	0.145	13	0.4713	4	35	1.2689	10393	6742	244.423	0.183795	8850	157	25	132	5.6918	3716	4017	64	2867	3039	61
ESPORTSTMNT01_2696159	Rensga eSports	Ayel	Jayce	1	6	1			8479	307.3958	0.226245	649.8852	424.4592	10	0.3625	7	0.2538	7	26	0.9426	10449	6798	246.4532	0.268447	10375	262	242	20	9.4985	2952	4134	75	4491	5141	83	-1539	-1007	-8			2	1	1		4994	7197	134	6598	7410	130	-1604	-213	4			2	1	1		Minerva	Viego	1	2	1				1167	42.3082	0.0311391	786.7069	424.9305	6	0.2175	11	0.3988	8	39	1.4139	7671	4020	145.7402	0.158739	7500	145	30	115	5.2568	2867	3039	61	3716	4017	64


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