dino_graveyard_loadouts (view)

47 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, EngineerMonkey, MonkeyAce 699 451 248 64.52% 11.37% 60.97%
BananaFarm, Druid, MonkeySub 381 234 147 61.42% 6.20% 56.53%
BananaFarm, BoomerangMonkey, EngineerMonkey 47 32 15 68.09% 0.76% 54.76%
BananaFarm, DartMonkey, MortarMonkey 33 23 10 69.70% 0.54% 54.02%
BananaFarm, DartMonkey, GlueGunner 49 32 17 65.31% 0.80% 51.98%
BananaFarm, DartlingGunner, IceMonkey 108 65 43 60.19% 1.76% 50.95%
IceMonkey, NinjaMonkey, SniperMonkey 33 22 11 66.67% 0.54% 50.58%
BananaFarm, BoomerangMonkey, NinjaMonkey 32 21 11 65.63% 0.52% 49.17%
Alchemist, MonkeyAce, SpikeFactory 61 36 25 59.02% 0.99% 46.67%
Druid, MonkeySub, SpikeFactory 40 24 16 60.00% 0.65% 44.82%
BananaFarm, BombShooter, WizardMonkey 46 27 19 58.70% 0.75% 44.47%
BananaFarm, BoomerangMonkey, MortarMonkey 29 18 11 62.07% 0.47% 44.41%
Alchemist, MonkeyBuccaneer, SpikeFactory 144 75 69 52.08% 2.34% 43.92%
HeliPilot, IceMonkey, SuperMonkey 57 32 25 56.14% 0.93% 43.26%
MonkeyAce, MonkeyVillage, SpikeFactory 57 32 25 56.14% 0.93% 43.26%
SniperMonkey, SpikeFactory, WizardMonkey 31 18 13 58.06% 0.50% 40.69%
GlueGunner, HeliPilot, MonkeyVillage 165 78 87 47.27% 2.68% 39.65%
DartMonkey, GlueGunner, MonkeyVillage 73 37 36 50.68% 1.19% 39.22%
BananaFarm, SniperMonkey, WizardMonkey 71 36 35 50.70% 1.16% 39.07%
DartlingGunner, MonkeyVillage, SuperMonkey 220 100 120 45.45% 3.58% 38.87%
DartlingGunner, SpikeFactory, SuperMonkey 45 24 21 53.33% 0.73% 38.76%
BananaFarm, DartMonkey, WizardMonkey 24 14 10 58.33% 0.39% 38.61%
Alchemist, DartlingGunner, SpikeFactory 42 22 20 52.38% 0.68% 37.28%
BananaFarm, BoomerangMonkey, SuperMonkey 23 13 10 56.52% 0.37% 36.26%
EngineerMonkey, TackShooter, WizardMonkey 30 16 14 53.33% 0.49% 35.48%
BananaFarm, TackShooter, WizardMonkey 80 37 43 46.25% 1.30% 35.32%
NinjaMonkey, SniperMonkey, WizardMonkey 28 15 13 53.57% 0.46% 35.10%
GlueGunner, MonkeySub, SuperMonkey 26 14 12 53.85% 0.42% 34.68%
BananaFarm, BombShooter, MonkeySub 34 17 17 50.00% 0.55% 33.19%
BananaFarm, MonkeyAce, SpikeFactory 34 17 17 50.00% 0.55% 33.19%
DartlingGunner, Druid, MonkeyVillage 35 17 18 48.57% 0.57% 32.01%
BananaFarm, DartlingGunner, SuperMonkey 129 52 77 40.31% 2.10% 31.85%
GlueGunner, MonkeyVillage, TackShooter 77 33 44 42.86% 1.25% 31.80%
BananaFarm, BoomerangMonkey, WizardMonkey 23 12 11 52.17% 0.37% 31.76%
HeliPilot, IceMonkey, MonkeyVillage 21 11 10 52.38% 0.34% 31.02%
Alchemist, BananaFarm, NinjaMonkey 26 12 14 46.15% 0.42% 26.99%
DartlingGunner, IceMonkey, MonkeyVillage 26 12 14 46.15% 0.42% 26.99%
SniperMonkey, TackShooter, WizardMonkey 26 12 14 46.15% 0.42% 26.99%
BananaFarm, BoomerangMonkey, SpikeFactory 29 13 16 44.83% 0.47% 26.73%
Alchemist, GlueGunner, NinjaMonkey 27 12 15 44.44% 0.44% 25.70%
BananaFarm, GlueGunner, MonkeySub 22 10 12 45.45% 0.36% 24.65%
BoomerangMonkey, SniperMonkey, WizardMonkey 22 10 12 45.45% 0.36% 24.65%
BananaFarm, SniperMonkey, TackShooter 25 11 14 44.00% 0.41% 24.54%
Druid, SniperMonkey, SuperMonkey 25 11 14 44.00% 0.41% 24.54%
Alchemist, HeliPilot, NinjaMonkey 52 19 33 36.54% 0.85% 23.45%
HeliPilot, MonkeyVillage, SuperMonkey 54 17 37 31.48% 0.88% 19.09%
BananaFarm, DartlingGunner, SpikeFactory 43 14 29 32.56% 0.70% 18.55%

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;