musiccaps_details (view)
2 rows where musiccaps_aspects contains "groovy music", musiccaps_aspects contains "medium fast tempo" and musiccaps_aspects contains "spirited"
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- groovy music · 2 ✖
- medium fast tempo · 2 ✖
- passionate 2
- spirited · 2 ✖
- arcade game soundtrack 1
- arcade games 1
- bells ring 1
- building tension 1
- cymbal crashes 1
- dangerous journey 1
- distortion guitar playing lead 1
- dragon quest 1
- drum rolls 1
- energetic 1
- fake punching sounds 1
- fight club 1
- game play 1
- inorganic sounds 1
- instrumental music 1
- instrumental musical retro game track 1
- intense battle 1
- metal music 1
- midi music 1
- never give up 1
- percussive bass line 1
- poor audio quality 1
- retro game tracks 1
- string section hits 1
- suoerfats drumming rhythm 1
- techno music 1
- valour and pride 1
- video game soundtrack 1
- video games 1
- vintage game music 1
- virtuoso guitar lead 1
- warriors fight 1
musiccaps_names (array) 4 ✖
- Music 2
- Cacophony 1
- Heavy metal 1
- Slam 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
[TAS] SNES Saturday Night Slam Masters by Cooljay in 14:02.5 | The song is an instrumental. The song is medium fast tempo with a techno drumming rhythm, keyboard harmony and synth string pad tones. The song is inorganic and exciting. The audio quality is poor and vintage in quality. | 2014-12-14T15:05:05Z | TASVideosChannel | This is a tool-assisted speedrun. For more information, see http://tasvideos.org/2736M.html. TAS originally published on 2014-12-14. Saturday Night Slam Masters is a 2d wrestling game by Capcom that offers a repertoire of throws, special moves and finishers for all wrestlers. It also features the Mayor of Metro City Mike "Macho" Haggar from the Final Fight series as a guest character. In this 4 minutes improvement, Cooljay chose a better character and found a new trick. | ["Music", "Slam"] | ["bells ring", "fake punching sounds", "techno music", "arcade games", "vintage game music", "passionate", "spirited", "never give up", "fight club", "midi music", "instrumental musical retro game track", "groovy music", "string section hits", "inorganic sounds", "video game soundtrack", "medium fast tempo"] | 1 | B_tbkQYT9N0 | 1262 | |
bakugan dimensions game play | The song is an instrumental. The tempo is medium fast with a percussive bass line, super fast metal drumming with cymbal crashes and fast drum rolls and a distorted guitar playing a virtuoso lead. The song is energetic and animated. The song has poor audio quality. | 2010-07-12T05:45:38Z | bradjr10 | more game play of bakugan dimensions | ["Heavy metal", "Music", "Cacophony"] | ["instrumental music", "metal music", "poor audio quality", "energetic", "passionate", "building tension", "warriors fight", "dragon quest", "dangerous journey", "valour and pride", "groovy music", "intense battle", "medium fast tempo", "arcade game soundtrack", "suoerfats drumming rhythm", "distortion guitar playing lead", "percussive bass line", "virtuoso guitar lead", "spirited", "cymbal crashes", "drum rolls", "game play", "video games", "retro game tracks"] | 1 | nT_R3O0OK6U | 4541 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW musiccaps_details AS select musiccaps.url as video, json_object( 'label', coalesce(videos.title, 'Missing from YouTube'), 'href', musiccaps.url ) as youtube_link, musiccaps.caption as musiccaps_caption, videos.publishedAt as youtube_published, videos.channelTitle as youtube_channel, videos.description as youtube_description, musiccaps.audioset_names as musiccaps_names, musiccaps.aspect_list as musiccaps_aspects, musiccaps.author_id as musiccaps_author, videos.id as youtube_id, musiccaps.rowid as musiccaps_rowid from musiccaps left join videos on musiccaps.ytid = videos.id;