CBLOL Dataset

Players stats and match history of CBLOL

@kaggle.arthur1511_cblol_2021_dataset

Table List

6 tables(2.44 MB)

Players Data 2021

@kaggle.arthur1511_cblol_2021_dataset.players_data_2021

284.62 KB
1270 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	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
2796	ESPORTSTMNT03/1682154	paiN Gaming	2209		1	11.01	0.7605	top	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
2797	ESPORTSTMNT03/1682154	paiN Gaming	2209		1	11.01	0.7605	jng	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	315	678	10	1	3	2	1	4	2	5144	5852	107	5257	5423	92	-113	429	15	1	3	3	1	5	2
2798	ESPORTSTMNT03/1682154	paiN Gaming	2209		1	11.01	0.7605	mid	tinowns	Zoe	2		9				18830	511.4531	0.322619	259.7193	147.3517	16	0.4346	7	0.1901	8	48	1.3038	13519	8737	237.311	0.223561	12750	293	277	16	12		7.9584	3576	4132	76	4057	3979	68	-481	153	8		5		2	3	1	5324	7069	126	6576	6838	126	-1252	231			5		2	4	1
2799	ESPORTSTMNT03/1682154	paiN Gaming	2209		1	11.01	0.7605	bot	brTT	Samira	1	1	2				5482	148.9	0.0939245	507.2703	264.1467	12	0.3259	12	0.3259	2	38	1.0321	14229	9447	256.5957	0.241728	12100	319	314	5		1	8.6646	3534	3169	75	3251	3019	68	283	150	7	1			1	2	1	5314	5467	123	4818	5275	115	496	192	8	1			1	3	1
2800	ESPORTSTMNT03/1682154	paiN Gaming	2209		1	11.01	0.7605	sup	Luci	Alistar		4	8				4818	130.8646	0.0825481	585.6587	572.5939	64	1.7383	19	0.5161	17	104	2.8248	7675	2893	78.5785	0.0740264	7075	43	43				1.1679	2428	2332	17	2270	2193	16	158	139	1		3	2		4	2	3283	3236	22	3305	3106	24	-22	130	-2		3	2		5	2
2801	ESPORTSTMNT03/1682154	LOUD	2209	1	1	11.01	0.7605	top	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
2802	ESPORTSTMNT03/1682154	LOUD	2209	1	1	11.01	0.7605	jng	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	-315	-678	-10	1	4	2	1	3	2	5257	5423	92	5144	5852	107	113	-429	-15	1	5	2	1	3	3
2803	ESPORTSTMNT03/1682154	LOUD	2209	1	1	11.01	0.7605	mid	dyNquedo	Twisted Fate	5	1	8		1		13463	365.6768	0.172238	440.8601	283.4314	19	0.5161	8	0.2173	8	44	1.1951	17575	12793	347.4785	0.281177	15650	325	321	4	4		8.8275	4057	3979	68	3576	4132	76	481	-153	-8	2	3	1		5		6576	6838	126	5324	7069	126	1252	-231		2	4	1		5
2804	ESPORTSTMNT03/1682154	LOUD	2209	1	1	11.01	0.7605	bot	DudsTheBoy	Kai'Sa	3	4	6		1		18394	499.6107	0.235323	443.8479	218.7053	27	0.7334	7	0.1901	11	42	1.1408	14461	9679	262.8972	0.212735	12030	311	295	16	16		8.4473	3251	3019	68	3534	3169	75	-283	-150	-7	1	2	1	1			4818	5275	115	5314	5467	123	-496	-192	-8	1	3	1	1
2805	ESPORTSTMNT03/1682154	LOUD	2209	1	1	11.01	0.7605	sup	Ceos	Leona		3	13		1		4466	121.3038	0.0571355	330.4482	381.8923	67	1.8198	14	0.3803	25	116	3.1507	8357	3575	97.1028	0.0785754	7525	40	40				1.0865	2270	2193	16	2428	2332	17	-158	-139	-1		4	2		3	2	3305	3106	24	3283	3236	22	22	-130	2		5	2		3	2


CREATE TABLE players_data_2021 (
  "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" 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
);