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 3435 2155 1280 62.74% 3.27% 61.12%
Adora_Fateweaver 1302 789 513 60.60% 1.24% 57.94%
Ezili_SmudgeCat 845 504 341 59.64% 0.81% 56.34%
Jericho 6057 3460 2597 57.12% 5.77% 55.88%
Adora 5442 3110 2332 57.15% 5.19% 55.83%
Jericho_Highwayman 1610 936 674 58.14% 1.53% 55.73%
Churchill_Sentai 1770 944 826 53.33% 1.69% 51.01%
Jericho_StarCaptain 1617 862 755 53.31% 1.54% 50.88%
StrikerJones_Biker 833 450 383 54.02% 0.79% 50.64%
Obyn 4884 2541 2343 52.03% 4.65% 50.63%
Quincy 5296 2672 2624 50.45% 5.05% 49.11%
Benjamin_DJ 907 464 443 51.16% 0.86% 47.90%
Etienne 21542 10438 11104 48.45% 20.53% 47.79%
PatFusty 1776 878 898 49.44% 1.69% 47.11%
Bonnie 12816 6123 6693 47.78% 12.21% 46.91%
Churchill 2865 1388 1477 48.45% 2.73% 46.62%
Gwendolin_Science 8603 4064 4539 47.24% 8.20% 46.18%
Obyn_Ocean 1850 895 955 48.38% 1.76% 46.10%
Quincy_Cyber 1886 902 984 47.83% 1.80% 45.57%
Etienne_Bee 11539 5320 6219 46.10% 11.00% 45.19%
Ezili 2475 1167 1308 47.15% 2.36% 45.18%
StrikerJones 837 391 446 46.71% 0.80% 43.33%
Gwendolin 3327 1412 1915 42.44% 3.17% 40.76%
Benjamin 1414 599 815 42.36% 1.35% 39.79%

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;