Dataset: League Of Legends Worlds (2011-2022) Stats

About this Dataset

League Of Legends Worlds (2011-2022) Stats

League of Legends is a multiplayer online battle arena (MOBA) genre video game developed by Riot Games. For a long time I had fun playing this game and one night thinking of some Data project that I could do in my spare time, the idea of the project came up. So I created a bot to scrape data from pages that I always follow to see data from championship matches.

All data came from data scraping from https://lol.fandom.com/ website. With the bots I created I managed to form 3 different files:

Historical match data, whether play-in or main event;
Historical data regarding the players of each team and their main statistics;
Historical data regarding the champions used in each year and their main statistics.

All data is public knowledge. I hope they are useful to you in some way.

Tables

Champions Stats

@kaggle.pedrocsar_league_of_legends_worlds_20112022_stats.champions_stats

67.46 KB
1345 rows
24 columns


CREATE TABLE champions_stats (
  "season" BIGINT,
  "event" VARCHAR,
  "champion" VARCHAR,
  "games_contests" BIGINT,
  "pick_ban_ratio" DOUBLE,
  "banned_games" DOUBLE,
  "played_games" BIGINT,
  "played_by_number_of_players" DOUBLE,
  "win" BIGINT,
  "lose" 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" DOUBLE,
  "damage" DOUBLE,
  "damage_min" DOUBLE,
  "kill_participation" DOUBLE,
  "kill_share" DOUBLE,
  "gold_share" DOUBLE
);

Matchs Stats

@kaggle.pedrocsar_league_of_legends_worlds_20112022_stats.matchs_stats

87.36 KB
1070 rows
37 columns


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

Players Stats

@kaggle.pedrocsar_league_of_legends_worlds_20112022_stats.players_stats

63.23 KB
1283 rows
21 columns


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