off_tide_heroes (view)

23 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
PatFusty_Snowman 478 304 174 63.60% 8.23% 59.28%
Benjamin 225 134 91 59.56% 3.87% 53.14%
Etienne_Bee 934 504 430 53.96% 16.08% 50.76%
StrikerJones_Biker 159 90 69 56.60% 2.74% 48.90%
Quincy_Cyber 583 307 276 52.66% 10.04% 48.61%
Jericho_StarCaptain 82 48 34 58.54% 1.41% 47.87%
Quincy 507 264 243 52.07% 8.73% 47.72%
Jericho_Highwayman 135 73 62 54.07% 2.32% 45.67%
PatFusty 83 45 38 54.22% 1.43% 43.50%
Jericho 328 159 169 48.48% 5.65% 43.07%
Etienne 581 270 311 46.47% 10.00% 42.42%
Ezili 176 85 91 48.30% 3.03% 40.91%
Gwendolin_Science 277 124 153 44.77% 4.77% 38.91%
Bonnie 321 138 183 42.99% 5.53% 37.57%
Obyn_Ocean 123 52 71 42.28% 2.12% 33.55%
Adora 140 58 82 41.43% 2.41% 33.27%
Churchill_Sentai 149 57 92 38.26% 2.57% 30.45%
Gwendolin 165 62 103 37.58% 2.84% 30.19%
StrikerJones 102 38 64 37.25% 1.76% 27.87%
Obyn 82 30 52 36.59% 1.41% 26.16%
Churchill 76 28 48 36.84% 1.31% 26.00%
Ezili_SmudgeCat 36 14 22 38.89% 0.62% 22.96%
Adora_Fateweaver 39 14 25 35.90% 0.67% 20.84%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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