CBLOL Dataset

Players stats and match history of CBLOL

@kaggle.arthur1511_cblol_2021_dataset

Table List

6 tables(2.44 MB)

Match Data 2021

@kaggle.arthur1511_cblol_2021_dataset.match_data_2021

592.12 KB
254 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_firstbloodassist Top Firstbloodassist	top_firstbloodvictim Top Firstbloodvictim	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_monsterkillsownjungle Top Monsterkillsownjungle	top_monsterkillsenemyjungle Top Monsterkillsenemyjungle	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_monsterkillsownjungle Jng Monsterkillsownjungle	jng_monsterkillsenemyjungle Jng Monsterkillsenemyjungle	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
ESPORTSTMNT03/1682154	paiN Gaming	Robo	Sion	4	5	3			15593	423.531	0.267159	962.9335	1713.5989	21	0.5704	9	0.2445	9	37	1.005	12679	7897	214.4952	0.202067	11825	269	255	14	6		7.3065	4084	4133	71	3499	4362	81	585	-229	-10	4		1	1	1		5912	6456	120	5618	6889	126	294	-433	-6	4		1	2	1		CarioK	Kindred	6	5	4			1	13643	370.5659	0.233749	865.206	468.6193	13	0.3531	22	0.5976	13	62	1.684	14889	10107	274.5224	0.258616	14175	275	68	207	141	12	7.4694	3642	3654	65	3327	2976	55
ESPORTSTMNT03/1682154	LOUD	Tay	Camille	4	1	3			19576	531.7157	0.250445	769.244	746.6455	15	0.4074	9	0.2445	3	36	0.9778	15700	10918	296.5505	0.239966	15425	320	297	23	4	12	8.6917	3499	4362	81	4084	4133	71	-585	229	10	1	1		4		1	5618	6889	126	5912	6456	120	-294	433	6	2	1		4		1	Don Arts	Taliyah	3	4	10	1			22266	604.7804	0.284859	729.588	296.4147	23	0.6247	6	0.163	8	51	1.3852	13315	8533	231.77	0.187547	11750	244	25	219	142	25	6.6274	3327	2976	55	3642	3654	65
ESPORTSTMNT03/1682203	Rensga eSports	Kiari	Camille	3	7	8		1	18464	525.0427	0.236861	994.4645	769.3934	9	0.2559	7	0.1991		22	0.6256	12901	8321	236.6161	0.236318	12583	234	221	13	4	1	6.654	2692	3599	56	3325	4271	60	-633	-672	-4		1	2	1	2	1	4407	5831	95	5037	6797	115	-630	-966	-20		2	2	1	2	2	Froststrike	Nidalee	5	3	2				11388	323.8294	0.146088	809.6588	387.8389	11	0.3128	12	0.3412	12	45	1.2796	10986	6406	182.1611	0.181932	11050	186	37	149	129		5.2891	2986	2463	48	2884	2847	54
ESPORTSTMNT03/1682203	FURIA Esports	Skeeto	Renekton	1	5	11	1		13948	396.6256	0.201505	943.4787	743.1754	15	0.4265	5	0.1422	9	34	0.9668	13016	8436	239.8863	0.190899	12025	235	226	9	7		6.6825	3325	4271	60	2692	3599	56	633	672	4	1	2	1		1	2	5037	6797	115	4407	5831	95	630	966	20	1	2	2		2	2	Follow	Taliyah	2	4	9		1		10343	294.1137	0.149424	644.9573	258.8531	12	0.3412	9	0.2559	12	52	1.4787	12571	7991	227.2322	0.180829	10500	218	19	199	126	16	6.1991	2884	2847	54	2986	2463	48
ESPORTSTMNT03/1682216	KaBuM! e-Sports	Bankai	Riven		6				4334	118.2	0.0617027	545.1	610.2	20	0.5455	3	0.0818	10	32	0.8727	10905	6141	167.4818	0.169147	10450	247	239	8	5		6.7364	2980	4533	70	3191	5010	88	-211	-477	-18							4750	7207	118	5876	7523	132	-1126	-316	-14			1	1	1		Mousty	Olaf	4	5	1	1			12437	339.1909	0.177064	854.0455	906.2727	17	0.4636	17	0.4636	18	55	1.5	11177	6413	174.9	0.176639	11000	171	40	131	95	2	4.6636	2961	3323	60	3337	3924	75
ESPORTSTMNT03/1682216	RED Canids	Guigo	Urgot	7	2	11			18183	495.9	0.242816	587.5091	694.4727	16	0.4364	17	0.4636	5	55	1.5	14949	10185	277.7727	0.225926	14825	245	240	5		1	6.6818	3191	5010	88	2980	4533	70	211	477	18							5876	7523	132	4750	7207	118	1126	316	14	1	1				1	Aegis	Lillia	2		11				10135	276.4091	0.135343	873.9818	539.1545	13	0.3545	15	0.4091	12	49	1.3364	13569	8805	240.1364	0.195315	12800	263	27	236	155	13	7.1727	3337	3924	75	2961	3323	60
ESPORTSTMNT03/1682228	INTZ	Sorry	Fiora		2	2			12687	357.7162	0.266623	545.8647	430.9398	14	0.3947	12	0.3383	7	43	1.2124	13261	8644	243.7218	0.230352	13538	337	321	16	4	4	9.5019	3076	4409	78	2956	4370	71	120	39	7							5183	7630	141	4757	7200	123	426	430	18		1					Revolta	Nidalee	5	2	1	1			9292	261.9925	0.195276	721.8327	402.8571	10	0.282	19	0.5357	13	57	1.6071	12772	8155	229.9342	0.217321	12475	223	56	167	121	12	6.2876	3523	3486	65	3833	3945	68
ESPORTSTMNT03/1682228	Cruzeiro eSports	Truklax	Volibear	2	1	6			6760	190.6015	0.122927	480.5921	838.8722	19	0.5357	8	0.2256	9	38	1.0714	12039	7422	209.2669	0.171169	11575	247	243	4			6.9643	2956	4370	71	3076	4409	78	-120	-39	-7							4757	7200	123	5183	7630	141	-426	-430	-18					1		Sting	Taliyah	3	6	10			1	17943	505.9117	0.326284	624.0226	273.7782	12	0.3383	7	0.1974	11	39	1.0996	14097	9480	267.2932	0.218629	13675	241	31	210	140	12	6.7951	3833	3945	68	3523	3486	65
ESPORTSTMNT03/1682262	Flamengo Esports	Parang	Kennen	5	1	5			16803	600.1071	0.25719	587.1429	443.6429	10	0.3571	8	0.2857	6	29	1.0357	11815	8112	289.7143	0.229074	10400	193	189	4			6.8929	3278	4384	80	2809	3785	66	469	599	14		1					6142	7172	128	4268	6189	104	1874	983	24		1				1	Ranger	Olaf	1	1	10				9208	328.8571	0.140939	1039.6071	834.3214	11	0.3929	12	0.4286	11	45	1.6071	10425	6722	240.0714	0.189823	9175	195	42	153	79	23	6.9643	3441	3358	59	3163	3374	62
ESPORTSTMNT03/1682262	Vorax Liberty	fNb	Gnar		4	2			7904	282.2857	0.204926	730.7143	477.8929	9	0.3214	6	0.2143	4	25	0.8929	7889	4186	149.5	0.191948	7300	183	178	5	3		6.5357	2809	3785	66	3278	4384	80	-469	-599	-14					1		4268	6189	104	6142	7172	128	-1874	-983	-24			1		1		Yampi	Nidalee	1	4	1		1		8951	319.6786	0.232072	991.5714	486.0714	24	0.8571	14	0.5	8	59	2.1071	8225	4522	161.5	0.207355	7850	160	19	141	103	9	5.7143	3163	3374	62	3441	3358	59


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