ports_heroes (view)

15 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 429 278 151 64.80% 20.59% 60.28%
Jericho_Highwayman 65 38 27 58.46% 3.12% 46.48%
Adora 53 30 23 56.60% 2.54% 43.26%
Bonnie 136 69 67 50.74% 6.53% 42.33%
Etienne 575 266 309 46.26% 27.59% 42.19%
Jericho_StarCaptain 97 50 47 51.55% 4.65% 41.60%
Quincy 161 79 82 49.07% 7.73% 41.35%
Quincy_Cyber 70 36 34 51.43% 3.36% 39.72%
Etienne_Bee 134 61 73 45.52% 6.43% 37.09%
StrikerJones 38 20 18 52.63% 1.82% 36.76%
Benjamin 30 12 18 40.00% 1.44% 22.47%
Obyn 47 16 31 34.04% 2.26% 20.50%
Gwendolin_Science 65 20 45 30.77% 3.12% 19.55%
Churchill 34 12 22 35.29% 1.63% 19.23%
Churchill_Sentai 40 12 28 30.00% 1.92% 15.80%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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