off_tide_heroes (view)

24 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 247 172 75 69.64% 3.73% 63.90%
Ezili_SmudgeCat 79 53 26 67.09% 1.19% 56.73%
Obyn 277 166 111 59.93% 4.18% 54.16%
Jericho 307 175 132 57.00% 4.63% 51.47%
Jericho_Highwayman 113 68 45 60.18% 1.71% 51.15%
Adora 291 162 129 55.67% 4.39% 49.96%
Etienne 1459 736 723 50.45% 22.03% 47.88%
Benjamin 105 60 45 57.14% 1.59% 47.68%
Adora_Fateweaver 63 37 26 58.73% 0.95% 46.57%
Jericho_StarCaptain 97 53 44 54.64% 1.46% 44.73%
Ezili 175 90 85 51.43% 2.64% 44.02%
Quincy 291 143 148 49.14% 4.39% 43.40%
Etienne_Bee 790 367 423 46.46% 11.93% 42.98%
Quincy_Cyber 169 84 85 49.70% 2.55% 42.17%
Bonnie 738 337 401 45.66% 11.14% 42.07%
Gwendolin_Science 705 303 402 42.98% 10.64% 39.32%
Benjamin_DJ 37 20 17 54.05% 0.56% 38.00%
PatFusty 117 53 64 45.30% 1.77% 36.28%
Churchill 111 49 62 44.14% 1.68% 34.91%
Obyn_Ocean 132 56 76 42.42% 1.99% 33.99%
StrikerJones_Biker 46 22 24 47.83% 0.69% 33.39%
Gwendolin 183 70 113 38.25% 2.76% 31.21%
StrikerJones 38 17 21 44.74% 0.57% 28.93%
Churchill_Sentai 54 19 35 35.19% 0.82% 22.45%

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;