dino_graveyard_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Losses, Winrate, Pickrate, Winrate_LowerBound_95CI

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 736 471 265 63.99% 10.57% 60.53%
Obyn 429 245 184 57.11% 6.16% 52.43%
PatFusty_Snowman 217 125 92 57.60% 3.12% 51.03%
Jericho_Highwayman 124 72 52 58.06% 1.78% 49.38%
Bonnie 1058 538 520 50.85% 15.20% 47.84%
Jericho_StarCaptain 189 99 90 52.38% 2.71% 45.26%
Quincy_Cyber 158 82 76 51.90% 2.27% 44.11%
StrikerJones_Biker 35 21 14 60.00% 0.50% 43.77%
Etienne 997 461 536 46.24% 14.32% 43.14%
Ezili 125 64 61 51.20% 1.80% 42.44%
Churchill_Sentai 170 84 86 49.41% 2.44% 41.90%
Gwendolin_Science 468 216 252 46.15% 6.72% 41.64%
Benjamin_DJ 171 81 90 47.37% 2.46% 39.88%
Gwendolin 190 89 101 46.84% 2.73% 39.75%
Etienne_Bee 536 235 301 43.84% 7.70% 39.64%
Quincy 230 106 124 46.09% 3.30% 39.64%
Benjamin 355 158 197 44.51% 5.10% 39.34%
Adora 230 105 125 45.65% 3.30% 39.21%
Adora_Fateweaver 46 24 22 52.17% 0.66% 37.74%
Ezili_SmudgeCat 42 22 20 52.38% 0.60% 37.28%
StrikerJones 67 32 35 47.76% 0.96% 35.80%
Obyn_Ocean 165 63 102 38.18% 2.37% 30.77%
Churchill 163 62 101 38.04% 2.34% 30.58%
PatFusty 61 26 35 42.62% 0.88% 30.21%

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;