musiccaps_details (view)
1 row where musiccaps_aspects contains "male voices", musiccaps_aspects contains "synth song" and musiccaps_names contains "House music"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
▶[nu disco] ★ Miles Dominic - In Retrospect | This disco song features female voices and male voices singing vocables in harmony in the background. A synth melody is played in the foreground. Toward the end of the melody, a synth swell is played in a ringing tone. At the peak, the percussion starts to play a dance beat. The synth changes melody to a faster rhythm. The mood of this song is happy and upbeat. This song can be played in a club. | 2016-01-02T17:30:01Z | Amazing Gaming Music | Welcome to my channe l hope you can help: 🌟🌟Please subscrire Channel :http://www.youtube.com/user/NighTcoreFC 🌟Please help like Fanpage : https://www.facebook.com/AMAZGM/ ------------------------------------------------------- ♥Song : Miles Dominic - In Retrospect ♥Link Download Original song :https://soundcloud.com/milesdominic/in-retrospect-free-dl ♥Link Donwload Channel Promo: ♥Link pic :https://www.facebook.com/NightcoreFanclub/photos/pcb.897139673714736/897138913714812/?type=3&theater ▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶ ▶ Please help us to develop Channel Nightcore Fanclub thank you ▶Link donation :https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=UK9AFXYFTB4MU ▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶▶ ★ Follow Nightcore Fanclub ▶Facebook :https://www.facebook.com/NightcoreFanclub ▶soundcloud:https://soundcloud.com/nightcorefcp ▶twitter :https://twitter.com/NFCPROMO ★ADMIN PAGE: https://www.facebook.com/lediep.quoctrung ▶Channel youtube : +Channel 1 :http://www.youtube.com/user/NighTcoreFC +Channel 2 :http://www.youtube.com/user/DeadMusicFC +Channel 3 :https://www.youtube.com/user/GamerVNFC ♥Steam . game Heartstone ▶▶▶http://talktv.vn/ziiyoyo ▶Follow Miles Dominic https://soundcloud.com/milesdominic https://www.facebook.com/MilesDominicMusic ---------------------------------------------------------------------------------------- ▶You can send Track For us. Channel Will support new song EDM without copyright . Thank For share.. ▶ziiyoy7@gmail.com ----------------------------------------------------------------------------------------- ▶If you use our music you MUST in the description of your video: 1. Include the full title of the track. (Stating the music was provided by NCF) 2. Include a link to the track on NightcoreFC YouTube. 3. Credit the artist(s) of the track by including their social network links. Welcome to my channe l hope you can help: 🌟🌟Please subscrire Channel : http://www.youtube.com/user/NighTcoreFC 🌟Please help like Fanpage : https://www.facebook.com/AMAZGM/ ---… | ["Disco", "House music", "Music"] | ["disco song", "dance song", "female voices", "male voices", "programmed percussion", "vocables", "synth song", "moderate tempo", "happy mood"] | 0 | DOb8htND5_o | 1470 |
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;