dino_graveyard_loadouts (view)

41 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, BoomerangMonkey, EngineerMonkey 56 42 14 75.00% 0.91% 63.66%
BananaFarm, EngineerMonkey, MonkeyAce 734 489 245 66.62% 11.97% 63.21%
BananaFarm, BombShooter, WizardMonkey 40 29 11 72.50% 0.65% 58.66%
BananaFarm, Druid, MonkeySub 505 302 203 59.80% 8.24% 55.53%
BananaFarm, NinjaMonkey, WizardMonkey 110 70 40 63.64% 1.79% 54.65%
BananaFarm, IceMonkey, MonkeySub 519 273 246 52.60% 8.47% 48.31%
EngineerMonkey, MonkeyAce, SpikeFactory 35 22 13 62.86% 0.57% 46.85%
BananaFarm, DartMonkey, SpikeFactory 39 24 15 61.54% 0.64% 46.27%
BananaFarm, DartlingGunner, IceMonkey 62 36 26 58.06% 1.01% 45.78%
BananaFarm, BoomerangMonkey, SpikeFactory 81 44 37 54.32% 1.32% 43.47%
BananaFarm, BoomerangMonkey, WizardMonkey 47 27 20 57.45% 0.77% 43.31%
BananaFarm, BoomerangMonkey, NinjaMonkey 79 41 38 51.90% 1.29% 40.88%
BananaFarm, MonkeySub, TackShooter 37 21 16 56.76% 0.60% 40.79%
MonkeyVillage, SniperMonkey, TackShooter 29 17 12 58.62% 0.47% 40.70%
BananaFarm, MonkeyAce, SpikeFactory 28 16 12 57.14% 0.46% 38.81%
DartlingGunner, MonkeyVillage, SuperMonkey 243 108 135 44.44% 3.96% 38.20%
BananaFarm, BoomerangMonkey, MonkeySub 44 23 21 52.27% 0.72% 37.51%
BananaFarm, SniperMonkey, TackShooter 44 23 21 52.27% 0.72% 37.51%
DartlingGunner, Druid, MonkeyVillage 44 23 21 52.27% 0.72% 37.51%
BananaFarm, DartlingGunner, NinjaMonkey 31 17 14 54.84% 0.51% 37.32%
BananaFarm, BombShooter, MonkeySub 97 45 52 46.39% 1.58% 36.47%
Alchemist, MonkeyBuccaneer, SpikeFactory 74 34 40 45.95% 1.21% 34.59%
DartlingGunner, Druid, SpikeFactory 24 13 11 54.17% 0.39% 34.23%
SniperMonkey, SpikeFactory, WizardMonkey 31 16 15 51.61% 0.51% 34.02%
DartMonkey, MonkeySub, NinjaMonkey 22 12 10 54.55% 0.36% 33.74%
BananaFarm, SniperMonkey, WizardMonkey 74 33 41 44.59% 1.21% 33.27%
BananaFarm, GlueGunner, MonkeySub 35 17 18 48.57% 0.57% 32.01%
BananaFarm, MonkeyAce, MonkeySub 35 17 18 48.57% 0.57% 32.01%
BananaFarm, TackShooter, WizardMonkey 107 44 63 41.12% 1.75% 31.80%
BananaFarm, DartlingGunner, SuperMonkey 110 44 66 40.00% 1.79% 30.84%
SniperMonkey, TackShooter, WizardMonkey 29 14 15 48.28% 0.47% 30.09%
EngineerMonkey, TackShooter, WizardMonkey 24 12 12 50.00% 0.39% 30.00%
Alchemist, HeliPilot, NinjaMonkey 33 15 18 45.45% 0.54% 28.47%
DartlingGunner, SpikeFactory, SuperMonkey 23 11 12 47.83% 0.38% 27.41%
NinjaMonkey, SniperMonkey, WizardMonkey 26 12 14 46.15% 0.42% 26.99%
DartMonkey, GlueGunner, MonkeyVillage 21 10 11 47.62% 0.34% 26.26%
Alchemist, MonkeyAce, SpikeFactory 37 14 23 37.84% 0.60% 22.21%
Alchemist, DartlingGunner, SpikeFactory 32 12 20 37.50% 0.52% 20.73%
GlueGunner, MonkeyVillage, TackShooter 52 15 37 28.85% 0.85% 16.53%
Druid, MonkeySub, SpikeFactory 31 10 21 32.26% 0.51% 15.80%
GlueGunner, HeliPilot, MonkeyVillage 40 12 28 30.00% 0.65% 15.80%

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;