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
Jericho_StarCaptain 58 40 18 68.97% 1.36% 57.06%
Quincy_Cyber 818 467 351 57.09% 19.23% 53.70%
Jericho_Highwayman 264 157 107 59.47% 6.21% 53.55%
Quincy 698 359 339 51.43% 16.41% 47.72%
Etienne_Bee 548 282 266 51.46% 12.88% 47.28%
Jericho 357 183 174 51.26% 8.39% 46.08%
Benjamin 100 55 45 55.00% 2.35% 45.25%
PatFusty_Snowman 136 72 64 52.94% 3.20% 44.55%
Obyn_Ocean 36 20 16 55.56% 0.85% 39.32%
Ezili 179 79 100 44.13% 4.21% 36.86%
Adora_Fateweaver 61 30 31 49.18% 1.43% 36.63%
Obyn 134 60 74 44.78% 3.15% 36.36%
Bonnie 146 64 82 43.84% 3.43% 35.79%
Gwendolin_Science 85 35 50 41.18% 2.00% 30.71%
Etienne 276 99 177 35.87% 6.49% 30.21%
Ezili_SmudgeCat 36 15 21 41.67% 0.85% 25.56%
Adora 49 19 30 38.78% 1.15% 25.13%
Churchill_Sentai 60 19 41 31.67% 1.41% 19.90%
StrikerJones 31 11 20 35.48% 0.73% 18.64%
Gwendolin 79 22 57 27.85% 1.86% 17.96%

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;