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 3121 1787 1334 57.26% 3.28% 55.52%
Jericho 8599 4804 3795 55.87% 9.05% 54.82%
Benjamin 3523 1967 1556 55.83% 3.71% 54.19%
Quincy_Cyber 11207 6092 5115 54.36% 11.79% 53.44%
Jericho_StarCaptain 1120 611 509 54.55% 1.18% 51.64%
Churchill_Sentai 5612 2938 2674 52.35% 5.90% 51.05%
Obyn 3003 1570 1433 52.28% 3.16% 50.49%
Quincy 7814 4015 3799 51.38% 8.22% 50.27%
Etienne_Bee 10834 5527 5307 51.02% 11.40% 50.07%
Adora_Fateweaver 898 477 421 53.12% 0.94% 49.85%
StrikerJones_Biker 2572 1315 1257 51.13% 2.71% 49.20%
Jericho_Highwayman 1812 912 900 50.33% 1.91% 48.03%
PatFusty 1266 626 640 49.45% 1.33% 46.69%
Adora 2786 1343 1443 48.21% 2.93% 46.35%
Ezili 2205 1051 1154 47.66% 2.32% 45.58%
Bonnie 6254 2892 3362 46.24% 6.58% 45.01%
Gwendolin_Science 3076 1426 1650 46.36% 3.24% 44.60%
StrikerJones 1470 684 786 46.53% 1.55% 43.98%
Etienne 9841 4215 5626 42.83% 10.35% 41.85%
Churchill 2681 1159 1522 43.23% 2.82% 41.35%
Gwendolin 2631 1077 1554 40.94% 2.77% 39.06%
Ezili_SmudgeCat 429 185 244 43.12% 0.45% 38.44%
Obyn_Ocean 1780 695 1085 39.04% 1.87% 36.78%
Benjamin_DJ 512 155 357 30.27% 0.54% 26.29%

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;