dino_graveyard_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Losses, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 857 584 273 68.14% 12.46% 65.03%
PatFusty_Snowman 205 115 90 56.10% 2.98% 49.30%
Obyn 611 320 291 52.37% 8.88% 48.41%
Jericho_Highwayman 107 60 47 56.07% 1.56% 46.67%
Quincy 457 231 226 50.55% 6.64% 45.96%
Jericho_StarCaptain 70 40 30 57.14% 1.02% 45.55%
Quincy_Cyber 205 107 98 52.20% 2.98% 45.36%
Bonnie 743 363 380 48.86% 10.80% 45.26%
Etienne_Bee 768 370 398 48.18% 11.17% 44.64%
Ezili 171 87 84 50.88% 2.49% 43.38%
Churchill_Sentai 334 156 178 46.71% 4.86% 41.36%
Etienne 780 343 437 43.97% 11.34% 40.49%
Adora_Fateweaver 48 26 22 54.17% 0.70% 40.07%
Benjamin 312 140 172 44.87% 4.54% 39.35%
Gwendolin_Science 323 142 181 43.96% 4.70% 38.55%
Gwendolin 208 92 116 44.23% 3.02% 37.48%
Churchill 190 77 113 40.53% 2.76% 33.55%
Obyn_Ocean 141 56 85 39.72% 2.05% 31.64%
Benjamin_DJ 30 14 16 46.67% 0.44% 28.81%
Adora 164 58 106 35.37% 2.38% 28.05%
Ezili_SmudgeCat 49 20 29 40.82% 0.71% 27.05%
StrikerJones 54 19 35 35.19% 0.79% 22.45%
PatFusty 26 10 16 38.46% 0.38% 19.76%

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;