all_maps (view)

26 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Map Games Pickrate Average Duration Average End Round Seconds per Round
banana_depot_scene 11124 2.67% 06:43 14.33 24.0
basalt_columns 8706 2.09% 05:55 11.42 25.87
bloon_bot_factory 7711 1.85% 06:20 14.21 26.78
bloonstone_quarry 25985 6.23% 10:47 20.99 27.98
building_site_scene 7654 1.84% 05:32 10.86 25.1
castle_ruins 16890 4.05% 07:55 15.82 26.27
cobra_command 21232 5.09% 07:24 16.73 26.55
dino_graveyard 25589 6.14% 08:35 17.16 26.54
garden 14349 3.44% 07:01 15.15 27.84
glade 12587 3.02% 06:32 13.02 25.52
inflection 10823 2.60% 05:52 11.25 25.98
koru 15024 3.60% 06:46 14.27 24.27
mayan_map_01 11677 2.80% 09:54 20.14 26.57
neo_highway 6574 1.58% 06:44 13.13 26.22
oasis 30000 7.20% 08:08 18.9 25.86
off_tide 25630 6.15% 07:02 16.65 25.39
pirate_cove 11652 2.80% 05:28 12.95 25.37
ports 7947 1.91% 05:37 10.27 27.0
precious_space 17206 4.13% 07:45 16.07 25.21
salmon_pool 13960 3.35% 07:33 15.18 25.95
sands_of_time 25848 6.20% 08:13 18.63 26.46
splashdown 2194 0.53% 06:14 14.39 26.0
star 32312 7.75% 08:25 18.81 26.86
sun_palace 26654 6.39% 08:07 18.85 25.86
times_up 11464 2.75% 06:32 13.72 24.26
up_on_the_roof 16019 3.84% 12:46 22.47 31.43

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