star_hero_loadouts (view)

47 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Hero

Hero Loadout Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
Jericho BananaFarm, EngineerMonkey, MonkeyAce 136 94 42 69.12% 1.60% 61.35%
Etienne BananaFarm, DartMonkey, GlueGunner 37 27 10 72.97% 0.44% 58.66%
Etienne_Bee GlueGunner, MonkeyVillage, TackShooter 37 27 10 72.97% 0.44% 58.66%
PatFusty_Snowman HeliPilot, IceMonkey, SuperMonkey 69 47 22 68.12% 0.81% 57.12%
Churchill_Sentai BananaFarm, BombShooter, MonkeySub 254 155 99 61.02% 2.99% 55.03%
PatFusty_Snowman IceMonkey, MonkeyVillage, TackShooter 70 45 25 64.29% 0.82% 53.06%
Adora BananaFarm, IceMonkey, SuperMonkey 60 38 22 63.33% 0.71% 51.14%
PatFusty_Snowman BananaFarm, DartlingGunner, IceMonkey 239 137 102 57.32% 2.81% 51.05%
PatFusty_Snowman IceMonkey, MonkeyVillage, NinjaMonkey 62 39 23 62.90% 0.73% 50.88%
Gwendolin_Science GlueGunner, MonkeyVillage, TackShooter 426 227 199 53.29% 5.01% 48.55%
Ezili BananaFarm, BombShooter, WizardMonkey 132 75 57 56.82% 1.55% 48.37%
Etienne_Bee BananaFarm, BoomerangMonkey, NinjaMonkey 154 86 68 55.84% 1.81% 48.00%
Quincy BananaFarm, TackShooter, WizardMonkey 191 104 87 54.45% 2.25% 47.39%
Etienne_Bee BananaFarm, BoomerangMonkey, EngineerMonkey 76 44 32 57.89% 0.89% 46.79%
Quincy BananaFarm, BombShooter, MonkeySub 69 40 29 57.97% 0.81% 46.32%
Jericho BananaFarm, TackShooter, WizardMonkey 72 41 31 56.94% 0.85% 45.51%
Gwendolin BananaFarm, IceMonkey, MonkeyBuccaneer 34 21 13 61.76% 0.40% 45.43%
Obyn BananaFarm, Druid, MonkeySub 402 201 201 50.00% 4.73% 45.11%
Etienne_Bee BananaFarm, BombShooter, MonkeySub 33 20 13 60.61% 0.39% 43.93%
Benjamin DartlingGunner, MonkeyVillage, SuperMonkey 128 67 61 52.34% 1.51% 43.69%
PatFusty DartMonkey, IceMonkey, MonkeyVillage 26 16 10 61.54% 0.31% 42.84%
Bonnie Alchemist, MonkeyBuccaneer, SpikeFactory 38 22 16 57.89% 0.45% 42.20%
PatFusty_Snowman DartlingGunner, IceMonkey, MonkeyVillage 35 20 15 57.14% 0.41% 40.75%
Ezili BananaFarm, NinjaMonkey, WizardMonkey 33 19 14 57.58% 0.39% 40.71%
Churchill BananaFarm, BombShooter, MonkeySub 87 44 43 50.57% 1.02% 40.07%
Etienne_Bee BananaFarm, BoomerangMonkey, SpikeFactory 87 44 43 50.57% 1.02% 40.07%
Obyn_Ocean Alchemist, BananaFarm, NinjaMonkey 72 37 35 51.39% 0.85% 39.84%
Quincy_Cyber BananaFarm, TackShooter, WizardMonkey 38 21 17 55.26% 0.45% 39.45%
StrikerJones_Biker BombShooter, MonkeyVillage, SpikeFactory 26 15 11 57.69% 0.31% 38.70%
Jericho_StarCaptain BananaFarm, TackShooter, WizardMonkey 35 19 16 54.29% 0.41% 37.78%
Jericho BananaFarm, BombShooter, MonkeySub 175 79 96 45.14% 2.06% 37.77%
StrikerJones BananaFarm, BombShooter, MortarMonkey 27 15 12 55.56% 0.32% 36.81%
Gwendolin_Science GlueGunner, HeliPilot, MonkeyVillage 135 60 75 44.44% 1.59% 36.06%
Etienne_Bee BananaFarm, BombShooter, SpikeFactory 69 33 36 47.83% 0.81% 36.04%
Etienne BananaFarm, GlueGunner, TackShooter 32 17 15 53.13% 0.38% 35.83%
Etienne BananaFarm, BombShooter, SpikeFactory 40 20 20 50.00% 0.47% 34.50%
Etienne EngineerMonkey, TackShooter, WizardMonkey 36 18 18 50.00% 0.42% 33.67%
Jericho_StarCaptain BananaFarm, BombShooter, MonkeySub 27 14 13 51.85% 0.32% 33.00%
Benjamin BananaFarm, DartlingGunner, SuperMonkey 50 23 27 46.00% 0.59% 32.19%
Etienne BananaFarm, TackShooter, WizardMonkey 39 17 22 43.59% 0.46% 28.03%
PatFusty_Snowman BananaFarm, IceMonkey, TackShooter 23 11 12 47.83% 0.27% 27.41%
Gwendolin_Science BananaFarm, GlueGunner, MonkeySub 29 13 16 44.83% 0.34% 26.73%
Gwendolin BananaFarm, MonkeySub, SuperMonkey 21 10 11 47.62% 0.25% 26.26%
Gwendolin GlueGunner, MonkeyVillage, TackShooter 57 21 36 36.84% 0.67% 24.32%
Obyn_Ocean Alchemist, HeliPilot, NinjaMonkey 41 16 25 39.02% 0.48% 24.09%
Etienne BananaFarm, BoomerangMonkey, NinjaMonkey 24 10 14 41.67% 0.28% 21.94%
Churchill_Sentai BombShooter, DartlingGunner, WizardMonkey 33 12 21 36.36% 0.39% 19.95%

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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