precious_space_heroes (view)

21 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 75 50 25 66.67% 1.93% 56.00%
Adora 214 126 88 58.88% 5.50% 52.29%
Jericho 324 183 141 56.48% 8.32% 51.08%
Quincy 288 163 125 56.60% 7.40% 50.87%
Ezili 61 38 23 62.30% 1.57% 50.13%
Jericho_Highwayman 71 43 28 60.56% 1.82% 49.20%
Adora_Fateweaver 72 43 29 59.72% 1.85% 48.39%
Bonnie 606 314 292 51.82% 15.57% 47.84%
Obyn 332 175 157 52.71% 8.53% 47.34%
Benjamin 305 144 161 47.21% 7.84% 41.61%
Etienne 611 277 334 45.34% 15.70% 41.39%
Etienne_Bee 256 114 142 44.53% 6.58% 38.44%
Jericho_StarCaptain 74 35 39 47.30% 1.90% 35.92%
Quincy_Cyber 51 25 26 49.02% 1.31% 35.30%
Gwendolin_Science 129 53 76 41.09% 3.31% 32.60%
Obyn_Ocean 62 27 35 43.55% 1.59% 31.21%
Benjamin_DJ 40 18 22 45.00% 1.03% 29.58%
StrikerJones 46 20 26 43.48% 1.18% 29.15%
Gwendolin 106 38 68 35.85% 2.72% 26.72%
Churchill_Sentai 61 22 39 36.07% 1.57% 24.02%
Churchill 45 10 35 22.22% 1.16% 10.08%

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;