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
Jericho 287 167 120 58.19% 4.15% 52.48%
PatFusty_Snowman 282 162 120 57.45% 4.08% 51.68%
Bonnie 1781 923 858 51.82% 25.77% 49.50%
Obyn 250 133 117 53.20% 3.62% 47.01%
Etienne 1089 529 560 48.58% 15.76% 45.61%
Jericho_StarCaptain 90 50 40 55.56% 1.30% 45.29%
Obyn_Ocean 149 79 70 53.02% 2.16% 45.01%
Etienne_Bee 670 326 344 48.66% 9.69% 44.87%
Gwendolin_Science 545 266 279 48.81% 7.88% 44.61%
Adora 297 146 151 49.16% 4.30% 43.47%
Gwendolin 321 157 164 48.91% 4.64% 43.44%
PatFusty 124 64 60 51.61% 1.79% 42.82%
Benjamin_DJ 97 49 48 50.52% 1.40% 40.57%
Jericho_Highwayman 77 39 38 50.65% 1.11% 39.48%
Churchill 123 58 65 47.15% 1.78% 38.33%
Quincy 227 99 128 43.61% 3.28% 37.16%
Benjamin 94 44 50 46.81% 1.36% 36.72%
StrikerJones 53 26 27 49.06% 0.77% 35.60%
Ezili 129 51 78 39.53% 1.87% 31.10%
Churchill_Sentai 61 26 35 42.62% 0.88% 30.21%
StrikerJones_Biker 45 18 27 40.00% 0.65% 25.69%
Quincy_Cyber 81 27 54 33.33% 1.17% 23.07%
Ezili_SmudgeCat 24 10 14 41.67% 0.35% 21.94%

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;