oasis_loadouts (view)
329 rows
This data as json, CSV (advanced)
| Loadout | Games | Wins | Losses | Winrate | Pickrate | WinRate_LowerBound_95CI |
|---|---|---|---|---|---|---|
| BananaFarm, BombShooter, MonkeySub | 2949 | 1839 | 1110 | 62.36% | 4.92% | 60.61% |
| BombShooter, DartlingGunner, SpikeFactory | 110 | 76 | 34 | 69.09% | 0.18% | 60.45% |
| HeliPilot, IceMonkey, NinjaMonkey | 78 | 55 | 23 | 70.51% | 0.13% | 60.39% |
| BananaFarm, EngineerMonkey, MonkeyAce | 1398 | 871 | 527 | 62.30% | 2.33% | 59.76% |
| BananaFarm, DartlingGunner, IceMonkey | 1180 | 732 | 448 | 62.03% | 1.97% | 59.26% |
| BananaFarm, BoomerangMonkey, EngineerMonkey | 246 | 160 | 86 | 65.04% | 0.41% | 59.08% |
| BananaFarm, BombShooter, MortarMonkey | 244 | 157 | 87 | 64.34% | 0.41% | 58.33% |
| BananaFarm, BombShooter, WizardMonkey | 1213 | 728 | 485 | 60.02% | 2.02% | 57.26% |
| BananaFarm, DartMonkey, MortarMonkey | 379 | 235 | 144 | 62.01% | 0.63% | 57.12% |
| BananaFarm, DartMonkey, GlueGunner | 824 | 496 | 328 | 60.19% | 1.37% | 56.85% |
| IceMonkey, MonkeyVillage, NinjaMonkey | 242 | 152 | 90 | 62.81% | 0.40% | 56.72% |
| BananaFarm, BombShooter, SpikeFactory | 2548 | 1490 | 1058 | 58.48% | 4.25% | 56.56% |
| DartlingGunner, Druid, SpikeFactory | 162 | 103 | 59 | 63.58% | 0.27% | 56.17% |
| BananaFarm, DartMonkey, SpikeFactory | 456 | 274 | 182 | 60.09% | 0.76% | 55.59% |
| BananaFarm, BoomerangMonkey, SniperMonkey | 215 | 132 | 83 | 61.40% | 0.36% | 54.89% |
| BananaFarm, HeliPilot, IceMonkey | 131 | 82 | 49 | 62.60% | 0.22% | 54.31% |
| Alchemist, MonkeyBuccaneer, MonkeySub | 46 | 31 | 15 | 67.39% | 0.08% | 53.84% |
| BananaFarm, BombShooter, DartlingGunner | 242 | 145 | 97 | 59.92% | 0.40% | 53.74% |
| BananaFarm, Druid, MonkeySub | 4223 | 2306 | 1917 | 54.61% | 7.04% | 53.10% |
| DartMonkey, Druid, MonkeyVillage | 96 | 60 | 36 | 62.50% | 0.16% | 52.82% |
| BananaFarm, Druid, MortarMonkey | 67 | 43 | 24 | 64.18% | 0.11% | 52.70% |
| BombShooter, MortarMonkey, SpikeFactory | 62 | 40 | 22 | 64.52% | 0.10% | 52.61% |
| BananaFarm, TackShooter, WizardMonkey | 2267 | 1226 | 1041 | 54.08% | 3.78% | 52.03% |
| MonkeyAce, SniperMonkey, WizardMonkey | 80 | 50 | 30 | 62.50% | 0.13% | 51.89% |
| BananaFarm, BombShooter, SniperMonkey | 110 | 67 | 43 | 60.91% | 0.18% | 51.79% |
| BoomerangMonkey, SniperMonkey, SuperMonkey | 97 | 59 | 38 | 60.82% | 0.16% | 51.11% |
| BombShooter, MonkeySub, SpikeFactory | 222 | 127 | 95 | 57.21% | 0.37% | 50.70% |
| EngineerMonkey, IceMonkey, SniperMonkey | 87 | 53 | 34 | 60.92% | 0.15% | 50.67% |
| IceMonkey, MonkeyVillage, WizardMonkey | 59 | 37 | 22 | 62.71% | 0.10% | 50.37% |
| BananaFarm, EngineerMonkey, SpikeFactory | 194 | 110 | 84 | 56.70% | 0.32% | 49.73% |
| DartlingGunner, IceMonkey, MonkeyVillage | 371 | 203 | 168 | 54.72% | 0.62% | 49.65% |
| BananaFarm, NinjaMonkey, WizardMonkey | 353 | 193 | 160 | 54.67% | 0.59% | 49.48% |
| BombShooter, MonkeyVillage, MortarMonkey | 60 | 37 | 23 | 61.67% | 0.10% | 49.36% |
| DartMonkey, SpikeFactory, WizardMonkey | 102 | 60 | 42 | 58.82% | 0.17% | 49.27% |
| DartMonkey, IceMonkey, MonkeyVillage | 244 | 135 | 109 | 55.33% | 0.41% | 49.09% |
| BananaFarm, IceMonkey, MonkeySub | 2097 | 1071 | 1026 | 51.07% | 3.50% | 48.93% |
| BananaFarm, EngineerMonkey, MonkeySub | 66 | 40 | 26 | 60.61% | 0.11% | 48.82% |
| BananaFarm, IceMonkey, WizardMonkey | 167 | 94 | 73 | 56.29% | 0.28% | 48.76% |
| BananaFarm, BoomerangMonkey, MortarMonkey | 242 | 133 | 109 | 54.96% | 0.40% | 48.69% |
| DartlingGunner, MonkeyVillage, SuperMonkey | 899 | 466 | 433 | 51.84% | 1.50% | 48.57% |
| IceMonkey, SniperMonkey, SuperMonkey | 50 | 31 | 19 | 62.00% | 0.08% | 48.55% |
| DartMonkey, GlueGunner, MonkeyVillage | 896 | 463 | 433 | 51.67% | 1.49% | 48.40% |
| BombShooter, SpikeFactory, WizardMonkey | 165 | 92 | 73 | 55.76% | 0.28% | 48.18% |
| Alchemist, HeliPilot, NinjaMonkey | 378 | 201 | 177 | 53.17% | 0.63% | 48.14% |
| BananaFarm, BoomerangMonkey, SpikeFactory | 468 | 246 | 222 | 52.56% | 0.78% | 48.04% |
| BananaFarm, EngineerMonkey, SuperMonkey | 514 | 269 | 245 | 52.33% | 0.86% | 48.02% |
| BananaFarm, BoomerangMonkey, WizardMonkey | 277 | 148 | 129 | 53.43% | 0.46% | 47.56% |
| BoomerangMonkey, MonkeySub, SpikeFactory | 100 | 57 | 43 | 57.00% | 0.17% | 47.30% |
| BoomerangMonkey, EngineerMonkey, SpikeFactory | 33 | 21 | 12 | 63.64% | 0.06% | 47.22% |
| BananaFarm, IceMonkey, NinjaMonkey | 324 | 170 | 154 | 52.47% | 0.54% | 47.03% |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW oasis_loadouts AS
WITH oasis AS
(SELECT *
FROM matches
WHERE map = 'oasis')
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 oasis) * 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 oasis
UNION ALL
SELECT printf('%s, %s, %s', rt1, rt2, rt3) AS Loadout,
NOT playerLeftWin AS Win
FROM oasis)
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;