splashdown_heroes (view)

21 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
Quincy_Cyber 825 493 332 59.76% 28.21% 56.41%
Obyn 63 42 21 66.67% 2.15% 55.03%
StrikerJones_Biker 134 74 60 55.22% 4.58% 46.80%
Bonnie 328 166 162 50.61% 11.22% 45.20%
Etienne_Bee 194 94 100 48.45% 6.63% 41.42%
Adora 94 48 46 51.06% 3.21% 40.96%
Ezili 44 24 20 54.55% 1.50% 39.83%
Quincy 243 110 133 45.27% 8.31% 39.01%
PatFusty 55 28 27 50.91% 1.88% 37.70%
PatFusty_Snowman 23 13 10 56.52% 0.79% 36.26%
Jericho_StarCaptain 46 23 23 50.00% 1.57% 35.55%
Jericho 156 67 89 42.95% 5.34% 35.18%
Churchill_Sentai 73 34 39 46.58% 2.50% 35.13%
Etienne 299 112 187 37.46% 10.23% 31.97%
Churchill 57 25 32 43.86% 1.95% 30.98%
Jericho_Highwayman 36 16 20 44.44% 1.23% 28.21%
Adora_Fateweaver 28 13 15 46.43% 0.96% 27.96%
Obyn_Ocean 41 17 24 41.46% 1.40% 26.38%
Gwendolin_Science 33 13 20 39.39% 1.13% 22.72%
Benjamin 34 12 22 35.29% 1.16% 19.23%
Gwendolin 55 17 38 30.91% 1.88% 18.70%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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