off_tide_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Winrate_LowerBound_95CI

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Etienne_Bee 1269 705 564 55.56% 18.35% 52.82%
Quincy_Cyber 262 154 108 58.78% 3.79% 52.82%
Jericho 551 310 241 56.26% 7.97% 52.12%
Jericho_StarCaptain 140 82 58 58.57% 2.02% 50.41%
Quincy 711 381 330 53.59% 10.28% 49.92%
Ezili 280 148 132 52.86% 4.05% 47.01%
PatFusty_Snowman 331 172 159 51.96% 4.79% 46.58%
Jericho_Highwayman 122 65 57 53.28% 1.76% 44.43%
Etienne 1113 511 602 45.91% 16.09% 42.98%
Bonnie 517 237 280 45.84% 7.48% 41.55%
Gwendolin_Science 321 147 174 45.79% 4.64% 40.34%
StrikerJones 102 50 52 49.02% 1.47% 39.32%
Benjamin 169 76 93 44.97% 2.44% 37.47%
Churchill_Sentai 135 61 74 45.19% 1.95% 36.79%
Adora 194 82 112 42.27% 2.81% 35.32%
Obyn 143 62 81 43.36% 2.07% 35.23%
Obyn_Ocean 111 46 65 41.44% 1.60% 32.28%
Gwendolin 160 61 99 38.13% 2.31% 30.60%
Adora_Fateweaver 62 25 37 40.32% 0.90% 28.11%
PatFusty 41 17 24 41.46% 0.59% 26.38%
Churchill 71 26 45 36.62% 1.03% 25.41%
StrikerJones_Biker 46 18 28 39.13% 0.67% 25.03%
Ezili_SmudgeCat 43 17 26 39.53% 0.62% 24.92%

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;