off_tide_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 2508 1575 933 62.80% 4.89% 60.91%
Quincy_Cyber 3438 1868 1570 54.33% 6.71% 52.67%
Etienne_Bee 5837 3107 2730 53.23% 11.39% 51.95%
Jericho_Highwayman 1170 636 534 54.36% 2.28% 51.50%
Jericho 3075 1622 1453 52.75% 6.00% 50.98%
Benjamin 1652 878 774 53.15% 3.22% 50.74%
Jericho_StarCaptain 1057 567 490 53.64% 2.06% 50.64%
Ezili 1726 903 823 52.32% 3.37% 49.96%
Quincy 3675 1893 1782 51.51% 7.17% 49.89%
Adora_Fateweaver 493 267 226 54.16% 0.96% 49.76%
Etienne 8859 4254 4605 48.02% 17.28% 46.98%
Adora 1736 851 885 49.02% 3.39% 46.67%
Bonnie 4679 2245 2434 47.98% 9.13% 46.55%
StrikerJones 710 347 363 48.87% 1.39% 45.20%
StrikerJones_Biker 606 289 317 47.69% 1.18% 43.71%
Obyn 1353 626 727 46.27% 2.64% 43.61%
Gwendolin_Science 3277 1483 1794 45.25% 6.39% 43.55%
Ezili_SmudgeCat 402 192 210 47.76% 0.78% 42.88%
PatFusty 611 285 326 46.64% 1.19% 42.69%
Obyn_Ocean 1103 469 634 42.52% 2.15% 39.60%
Gwendolin 1373 553 820 40.28% 2.68% 37.68%
Benjamin_DJ 306 132 174 43.14% 0.60% 37.59%
Churchill 735 269 466 36.60% 1.43% 33.12%
Churchill_Sentai 879 319 560 36.29% 1.71% 33.11%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW off_tide_heroes AS 
WITH off_tide AS
    (SELECT *
    FROM matches
    WHERE map = 'off_tide')
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 off_tide) * 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 off_tide
                  UNION ALL
                  SELECT rHero             AS Hero,
                         NOT playerLeftWin AS Win
                  FROM off_tide)
            GROUP BY Hero))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;