off_tide_loadouts (view)

48 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, MortarMonkey 88 60 28 68.18% 1.51% 58.45%
BananaFarm, BoomerangMonkey, NinjaMonkey 51 36 15 70.59% 0.87% 58.08%
DartlingGunner, MonkeyVillage, SuperMonkey 122 80 42 65.57% 2.09% 57.14%
BananaFarm, TackShooter, WizardMonkey 362 217 145 59.94% 6.21% 54.90%
BananaFarm, DartlingGunner, IceMonkey 94 60 34 63.83% 1.61% 54.12%
BananaFarm, DartMonkey, SpikeFactory 46 31 15 67.39% 0.79% 53.84%
BananaFarm, DartMonkey, MortarMonkey 151 93 58 61.59% 2.59% 53.83%
BananaFarm, BoomerangMonkey, SpikeFactory 183 111 72 60.66% 3.14% 53.58%
BananaFarm, IceMonkey, TackShooter 99 62 37 62.63% 1.70% 53.10%
BananaFarm, EngineerMonkey, MonkeyAce 81 51 30 62.96% 1.39% 52.45%
BananaFarm, DartMonkey, GlueGunner 191 112 79 58.64% 3.28% 51.65%
BananaFarm, BombShooter, WizardMonkey 122 71 51 58.20% 2.09% 49.44%
BananaFarm, MortarMonkey, TackShooter 130 73 57 56.15% 2.23% 47.62%
BoomerangMonkey, MortarMonkey, SpikeFactory 33 21 12 63.64% 0.57% 47.22%
BananaFarm, SniperMonkey, TackShooter 44 27 17 61.36% 0.75% 46.98%
BananaFarm, BombShooter, SpikeFactory 135 73 62 54.07% 2.32% 45.67%
BananaFarm, GlueGunner, TackShooter 66 38 28 57.58% 1.13% 45.65%
DartMonkey, GlueGunner, MonkeyVillage 105 57 48 54.29% 1.80% 44.76%
SpikeFactory, TackShooter, WizardMonkey 60 34 26 56.67% 1.03% 44.13%
GlueGunner, HeliPilot, MonkeyVillage 198 89 109 44.95% 3.40% 38.02%
GlueGunner, MonkeyVillage, TackShooter 189 85 104 44.97% 3.24% 37.88%
BananaFarm, BoomerangMonkey, SuperMonkey 29 16 13 55.17% 0.50% 37.07%
NinjaMonkey, SniperMonkey, WizardMonkey 29 16 13 55.17% 0.50% 37.07%
Alchemist, BananaFarm, NinjaMonkey 50 25 25 50.00% 0.86% 36.14%
BananaFarm, BoomerangMonkey, EngineerMonkey 28 15 13 53.57% 0.48% 35.10%
BananaFarm, DartlingGunner, SuperMonkey 62 29 33 46.77% 1.06% 34.35%
BananaFarm, BoomerangMonkey, WizardMonkey 24 13 11 54.17% 0.41% 34.23%
BananaFarm, DartlingGunner, SpikeFactory 24 13 11 54.17% 0.41% 34.23%
MortarMonkey, SpikeFactory, TackShooter 36 18 18 50.00% 0.62% 33.67%
BananaFarm, SniperMonkey, WizardMonkey 46 22 24 47.83% 0.79% 33.39%
BananaFarm, BombShooter, MonkeySub 32 16 16 50.00% 0.55% 32.68%
SniperMonkey, SpikeFactory, WizardMonkey 35 17 18 48.57% 0.60% 32.01%
DartlingGunner, IceMonkey, MonkeyVillage 21 11 10 52.38% 0.36% 31.02%
DartlingGunner, SniperMonkey, SpikeFactory 21 11 10 52.38% 0.36% 31.02%
BoomerangMonkey, SniperMonkey, WizardMonkey 26 13 13 50.00% 0.45% 30.78%
BananaFarm, IceMonkey, SuperMonkey 38 17 21 44.74% 0.65% 28.93%
BananaFarm, IceMonkey, NinjaMonkey 30 14 16 46.67% 0.51% 28.81%
HeliPilot, MonkeyVillage, SuperMonkey 33 15 18 45.45% 0.57% 28.47%
BananaFarm, IceMonkey, WizardMonkey 23 11 12 47.83% 0.39% 27.41%
EngineerMonkey, TackShooter, WizardMonkey 26 12 14 46.15% 0.45% 26.99%
BananaFarm, BombShooter, MortarMonkey 38 16 22 42.11% 0.65% 26.41%
IceMonkey, NinjaMonkey, SniperMonkey 24 11 13 45.83% 0.41% 25.90%
IceMonkey, MonkeyVillage, TackShooter 62 23 39 37.10% 1.06% 25.07%
SniperMonkey, TackShooter, WizardMonkey 51 19 32 37.25% 0.87% 23.99%
BananaFarm, Druid, MonkeySub 45 16 29 35.56% 0.77% 21.57%
HeliPilot, IceMonkey, SuperMonkey 39 14 25 35.90% 0.67% 20.84%
MonkeyVillage, SniperMonkey, TackShooter 25 10 15 40.00% 0.43% 20.80%
Alchemist, HeliPilot, NinjaMonkey 37 12 25 32.43% 0.63% 17.35%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW off_tide_loadouts AS 
WITH off_tide AS
    (SELECT *
    FROM matches
    WHERE map = 'off_tide')
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 off_tide) * 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 off_tide
                  UNION ALL
                  SELECT printf('%s, %s, %s', rt1, rt2, rt3) AS Loadout,
                         NOT playerLeftWin                   AS Win
                  FROM off_tide)
            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;