ports_heroes (view)

13 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 349 210 139 60.17% 18.25% 55.04%
Obyn 47 32 15 68.09% 2.46% 54.76%
Bonnie 82 51 31 62.20% 4.29% 51.70%
Jericho_Highwayman 60 37 23 61.67% 3.14% 49.36%
Quincy_Cyber 402 202 200 50.25% 21.03% 45.36%
Etienne 299 144 155 48.16% 15.64% 42.50%
Jericho_StarCaptain 45 25 20 55.56% 2.35% 41.04%
StrikerJones_Biker 129 61 68 47.29% 6.75% 38.67%
Quincy 200 86 114 43.00% 10.46% 36.14%
Etienne_Bee 56 23 33 41.07% 2.93% 28.19%
StrikerJones 27 12 15 44.44% 1.41% 25.70%
Adora 29 10 19 34.48% 1.52% 17.18%
Churchill_Sentai 34 11 23 32.35% 1.78% 16.63%

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;