all_maps (view)

25 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: Average Duration

Map Games Pickrate Average Duration Average End Round Seconds per Round
banana_depot_scene 1472 2.84% 06:39 14.29 23.79
basalt_columns 1248 2.41% 05:52 11.55 25.31
bloon_bot_factory 1013 1.95% 06:18 14.12 26.79
bloonstone_quarry 3103 5.98% 10:46 20.05 29.27
building_site_scene 1105 2.13% 04:27 11.11 24.04
castle_ruins 1960 3.78% 07:30 14.91 26.19
cobra_command 2784 5.37% 07:01 16.03 26.31
dino_graveyard 3065 5.91% 08:38 16.66 27.55
garden 1793 3.46% 06:28 14.44 26.87
glade 1700 3.28% 05:15 12.75 24.77
inflection 1493 2.88% 05:14 11.19 28.13
koru 2127 4.10% 06:42 14.37 23.83
mayan_map_01 1274 2.46% 08:22 19.28 26.06
neo_highway 1243 2.40% 06:40 13.0 26.21
oasis 3889 7.50% 08:00 18.55 25.9
off_tide 3081 5.94% 07:39 15.67 25.46
pirate_cove 1526 2.94% 05:21 12.73 25.24
ports 1101 2.12% 04:24 10.42 25.36
precious_space 2308 4.45% 06:29 15.75 24.74
salmon_pool 1844 3.55% 06:09 14.53 25.44
sands_of_time 3287 6.34% 08:35 17.54 25.95
star 4050 7.81% 08:51 17.96 26.26
sun_palace 2962 5.71% 08:38 18.2 25.21
times_up 1452 2.80% 05:18 13.22 24.12
up_on_the_roof 1003 1.93% 11:12 21.94 30.63

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);