precious_space_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses, Winrate_LowerBound_95CI

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Benjamin_DJ 93 62 31 66.67% 2.00% 57.09%
Obyn 384 213 171 55.47% 8.26% 50.50%
Jericho 371 206 165 55.53% 7.98% 50.47%
Adora_Fateweaver 108 64 44 59.26% 2.32% 49.99%
Jericho_Highwayman 133 77 56 57.89% 2.86% 49.50%
Adora 255 141 114 55.29% 5.49% 49.19%
Quincy 276 147 129 53.26% 5.94% 47.37%
Ezili_SmudgeCat 28 18 10 64.29% 0.60% 46.54%
Benjamin 210 109 101 51.90% 4.52% 45.15%
StrikerJones 55 32 23 58.18% 1.18% 45.15%
Bonnie 695 336 359 48.35% 14.95% 44.63%
Quincy_Cyber 152 78 74 51.32% 3.27% 43.37%
Ezili 116 60 56 51.72% 2.50% 42.63%
PatFusty_Snowman 61 33 28 54.10% 1.31% 41.59%
Jericho_StarCaptain 155 76 79 49.03% 3.33% 41.16%
Etienne_Bee 360 163 197 45.28% 7.75% 40.14%
Etienne 717 305 412 42.54% 15.43% 38.92%
Gwendolin 102 45 57 44.12% 2.19% 34.48%
Gwendolin_Science 166 67 99 40.36% 3.57% 32.90%
Churchill 69 29 40 42.03% 1.48% 30.38%
PatFusty 20 10 10 50.00% 0.43% 28.09%
Obyn_Ocean 60 24 36 40.00% 1.29% 27.60%
Churchill_Sentai 48 19 29 39.58% 1.03% 25.75%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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