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 749 474 275 63.28% 3.02% 59.83%
Jericho 1748 1004 744 57.44% 7.06% 55.12%
Quincy_Cyber 5081 2835 2246 55.80% 20.51% 54.43%
Obyn 876 471 405 53.77% 3.54% 50.47%
Etienne_Bee 1952 1008 944 51.64% 7.88% 49.42%
Churchill_Sentai 1176 604 572 51.36% 4.75% 48.50%
PatFusty 308 166 142 53.90% 1.24% 48.33%
StrikerJones_Biker 645 334 311 51.78% 2.60% 47.93%
Jericho_Highwayman 545 276 269 50.64% 2.20% 46.44%
Benjamin 1653 805 848 48.70% 6.67% 46.29%
Ezili 539 261 278 48.42% 2.18% 44.20%
Bonnie 1790 826 964 46.15% 7.23% 43.84%
Adora 813 378 435 46.49% 3.28% 43.07%
Jericho_StarCaptain 317 152 165 47.95% 1.28% 42.45%
Quincy 1537 667 870 43.40% 6.20% 40.92%
Adora_Fateweaver 201 96 105 47.76% 0.81% 40.86%
Churchill 830 360 470 43.37% 3.35% 40.00%
Etienne 2219 929 1290 41.87% 8.96% 39.81%
Obyn_Ocean 368 165 203 44.84% 1.49% 39.76%
StrikerJones 231 102 129 44.16% 0.93% 37.75%
Gwendolin 441 181 260 41.04% 1.78% 36.45%
Ezili_SmudgeCat 144 62 82 43.06% 0.58% 34.97%
Gwendolin_Science 575 222 353 38.61% 2.32% 34.63%
Benjamin_DJ 36 9 27 25.00% 0.15% 10.85%

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 LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;