off_tide_heroes (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Pickrate, Winrate_LowerBound_95CI

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 362 238 124 65.75% 5.72% 60.86%
Adora_Fateweaver 46 31 15 67.39% 0.73% 53.84%
Quincy_Cyber 1128 610 518 54.08% 17.84% 51.17%
Quincy 548 300 248 54.74% 8.67% 50.58%
Adora 173 96 77 55.49% 2.74% 48.09%
Benjamin 343 183 160 53.35% 5.42% 48.07%
Bonnie 348 185 163 53.16% 5.50% 47.92%
Etienne_Bee 590 300 290 50.85% 9.33% 46.81%
Jericho_Highwayman 241 128 113 53.11% 3.81% 46.81%
Jericho_StarCaptain 117 62 55 52.99% 1.85% 43.95%
Jericho 331 162 169 48.94% 5.23% 43.56%
StrikerJones_Biker 205 98 107 47.80% 3.24% 40.97%
Etienne 690 299 391 43.33% 10.91% 39.64%
Ezili 154 72 82 46.75% 2.44% 38.87%
StrikerJones 122 57 65 46.72% 1.93% 37.87%
Obyn 118 51 67 43.22% 1.87% 34.28%
Obyn_Ocean 127 53 74 41.73% 2.01% 33.16%
Gwendolin 96 41 55 42.71% 1.52% 32.81%
PatFusty 101 40 61 39.60% 1.60% 30.07%
Gwendolin_Science 191 69 122 36.13% 3.02% 29.31%
Churchill_Sentai 142 45 97 31.69% 2.25% 24.04%
Churchill 118 32 86 27.12% 1.87% 19.10%

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;