koru_heroes (view)

20 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 132 85 47 64.39% 3.59% 56.23%
Quincy_Cyber 840 487 353 57.98% 22.88% 54.64%
Adora_Fateweaver 58 37 21 63.79% 1.58% 51.42%
Benjamin 108 64 44 59.26% 2.94% 49.99%
Jericho_Highwayman 139 80 59 57.55% 3.79% 49.34%
StrikerJones_Biker 94 53 41 56.38% 2.56% 46.36%
Quincy 482 240 242 49.79% 13.13% 45.33%
Etienne_Bee 452 219 233 48.45% 12.31% 43.84%
Jericho 275 129 146 46.91% 7.49% 41.01%
Ezili 116 58 58 50.00% 3.16% 40.90%
Obyn 73 34 39 46.58% 1.99% 35.13%
Etienne 298 119 179 39.93% 8.12% 34.37%
PatFusty 46 22 24 47.83% 1.25% 33.39%
Jericho_StarCaptain 39 19 20 48.72% 1.06% 33.03%
Gwendolin_Science 91 39 52 42.86% 2.48% 32.69%
Bonnie 132 51 81 38.64% 3.59% 30.33%
Churchill 42 17 25 40.48% 1.14% 25.63%
Adora 55 20 35 36.36% 1.50% 23.65%
StrikerJones 49 17 32 34.69% 1.33% 21.37%
Gwendolin 70 22 48 31.43% 1.91% 20.55%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW koru_heroes AS 
WITH koru AS
    (SELECT *
    FROM matches
    WHERE map = 'koru')
SELECT Hero,
       Games,
       Wins,
       Losses,
       printf('%.2f%%', WR * 100)                                          AS Winrate,
       printf('%.2f%%', PR * 100)                                          AS Pickrate,
       printf('%.2f%%', (WR - 1.96 * SQRT((WR * (1 - WR)) / Games)) * 100) AS Winrate_LowerBound_95CI
FROM (SELECT Hero,
             Games,
             Wins,
             Losses,
             CAST(Wins AS REAL) / Games AS WR,
             CAST(Games AS REAL) / (
                 (SELECT COUNT(*)
                  FROM koru) * 2)    AS PR
      FROM (SELECT Hero,
                   SUM(Win) + SUM(NOT Win) AS Games,
                   SUM(Win)                AS Wins,
                   SUM(NOT Win)            AS Losses
            FROM (SELECT lHero             AS Hero,
                         playerLeftWin     AS Win
                  FROM koru
                  UNION ALL
                  SELECT rHero             AS Hero,
                         NOT playerLeftWin AS Win
                  FROM koru)
            GROUP BY Hero))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;