League Of Legends Worlds (2011-2022) Stats

League of Legends Worlds Championship data (2011-2022)

@kaggle.pedrocsar_league_of_legends_worlds_20112022_stats

Table List

3 tables(218.05 KB)

Champions Stats

Matchs Stats

Players Stats

Players Stats

@kaggle.pedrocsar_league_of_legends_worlds_20112022_stats.players_stats

63.23 KB
1283 rows
21 columns

season Season	event Event	team Team	player Player	games_played Games Played	wins Wins	loses Loses	win_rate Win Rate	kills Kills	deaths Deaths	assists Assists	kill_death_assist_ratio Kill Death Assist Ratio	creep_score Creep Score	cs_min Cs/min	gold Gold	gold_min Gold/min
1	Main	Against_All_authority	Kujaa	12	7	5	58.3	0.25	2.58	8.33	3.32	13.58	0.34	7.8	198
1	Main	Against_All_authority	Linak	12	7	5	58.3	1.75	3.58	7.67	2.63	113.17	2.86	10.3	259
1	Main	Against_All_authority	MoMa	12	7	5	58.3	4.17	2.75	5.58	3.55	242.25	6.13	12.1	307
1	Main	Against_All_authority	sOAZ	12	7	5	58.3	4	2.92	7.08	3.8	214.67	5.43	11.6	293
1	Main	Against_All_authority	YellOwStaR	12	7	5	58.3	3.75	3.25	5.17	2.74	276.33	6.99	13.2	333
1	Main	Counter_Logic_Gaming	bigfatlp	6	3	3	50	2.5	2.5	5.33	3.13	191.17	5.37	9.8	275
1	Main	Counter_Logic_Gaming	Chauster	6	3	3	50	3.17	1.67	2.5	3.4	221	6.21	10.4	293
1	Main	Counter_Logic_Gaming	Elementz	6	3	3	50	1	2.33	6.33	3.14	50.67	1.42	7.1	200
1	Main	Counter_Logic_Gaming	HotshotGG	6	3	3	50	1.83	2.67	3.83	2.13	188.83	5.31	9.7	273
1	Main	Counter_Logic_Gaming	Saintvicious	6	3	3	50	2.5	2.67	5	2.81	112	3.15	9.2	258


CREATE TABLE players_stats (
  "season" BIGINT,
  "event" VARCHAR,
  "team" VARCHAR,
  "player" VARCHAR,
  "games_played" BIGINT,
  "wins" BIGINT,
  "loses" BIGINT,
  "win_rate" DOUBLE,
  "kills" DOUBLE,
  "deaths" DOUBLE,
  "assists" DOUBLE,
  "kill_death_assist_ratio" DOUBLE,
  "creep_score" DOUBLE,
  "cs_min" DOUBLE,
  "gold" DOUBLE,
  "gold_min" BIGINT,
  "damage" DOUBLE,
  "damage_min" DOUBLE,
  "kill_participation" DOUBLE,
  "kill_share" DOUBLE,
  "gold_share" DOUBLE
);