off_tide_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 390 260 130 66.67% 5.73% 61.99%
Etienne_Bee 638 349 289 54.70% 9.37% 50.84%
Bonnie 698 371 327 53.15% 10.25% 49.45%
Jericho_StarCaptain 253 138 115 54.55% 3.72% 48.41%
Jericho 416 214 202 51.44% 6.11% 46.64%
Jericho_Highwayman 97 54 43 55.67% 1.42% 45.78%
Benjamin 230 119 111 51.74% 3.38% 45.28%
Etienne 1494 712 782 47.66% 21.94% 45.12%
Gwendolin_Science 571 274 297 47.99% 8.39% 43.89%
Adora 212 104 108 49.06% 3.11% 42.33%
Ezili 190 91 99 47.89% 2.79% 40.79%
Obyn 225 105 120 46.67% 3.30% 40.15%
PatFusty 110 54 56 49.09% 1.62% 39.75%
Benjamin_DJ 91 45 46 49.45% 1.34% 39.18%
StrikerJones 85 42 43 49.41% 1.25% 38.78%
Quincy 254 111 143 43.70% 3.73% 37.60%
Obyn_Ocean 189 84 105 44.44% 2.78% 37.36%
Quincy_Cyber 175 76 99 43.43% 2.57% 36.08%
Adora_Fateweaver 74 35 39 47.30% 1.09% 35.92%
Gwendolin 162 68 94 41.98% 2.38% 34.38%
StrikerJones_Biker 33 16 17 48.48% 0.48% 31.43%
Churchill 109 43 66 39.45% 1.60% 30.27%
Ezili_SmudgeCat 43 17 26 39.53% 0.63% 24.92%
Churchill_Sentai 69 22 47 31.88% 1.01% 20.89%

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;