League Of Legends Worlds (2011-2022) Stats
League of Legends Worlds Championship data (2011-2022)
@kaggle.pedrocsar_league_of_legends_worlds_20112022_stats
Champions Stats
@kaggle.pedrocsar_league_of_legends_worlds_20112022_stats.champions_stats
- 67.46 KB
- 1345 rows
- 24 columns
seasonSeason | eventEvent | championChampion | games_contestsGames Contests | pick_ban_ratioPick Ban Ratio | banned_gamesBanned Games | played_gamesPlayed Games | played_by_number_of_playersPlayed By Number Of Players | winWin | loseLose | win_rateWin Rate | killsKills | deathsDeaths | assistsAssists | kill_death_assist_ratioKill Death Assist Ratio | creep_scoreCreep Score | cs_minCs/min | goldGold | gold_minGold/min | damageDamage | damage_minDamage/min | kill_participationKill Participation | kill_shareKill Share | gold_shareGold Share |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Main | Nunu | 27 | 96.4 | 9 | 18 | 6 | 12 | 6 | 66.7 | 1.06 | 2.67 | 8.61 | 3.63 | 90.17 | 2.46 | 9.4 | 256 | |||||
| 1 | Main | Alistar | 25 | 89.3 | 12 | 13 | 4 | 8 | 5 | 61.5 | 3.46 | 2.69 | 7.38 | 4.03 | 114 | 3.11 | 9.6 | 261 | |||||
| 1 | Main | Rumble | 23 | 82.1 | 21 | 2 | 2 | 2 | 100 | 3.5 | 1.5 | 9 | 8.33 | 162 | 5.02 | 10.1 | 311 | ||||||
| 1 | Main | Vladimir | 22 | 78.6 | 14 | 8 | 5 | 3 | 5 | 37.5 | 4.5 | 3.5 | 3.88 | 2.39 | 224.63 | 5.99 | 11.2 | 298 | |||||
| 1 | Main | Twisted Fate | 22 | 78.6 | 18 | 4 | 2 | 2 | 2 | 50 | 2 | 4.5 | 5.5 | 1.67 | 206.5 | 5.43 | 11.4 | 299 | |||||
| 1 | Main | Corki | 20 | 71.4 | 5 | 15 | 8 | 8 | 7 | 53.3 | 4.67 | 2.73 | 4.27 | 3.27 | 266.13 | 7.07 | 12.6 | 334 | |||||
| 1 | Main | Jarvan IV | 20 | 71.4 | 7 | 13 | 5 | 8 | 5 | 61.5 | 2.77 | 2.77 | 10 | 4.61 | 152.77 | 3.75 | 12.5 | 306 | |||||
| 1 | Main | Vayne | 20 | 71.4 | 12 | 8 | 5 | 4 | 4 | 50 | 5.75 | 4.38 | 5.5 | 2.57 | 228.75 | 6.1 | 12.1 | 322 | |||||
| 1 | Main | Janna | 19 | 67.9 | 1 | 18 | 6 | 10 | 8 | 55.6 | 0.28 | 2.33 | 9.5 | 4.19 | 25.06 | 0.63 | 8.1 | 204 | |||||
| 1 | Main | Ashe | 19 | 67.9 | 2 | 17 | 8 | 13 | 4 | 76.5 | 4.29 | 2.18 | 7 | 5.19 | 244 | 6.26 | 13.2 | 340 |
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
);