koru_hero_loadouts (view)

146 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Hero Loadout Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Adora_Fateweaver BananaFarm, TackShooter, WizardMonkey 399 304 95 76.19% 1.33% 72.01%
StrikerJones_Biker BananaFarm, MonkeyAce, SpikeFactory 155 120 35 77.42% 0.52% 70.84%
Benjamin DartlingGunner, MonkeyVillage, SuperMonkey 208 154 54 74.04% 0.69% 68.08%
Benjamin_DJ DartlingGunner, MonkeyVillage, SuperMonkey 51 40 11 78.43% 0.17% 67.14%
Etienne_Bee BombShooter, GlueGunner, SpikeFactory 62 48 14 77.42% 0.21% 67.01%
PatFusty_Snowman BananaFarm, DartlingGunner, IceMonkey 465 328 137 70.54% 1.55% 66.39%
Quincy_Cyber BananaFarm, EngineerMonkey, WizardMonkey 56 43 13 76.79% 0.19% 65.73%
Quincy BananaFarm, MortarMonkey, TackShooter 540 371 169 68.70% 1.80% 64.79%
Quincy_Cyber BananaFarm, TackShooter, WizardMonkey 2532 1607 925 63.47% 8.43% 61.59%
Etienne_Bee BananaFarm, BoomerangMonkey, MonkeyAce 41 30 11 73.17% 0.14% 59.61%
Benjamin BananaFarm, TackShooter, WizardMonkey 332 207 125 62.35% 1.10% 57.14%
PatFusty_Snowman BananaFarm, IceMonkey, TackShooter 317 196 121 61.83% 1.05% 56.48%
Etienne_Bee BananaFarm, IceMonkey, TackShooter 40 28 12 70.00% 0.13% 55.80%
Jericho_Highwayman BananaFarm, TackShooter, WizardMonkey 619 367 252 59.29% 2.06% 55.42%
Adora BananaFarm, TackShooter, WizardMonkey 118 75 43 63.56% 0.39% 54.88%
Jericho_StarCaptain BananaFarm, TackShooter, WizardMonkey 278 167 111 60.07% 0.93% 54.31%
Adora_Fateweaver BananaFarm, MortarMonkey, TackShooter 126 79 47 62.70% 0.42% 54.25%
Bonnie BananaFarm, TackShooter, WizardMonkey 49 33 16 67.35% 0.16% 54.22%
Quincy BananaFarm, BoomerangMonkey, MortarMonkey 178 109 69 61.24% 0.59% 54.08%
Etienne BananaFarm, BoomerangMonkey, SpikeFactory 319 187 132 58.62% 1.06% 53.22%
Quincy BananaFarm, TackShooter, WizardMonkey 1453 805 648 55.40% 4.84% 52.85%
Jericho BananaFarm, TackShooter, WizardMonkey 1186 658 528 55.48% 3.95% 52.65%
Ezili BananaFarm, BombShooter, WizardMonkey 382 220 162 57.59% 1.27% 52.64%
Etienne_Bee BananaFarm, BoomerangMonkey, IceMonkey 204 120 84 58.82% 0.68% 52.07%
PatFusty_Snowman BananaFarm, IceMonkey, NinjaMonkey 119 72 47 60.50% 0.40% 51.72%
PatFusty_Snowman BananaFarm, DartMonkey, IceMonkey 50 32 18 64.00% 0.17% 50.70%
Ezili BananaFarm, TackShooter, WizardMonkey 501 274 227 54.69% 1.67% 50.33%
Adora_Fateweaver BananaFarm, IceMonkey, TackShooter 41 26 15 63.41% 0.14% 48.67%
Etienne_Bee BananaFarm, TackShooter, WizardMonkey 190 105 85 55.26% 0.63% 48.19%
Quincy_Cyber BananaFarm, BoomerangMonkey, WizardMonkey 67 40 27 59.70% 0.22% 47.96%
Gwendolin BananaFarm, TackShooter, WizardMonkey 101 58 43 57.43% 0.34% 47.78%
Etienne_Bee BananaFarm, BoomerangMonkey, NinjaMonkey 208 113 95 54.33% 0.69% 47.56%
Etienne BananaFarm, GlueGunner, TackShooter 664 338 326 50.90% 2.21% 47.10%
Quincy BananaFarm, DartMonkey, MortarMonkey 28 18 10 64.29% 0.09% 46.54%
Obyn BananaFarm, Druid, MonkeySub 366 189 177 51.64% 1.22% 46.52%
Adora BananaFarm, MortarMonkey, TackShooter 135 74 61 54.81% 0.45% 46.42%
Etienne_Bee BananaFarm, GlueGunner, TackShooter 204 108 96 52.94% 0.68% 46.09%
Etienne_Bee BananaFarm, BombShooter, TackShooter 41 25 16 60.98% 0.14% 46.04%
Jericho_StarCaptain BananaFarm, MortarMonkey, TackShooter 85 48 37 56.47% 0.28% 45.93%
Bonnie SuperMonkey, TackShooter, WizardMonkey 36 22 14 61.11% 0.12% 45.19%
Ezili BananaFarm, NinjaMonkey, WizardMonkey 60 34 26 56.67% 0.20% 44.13%
Adora Alchemist, DartlingGunner, SuperMonkey 82 45 37 54.88% 0.27% 44.11%
Quincy_Cyber BananaFarm, BombShooter, WizardMonkey 70 39 31 55.71% 0.23% 44.08%
Etienne_Bee BananaFarm, BoomerangMonkey, MortarMonkey 35 21 14 60.00% 0.12% 43.77%
Bonnie SpikeFactory, TackShooter, WizardMonkey 132 69 63 52.27% 0.44% 43.75%
Bonnie BananaFarm, SniperMonkey, WizardMonkey 45 26 19 57.78% 0.15% 43.35%
Etienne_Bee BananaFarm, SpikeFactory, TackShooter 57 32 25 56.14% 0.19% 43.26%
Jericho BananaFarm, BoomerangMonkey, MortarMonkey 26 16 10 61.54% 0.09% 42.84%
Adora_Fateweaver BananaFarm, BoomerangMonkey, MortarMonkey 40 23 17 57.50% 0.13% 42.18%
Etienne SpikeFactory, TackShooter, WizardMonkey 168 83 85 49.40% 0.56% 41.84%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW koru_hero_loadouts AS 
WITH koru AS
    (SELECT *
    FROM matches
    WHERE map = 'koru')
SELECT Hero,
       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 Hero,
             Loadout,
             Games,
             Wins,
             Losses,
             CAST(Wins AS REAL) / Games AS WR,
             CAST(Games AS REAL) / (
                 (SELECT COUNT(*)
                  FROM koru) * 2)    AS PR
      FROM (SELECT Hero,
                   Loadout,
                   SUM(Wins) + SUM(NOT Wins) AS Games,
                   SUM(Wins)                 AS Wins,
                   SUM(NOT Wins)             AS Losses
            FROM (SELECT lHero                               AS Hero,
                         printf('%s, %s, %s', lt1, lt2, lt3) AS Loadout,
                         playerLeftWin                       AS Wins
                  FROM koru
                  UNION ALL
                  SELECT rHero                               AS Hero,
                         printf('%s, %s, %s', rt1, rt2, rt3) AS Loadout,
                         NOT playerLeftWin                   AS Wins
                  FROM koru)
            GROUP BY Hero,
                     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;