dino_graveyard_loadouts (view)

50 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Losses

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, EngineerMonkey, MonkeyAce 900 576 324 64.00% 13.24% 60.86%
MonkeyAce, MonkeyVillage, SpikeFactory 79 55 24 69.62% 1.16% 59.48%
BananaFarm, DartlingGunner, IceMonkey 118 76 42 64.41% 1.74% 55.77%
BananaFarm, Druid, MonkeySub 306 185 121 60.46% 4.50% 54.98%
BananaFarm, BoomerangMonkey, SpikeFactory 44 28 16 63.64% 0.65% 49.42%
BananaFarm, DartlingGunner, NinjaMonkey 82 49 33 59.76% 1.21% 49.14%
DartlingGunner, MonkeyVillage, SuperMonkey 396 213 183 53.79% 5.82% 48.88%
BananaFarm, MonkeySub, WizardMonkey 34 22 12 64.71% 0.50% 48.64%
BananaFarm, EngineerMonkey, WizardMonkey 52 32 20 61.54% 0.76% 48.32%
BananaFarm, BoomerangMonkey, WizardMonkey 54 33 21 61.11% 0.79% 48.11%
BananaFarm, MonkeyAce, SpikeFactory 31 20 11 64.52% 0.46% 47.67%
BananaFarm, HeliPilot, IceMonkey 33 21 12 63.64% 0.49% 47.22%
BananaFarm, BombShooter, WizardMonkey 37 23 14 62.16% 0.54% 46.53%
Alchemist, GlueGunner, NinjaMonkey 48 28 20 58.33% 0.71% 44.39%
BananaFarm, NinjaMonkey, WizardMonkey 60 34 26 56.67% 0.88% 44.13%
BananaFarm, BombShooter, MonkeySub 57 31 26 54.39% 0.84% 41.46%
EngineerMonkey, MonkeyAce, MonkeyVillage 132 65 67 49.24% 1.94% 40.71%
BananaFarm, BoomerangMonkey, NinjaMonkey 70 36 34 51.43% 1.03% 39.72%
BananaFarm, TackShooter, WizardMonkey 181 84 97 46.41% 2.66% 39.14%
BananaFarm, DartMonkey, WizardMonkey 32 18 14 56.25% 0.47% 39.06%
Alchemist, MonkeyBuccaneer, SpikeFactory 65 33 32 50.77% 0.96% 38.62%
BananaFarm, SniperMonkey, SuperMonkey 24 14 10 58.33% 0.35% 38.61%
HeliPilot, IceMonkey, MonkeyVillage 77 37 40 48.05% 1.13% 36.89%
EngineerMonkey, TackShooter, WizardMonkey 25 14 11 56.00% 0.37% 36.54%
DartlingGunner, SniperMonkey, SpikeFactory 23 13 10 56.52% 0.34% 36.26%
DartMonkey, SniperMonkey, SpikeFactory 35 18 17 51.43% 0.51% 34.87%
BananaFarm, SniperMonkey, WizardMonkey 84 38 46 45.24% 1.24% 34.59%
BananaFarm, DartlingGunner, SuperMonkey 97 43 54 44.33% 1.43% 34.44%
DartMonkey, MonkeyVillage, SuperMonkey 38 19 19 50.00% 0.56% 34.10%
BananaFarm, IceMonkey, MonkeySub 148 62 86 41.89% 2.18% 33.94%
BoomerangMonkey, MonkeySub, SpikeFactory 22 12 10 54.55% 0.32% 33.74%
BananaFarm, DartlingGunner, SpikeFactory 36 18 18 50.00% 0.53% 33.67%
BananaFarm, EngineerMonkey, SuperMonkey 44 20 24 45.45% 0.65% 30.74%
MonkeySub, MonkeyVillage, SuperMonkey 52 23 29 44.23% 0.76% 30.73%
BananaFarm, MonkeyAce, WizardMonkey 39 18 21 46.15% 0.57% 30.51%
MonkeyVillage, SniperMonkey, SuperMonkey 37 17 20 45.95% 0.54% 29.89%
DartlingGunner, Druid, MonkeyVillage 40 18 22 45.00% 0.59% 29.58%
BananaFarm, SniperMonkey, TackShooter 20 10 10 50.00% 0.29% 28.09%
SniperMonkey, SpikeFactory, WizardMonkey 34 15 19 44.12% 0.50% 27.43%
Druid, MonkeySub, SpikeFactory 30 13 17 43.33% 0.44% 25.60%
BoomerangMonkey, SniperMonkey, SuperMonkey 39 16 23 41.03% 0.57% 25.59%
EngineerMonkey, MonkeyVillage, SpikeFactory 22 10 12 45.45% 0.32% 24.65%
HeliPilot, MonkeyAce, MonkeyVillage 22 10 12 45.45% 0.32% 24.65%
BananaFarm, DartlingGunner, WizardMonkey 38 15 23 39.47% 0.56% 23.93%
Alchemist, DartlingGunner, SuperMonkey 32 13 19 40.63% 0.47% 23.61%
Alchemist, BananaFarm, DartlingGunner 26 11 15 42.31% 0.38% 23.32%
Alchemist, DartlingGunner, SpikeFactory 30 12 18 40.00% 0.44% 22.47%
GlueGunner, MonkeyVillage, TackShooter 50 17 33 34.00% 0.74% 20.87%
Alchemist, MonkeyVillage, NinjaMonkey 27 10 17 37.04% 0.40% 18.82%
GlueGunner, HeliPilot, MonkeyVillage 37 12 25 32.43% 0.54% 17.35%

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;