musiccaps_details (view)
2 rows where musiccaps_aspects contains "female voices" and musiccaps_aspects contains "programmed percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 12 ✖
- female voices · 2 ✖
- programmed percussion · 2 ✖
- dance song 1
- disco song 1
- fast tempo 1
- folk dubstep 1
- happy mood 1
- jaw harp 1
- male voices 1
- moderate tempo 1
- synth song 1
- vocables 1
musiccaps_names (array) 7 ✖
- Music 2
- Disco 1
- Dubstep 1
- Electronic music 1
- House music 1
- Pop music 1
- Zing 1
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 | |
Ukraine Epic Dubstep | This folk dubstep features female voices singing the main melody. This is accompanied by percussion playing a dubstep beat. The tempo of the beat is fast, incorporating shuffles. A jaw harp plays a quirky sound in the background. The tempo of the song is fast. At the beginning, there is no bass. Toward the end, the bass plays while the percussion gets louder. This song can be played in a club. | 2013-05-18T14:16:11Z | Tvz777 | Kind Of Zero feat Marvinok-Коломийки. | ["Electronic music", "Music", "Pop music", "Zing", "Dubstep"] | ["folk dubstep", "fast tempo", "female voices", "jaw harp", "programmed percussion"] | 0 | qpwjSTEaswI | 4825 |
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;