dino_graveyard_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 689 429 260 62.26% 11.21% 58.64%
PatFusty_Snowman 264 157 107 59.47% 4.30% 53.55%
Obyn 473 269 204 56.87% 7.70% 52.41%
PatFusty 94 54 40 57.45% 1.53% 47.45%
Etienne_Bee 360 185 175 51.39% 5.86% 46.23%
Quincy 293 150 143 51.19% 4.77% 45.47%
Ezili 106 57 49 53.77% 1.72% 44.28%
Bonnie 949 449 500 47.31% 15.44% 44.14%
Gwendolin_Science 369 179 190 48.51% 6.00% 43.41%
Jericho_Highwayman 105 55 50 52.38% 1.71% 42.83%
Gwendolin 253 122 131 48.22% 4.12% 42.06%
Quincy_Cyber 106 54 52 50.94% 1.72% 41.43%
Jericho_StarCaptain 113 57 56 50.44% 1.84% 41.22%
Etienne 826 362 464 43.83% 13.44% 40.44%
Churchill_Sentai 176 82 94 46.59% 2.86% 39.22%
StrikerJones_Biker 39 21 18 53.85% 0.63% 38.20%
Benjamin 365 156 209 42.74% 5.94% 37.66%
Ezili_SmudgeCat 41 21 20 51.22% 0.67% 35.92%
Adora 136 60 76 44.12% 2.21% 35.77%
Obyn_Ocean 107 46 61 42.99% 1.74% 33.61%
StrikerJones 65 27 38 41.54% 1.06% 29.56%
Churchill 124 46 78 37.10% 2.02% 28.59%
Benjamin_DJ 49 19 30 38.78% 0.80% 25.13%
Adora_Fateweaver 44 16 28 36.36% 0.72% 22.15%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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