dino_graveyard_loadouts (view)

327 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, EngineerMonkey, MonkeyAce 5481 3675 1806 67.05% 10.71% 65.81%
EngineerMonkey, MonkeyAce, SpikeFactory 210 138 72 65.71% 0.41% 59.29%
MonkeyAce, MonkeyVillage, SpikeFactory 286 183 103 63.99% 0.56% 58.42%
BananaFarm, Druid, MonkeySub 2919 1733 1186 59.37% 5.70% 57.59%
BananaFarm, DartlingGunner, IceMonkey 651 396 255 60.83% 1.27% 57.08%
BananaFarm, DartMonkey, MortarMonkey 301 185 116 61.46% 0.59% 55.96%
BananaFarm, DartMonkey, MonkeySub 126 81 45 64.29% 0.25% 55.92%
BananaFarm, BoomerangMonkey, EngineerMonkey 201 125 76 62.19% 0.39% 55.49%
BombShooter, DartlingGunner, MonkeyVillage 45 31 14 68.89% 0.09% 55.36%
BananaFarm, DartMonkey, WizardMonkey 220 135 85 61.36% 0.43% 54.93%
Alchemist, MonkeyAce, SpikeFactory 326 195 131 59.82% 0.64% 54.49%
BananaFarm, NinjaMonkey, WizardMonkey 307 184 123 59.93% 0.60% 54.45%
BananaFarm, Druid, MortarMonkey 44 30 14 68.18% 0.09% 54.42%
BananaFarm, BombShooter, WizardMonkey 487 286 201 58.73% 0.95% 54.35%
BananaFarm, MonkeySub, SuperMonkey 202 123 79 60.89% 0.39% 54.16%
EngineerMonkey, SniperMonkey, WizardMonkey 81 52 29 64.20% 0.16% 53.76%
BananaFarm, BoomerangMonkey, SpikeFactory 438 253 185 57.76% 0.86% 53.14%
DartlingGunner, Druid, SpikeFactory 139 85 54 61.15% 0.27% 53.05%
EngineerMonkey, MonkeyAce, SniperMonkey 37 25 12 67.57% 0.07% 52.48%
IceMonkey, NinjaMonkey, SniperMonkey 58 37 21 63.79% 0.11% 51.42%
BoomerangMonkey, GlueGunner, MonkeySub 41 27 14 65.85% 0.08% 51.34%
MonkeyAce, MonkeyBuccaneer, MonkeySub 41 27 14 65.85% 0.08% 51.34%
Alchemist, MonkeyBuccaneer, SpikeFactory 921 498 423 54.07% 1.80% 50.85%
BananaFarm, DartlingGunner, NinjaMonkey 296 165 131 55.74% 0.58% 50.08%
BananaFarm, MonkeySub, SpikeFactory 88 53 35 60.23% 0.17% 50.00%
BananaFarm, IceMonkey, MonkeySub 1097 574 523 52.32% 2.14% 49.37%
MonkeyAce, SpikeFactory, WizardMonkey 73 44 29 60.27% 0.14% 49.05%
BananaFarm, MonkeyAce, MonkeyBuccaneer 34 22 12 64.71% 0.07% 48.64%
BananaFarm, BoomerangMonkey, NinjaMonkey 507 267 240 52.66% 0.99% 48.32%
DartlingGunner, IceMonkey, MonkeyVillage 180 100 80 55.56% 0.35% 48.30%
BananaFarm, BoomerangMonkey, MonkeySub 215 118 97 54.88% 0.42% 48.23%
BananaFarm, BoomerangMonkey, SniperMonkey 188 104 84 55.32% 0.37% 48.21%
BoomerangMonkey, MonkeySub, SpikeFactory 135 76 59 56.30% 0.26% 47.93%
HeliPilot, IceMonkey, SuperMonkey 199 109 90 54.77% 0.39% 47.86%
GlueGunner, MonkeySub, SuperMonkey 69 41 28 59.42% 0.13% 47.83%
BoomerangMonkey, NinjaMonkey, WizardMonkey 38 24 14 63.16% 0.07% 47.82%
BananaFarm, DartMonkey, GlueGunner 348 184 164 52.87% 0.68% 47.63%
BananaFarm, DartMonkey, SpikeFactory 231 124 107 53.68% 0.45% 47.25%
DartMonkey, SpikeFactory, WizardMonkey 129 72 57 55.81% 0.25% 47.24%
Druid, MonkeyAce, MonkeyVillage 33 21 12 63.64% 0.06% 47.22%
BananaFarm, MonkeyAce, SpikeFactory 271 144 127 53.14% 0.53% 47.20%
SniperMonkey, SpikeFactory, WizardMonkey 275 146 129 53.09% 0.54% 47.19%
HeliPilot, IceMonkey, NinjaMonkey 44 27 17 61.36% 0.09% 46.98%
BananaFarm, MonkeySub, WizardMonkey 122 68 54 55.74% 0.24% 46.92%
DartlingGunner, GlueGunner, MonkeyVillage 80 46 34 57.50% 0.16% 46.67%
BananaFarm, BoomerangMonkey, MortarMonkey 174 94 80 54.02% 0.34% 46.62%
DartlingGunner, MonkeyVillage, SuperMonkey 1757 860 897 48.95% 3.43% 46.61%
Alchemist, BananaFarm, MonkeyAce 110 61 49 55.45% 0.21% 46.17%
BananaFarm, SniperMonkey, TackShooter 285 148 137 51.93% 0.56% 46.13%
BananaFarm, BoomerangMonkey, GlueGunner 60 35 25 58.33% 0.12% 45.86%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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