bloonstone_quarry_heroes (view)

23 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 486 308 178 63.37% 7.51% 59.09%
Bonnie 1461 780 681 53.39% 22.57% 50.83%
Jericho 279 156 123 55.91% 4.31% 50.09%
Obyn 215 115 100 53.49% 3.32% 46.82%
Etienne_Bee 594 290 304 48.82% 9.18% 44.80%
Quincy 392 188 204 47.96% 6.05% 43.01%
Quincy_Cyber 195 97 98 49.74% 3.01% 42.73%
Churchill_Sentai 201 99 102 49.25% 3.10% 42.34%
Ezili 125 63 62 50.40% 1.93% 41.63%
Ezili_SmudgeCat 43 24 19 55.81% 0.66% 40.97%
Benjamin 285 133 152 46.67% 4.40% 40.87%
Etienne 692 308 384 44.51% 10.69% 40.81%
StrikerJones 58 31 27 53.45% 0.90% 40.61%
Gwendolin_Science 350 159 191 45.43% 5.41% 40.21%
Jericho_StarCaptain 65 34 31 52.31% 1.00% 40.17%
Jericho_Highwayman 72 37 35 51.39% 1.11% 39.84%
PatFusty 63 32 31 50.79% 0.97% 38.45%
Churchill 153 70 83 45.75% 2.36% 37.86%
Gwendolin 298 127 171 42.62% 4.60% 37.00%
Adora_Fateweaver 56 27 29 48.21% 0.86% 35.13%
Obyn_Ocean 141 61 80 43.26% 2.18% 35.08%
Adora 194 81 113 41.75% 3.00% 34.81%
StrikerJones_Biker 30 11 19 36.67% 0.46% 19.42%

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;