bloonstone_quarry_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 556 340 216 61.15% 9.17% 57.10%
Jericho 291 164 127 56.36% 4.80% 50.66%
Bonnie 1470 775 695 52.72% 24.25% 50.17%
Jericho_StarCaptain 69 40 29 57.97% 1.14% 46.32%
Benjamin 311 160 151 51.45% 5.13% 45.89%
Gwendolin_Science 390 193 197 49.49% 6.43% 44.53%
Ezili 92 50 42 54.35% 1.52% 44.17%
Gwendolin 289 142 147 49.13% 4.77% 43.37%
Etienne 779 361 418 46.34% 12.85% 42.84%
Adora 244 119 125 48.77% 4.03% 42.50%
Etienne_Bee 312 139 173 44.55% 5.15% 39.04%
Churchill 150 70 80 46.67% 2.47% 38.68%
Quincy 281 124 157 44.13% 4.64% 38.32%
Obyn 156 71 85 45.51% 2.57% 37.70%
Jericho_Highwayman 57 28 29 49.12% 0.94% 36.14%
Obyn_Ocean 116 52 64 44.83% 1.91% 35.78%
Churchill_Sentai 125 53 72 42.40% 2.06% 33.74%
StrikerJones 76 33 43 43.42% 1.25% 32.28%
Adora_Fateweaver 35 17 18 48.57% 0.58% 32.01%
PatFusty 84 34 50 40.48% 1.39% 29.98%
Quincy_Cyber 90 35 55 38.89% 1.48% 28.82%
Ezili_SmudgeCat 25 11 14 44.00% 0.41% 24.54%
Benjamin_DJ 45 14 31 31.11% 0.74% 17.58%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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