star_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 899 545 354 60.62% 11.10% 57.43%
Jericho_StarCaptain 85 55 30 64.71% 1.05% 54.55%
PatFusty_Snowman 429 250 179 58.28% 5.30% 53.61%
Ezili 235 135 100 57.45% 2.90% 51.13%
Churchill_Sentai 965 496 469 51.40% 11.91% 48.25%
Quincy_Cyber 468 246 222 52.56% 5.78% 48.04%
Etienne_Bee 800 408 392 51.00% 9.88% 47.54%
Obyn 466 241 225 51.72% 5.75% 47.18%
Gwendolin_Science 418 216 202 51.67% 5.16% 46.88%
Jericho_Highwayman 173 91 82 52.60% 2.14% 45.16%
Quincy 605 285 320 47.11% 7.47% 43.13%
Churchill 304 143 161 47.04% 3.75% 41.43%
Benjamin 246 111 135 45.12% 3.04% 38.90%
Etienne 606 257 349 42.41% 7.48% 38.47%
Gwendolin 261 113 148 43.30% 3.22% 37.28%
Bonnie 527 215 312 40.80% 6.51% 36.60%
Adora_Fateweaver 36 19 17 52.78% 0.44% 36.47%
StrikerJones 89 40 49 44.94% 1.10% 34.61%
PatFusty 56 25 31 44.64% 0.69% 31.62%
StrikerJones_Biker 56 24 32 42.86% 0.69% 29.90%
Adora 138 51 87 36.96% 1.70% 28.90%
Obyn_Ocean 110 41 69 37.27% 1.36% 28.24%
Ezili_SmudgeCat 86 30 56 34.88% 1.06% 24.81%
Benjamin_DJ 42 13 29 30.95% 0.52% 16.97%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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