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 4939 2853 2086 57.76% 4.38% 56.39%
Jericho 8965 5118 3847 57.09% 7.96% 56.06%
Quincy_Cyber 4840 2695 2145 55.68% 4.30% 54.28%
Jericho_StarCaptain 1849 1015 834 54.89% 1.64% 52.63%
Adora 4788 2577 2211 53.82% 4.25% 52.41%
Etienne_Bee 13269 6944 6325 52.33% 11.78% 51.48%
Adora_Fateweaver 1388 745 643 53.67% 1.23% 51.05%
Churchill_Sentai 4889 2465 2424 50.42% 4.34% 49.02%
Obyn 5596 2807 2789 50.16% 4.97% 48.85%
Jericho_Highwayman 1826 929 897 50.88% 1.62% 48.58%
Quincy 10125 5001 5124 49.39% 8.99% 48.42%
Ezili 3012 1486 1526 49.34% 2.67% 47.55%
Bonnie 10106 4885 5221 48.34% 8.97% 47.36%
StrikerJones 1297 641 656 49.42% 1.15% 46.70%
Benjamin 3787 1789 1998 47.24% 3.36% 45.65%
Gwendolin_Science 5853 2741 3112 46.83% 5.20% 45.55%
Etienne 15142 6926 8216 45.74% 13.44% 44.95%
Churchill 3661 1701 1960 46.46% 3.25% 44.85%
StrikerJones_Biker 580 266 314 45.86% 0.51% 41.81%
Gwendolin 3181 1318 1863 41.43% 2.82% 39.72%
Obyn_Ocean 1734 712 1022 41.06% 1.54% 38.75%
Ezili_SmudgeCat 672 277 395 41.22% 0.60% 37.50%
PatFusty 760 302 458 39.74% 0.67% 36.26%
Benjamin_DJ 389 131 258 33.68% 0.35% 28.98%

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;