ports_loadouts (view)

74 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Loadout Games Wins Losses Winrate Pickrate WinRate_LowerBound_95CI
BananaFarm, HeliPilot, SniperMonkey 95 76 19 80.00% 0.60% 71.96%
BananaFarm, DartMonkey, MortarMonkey 305 223 82 73.11% 1.92% 68.14%
Alchemist, MonkeyAce, MonkeySub 2951 1979 972 67.06% 18.57% 65.37%
BananaFarm, MonkeyAce, MortarMonkey 792 511 281 64.52% 4.98% 61.19%
MortarMonkey, SniperMonkey, TackShooter 53 35 18 66.04% 0.33% 53.29%
Alchemist, BananaFarm, MonkeyAce 1669 929 740 55.66% 10.50% 53.28%
BananaFarm, MonkeyAce, MonkeySub 1231 688 543 55.89% 7.75% 53.12%
Alchemist, MonkeyAce, MortarMonkey 153 93 60 60.78% 0.96% 53.05%
BananaFarm, HeliPilot, MonkeySub 260 149 111 57.31% 1.64% 51.30%
Druid, MonkeyAce, MortarMonkey 36 24 12 66.67% 0.23% 51.27%
Alchemist, MonkeyAce, SniperMonkey 68 42 26 61.76% 0.43% 50.21%
Alchemist, MonkeyAce, SpikeFactory 396 218 178 55.05% 2.49% 50.15%
BananaFarm, Druid, MonkeySub 285 150 135 52.63% 1.79% 46.83%
Alchemist, MonkeyAce, MonkeyBuccaneer 166 90 76 54.22% 1.04% 46.64%
MonkeyAce, MonkeySub, SniperMonkey 68 38 30 55.88% 0.43% 44.08%
BananaFarm, HeliPilot, WizardMonkey 37 22 15 59.46% 0.23% 43.64%
HeliPilot, MonkeyBuccaneer, MonkeySub 25 15 10 60.00% 0.16% 40.80%
BananaFarm, MonkeyAce, SniperMonkey 44 24 20 54.55% 0.28% 39.83%
BananaFarm, EngineerMonkey, MonkeyAce 173 81 92 46.82% 1.09% 39.39%
BananaFarm, HeliPilot, MortarMonkey 34 18 16 52.94% 0.21% 36.16%
MonkeyAce, MonkeyBuccaneer, SpikeFactory 32 17 15 53.13% 0.20% 35.83%
Alchemist, DartlingGunner, WizardMonkey 28 15 13 53.57% 0.18% 35.10%
BananaFarm, MonkeySub, WizardMonkey 55 26 29 47.27% 0.35% 34.08%
Alchemist, EngineerMonkey, MonkeyAce 22 12 10 54.55% 0.14% 33.74%
Alchemist, DartMonkey, MonkeyAce 58 27 31 46.55% 0.36% 33.71%
BananaFarm, BombShooter, MonkeySub 165 68 97 41.21% 1.04% 33.70%
BananaFarm, MonkeySub, TackShooter 110 46 64 41.82% 0.69% 32.60%
BananaFarm, MonkeyAce, WizardMonkey 55 25 30 45.45% 0.35% 32.29%
BananaFarm, DartMonkey, SniperMonkey 50 23 27 46.00% 0.31% 32.19%
MonkeyAce, MonkeySub, SpikeFactory 48 22 26 45.83% 0.30% 31.74%
BananaFarm, MonkeySub, SpikeFactory 33 16 17 48.48% 0.21% 31.43%
MonkeySub, SniperMonkey, WizardMonkey 27 13 14 48.15% 0.17% 29.30%
BananaFarm, DartMonkey, MonkeySub 100 38 62 38.00% 0.63% 28.49%
DartMonkey, MonkeyAce, MonkeySub 36 16 20 44.44% 0.23% 28.21%
MonkeyBuccaneer, SniperMonkey, WizardMonkey 89 34 55 38.20% 0.56% 28.11%
NinjaMonkey, SniperMonkey, WizardMonkey 28 13 15 46.43% 0.18% 27.96%
SniperMonkey, SuperMonkey, WizardMonkey 31 14 17 45.16% 0.20% 27.64%
HeliPilot, MonkeyBuccaneer, WizardMonkey 23 11 12 47.83% 0.14% 27.41%
SniperMonkey, TackShooter, WizardMonkey 32 14 18 43.75% 0.20% 26.56%
BananaFarm, SniperMonkey, WizardMonkey 81 30 51 37.04% 0.51% 26.52%
MonkeyAce, SniperMonkey, WizardMonkey 35 15 20 42.86% 0.22% 26.46%
GlueGunner, MonkeySub, SniperMonkey 21 10 11 47.62% 0.13% 26.26%
DartMonkey, GlueGunner, SniperMonkey 27 12 15 44.44% 0.17% 25.70%
BananaFarm, GlueGunner, MonkeyAce 36 15 21 41.67% 0.23% 25.56%
DartMonkey, MonkeyAce, MonkeyBuccaneer 46 18 28 39.13% 0.29% 25.03%
GlueGunner, MonkeyBuccaneer, MonkeySub 22 10 12 45.45% 0.14% 24.65%
BananaFarm, BoomerangMonkey, WizardMonkey 25 11 14 44.00% 0.16% 24.54%
BananaFarm, HeliPilot, MonkeyAce 25 11 14 44.00% 0.16% 24.54%
GlueGunner, MonkeyAce, MonkeyBuccaneer 25 11 14 44.00% 0.16% 24.54%
MonkeyAce, MonkeyBuccaneer, SniperMonkey 35 14 21 40.00% 0.22% 23.77%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW ports_loadouts AS 
WITH ports AS
    (SELECT *
    FROM matches
    WHERE map = 'ports')
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 ports) * 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 ports
                  UNION ALL
                  SELECT printf('%s, %s, %s', rt1, rt2, rt3) AS Loadout,
                         NOT playerLeftWin                   AS Win
                  FROM ports)
            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;