all_towers (view)

22 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Winrate

Tower Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
EngineerMonkey 2237 1254 983 56.06% 3.01% 54.00%
MonkeyAce 1863 1048 815 56.25% 2.51% 54.00%
BananaFarm 15692 8366 7326 53.31% 21.11% 52.53%
WizardMonkey 6661 3469 3192 52.08% 8.96% 50.88%
BombShooter 2513 1312 1201 52.21% 3.38% 50.26%
TackShooter 5593 2865 2728 51.22% 7.53% 49.91%
IceMonkey 2436 1263 1173 51.85% 3.28% 49.86%
MortarMonkey 1612 836 776 51.86% 2.17% 49.42%
DartMonkey 2290 1173 1117 51.22% 3.08% 49.18%
SpikeFactory 4658 2320 2338 49.81% 6.27% 48.37%
MonkeySub 3524 1760 1764 49.94% 4.74% 48.29%
DartlingGunner 3845 1893 1952 49.23% 5.17% 47.65%
Alchemist 2052 1015 1037 49.46% 2.76% 47.30%
BoomerangMonkey 2673 1285 1388 48.07% 3.60% 46.18%
Druid 1385 674 711 48.66% 1.86% 46.03%
NinjaMonkey 3127 1456 1671 46.56% 4.21% 44.81%
HeliPilot 1350 636 714 47.11% 1.82% 44.45%
MonkeyBuccaneer 1427 620 807 43.45% 1.92% 40.88%
SuperMonkey 2387 1019 1368 42.69% 3.21% 40.71%
MonkeyVillage 2840 1195 1645 42.08% 3.82% 40.26%
GlueGunner 1814 748 1066 41.23% 2.44% 38.97%
SniperMonkey 2343 954 1389 40.72% 3.15% 38.73%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW all_towers AS 
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 matches) * 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 matches
                  UNION ALL
                  SELECT lt2           AS Tower,
                         playerLeftWin AS Win
                  FROM matches
                  UNION ALL
                  SELECT lt3           AS Tower,
                         playerLeftWin AS Win
                  FROM matches
                  UNION ALL
                  SELECT rt1               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM matches
                  UNION ALL
                  SELECT rt2               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM matches
                  UNION ALL
                  SELECT rt3               AS Tower,
                         NOT playerLeftWin AS Win
                  FROM matches)
            GROUP BY Tower))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;