off_tide_towers (view)

21 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Games, Wins, Losses, Winrate, Pickrate

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
BananaFarm 1231 654 577 53.13% 24.08% 50.34%
WizardMonkey 653 345 308 52.83% 12.77% 49.00%
TackShooter 645 337 308 52.25% 12.62% 48.39%
IceMonkey 174 97 77 55.75% 3.40% 48.37%
DartlingGunner 323 168 155 52.01% 6.32% 46.56%
BoomerangMonkey 312 160 152 51.28% 6.10% 45.74%
MortarMonkey 114 61 53 53.51% 2.23% 44.35%
EngineerMonkey 93 50 43 53.76% 1.82% 43.63%
SpikeFactory 248 121 127 48.79% 4.85% 42.57%
Druid 58 32 26 55.17% 1.13% 42.37%
MonkeySub 50 28 22 56.00% 0.98% 42.24%
NinjaMonkey 264 118 146 44.70% 5.16% 38.70%
BombShooter 148 66 82 44.59% 2.90% 36.59%
DartMonkey 75 35 40 46.67% 1.47% 35.38%
HeliPilot 46 22 24 47.83% 0.90% 33.39%
MonkeyVillage 171 68 103 39.77% 3.35% 32.43%
GlueGunner 116 48 68 41.38% 2.27% 32.42%
MonkeyAce 45 21 24 46.67% 0.88% 32.09%
SniperMonkey 123 50 73 40.65% 2.41% 31.97%
SuperMonkey 136 48 88 35.29% 2.66% 27.26%
Alchemist 75 27 48 36.00% 1.47% 25.14%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW off_tide_towers AS 
WITH off_tide AS
    (SELECT *
    FROM matches
    WHERE map = 'off_tide')
SELECT Tower,
       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 Tower,
             Games,
             Wins,
             Losses,
             CAST(Wins AS REAL) / Games AS WR,
             CAST(Games AS REAL) / (
                 (SELECT COUNT(*)
                  FROM off_tide) * 6)    AS PR
      FROM (SELECT Tower,
                   SUM(Win) + SUM(NOT Win) AS Games,
                   SUM(Win)                AS Wins,
                   SUM(NOT Win)            AS Losses
            FROM (SELECT lt1           AS Tower,
                         playerLeftWin AS Win
                  FROM off_tide
                  UNION ALL
                  SELECT lt2           AS Tower,
                         playerLeftWin AS Win
                  FROM off_tide
                  UNION ALL
                  SELECT lt3           AS Tower,
                         playerLeftWin AS Win
                  FROM off_tide
                  UNION ALL
                  SELECT rt1               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM off_tide
                  UNION ALL
                  SELECT rt2               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM off_tide
                  UNION ALL
                  SELECT rt3               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM off_tide)
            GROUP BY Tower))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;