dino_graveyard_loadouts (view)

54 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 434 302 132 69.59% 6.81% 65.26%
BananaFarm, BoomerangMonkey, SpikeFactory 52 39 13 75.00% 0.82% 63.23%
BananaFarm, DartlingGunner, IceMonkey 70 51 19 72.86% 1.10% 62.44%
DartlingGunner, Druid, SpikeFactory 54 40 14 74.07% 0.85% 62.39%
BananaFarm, MonkeySub, SuperMonkey 68 48 20 70.59% 1.07% 59.76%
BananaFarm, Druid, MonkeySub 264 166 98 62.88% 4.14% 57.05%
BananaFarm, DartMonkey, MortarMonkey 87 58 29 66.67% 1.37% 56.76%
DartlingGunner, IceMonkey, MonkeyVillage 54 36 18 66.67% 0.85% 54.09%
MonkeyAce, MonkeyVillage, SpikeFactory 41 28 13 68.29% 0.64% 54.05%
BananaFarm, DartMonkey, SpikeFactory 35 24 11 68.57% 0.55% 53.19%
BananaFarm, BoomerangMonkey, NinjaMonkey 42 28 14 66.67% 0.66% 52.41%
Alchemist, BananaFarm, MonkeyAce 30 19 11 63.33% 0.47% 46.09%
Alchemist, HeliPilot, NinjaMonkey 45 27 18 60.00% 0.71% 45.69%
BananaFarm, TackShooter, WizardMonkey 59 34 25 57.63% 0.93% 45.02%
Alchemist, MonkeyBuccaneer, SpikeFactory 121 65 56 53.72% 1.90% 44.83%
Alchemist, MonkeyAce, SpikeFactory 35 21 14 60.00% 0.55% 43.77%
SniperMonkey, SpikeFactory, WizardMonkey 41 24 17 58.54% 0.64% 43.46%
BananaFarm, BombShooter, WizardMonkey 72 39 33 54.17% 1.13% 42.66%
BananaFarm, SniperMonkey, TackShooter 41 23 18 56.10% 0.64% 40.91%
Druid, MonkeySub, SpikeFactory 41 23 18 56.10% 0.64% 40.91%
DartlingGunner, Druid, MonkeyVillage 154 72 82 46.75% 2.42% 38.87%
Alchemist, GlueGunner, NinjaMonkey 87 42 45 48.28% 1.37% 37.78%
BananaFarm, DartMonkey, GlueGunner 65 32 33 49.23% 1.02% 37.08%
BananaFarm, DartMonkey, WizardMonkey 29 16 13 55.17% 0.46% 37.07%
BananaFarm, MonkeyAce, SpikeFactory 50 25 25 50.00% 0.78% 36.14%
GlueGunner, HeliPilot, MonkeyVillage 116 52 64 44.83% 1.82% 35.78%
BananaFarm, DartlingGunner, SuperMonkey 159 69 90 43.40% 2.50% 35.69%
DartlingGunner, MonkeyVillage, SuperMonkey 102 46 56 45.10% 1.60% 35.44%
Alchemist, Druid, MonkeyVillage 37 19 18 51.35% 0.58% 35.25%
SniperMonkey, TackShooter, WizardMonkey 29 15 14 51.72% 0.46% 33.54%
SniperMonkey, SuperMonkey, WizardMonkey 34 17 17 50.00% 0.53% 33.19%
DartMonkey, GlueGunner, MonkeyVillage 111 47 64 42.34% 1.74% 33.15%
SniperMonkey, SpikeFactory, SuperMonkey 58 26 32 44.83% 0.91% 32.03%
SpikeFactory, TackShooter, WizardMonkey 23 12 11 52.17% 0.36% 31.76%
MonkeyVillage, SniperMonkey, TackShooter 33 16 17 48.48% 0.52% 31.43%
GlueGunner, MonkeyVillage, NinjaMonkey 112 45 67 40.18% 1.76% 31.10%
BoomerangMonkey, NinjaMonkey, SniperMonkey 21 11 10 52.38% 0.33% 31.02%
DartlingGunner, GlueGunner, NinjaMonkey 21 11 10 52.38% 0.33% 31.02%
Druid, SniperMonkey, WizardMonkey 21 11 10 52.38% 0.33% 31.02%
BananaFarm, BombShooter, SpikeFactory 36 17 19 47.22% 0.56% 30.91%
BananaFarm, BoomerangMonkey, SniperMonkey 26 13 13 50.00% 0.41% 30.78%
DartMonkey, IceMonkey, MonkeyVillage 37 17 20 45.95% 0.58% 29.89%
BananaFarm, SniperMonkey, WizardMonkey 35 16 19 45.71% 0.55% 29.21%
GlueGunner, MonkeyVillage, TackShooter 41 17 24 41.46% 0.64% 26.38%
Alchemist, NinjaMonkey, SpikeFactory 34 14 20 41.18% 0.53% 24.63%
BananaFarm, BombShooter, DartlingGunner 32 13 19 40.63% 0.50% 23.61%
BombShooter, HeliPilot, WizardMonkey 29 12 17 41.38% 0.46% 23.45%
DartMonkey, GlueGunner, SuperMonkey 29 12 17 41.38% 0.46% 23.45%
Alchemist, DartlingGunner, SpikeFactory 56 18 38 32.14% 0.88% 19.91%
EngineerMonkey, TackShooter, WizardMonkey 34 12 22 35.29% 0.53% 19.23%

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;