star_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses, Winrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 926 577 349 62.31% 12.68% 59.19%
PatFusty_Snowman 334 189 145 56.59% 4.58% 51.27%
Benjamin 316 171 145 54.11% 4.33% 48.62%
Quincy_Cyber 557 289 268 51.89% 7.63% 47.74%
Etienne_Bee 668 339 329 50.75% 9.15% 46.96%
Quincy 487 250 237 51.33% 6.67% 46.90%
Gwendolin_Science 455 234 221 51.43% 6.23% 46.84%
Churchill_Sentai 577 276 301 47.83% 7.90% 43.76%
Jericho_Highwayman 150 77 73 51.33% 2.05% 43.33%
Bonnie 447 211 236 47.20% 6.12% 42.58%
Obyn 253 122 131 48.22% 3.47% 42.06%
StrikerJones 116 58 58 50.00% 1.59% 40.90%
StrikerJones_Biker 227 104 123 45.81% 3.11% 39.33%
Gwendolin 271 121 150 44.65% 3.71% 38.73%
Etienne 556 233 323 41.91% 7.62% 37.81%
Adora_Fateweaver 64 32 32 50.00% 0.88% 37.75%
PatFusty 127 58 69 45.67% 1.74% 37.01%
Adora 120 54 66 45.00% 1.64% 36.10%
Ezili 171 73 98 42.69% 2.34% 35.28%
Jericho_StarCaptain 77 35 42 45.45% 1.05% 34.33%
Obyn_Ocean 113 46 67 40.71% 1.55% 31.65%
Churchill 180 64 116 35.56% 2.47% 28.56%
Ezili_SmudgeCat 39 17 22 43.59% 0.53% 28.03%
Benjamin_DJ 69 20 49 28.99% 0.95% 18.28%

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;