all_maps (view)

25 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Average Duration, Seconds per Round

Map Games Pickrate Average Duration Average End Round Seconds per Round
banana_depot_scene 1585 2.82% 06:41 14.25 23.97
basalt_columns 1132 2.02% 05:42 11.05 25.55
bloon_bot_factory 1075 1.92% 06:11 13.69 27.1
bloonstone_quarry 3237 5.77% 09:21 20.67 27.16
building_site_scene 1089 1.94% 04:19 10.72 24.21
castle_ruins 2339 4.17% 07:41 15.3 26.22
cobra_command 2954 5.26% 07:11 16.3 26.49
dino_graveyard 3439 6.13% 07:01 16.28 25.9
garden 1847 3.29% 07:36 14.28 27.76
glade 1701 3.03% 05:16 12.68 24.97
inflection 1415 2.52% 05:44 11.05 25.73
koru 2079 3.70% 06:58 14.1 25.41
mayan_map_01 1557 2.77% 09:37 19.57 26.46
neo_highway 1311 2.34% 06:53 13.5 26.22
oasis 4205 7.49% 08:52 18.31 25.82
off_tide 3458 6.16% 07:41 16.08 24.95
pirate_cove 1677 2.99% 05:19 12.59 25.4
ports 1061 1.89% 04:17 10.05 25.6
precious_space 2295 4.09% 06:29 15.67 24.85
salmon_pool 1898 3.38% 06:28 14.96 25.99
sands_of_time 3336 5.94% 08:54 18.17 26.1
star 4250 7.57% 08:01 18.31 26.3
sun_palace 3624 6.46% 08:59 18.51 25.92
times_up 1621 2.89% 06:33 13.76 24.26
up_on_the_roof 1943 3.46% 11:24 21.83 31.37

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW all_maps AS 
WITH elite_maps AS (
    SELECT map, duration, endRound
    FROM matches
    WHERE map NOT IN ('bloontonium_mines', 'docks', 'in_the_wall', 'island_base', 'thin_ice')
)
SELECT map AS Map,
       Games,
       printf('%.2f%%', Games * 100.0 / (SELECT COUNT(*) FROM elite_maps)) AS Pickrate,
       REPLACE((CASE
                    WHEN CAST(ROUND(avg_duration / 60, 0) AS INTEGER) < 10
                        THEN '0' || CAST(ROUND(avg_duration / 60, 0) AS TEXT)
                    ELSE CAST(ROUND(avg_duration / 60, 0) AS TEXT)
           END) || ':' ||
               (CASE
                    WHEN CAST(ROUND(avg_duration % 60, 0) AS INTEGER) < 10
                        THEN '0' || CAST(ROUND(avg_duration % 60, 0) AS TEXT)
                    ELSE CAST(ROUND(avg_duration % 60, 0) AS TEXT)
                   END), '.0', '')                                 AS [Average Duration],
       ROUND(avg_end_round, 2)                                     AS [Average End Round],
       ROUND(avg_duration / avg_end_round, 2)                      AS [Seconds per Round]
FROM (SELECT map,
             AVG(duration) AS avg_duration,
             AVG(endRound) AS avg_end_round,
             COUNT(*)      AS Games
      FROM elite_maps
      GROUP BY map);