dino_graveyard_loadouts (view)

58 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
MonkeyAce, MonkeyVillage, SpikeFactory 54 41 13 75.93% 0.78% 64.52%
BananaFarm, EngineerMonkey, MonkeyAce 681 449 232 65.93% 9.78% 62.37%
BananaFarm, Druid, MonkeySub 300 198 102 66.00% 4.31% 60.64%
Alchemist, MonkeyAce, SpikeFactory 51 35 16 68.63% 0.73% 55.89%
BananaFarm, DartlingGunner, IceMonkey 101 64 37 63.37% 1.45% 53.97%
Alchemist, MonkeyBuccaneer, SpikeFactory 211 118 93 55.92% 3.03% 49.23%
BananaFarm, MonkeySub, SuperMonkey 34 22 12 64.71% 0.49% 48.64%
BananaFarm, DartMonkey, MortarMonkey 85 49 36 57.65% 1.22% 47.14%
DartlingGunner, MonkeyVillage, SuperMonkey 231 123 108 53.25% 3.32% 46.81%
BananaFarm, BoomerangMonkey, SpikeFactory 51 30 21 58.82% 0.73% 45.32%
BananaFarm, BombShooter, WizardMonkey 56 32 24 57.14% 0.80% 44.18%
MonkeyAce, SniperMonkey, WizardMonkey 37 22 15 59.46% 0.53% 43.64%
GlueGunner, HeliPilot, MonkeyVillage 185 94 91 50.81% 2.66% 43.61%
BananaFarm, BoomerangMonkey, NinjaMonkey 39 23 16 58.97% 0.56% 43.54%
Alchemist, DartlingGunner, SpikeFactory 55 31 24 56.36% 0.79% 43.26%
BananaFarm, DartMonkey, WizardMonkey 30 18 12 60.00% 0.43% 42.47%
MonkeyVillage, SniperMonkey, TackShooter 54 30 24 55.56% 0.78% 42.30%
BananaFarm, SniperMonkey, TackShooter 41 23 18 56.10% 0.59% 40.91%
BananaFarm, BombShooter, MonkeySub 35 20 15 57.14% 0.50% 40.75%
DartlingGunner, Druid, MonkeyVillage 103 50 53 48.54% 1.48% 38.89%
BananaFarm, DartlingGunner, GlueGunner 28 16 12 57.14% 0.40% 38.81%
BombShooter, HeliPilot, WizardMonkey 28 16 12 57.14% 0.40% 38.81%
DartMonkey, GlueGunner, MonkeyVillage 76 38 38 50.00% 1.09% 38.76%
BananaFarm, MonkeyAce, SniperMonkey 24 14 10 58.33% 0.34% 38.61%
SpikeFactory, TackShooter, WizardMonkey 24 14 10 58.33% 0.34% 38.61%
Alchemist, Druid, MonkeyVillage 35 19 16 54.29% 0.50% 37.78%
DartlingGunner, IceMonkey, MonkeyVillage 46 24 22 52.17% 0.66% 37.74%
DartlingGunner, MonkeyVillage, SpikeFactory 46 24 22 52.17% 0.66% 37.74%
BananaFarm, SniperMonkey, WizardMonkey 60 30 30 50.00% 0.86% 37.35%
BananaFarm, BoomerangMonkey, SuperMonkey 42 22 20 52.38% 0.60% 37.28%
BananaFarm, DartMonkey, GlueGunner 58 29 29 50.00% 0.83% 37.13%
BananaFarm, BoomerangMonkey, SniperMonkey 29 16 13 55.17% 0.42% 37.07%
SniperMonkey, SuperMonkey, TackShooter 40 21 19 52.50% 0.57% 37.02%
HeliPilot, IceMonkey, SuperMonkey 34 18 16 52.94% 0.49% 36.16%
SniperMonkey, SpikeFactory, WizardMonkey 30 16 14 53.33% 0.43% 35.48%
BananaFarm, TackShooter, WizardMonkey 64 30 34 46.88% 0.92% 34.65%
BananaFarm, DartlingGunner, NinjaMonkey 24 13 11 54.17% 0.34% 34.23%
BananaFarm, DartlingGunner, SuperMonkey 154 63 91 40.91% 2.21% 33.14%
Druid, MonkeySub, SpikeFactory 27 14 13 51.85% 0.39% 33.00%
BananaFarm, DartMonkey, SpikeFactory 44 21 23 47.73% 0.63% 32.97%
MonkeyBuccaneer, SniperMonkey, WizardMonkey 35 17 18 48.57% 0.50% 32.01%
NinjaMonkey, SniperMonkey, WizardMonkey 23 12 11 52.17% 0.33% 31.76%
DartlingGunner, SpikeFactory, SuperMonkey 48 22 26 45.83% 0.69% 31.74%
BombShooter, DartlingGunner, MonkeyBuccaneer 26 13 13 50.00% 0.37% 30.78%
Alchemist, GlueGunner, NinjaMonkey 47 21 26 44.68% 0.68% 30.47%
MonkeyVillage, SniperMonkey, SuperMonkey 24 12 12 50.00% 0.34% 30.00%
BananaFarm, DartlingGunner, SpikeFactory 38 17 21 44.74% 0.55% 28.93%
GlueGunner, MonkeyVillage, NinjaMonkey 62 25 37 40.32% 0.89% 28.11%
Alchemist, HeliPilot, NinjaMonkey 54 22 32 40.74% 0.78% 27.64%
MonkeyAce, MonkeyBuccaneer, SniperMonkey 23 11 12 47.83% 0.33% 27.41%

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;