glade_heroes (view)

20 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora 311 219 92 70.42% 9.36% 65.35%
Churchill 342 188 154 54.97% 10.30% 49.70%
PatFusty_Snowman 68 41 27 60.29% 2.05% 48.66%
Adora_Fateweaver 68 40 28 58.82% 2.05% 47.13%
Quincy 213 113 100 53.05% 6.41% 46.35%
Benjamin 90 49 41 54.44% 2.71% 44.16%
Churchill_Sentai 208 104 104 50.00% 6.26% 43.20%
Etienne_Bee 230 112 118 48.70% 6.92% 42.24%
Benjamin_DJ 36 21 15 58.33% 1.08% 42.23%
Bonnie 349 161 188 46.13% 10.51% 40.90%
Etienne 658 290 368 44.07% 19.81% 40.28%
Jericho 191 88 103 46.07% 5.75% 39.00%
Jericho_StarCaptain 65 31 34 47.69% 1.96% 35.55%
Quincy_Cyber 85 39 46 45.88% 2.56% 35.29%
Obyn 68 32 36 47.06% 2.05% 35.20%
Gwendolin 67 29 38 43.28% 2.02% 31.42%
Obyn_Ocean 37 16 21 43.24% 1.11% 27.28%
PatFusty 30 13 17 43.33% 0.90% 25.60%
Gwendolin_Science 121 41 80 33.88% 3.64% 25.45%
Jericho_Highwayman 28 11 17 39.29% 0.84% 21.20%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW glade_heroes AS 
WITH glade AS
    (SELECT *
    FROM matches
    WHERE map = 'glade')
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 glade) * 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 glade
                  UNION ALL
                  SELECT rHero             AS Hero,
                         NOT playerLeftWin AS Win
                  FROM glade)
            GROUP BY Hero))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;