off_tide_heroes (view)
24 rows
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
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;