cobra_command_heroes (view)

24 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
Ezili_SmudgeCat 49 34 15 69.39% 0.89% 56.48%
Jericho 241 145 96 60.17% 4.37% 53.99%
Jericho_Highwayman 92 57 35 61.96% 1.67% 52.04%
Etienne 1619 851 768 52.56% 29.35% 50.13%
Quincy 207 115 92 55.56% 3.75% 48.79%
Etienne_Bee 886 461 425 52.03% 16.06% 48.74%
Bonnie 591 303 288 51.27% 10.71% 47.24%
PatFusty_Snowman 138 76 62 55.07% 2.50% 46.77%
Jericho_StarCaptain 80 43 37 53.75% 1.45% 42.82%
Quincy_Cyber 115 57 58 49.57% 2.08% 40.43%
StrikerJones_Biker 45 24 21 53.33% 0.82% 38.76%
Obyn 149 68 81 45.64% 2.70% 37.64%
Obyn_Ocean 90 42 48 46.67% 1.63% 36.36%
Adora 195 82 113 42.05% 3.54% 35.12%
Adora_Fateweaver 59 28 31 47.46% 1.07% 34.72%
Churchill 97 43 54 44.33% 1.76% 34.44%
Gwendolin_Science 352 138 214 39.20% 6.38% 34.10%
Ezili 114 48 66 42.11% 2.07% 33.04%
StrikerJones 77 33 44 42.86% 1.40% 31.80%
Gwendolin 107 35 72 32.71% 1.94% 23.82%
Benjamin_DJ 29 12 17 41.38% 0.53% 23.45%
Churchill_Sentai 46 17 29 36.96% 0.83% 23.01%
PatFusty 74 25 49 33.78% 1.34% 23.01%
Benjamin 64 21 43 32.81% 1.16% 21.31%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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