musiccaps_details (view)
2 rows where musiccaps_aspects contains "arcade game music" and musiccaps_aspects contains "groovy bass line" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- arcade game music · 2 ✖
- groovy bass line · 2 ✖
- instrumental music 2
- acoustic guitar lead 1
- adventure 1
- adventurous 1
- animate vocals 1
- average sound quality 1
- building anticipation 1
- cheer 1
- children playing games 1
- computer music 1
- emotional 1
- excited vocals 1
- excitement 1
- fun 1
- game music track 1
- groovy bas slime 1
- handheld game 1
- keyboard harmony 1
- medium fast tempo 1
- medium tempo 1
- midi music 1
- mysterious 1
- poor quality audio 1
- positive 1
- retro game tracks 1
- steady drumming rhythm 1
- string synth harmony 1
- suspense 1
- the great adventure 1
- video game soundtrack 1
- whip sounds 1
musiccaps_names (array) 4 ✖
- Music 2
- /t/dd00032 1
- Background music 1
- Burst, pop 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mabinogi Music Playing- Kuroshitsuji Ending 2: Lacrimosa | The song is an instrumental. The song is medium tempo with a groovy bass line and a guitar synth tone playing melody. The song is exciting and adventurous in nature. The song is a video game song track. | 2011-04-21T22:37:24Z | CatnipMafia | For this score by me and more, please visit: [ http://reo12.webs.com/mmlscript.htm ] | ["Background music", "Music", "/t/dd00032"] | ["acoustic guitar lead", "midi music", "groovy bass line", "children playing games", "handheld game", "arcade game music", "retro game tracks", "poor quality audio", "instrumental music", "computer music", "medium tempo", "game music track", "emotional", "adventurous"] | 1 | uT-S_JC_GzU | 5116 | |
Mario Party 9 | Bowser Pop | The song is an instrumental. The song is medium fast tempo with keyboard accompaniment, steady drumming rhythm, whopping sounds, strong bass line, and string synth harmony. The song is exciting and suspenseful. The song is a video arcade game soundtrack with average quality audio. | 2013-05-26T00:11:26Z | Red9378 | [122 - 720p HD] Mario Party 9 | Bowser Pop Talk about an inflated ego! The COM was set to Master difficulty. This video was recorded on May 16, 2013. | ["Music", "Burst, pop"] | ["arcade game music", "animate vocals", "average sound quality", "instrumental music", "video game soundtrack", "excitement", "adventure", "suspense", "building anticipation", "fun", "cheer", "positive", "the great adventure", "excited vocals", "mysterious", "whip sounds", "medium fast tempo", "groovy bas slime", "keyboard harmony", "string synth harmony", "groovy bass line", "steady drumming rhythm"] | 1 | tAdNaRRFFXg | 5013 |
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;