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

Matchs Stats

@kaggle.pedrocsar_league_of_legends_worlds_20112022_stats.matchs_stats

87.36 KB
1070 rows
37 columns

season Season	date Date	event Event	blue_team Blue Team	red_team Red Team	winner Winner	ban_1_blue_team Ban 1 Blue Team	ban_2_blue_team Ban 2 Blue Team	ban_3_blue_team Ban 3 Blue Team	ban_4_blue_team Ban 4 Blue Team	ban_5_blue_team Ban 5 Blue Team	ban_1_red_team Ban 1 Red Team	ban_2_red_team Ban 2 Red Team	ban_3_red_team Ban 3 Red Team	ban_4_red_team Ban 4 Red Team	ban_5_red_team Ban 5 Red Team	pick_1_blue_team Pick 1 Blue Team	pick_2_blue_team Pick 2 Blue Team	pick_3_blue_team Pick 3 Blue Team	pick_4_blue_team Pick 4 Blue Team	pick_5_blue_team Pick 5 Blue Team	pick_1_red_team Pick 1 Red Team	pick_2_red_team Pick 2 Red Team	pick_3_red_team Pick 3 Red Team	pick_4_red_team Pick 4 Red Team	pick_5_red_team Pick 5 Red Team	top_blue_team Top Blue Team	jungler_blue_team Jungler Blue Team	mid_blue_team Mid Blue Team	adc_blue_team Adc Blue Team	support_blue_team Support Blue Team	top_red_team Top Red Team	jungler_red_team Jungler Red Team	mid_red_team Mid Red Team	adc_red_team Adc Red Team	support_red_team Support Red Team
1	Mon Jun 20 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Main	Against_All_authority	Fnatic	Fnatic	Alistar	Gragas	Anivia	nan	nan	Rumble	Nunu	Amumu	nan	nan	Malzahar	Jarvan IV	Irelia	Corki	Janna	Brand	Warwick	Karthus	Ashe	Sona	MoMa	Linak	sOAZ	YellOwStaR	Kujaa	Shushei	Cyanide	xPeke	Lamia	Mellisan
1	Mon Jun 20 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Main	Fnatic	Against_All_authority	Against_All_authority	Nunu	Warwick	Amumu	nan	nan	Gragas	Alistar	Rumble	nan	nan	Brand	Rammus	Malzahar	Corki	Janna	Irelia	Jarvan IV	Anivia	Ashe	Sona	Shushei	Cyanide	xPeke	Lamia	Mellisan	sOAZ	Linak	MoMa	YellOwStaR	Kujaa
1	Mon Jun 20 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Main	Against_All_authority	TSM	Against_All_authority	Jarvan IV	Annie	Singed	nan	nan	Rumble	Corki	Vladimir	nan	nan	Sion	Nunu	Malzahar	Vayne	Janna	Cho'Gath	Warwick	Twisted Fate	Teemo	Alistar	YellOwStaR	Linak	MoMa	sOAZ	Kujaa	Chaox	TheOddOne	Reginald	TheRainMan	Xpecial
1	Mon Jun 20 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Main	Epik_Gamer	TSM	TSM	Zilean	Vayne	Alistar	nan	nan	Akali	Vladimir	Corki	nan	nan	Singed	Amumu	Annie	Miss Fortune	Janna	Teemo	Nunu	Twisted Fate	Ashe	Taric	Dyrus	Dan Dinh	Salce	Westrice	Doublelift	TheRainMan	TheOddOne	Reginald	Chaox	Xpecial
1	Mon Jun 20 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Main	TSM	Epik_Gamer	TSM	Akali	Vladimir	Taric	nan	nan	Vayne	Zilean	Twisted Fate	nan	nan	Jarvan IV	Warwick	Annie	Corki	Alistar	Tristana	Nunu	Malzahar	Miss Fortune	Janna	TheRainMan	TheOddOne	Reginald	Chaox	Xpecial	Westrice	Dan Dinh	Salce	Dyrus	Doublelift
1	Mon Jun 20 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Main	Fnatic	Against_All_authority	Fnatic	Nunu	Warwick	Amumu	nan	nan	Alistar	Rumble	Gragas	nan	nan	Anivia	Jarvan IV	Malzahar	Ashe	Sona	Karthus	Nocturne	Annie	Corki	Janna	Shushei	Cyanide	xPeke	Lamia	Mellisan	MoMa	Linak	sOAZ	YellOwStaR	Kujaa
1	Mon Jun 20 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Main	Against_All_authority	Fnatic	Fnatic	Alistar	Ashe	Vladimir	nan	nan	Rumble	Nunu	Amumu	nan	nan	Nidalee	Warwick	Anivia	Miss Fortune	Sona	Gragas	Jarvan IV	Malzahar	Corki	Janna	sOAZ	Linak	MoMa	YellOwStaR	Kujaa	Shushei	Cyanide	xPeke	Lamia	Mellisan
1	Sun Jun 19 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Main	Fnatic	Epik_Gamer	Fnatic	Vladimir	Taric	Akali	nan	nan	Rumble	Nidalee	Amumu	nan	nan	Karthus	Jarvan IV	Alistar	Ashe	Janna	Vayne	Nunu	Malzahar	Blitzcrank	Soraka	xPeke	Cyanide	Shushei	Lamia	Mellisan	Westrice	Dan Dinh	Salce	Doublelift	Dyrus
1	Sun Jun 19 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Main	Epik_Gamer	Fnatic	Fnatic	Rumble	Nidalee	Twisted Fate	nan	nan	Vladimir	Taric	Corki	nan	nan	Jarvan IV	Nunu	Swain	Vayne	Soraka	Malzahar	Amumu	Alistar	Ashe	Janna	Dyrus	Dan Dinh	Salce	Westrice	Doublelift	xPeke	Cyanide	Shushei	Lamia	Mellisan
1	Sun Jun 19 2011 00:00:00 GMT+0000 (Coordinated Universal Time)	Main	TSM	Against_All_authority	Against_All_authority	Nidalee	Irelia	Warwick	nan	nan	Vayne	Twisted Fate	Jarvan IV	nan	nan	Singed	Nunu	Vladimir	Caitlyn	Alistar	Malzahar	Amumu	Rumble	Corki	Sona	TheRainMan	TheOddOne	Reginald	Chaox	Xpecial	MoMa	Linak	sOAZ	YellOwStaR	Kujaa


