dino_graveyard_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Losses, Pickrate, Winrate_LowerBound_95CI

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 201 126 75 62.69% 3.15% 56.00%
Jericho 471 283 188 60.08% 7.39% 55.66%
Jericho_Highwayman 106 68 38 64.15% 1.66% 55.02%
Obyn 467 276 191 59.10% 7.33% 54.64%
Adora 262 147 115 56.11% 4.11% 50.10%
Jericho_StarCaptain 84 49 35 58.33% 1.32% 47.79%
StrikerJones 37 23 14 62.16% 0.58% 46.53%
Obyn_Ocean 155 84 71 54.19% 2.43% 46.35%
Bonnie 954 465 489 48.74% 14.97% 45.57%
Etienne_Bee 765 359 406 46.93% 12.01% 43.39%
Etienne 1099 509 590 46.31% 17.25% 43.37%
Quincy 240 116 124 48.33% 3.77% 42.01%
StrikerJones_Biker 53 29 24 54.72% 0.83% 41.32%
Churchill_Sentai 85 44 41 51.76% 1.33% 41.14%
Gwendolin_Science 457 205 252 44.86% 7.17% 40.30%
Ezili_SmudgeCat 30 17 13 56.67% 0.47% 38.93%
Ezili 143 65 78 45.45% 2.24% 37.29%
Gwendolin 209 92 117 44.02% 3.28% 37.29%
PatFusty 98 45 53 45.92% 1.54% 36.05%
Quincy_Cyber 85 39 46 45.88% 1.33% 35.29%
Benjamin_DJ 73 32 41 43.84% 1.15% 32.45%
Adora_Fateweaver 41 19 22 46.34% 0.64% 31.08%
Churchill 132 52 80 39.39% 2.07% 31.06%
Benjamin 125 42 83 33.60% 1.96% 25.32%

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;