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 4725 2889 1836 61.14% 4.14% 59.75%
Adora_Fateweaver 1460 874 586 59.86% 1.28% 57.35%
Jericho 8500 4725 3775 55.59% 7.45% 54.53%
Adora 5811 3204 2607 55.14% 5.09% 53.86%
StrikerJones 1519 830 689 54.64% 1.33% 52.14%
Jericho_Highwayman 1720 907 813 52.73% 1.51% 50.37%
Ezili_SmudgeCat 649 350 299 53.93% 0.57% 50.09%
Ezili 2735 1415 1320 51.74% 2.40% 49.86%
Jericho_StarCaptain 3066 1557 1509 50.78% 2.69% 49.01%
Bonnie 13373 6600 6773 49.35% 11.72% 48.51%
Etienne_Bee 9120 4507 4613 49.42% 8.00% 48.39%
Benjamin_DJ 1930 976 954 50.57% 1.69% 48.34%
Obyn 4496 2234 2262 49.69% 3.94% 48.23%
Quincy 5226 2547 2679 48.74% 4.58% 47.38%
Churchill_Sentai 2991 1454 1537 48.61% 2.62% 46.82%
Gwendolin_Science 7973 3820 4153 47.91% 6.99% 46.82%
Benjamin 3996 1927 2069 48.22% 3.50% 46.67%
Etienne 20862 9835 11027 47.14% 18.29% 46.47%
PatFusty 1430 687 743 48.04% 1.25% 45.45%
Churchill 3348 1570 1778 46.89% 2.94% 45.20%
Quincy_Cyber 2918 1371 1547 46.98% 2.56% 45.17%
StrikerJones_Biker 542 263 279 48.52% 0.48% 44.32%
Obyn_Ocean 2411 1079 1332 44.75% 2.11% 42.77%
Gwendolin 3263 1411 1852 43.24% 2.86% 41.54%

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;