home / season_27_matches

off_tide_heroes (view)

24 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Wins, Losses

Hero Games Wins Losses Winrate Pickrate Winrate_LowerBound_95CI
PatFusty_Snowman 407 243 164 59.71% 6.98% 54.94%
Jericho_StarCaptain 152 95 57 62.50% 2.61% 54.80%
Benjamin 265 152 113 57.36% 4.55% 51.40%
Etienne_Bee 528 287 241 54.36% 9.06% 50.11%
Adora_Fateweaver 82 49 33 59.76% 1.41% 49.14%
Ezili 167 94 73 56.29% 2.86% 48.76%
StrikerJones 130 72 58 55.38% 2.23% 46.84%
Etienne 1141 562 579 49.26% 19.57% 46.35%
Jericho 335 172 163 51.34% 5.75% 45.99%
Adora 241 123 118 51.04% 4.13% 44.73%
Bonnie 567 274 293 48.32% 9.73% 44.21%
Quincy 379 185 194 48.81% 6.50% 43.78%
Gwendolin_Science 440 201 239 45.68% 7.55% 41.03%
Jericho_Highwayman 90 46 44 51.11% 1.54% 40.78%
Ezili_SmudgeCat 38 21 17 55.26% 0.65% 39.45%
Quincy_Cyber 94 45 49 47.87% 1.61% 37.77%
Obyn 143 63 80 44.06% 2.45% 35.92%
Obyn_Ocean 99 42 57 42.42% 1.70% 32.69%
Gwendolin 204 78 126 38.24% 3.50% 31.57%
PatFusty 95 37 58 38.95% 1.63% 29.14%
Benjamin_DJ 45 18 27 40.00% 0.77% 25.69%
StrikerJones_Biker 42 16 26 38.10% 0.72% 23.41%
Churchill 70 20 50 28.57% 1.20% 17.99%
Churchill_Sentai 76 20 56 26.32% 1.30% 16.42%

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE VIEW off_tide_heroes AS 
WITH off_tide AS
    (SELECT *
    FROM matches
    WHERE map = 'off_tide')
SELECT Hero,
       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,
             Games,
             Wins,
             Losses,
             CAST(Wins AS REAL) / Games AS WR,
             CAST(Games AS REAL) / (
                 (SELECT COUNT(*)
                  FROM off_tide) * 2)    AS PR
      FROM (SELECT Hero,
                   SUM(Win) + SUM(NOT Win) AS Games,
                   SUM(Win)                AS Wins,
                   SUM(NOT Win)            AS Losses
            FROM (SELECT lHero             AS Hero,
                         playerLeftWin     AS Win
                  FROM off_tide
                  UNION ALL
                  SELECT rHero             AS Hero,
                         NOT playerLeftWin AS Win
                  FROM off_tide)
            GROUP BY Hero))
WHERE Wins >= 10 AND Losses >= 10 AND LENGTH(Winrate_LowerBound_95CI) = 6
ORDER BY Winrate_LowerBound_95CI DESC;
Powered by Datasette · Queries took 552.012ms