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 2496 1558 938 62.42% 2.42% 60.52%
Benjamin 5324 2950 2374 55.41% 5.16% 54.07%
Quincy_Cyber 16580 9045 7535 54.55% 16.06% 53.80%
Jericho 6798 3650 3148 53.69% 6.58% 52.51%
Etienne_Bee 8158 4332 3826 53.10% 7.90% 52.02%
Obyn 3350 1745 1605 52.09% 3.24% 50.40%
Adora 3035 1563 1472 51.50% 2.94% 49.72%
Jericho_StarCaptain 1424 732 692 51.40% 1.38% 48.81%
StrikerJones_Biker 4553 2286 2267 50.21% 4.41% 48.76%
Churchill_Sentai 5386 2670 2716 49.57% 5.22% 48.24%
Jericho_Highwayman 2313 1158 1155 50.06% 2.24% 48.03%
Quincy 7868 3809 4059 48.41% 7.62% 47.31%
Bonnie 7575 3661 3914 48.33% 7.34% 47.20%
Ezili 1834 896 938 48.85% 1.78% 46.57%
StrikerJones 1887 899 988 47.64% 1.83% 45.39%
Adora_Fateweaver 881 426 455 48.35% 0.85% 45.05%
Etienne 11492 5129 6363 44.63% 11.13% 43.72%
Gwendolin_Science 2571 1135 1436 44.15% 2.49% 42.23%
Churchill 3609 1492 2117 41.34% 3.50% 39.73%
PatFusty 1665 695 970 41.74% 1.61% 39.37%
Gwendolin 2084 858 1226 41.17% 2.02% 39.06%
Obyn_Ocean 1640 670 970 40.85% 1.59% 38.47%
Ezili_SmudgeCat 424 176 248 41.51% 0.41% 36.82%
Benjamin_DJ 311 94 217 30.23% 0.30% 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 LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;