precious_space_heroes (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho_StarCaptain 53 37 16 69.81% 1.34% 57.45%
Benjamin 250 155 95 62.00% 6.34% 55.98%
Jericho 501 280 221 55.89% 12.70% 51.54%
Quincy_Cyber 528 288 240 54.55% 13.38% 50.30%
Jericho_Highwayman 164 93 71 56.71% 4.16% 49.12%
Adora_Fateweaver 71 42 29 59.15% 1.80% 47.72%
Quincy 380 196 184 51.58% 9.63% 46.55%
Etienne_Bee 460 229 231 49.78% 11.66% 45.21%
Bonnie 335 164 171 48.96% 8.49% 43.60%
Obyn 98 50 48 51.02% 2.48% 41.12%
Churchill_Sentai 69 33 36 47.83% 1.75% 36.04%
PatFusty_Snowman 32 17 15 53.13% 0.81% 35.83%
Etienne 377 147 230 38.99% 9.55% 34.07%
PatFusty 52 24 28 46.15% 1.32% 32.60%
StrikerJones 48 22 26 45.83% 1.22% 31.74%
Adora 93 38 55 40.86% 2.36% 30.87%
Obyn_Ocean 67 28 39 41.79% 1.70% 29.98%
StrikerJones_Biker 55 22 33 40.00% 1.39% 27.05%
Gwendolin_Science 44 18 26 40.91% 1.12% 26.38%
Ezili 74 27 47 36.49% 1.88% 25.52%
Gwendolin 114 39 75 34.21% 2.89% 25.50%
Churchill 42 15 27 35.71% 1.06% 21.22%

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;