musiccaps_details (view)
2 rows where musiccaps_aspects contains "male voices" and musiccaps_names contains "Disco"
This data as json, CSV (advanced)
musiccaps_aspects (array) 11 ✖
- male voices · 2 ✖
- collage 1
- dance song 1
- disco song 1
- female voices 1
- happy mood 1
- indie music 1
- moderate tempo 1
- programmed percussion 1
- synth song 1
- vocables 1
musiccaps_names (array) 9 ✖
- Disco · 2 ✖
- Music 2
- House music 1
- Independent music 1
- Pop music 1
- Psychedelic rock 1
- Punk rock 1
- Rock and roll 1
- Rock 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 | |
ITV Chart Show Indie Chart May 1989 | The excerpt is actually a song collage and it features third songs. In the first one a male voice is singing and the song has a dance feel to it. In the second song a male voice is singing and being backed by male voices at the same time. The instruments used are more close to the rock genre. The third song lasts for a few milliseconds and so it's hard to notice anything about it. | 2007-08-05T19:39:57Z | David Bryant | Features: Wire - Eardrum Buzz My apologies for not including Pixies "Monkey Gone To Heaven" again. Please see April's edition for the featured version. | ["Disco", "Music", "Punk rock", "Independent music", "Psychedelic rock", "Pop music", "Rock music", "Rock and roll"] | ["collage", "male voices", "indie music"] | 2 | oT6ud0OdR_E | 4633 |
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;