CREATE TABLE matchs_stats (
  "season" BIGINT,
  "date" TIMESTAMP,
  "event" VARCHAR,
  "patch" DOUBLE,
  "blue_team" VARCHAR,
  "red_team" VARCHAR,
  "winner" VARCHAR,
  "ban_1_blue_team" VARCHAR,
  "ban_2_blue_team" VARCHAR,
  "ban_3_blue_team" VARCHAR,
  "ban_4_blue_team" VARCHAR,
  "ban_5_blue_team" VARCHAR,
  "ban_1_red_team" VARCHAR,
  "ban_2_red_team" VARCHAR,
  "ban_3_red_team" VARCHAR,
  "ban_4_red_team" VARCHAR,
  "ban_5_red_team" VARCHAR,
  "pick_1_blue_team" VARCHAR,
  "pick_2_blue_team" VARCHAR,
  "pick_3_blue_team" VARCHAR,
  "pick_4_blue_team" VARCHAR,
  "pick_5_blue_team" VARCHAR,
  "pick_1_red_team" VARCHAR,
  "pick_2_red_team" VARCHAR,
  "pick_3_red_team" VARCHAR,
  "pick_4_red_team" VARCHAR,
  "pick_5_red_team" VARCHAR,
  "top_blue_team" VARCHAR,
  "jungler_blue_team" VARCHAR,
  "mid_blue_team" VARCHAR,
  "adc_blue_team" VARCHAR,
  "support_blue_team" VARCHAR,
  "top_red_team" VARCHAR,
  "jungler_red_team" VARCHAR,
  "mid_red_team" VARCHAR,
  "adc_red_team" VARCHAR,
  "support_red_team" VARCHAR
);