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 5786 3422 2364 59.14% 5.91% 57.88%
Adora_Fateweaver 1355 800 555 59.04% 1.38% 56.42%
Jericho 7635 4168 3467 54.59% 7.80% 53.47%
Adora 5130 2798 2332 54.54% 5.24% 53.18%
Jericho_StarCaptain 1701 926 775 54.44% 1.74% 52.07%
Ezili 2188 1159 1029 52.97% 2.23% 50.88%
Etienne_Bee 6827 3467 3360 50.78% 6.97% 49.60%
Benjamin 4193 2127 2066 50.73% 4.28% 49.21%
Ezili_SmudgeCat 552 294 258 53.26% 0.56% 49.10%
StrikerJones 1607 822 785 51.15% 1.64% 48.71%
Obyn 4088 2043 2045 49.98% 4.17% 48.44%
Bonnie 10991 5415 5576 49.27% 11.22% 48.33%
Quincy 6479 3200 3279 49.39% 6.62% 48.17%
Gwendolin_Science 5949 2921 3028 49.10% 6.08% 47.83%
Jericho_Highwayman 1404 703 701 50.07% 1.43% 47.46%
Churchill_Sentai 2892 1381 1511 47.75% 2.95% 45.93%
Etienne 16732 7795 8937 46.59% 17.09% 45.83%
Quincy_Cyber 2068 976 1092 47.20% 2.11% 45.04%
Churchill 2963 1352 1611 45.63% 3.03% 43.84%
PatFusty 1328 611 717 46.01% 1.36% 43.33%
Gwendolin 3409 1529 1880 44.85% 3.48% 43.18%
Obyn_Ocean 1474 609 865 41.32% 1.51% 38.80%
StrikerJones_Biker 545 231 314 42.39% 0.56% 38.24%
Benjamin_DJ 624 211 413 33.81% 0.64% 30.10%

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;