musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "instrumental music" and musiccaps_aspects contains "retro game tracks" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- instrumental music · 2 ✖
- retro game tracks · 2 ✖
- acoustic guitar lead 1
- adventurous 1
- arcade game music 1
- arcade game soundtrack 1
- building tension 1
- children playing games 1
- computer music 1
- cymbal crashes 1
- dangerous journey 1
- distortion guitar playing lead 1
- dragon quest 1
- drum rolls 1
- emotional 1
- energetic 1
- game music track 1
- game play 1
- groovy bass line 1
- groovy music 1
- handheld game 1
- intense battle 1
- medium fast tempo 1
- medium tempo 1
- metal music 1
- midi music 1
- passionate 1
- percussive bass line 1
- poor audio quality 1
- poor quality audio 1
- spirited 1
- suoerfats drumming rhythm 1
- valour and pride 1
- video games 1
- virtuoso guitar lead 1
- warriors fight 1
musiccaps_names (array) 5 ✖
- Music 2
- /t/dd00032 1
- Background music 1
- Cacophony 1
- Heavy metal 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 | |
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;