CBLOL Dataset

Players stats and match history of CBLOL

@kaggle.arthur1511_cblol_2021_dataset

Table List

6 tables(2.44 MB)

Team Data 2021

@kaggle.arthur1511_cblol_2021_dataset.team_data_2021

131 KB
254 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	infernals Infernals	mountains Mountains	clouds Clouds	oceans Oceans	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	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	monsterkillsownjungle Monsterkillsownjungle	monsterkillsenemyjungle Monsterkillsenemyjungle	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
2806	ESPORTSTMNT03/1682154	paiN Gaming	2209		1	11.01	0.7605	Blue	Aatrox	Galio	Akali	Syndra	Yone	13	15		0.3531		4	2		1		3			2		1	1		3	10				2	58366	1585.3146	3180.7877	3166.3105	126	3.4224	69	1.8742	49	289	7.8497	62991	39081	1061.5029	57925	-0.0740618	957	242	159	13	32.5668	17264	17420	304	16404	16529	288	860	891	16	6	11	5	5	14	6	24977	28080	498	25574	27531	483	-597	549	15	6	11	6	6	18	6
2807	ESPORTSTMNT03/1682154	LOUD	2209	1	1	11.01	0.7605	Red	Graves	Olaf	Pantheon	Hecarim	Lee Sin	15	13	1	0.4074	1	2	4	1			1	1	2		1	1	1	1	10	3	1	1	2		78165	2123.0874	2713.9882	1927.0892	151	4.1014	44	1.1951	55	289	7.8497	69408	45498	1235.799	62380	0.0740618	978	262	166	37	33.6804	16404	16529	288	17264	17420	304	-860	-891	-16	5	14	6	6	11	5	25574	27531	483	24977	28080	498	597	-549	-15	6	18	6	6	11	6
2818	ESPORTSTMNT03/1682203	Rensga eSports	2110		1	11.01	1.0237	Blue	Aphelios	Galio	Volibear	Thresh	Sett	16	20		0.455		1	4		1					2			2		3	11				3	77953	2216.673	3002.1043	2328.6256	107	3.0427	45	1.2796	48	226	6.4265	58111	35211	1001.2607	55583	-0.102289	829	206	169	1	29.4313	13874	15516	270	15288	16546	273	-1414	-1030	-3	1	4	4	4	9	1	21722	25854	444	25159	28049	491	-3437	-2195	-47	2	6	5	5	11	2
2819	ESPORTSTMNT03/1682203	FURIA Esports	2110	1	1	11.01	1.0237	Red	Akali	Pantheon	Kai'Sa	Twisted Fate	Yone	20	16	1	0.5687	1	4	1	3			1	1	2		1	2		1	11	3	1	1	3		69219	1968.3128	3012.5972	2190.1422	105	2.9858	50	1.4218	53	303	8.6161	67091	44191	1256.6161	61575	0.102289	813	244	156	17	30.0569	15288	16546	273	13874	15516	270	1414	1030	3	4	9	1	1	4	4	25159	28049	491	21722	25854	444	3437	2195	47	5	11	2	2	6	5
2830	ESPORTSTMNT03/1682216	KaBuM! e-Sports	2200		1	11.01	0.8727	Blue	Camille	Pantheon	Lucian	Thresh	Jayce	9	23	1	0.2455	1	2	4	1			1			2		1	1		4	9				2	70240	1915.6364	2790.8455	2818.9364	129	3.5182	47	1.2818	67	268	7.3091	60126	36308	990.2182	57400	-0.120344	910	210	151	18	30.5455	14482	18130	318	15170	18800	354	-688	-670	-36							23914	28756	488	25091	29032	531	-1177	-276	-43	3	8	2	2	2	3
2831	ESPORTSTMNT03/1682216	RED Canids	2200	1	1	11.01	0.8727	Red	Akali	Taliyah	Miss Fortune	Alistar	Renekton	23	9		0.6273		4	2	3		1		1	2		1	1	1	1	9	4	1	1	2		74884	2042.2909	3083.2909	2595.7636	114	3.1091	62	1.6909	49	291	7.9364	68901	45083	1229.5364	64750	0.120344	941	267	171	20	32.9455	15170	18800	354	14482	18130	318	688	670	36							25091	29032	531	23914	28756	488	1177	276	43	2	2	3	3	8	2
2842	ESPORTSTMNT03/1682228	INTZ	2128		1	11.01	0.7331	Blue	Aphelios	Pantheon	Akali	Yone	Orianna	8	19	1	0.2256		1	4				1		1	1			2		5	9				3	47584	1341.6541	2727.6598	2502.7444	125	3.5244	46	1.297	51	295	8.3177	60610	37526	1058.0639	60273	-0.0311949	945	242	172	19	33.468	15962	18072	329	17468	18663	331	-1506	-591	-2	1	1	3	3	6	1	24037	28474	513	26160	29516	537	-2123	-1042	-24	2	4	3	3	6	2
2843	ESPORTSTMNT03/1682228	Cruzeiro eSports	2128	1	1	11.01	0.7331	Red	Renekton	Lucian	Camille	LeBlanc	Aatrox	18	8		0.5075	1	4	1	1		1	2	1	1	1	1	2		1	9	5	1	1	3		54992	1550.5263	2124.3327	2023.2237	108	3.0451	42	1.1842	46	241	6.7951	66446	43362	1222.6128	62183	0.0311949	870	236	157	12	31.1842	17468	18663	331	15962	18072	329	1506	591	2	3	6	1	1	1	3	26160	29516	537	24037	28474	513	2123	1042	24	3	6	2	2	4	3
2854	ESPORTSTMNT03/1682262	Flamengo Esports	1680	1	1	11.01	0.75	Blue	Samira	Camille	Aatrox	Irelia	Lucian	18	3		0.6429	1	4			1	1	2	1	1	1	1	1		1	10	1	1	1	2		65333	2333.3214	2581.7857	2157.5357	104	3.7143	55	1.9643	48	239	8.5357	53927	35413	1264.75	46050	0.168973	713	173	87	27	31.6429	15741	17247	304	14811	16882	308	930	365	-4	3	4	1	1	3	3	26623	29840	521	22618	27112	496	4005	2728	25	5	7	1	1	3	5
2855	ESPORTSTMNT03/1682262	Vorax Liberty	1680		1	11.01	0.75	Red	Syndra	Akali	Pantheon	Jayce	Sett	3	18	1	0.1071			4						1	1			1		1	10				2	38570	1377.5	3247.5714	2257.7143	93	3.3214	37	1.3214	34	175	6.25	40323	21809	778.8929	38875	-0.168973	689	146	106	9	29.8214	14811	16882	308	15741	17247	304	-930	-365	4	1	3	3	3	4	1	22618	27112	496	26623	29840	521	-4005	-2728	-25	1	3	5	5	7	1


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