bloonstone_quarry_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Pickrate

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho 568 351 217 61.80% 9.15% 57.80%
Churchill_Sentai 547 312 235 57.04% 8.81% 52.89%
PatFusty_Snowman 352 201 151 57.10% 5.67% 51.93%
Bonnie 1061 527 534 49.67% 17.10% 46.66%
Etienne_Bee 498 252 246 50.60% 8.02% 46.21%
Ezili 134 73 61 54.48% 2.16% 46.05%
Quincy_Cyber 377 189 188 50.13% 6.07% 45.09%
Benjamin 170 87 83 51.18% 2.74% 43.66%
Ezili_SmudgeCat 64 35 29 54.69% 1.03% 42.49%
Jericho_Highwayman 100 51 49 51.00% 1.61% 41.20%
Obyn 257 121 136 47.08% 4.14% 40.98%
PatFusty 43 24 19 55.81% 0.69% 40.97%
Adora_Fateweaver 35 20 15 57.14% 0.56% 40.75%
Quincy 392 177 215 45.15% 6.32% 40.23%
Gwendolin_Science 207 97 110 46.86% 3.34% 40.06%
StrikerJones_Biker 34 19 15 55.88% 0.55% 39.19%
Gwendolin 249 110 139 44.18% 4.01% 38.01%
Etienne 470 193 277 41.06% 7.57% 36.62%
Obyn_Ocean 139 62 77 44.60% 2.24% 36.34%
Adora 153 62 91 40.52% 2.47% 32.74%
Churchill 227 88 139 38.77% 3.66% 32.43%
Jericho_StarCaptain 40 19 21 47.50% 0.64% 32.02%
StrikerJones 46 20 26 43.48% 0.74% 29.15%
Benjamin_DJ 43 13 30 30.23% 0.69% 16.51%

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;