all_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 27961 16647 11314 59.54% 3.35% 58.96%
Adora_Fateweaver 9744 5532 4212 56.77% 1.17% 55.79%
Jericho 61262 34200 27062 55.83% 7.33% 55.43%
Adora 36017 19329 16688 53.67% 4.31% 53.15%
Quincy_Cyber 54777 29307 25470 53.50% 6.56% 53.08%
Jericho_StarCaptain 13643 7237 6406 53.05% 1.63% 52.21%
Jericho_Highwayman 15308 8019 7289 52.38% 1.83% 51.59%
Etienne_Bee 71128 36197 34931 50.89% 8.51% 50.52%
Obyn 34385 17394 16991 50.59% 4.12% 50.06%
Churchill_Sentai 33338 16814 16524 50.43% 3.99% 49.90%
Ezili 20674 10425 10249 50.43% 2.47% 49.74%
Benjamin 26965 13532 13433 50.18% 3.23% 49.59%
StrikerJones 10765 5434 5331 50.48% 1.29% 49.53%
StrikerJones_Biker 10866 5447 5419 50.13% 1.30% 49.19%
Quincy 58492 29004 29488 49.59% 7.00% 49.18%
Ezili_SmudgeCat 5775 2864 2911 49.59% 0.69% 48.30%
Bonnie 86698 41681 45017 48.08% 10.38% 47.74%
Gwendolin_Science 44607 21246 23361 47.63% 5.34% 47.17%
Etienne 130911 60995 69916 46.59% 15.67% 46.32%
PatFusty 9804 4614 5190 47.06% 1.17% 46.07%
Churchill 25806 11682 14124 45.27% 3.09% 44.66%
Benjamin_DJ 6304 2801 3503 44.43% 0.75% 43.21%
Obyn_Ocean 15094 6534 8560 43.29% 1.81% 42.50%
Gwendolin 25030 10742 14288 42.92% 3.00% 42.30%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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