bloonstone_quarry_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 216 144 72 66.67% 3.44% 60.38%
Churchill_Sentai 322 185 137 57.45% 5.13% 52.05%
Benjamin 449 245 204 54.57% 7.15% 49.96%
Jericho 430 234 196 54.42% 6.85% 49.71%
Etienne_Bee 392 212 180 54.08% 6.25% 49.15%
Obyn 162 91 71 56.17% 2.58% 48.53%
Ezili 132 75 57 56.82% 2.10% 48.37%
Bonnie 1020 516 504 50.59% 16.25% 47.52%
Adora 186 99 87 53.23% 2.96% 46.06%
Quincy 326 162 164 49.69% 5.19% 44.27%
Quincy_Cyber 532 252 280 47.37% 8.48% 43.13%
StrikerJones_Biker 316 153 163 48.42% 5.04% 42.91%
StrikerJones 95 48 47 50.53% 1.51% 40.47%
Jericho_StarCaptain 62 32 30 51.61% 0.99% 39.17%
Gwendolin_Science 137 63 74 45.99% 2.18% 37.64%
Etienne 611 252 359 41.24% 9.74% 37.34%
Churchill 272 115 157 42.28% 4.33% 36.41%
Obyn_Ocean 142 62 80 43.66% 2.26% 35.50%
Jericho_Highwayman 106 47 59 44.34% 1.69% 34.88%
PatFusty 130 55 75 42.31% 2.07% 33.81%
Gwendolin 158 63 95 39.87% 2.52% 32.24%
Ezili_SmudgeCat 28 14 14 50.00% 0.45% 31.48%
Adora_Fateweaver 31 12 19 38.71% 0.49% 21.56%

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;