musiccaps_details (view)
2 rows where musiccaps_aspects contains "dance song" and musiccaps_names contains "House music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- dance song · 2 ✖
- moderate tempo 2
- programmed percussion 2
- bass 1
- club music 1
- disco song 1
- female voices 1
- happy mood 1
- instrumental 1
- male voices 1
- no voices 1
- synth 1
- synth song 1
- techno song 1
- vocables 1
musiccaps_names (array) 6 ✖
- House music · 2 ✖
- Music 2
- Disco 1
- Dubstep 1
- Electronic dance music 1
- Electronic music 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 | |
Tony Igy - Selection | This techno song features a synth playing the main melody. It is based on chord structures. The bass plays the root notes of the chords. The percussion is programmed. The kick plays on every count and the hi-hat plays on the 'and' of every count. After four bars, the kick plays an eighth note rhythm. This song can be played in a club. | 2010-10-13T03:36:22Z | robiimusic | eLecTro MuSiC | ["Electronic music", "House music", "Music", "Dubstep", "Electronic dance music"] | ["techno song", "no voices", "programmed percussion", "synth", "bass", "moderate tempo", "instrumental", "dance song", "club music"] | 0 | bqeVxA97TQU | 3658 |
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;