all_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 8987 5057 3930 56.27% 8.64% 55.24%
Jericho_Highwayman 3007 1670 1337 55.54% 2.89% 53.76%
Jericho_StarCaptain 1170 659 511 56.32% 1.12% 53.48%
Quincy_Cyber 10610 5731 4879 54.02% 10.20% 53.07%
PatFusty_Snowman 2997 1632 1365 54.45% 2.88% 52.67%
Etienne_Bee 12790 6811 5979 53.25% 12.29% 52.39%
Adora_Fateweaver 948 524 424 55.27% 0.91% 52.11%
Benjamin 2764 1433 1331 51.85% 2.66% 49.98%
Quincy 10240 5166 5074 50.45% 9.84% 49.48%
StrikerJones 1181 618 563 52.33% 1.13% 49.48%
Churchill_Sentai 7998 4035 3963 50.45% 7.69% 49.35%
Obyn 5130 2595 2535 50.58% 4.93% 49.22%
Ezili 2780 1407 1373 50.61% 2.67% 48.75%
Adora 3228 1618 1610 50.12% 3.10% 48.40%
StrikerJones_Biker 531 268 263 50.47% 0.51% 46.22%
Gwendolin_Science 3127 1477 1650 47.23% 3.01% 45.48%
PatFusty 655 311 344 47.48% 0.63% 43.66%
Bonnie 7451 3312 4139 44.45% 7.16% 43.32%
Gwendolin 2442 1066 1376 43.65% 2.35% 41.69%
Etienne 9690 4069 5621 41.99% 9.31% 41.01%
Churchill 3495 1471 2024 42.09% 3.36% 40.45%
Obyn_Ocean 1598 640 958 40.05% 1.54% 37.65%
Ezili_SmudgeCat 864 347 517 40.16% 0.83% 36.89%
Benjamin_DJ 373 111 262 29.76% 0.36% 25.12%

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;