koru_heroes (view)

20 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 309 191 118 61.81% 9.44% 56.40%
Adora_Fateweaver 133 85 48 63.91% 4.06% 55.75%
Benjamin 118 74 44 62.71% 3.61% 53.99%
Ezili 163 92 71 56.44% 4.98% 48.83%
Quincy 317 166 151 52.37% 9.69% 46.87%
Adora 107 59 48 55.14% 3.27% 45.72%
Etienne_Bee 279 143 136 51.25% 8.53% 45.39%
Jericho 260 132 128 50.77% 7.95% 44.69%
StrikerJones_Biker 28 17 11 60.71% 0.86% 42.62%
Etienne 601 271 330 45.09% 18.37% 41.11%
Jericho_StarCaptain 92 47 45 51.09% 2.81% 40.87%
Quincy_Cyber 109 54 55 49.54% 3.33% 40.15%
Jericho_Highwayman 51 26 25 50.98% 1.56% 37.26%
Bonnie 171 74 97 43.27% 5.23% 35.85%
Gwendolin 124 54 70 43.55% 3.79% 34.82%
Gwendolin_Science 127 48 79 37.80% 3.88% 29.36%
StrikerJones 47 19 28 40.43% 1.44% 26.40%
PatFusty 42 15 27 35.71% 1.28% 21.22%
Churchill 35 12 23 34.29% 1.07% 18.56%
Obyn 73 21 52 28.77% 2.23% 18.38%

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;