bloonstone_quarry_loadouts (view)

49 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, IceMonkey, MonkeySub 991 597 394 60.24% 15.97% 57.20%
BananaFarm, BombShooter, MonkeySub 160 101 59 63.13% 2.58% 55.65%
IceMonkey, MonkeyVillage, NinjaMonkey 44 30 14 68.18% 0.71% 54.42%
BananaFarm, BoomerangMonkey, SpikeFactory 46 30 16 65.22% 0.74% 51.45%
Alchemist, MonkeyBuccaneer, SpikeFactory 385 215 170 55.84% 6.20% 50.88%
BananaFarm, Druid, MonkeySub 172 98 74 56.98% 2.77% 49.58%
DartlingGunner, MonkeyVillage, SuperMonkey 143 80 63 55.94% 2.30% 47.81%
DartlingGunner, GlueGunner, MonkeyVillage 31 20 11 64.52% 0.50% 47.67%
BananaFarm, BoomerangMonkey, NinjaMonkey 46 28 18 60.87% 0.74% 46.77%
BananaFarm, DartlingGunner, IceMonkey 71 41 30 57.75% 1.14% 46.26%
HeliPilot, IceMonkey, SuperMonkey 60 35 25 58.33% 0.97% 45.86%
IceMonkey, MonkeyVillage, TackShooter 94 52 42 55.32% 1.51% 45.27%
BombShooter, MonkeySub, SpikeFactory 43 25 18 58.14% 0.69% 43.39%
GlueGunner, HeliPilot, MonkeyVillage 26 16 10 61.54% 0.42% 42.84%
DartlingGunner, IceMonkey, MonkeyVillage 48 27 21 56.25% 0.77% 42.22%
BananaFarm, BoomerangMonkey, MonkeySub 46 26 20 56.52% 0.74% 42.20%
IceMonkey, MonkeyVillage, WizardMonkey 25 15 10 60.00% 0.40% 40.80%
BananaFarm, BombShooter, SpikeFactory 31 18 13 58.06% 0.50% 40.69%
BananaFarm, TackShooter, WizardMonkey 141 69 72 48.94% 2.27% 40.68%
Alchemist, IceMonkey, NinjaMonkey 53 28 25 52.83% 0.85% 39.39%
BananaFarm, NinjaMonkey, WizardMonkey 49 26 23 53.06% 0.79% 39.09%
BombShooter, MonkeyVillage, SpikeFactory 56 29 27 51.79% 0.90% 38.70%
HeliPilot, IceMonkey, NinjaMonkey 26 15 11 57.69% 0.42% 38.70%
GlueGunner, MonkeyVillage, TackShooter 93 45 48 48.39% 1.50% 38.23%
BananaFarm, BombShooter, SniperMonkey 35 19 16 54.29% 0.56% 37.78%
BananaFarm, SniperMonkey, TackShooter 27 15 12 55.56% 0.44% 36.81%
DartMonkey, MonkeySub, NinjaMonkey 25 14 11 56.00% 0.40% 36.54%
BananaFarm, DartMonkey, MonkeySub 36 19 17 52.78% 0.58% 36.47%
BananaFarm, EngineerMonkey, MonkeySub 22 12 10 54.55% 0.35% 33.74%
Alchemist, MonkeySub, SpikeFactory 27 14 13 51.85% 0.44% 33.00%
BananaFarm, IceMonkey, WizardMonkey 23 12 11 52.17% 0.37% 31.76%
BananaFarm, SniperMonkey, WizardMonkey 49 22 27 44.90% 0.79% 30.97%
MonkeyVillage, SniperMonkey, TackShooter 26 13 13 50.00% 0.42% 30.78%
DartlingGunner, SpikeFactory, SuperMonkey 44 20 24 45.45% 0.71% 30.74%
Druid, IceMonkey, NinjaMonkey 24 12 12 50.00% 0.39% 30.00%
DartlingGunner, Druid, MonkeyVillage 27 13 14 48.15% 0.44% 29.30%
Alchemist, NinjaMonkey, SniperMonkey 22 11 11 50.00% 0.35% 29.11%
HeliPilot, IceMonkey, MonkeyVillage 28 13 15 46.43% 0.45% 27.96%
BananaFarm, DartlingGunner, SuperMonkey 23 11 12 47.83% 0.37% 27.41%
MonkeyVillage, SniperMonkey, SuperMonkey 25 11 14 44.00% 0.40% 24.54%
EngineerMonkey, TackShooter, WizardMonkey 36 14 22 38.89% 0.58% 22.96%
BananaFarm, MonkeySub, TackShooter 27 11 16 40.74% 0.44% 22.21%
Druid, MonkeySub, SpikeFactory 37 14 23 37.84% 0.60% 22.21%
GlueGunner, MonkeySub, SpikeFactory 24 10 14 41.67% 0.39% 21.94%
GlueGunner, MonkeySub, TackShooter 29 11 18 37.93% 0.47% 20.27%
IceMonkey, MonkeyVillage, SuperMonkey 26 10 16 38.46% 0.42% 19.76%
NinjaMonkey, SniperMonkey, WizardMonkey 26 10 16 38.46% 0.42% 19.76%
Alchemist, DartlingGunner, SpikeFactory 50 16 34 32.00% 0.81% 19.07%
BananaFarm, MonkeySub, SpikeFactory 27 10 17 37.04% 0.44% 18.82%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW bloonstone_quarry_loadouts AS 
WITH bloonstone_quarry AS
    (SELECT *
    FROM matches
    WHERE map = 'bloonstone_quarry')
SELECT Loadout,
       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 Loadout,
             Games,
             Wins,
             Losses,
             CAST(Wins AS REAL) / Games AS WR,
             CAST(Games AS REAL) / (
                 (SELECT COUNT(*)
                  FROM bloonstone_quarry) * 2)    AS PR
      FROM (SELECT Loadout,
                   SUM(Win) + SUM(NOT Win) AS Games,
                   SUM(Win)                AS Wins,
                   SUM(NOT Win)            AS Losses
            FROM (SELECT printf('%s, %s, %s', lt1, lt2, lt3) AS Loadout,
                         playerLeftWin                       AS Win
                  FROM bloonstone_quarry
                  UNION ALL
                  SELECT printf('%s, %s, %s', rt1, rt2, rt3) AS Loadout,
                         NOT playerLeftWin                   AS Win
                  FROM bloonstone_quarry)
            GROUP BY Loadout)
      WHERE Wins >= 10
        AND Losses >= 10)
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(WinRate_LowerBound_95CI) = 6
ORDER BY WinRate_LowerBound_95CI DESC;