koru_heroes (view)

21 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Winrate, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 103 68 35 66.02% 2.55% 56.87%
Quincy_Cyber 1336 778 558 58.23% 33.05% 55.59%
Benjamin 175 105 70 60.00% 4.33% 52.74%
Adora 90 55 35 61.11% 2.23% 51.04%
Quincy 465 231 234 49.68% 11.50% 45.13%
Etienne_Bee 257 130 127 50.58% 6.36% 44.47%
Ezili 84 45 39 53.57% 2.08% 42.91%
Adora_Fateweaver 64 34 30 53.13% 1.58% 40.90%
Bonnie 137 66 71 48.18% 3.39% 39.81%
Jericho_Highwayman 154 73 81 47.40% 3.81% 39.52%
Jericho 236 102 134 43.22% 5.84% 36.90%
StrikerJones 59 27 32 45.76% 1.46% 33.05%
Etienne 351 126 225 35.90% 8.68% 30.88%
StrikerJones_Biker 59 25 34 42.37% 1.46% 29.76%
PatFusty 39 16 23 41.03% 0.96% 25.59%
Gwendolin_Science 84 30 54 35.71% 2.08% 25.47%
Jericho_StarCaptain 58 22 36 37.93% 1.43% 25.44%
Gwendolin 69 25 44 36.23% 1.71% 24.89%
Churchill 56 20 36 35.71% 1.39% 23.16%
Obyn 69 19 50 27.54% 1.71% 17.00%
Churchill_Sentai 44 11 33 25.00% 1.09% 12.21%

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;