glade_loadouts (view)

141 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, BoomerangMonkey, MortarMonkey 708 490 218 69.21% 2.81% 65.81%
DartlingGunner, MonkeyVillage, SuperMonkey 305 208 97 68.20% 1.21% 62.97%
BananaFarm, DartMonkey, SpikeFactory 5668 3540 2128 62.46% 22.52% 61.20%
BananaFarm, DartlingGunner, IceMonkey 299 195 104 65.22% 1.19% 59.82%
Alchemist, DartlingGunner, SuperMonkey 71 50 21 70.42% 0.28% 59.81%
BananaFarm, DartlingGunner, NinjaMonkey 192 127 65 66.15% 0.76% 59.45%
BananaFarm, BombShooter, MonkeySub 185 120 65 64.86% 0.73% 57.99%
Alchemist, DartMonkey, SpikeFactory 265 159 106 60.00% 1.05% 54.10%
BananaFarm, DartMonkey, SniperMonkey 161 99 62 61.49% 0.64% 53.97%
EngineerMonkey, IceMonkey, SniperMonkey 48 32 16 66.67% 0.19% 53.33%
BananaFarm, TackShooter, WizardMonkey 1008 562 446 55.75% 4.00% 52.69%
BananaFarm, BoomerangMonkey, GlueGunner 111 68 43 61.26% 0.44% 52.20%
BananaFarm, GlueGunner, MonkeySub 48 31 17 64.58% 0.19% 51.05%
BananaFarm, BoomerangMonkey, IceMonkey 52 33 19 63.46% 0.21% 50.37%
BananaFarm, EngineerMonkey, WizardMonkey 49 31 18 63.27% 0.19% 49.77%
DartMonkey, GlueGunner, SpikeFactory 164 94 70 57.32% 0.65% 49.75%
DartMonkey, MortarMonkey, SpikeFactory 133 77 56 57.89% 0.53% 49.50%
BananaFarm, DartMonkey, WizardMonkey 150 86 64 57.33% 0.60% 49.42%
BananaFarm, MonkeySub, SpikeFactory 141 81 60 57.45% 0.56% 49.29%
BananaFarm, DartMonkey, MortarMonkey 410 221 189 53.90% 1.63% 49.08%
BananaFarm, Druid, MonkeySub 351 190 161 54.13% 1.39% 48.92%
DartMonkey, SniperMonkey, SpikeFactory 83 48 35 57.83% 0.33% 47.21%
BananaFarm, BoomerangMonkey, WizardMonkey 250 131 119 52.40% 0.99% 46.21%
BananaFarm, BoomerangMonkey, SniperMonkey 109 59 50 54.13% 0.43% 44.77%
BananaFarm, DartMonkey, MonkeySub 160 84 76 52.50% 0.64% 44.76%
EngineerMonkey, SpikeFactory, WizardMonkey 29 18 11 62.07% 0.12% 44.41%
BoomerangMonkey, IceMonkey, MonkeySub 78 43 35 55.13% 0.31% 44.09%
BoomerangMonkey, MortarMonkey, SpikeFactory 264 131 133 49.62% 1.05% 43.59%
BoomerangMonkey, MonkeySub, SpikeFactory 77 42 35 54.55% 0.31% 43.42%
DartMonkey, MonkeyBuccaneer, SpikeFactory 59 33 26 55.93% 0.23% 43.26%
BoomerangMonkey, SniperMonkey, WizardMonkey 96 51 45 53.13% 0.38% 43.14%
BananaFarm, HeliPilot, IceMonkey 34 20 14 58.82% 0.14% 42.28%
BananaFarm, BoomerangMonkey, NinjaMonkey 231 112 119 48.48% 0.92% 42.04%
Alchemist, MonkeyBuccaneer, SpikeFactory 216 105 111 48.61% 0.86% 41.95%
BananaFarm, BoomerangMonkey, SpikeFactory 1118 498 620 44.54% 4.44% 41.63%
BananaFarm, MonkeySub, WizardMonkey 78 41 37 52.56% 0.31% 41.48%
Alchemist, DartlingGunner, SpikeFactory 301 140 161 46.51% 1.20% 40.88%
BananaFarm, HeliPilot, SpikeFactory 50 27 23 54.00% 0.20% 40.19%
DartMonkey, MonkeyVillage, SpikeFactory 49 26 23 53.06% 0.19% 39.09%
BananaFarm, EngineerMonkey, MonkeySub 26 15 11 57.69% 0.10% 38.70%
SniperMonkey, SpikeFactory, WizardMonkey 111 53 58 47.75% 0.44% 38.46%
BananaFarm, DartlingGunner, GlueGunner 52 27 25 51.92% 0.21% 38.34%
BananaFarm, DartMonkey, GlueGunner 427 182 245 42.62% 1.70% 37.93%
BananaFarm, DartlingGunner, SpikeFactory 181 81 100 44.75% 0.72% 37.51%
BananaFarm, SniperMonkey, WizardMonkey 228 100 128 43.86% 0.91% 37.42%
BananaFarm, DartMonkey, NinjaMonkey 29 16 13 55.17% 0.12% 37.07%
HeliPilot, SniperMonkey, WizardMonkey 40 21 19 52.50% 0.16% 37.02%
BananaFarm, NinjaMonkey, WizardMonkey 106 49 57 46.23% 0.42% 36.73%
BoomerangMonkey, NinjaMonkey, SpikeFactory 25 14 11 56.00% 0.10% 36.54%
MonkeyBuccaneer, SniperMonkey, WizardMonkey 59 29 30 49.15% 0.23% 36.40%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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