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 571 367 204 64.27% 8.40% 60.34%
PatFusty_Snowman 115 75 40 65.22% 1.69% 56.51%
Obyn 419 231 188 55.13% 6.16% 50.37%
StrikerJones_Biker 696 366 330 52.59% 10.24% 48.88%
Quincy_Cyber 673 352 321 52.30% 9.90% 48.53%
Etienne_Bee 499 260 239 52.10% 7.34% 47.72%
Benjamin 538 271 267 50.37% 7.91% 46.15%
Bonnie 600 293 307 48.83% 8.82% 44.83%
Jericho_StarCaptain 68 36 32 52.94% 1.00% 41.08%
Obyn_Ocean 157 76 81 48.41% 2.31% 40.59%
Jericho_Highwayman 94 47 47 50.00% 1.38% 39.89%
Etienne 642 279 363 43.46% 9.44% 39.62%
Quincy 374 167 207 44.65% 5.50% 39.61%
Gwendolin 127 61 66 48.03% 1.87% 39.34%
Churchill_Sentai 288 127 161 44.10% 4.24% 38.36%
Ezili 142 65 77 45.77% 2.09% 37.58%
StrikerJones 95 45 50 47.37% 1.40% 37.33%
PatFusty 115 52 63 45.22% 1.69% 36.12%
Adora 197 84 113 42.64% 2.90% 35.73%
Churchill 178 67 111 37.64% 2.62% 30.52%
Gwendolin_Science 113 44 69 38.94% 1.66% 29.95%
Benjamin_DJ 29 12 17 41.38% 0.43% 23.45%
Ezili_SmudgeCat 31 11 20 35.48% 0.46% 18.64%
Adora_Fateweaver 39 12 27 30.77% 0.57% 16.28%

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;