musiccaps_details (view)
3 rows where musiccaps_aspects contains "groovy music", musiccaps_aspects contains "medium fast tempo" and musiccaps_aspects contains "passionate"
This data as json, CSV (advanced)
musiccaps_aspects (array) 53 ✖
- groovy music · 3 ✖
- medium fast tempo · 3 ✖
- passionate · 3 ✖
- instrumental music 2
- spirited 2
- arcade game soundtrack 1
- arcade games 1
- bells ring 1
- booming bass line 1
- building tension 1
- cymbal crashes 1
- dangerous journey 1
- distortion guitar playing lead 1
- dragon quest 1
- drum rolls 1
- electric guitar player 1
- energetic 1
- excited 1
- exciting 1
- fake punching sounds 1
- fight club 1
- game play 1
- groovy 1
- guitar demonstration 1
- guitar lessons online 1
- guitar licks 1
- guitar solo 1
- guitarist 1
- inorganic sounds 1
- inspiring 1
- instrumental musical retro game track 1
- intense battle 1
- medium fats tempo 1
- metal music 1
- midi music 1
- never give up 1
- percussive bass line 1
- poor audio quality 1
- positive 1
- retro game tracks 1
- riffs 1
- soloist 1
- string section hits 1
- strumming rhythm 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
- youtube music video 1
musiccaps_names (array) 9 ✖
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 | |
Bill Lawrence "Wilde" L-45 pickups | The song is an instrumental. The song is medium tempo with an electric guitar playing guitar riffs with a nice low end; The audio quality is average. The song is passionate and exciting. | 2010-06-03T01:03:09Z | Flagrant Potato | Playing starts at 2:25. Quick sound test of the Bill and Becky "Wilde" L-45 strat pickups in my Warmoth guitar. Alnico V magnets, dual rail pole pieces (flat). Guitar is 1pc alder body with a goncalo alves neck and ebony fretboard. Guitar is plugged straight into a Yamaha Fifty (G50) 410 combo and was recorded with an active dual-ribbon mic. | ["Reverberation", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] | ["electric guitar player", "guitarist", "riffs", "guitar licks", "passionate", "exciting", "guitar lessons online", "soloist", "youtube music video", "guitar demonstration", "excited", "positive", "medium fast tempo", "groovy music", "inspiring", "inspiring", "guitar solo", "medium fats tempo", "strumming rhythm", "groovy", "booming bass line", "instrumental music"] | 1 | Ta0GmXPnGWk | 2847 | |
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;