musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic dance music" and musiccaps_names contains "Rhythm and blues" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 36 ✖
- electronic dance music · 2 ✖
- backup singers 1
- buddha music 1
- church bells 1
- dance party 1
- dj 1
- dj introduction 1
- dj introduction video 1
- electronic music 1
- exciting 1
- flute playing 1
- groovy 1
- groovy bass line 1
- groovy drumming rhythm 1
- instrumental music 1
- keyboard harmony 1
- lounge music 1
- lounge techno music 1
- male and female vocals 1
- male singer 1
- male vocals 1
- medium tempo 1
- oriental music 1
- party all night 1
- party music 1
- party time 1
- passionate 1
- people dancing 1
- poor audio quality 1
- relaxing 1
- relaxing playlist 1
- slow dancing 1
- strong bass line 1
- techno dance music 1
- wave your hands 1
- youthful music 1
musiccaps_names (array) 3 ✖
- Music 2
- Rhythm and blues · 2 ✖
- Hip hop music 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ILLY NOISE - Voyage | The song is an instrumental with a smattering of female and male vocals. The song is medium tempo with a groovy drum rhythm, church bell accompaniment, slick percussion hits, sustained bass hits, flute playing and vocal chants. The song is relaxing. The song is a techno lounge tune. | 2014-11-28T08:00:03Z | inversic. | ILLY NOISE - Voyage Subscribe for Daily Music ► [http://bit.do/ParadoxiumMusic] Submit Track: [http://www.paradoxium.net/submit-track] Stay Connected » Facebook: http://on.fb.me/1vpsoe0 » Twitter: http://goo.gl/J6Jvnz » Soundcloud: http://goo.gl/dqulbq Purchase Track: / Free Download: https://soundcloud.com/xxx/illy-noise-voyage ▼ Follow https://www.youtube.com/user/illynoisemusic https://www.facebook.com/illynoiseofficial http://www.twitter.com/illynoisemusic https://soundcloud.com/illynoise Picture By: ReneAigner http://reneaigner.deviantart.com/art/The-Narrow-Sea-272550570 - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - Paradoxium only uploads music along with pictures for the entertainment of others. If any label or artist of either the song or picture removed, Please do not strike the video, ask to have it removed via email, which will be done ASAP paradoxiumsounds@outlook.com | ["Music", "Rhythm and blues"] | ["oriental music", "techno dance music", "electronic music", "relaxing playlist", "flute playing", "male and female vocals", "medium tempo", "groovy drumming rhythm", "strong bass line", "lounge techno music", "electronic dance music", "lounge music", "buddha music", "exciting", "passionate", "relaxing", "groovy", "instrumental music", "church bells"] | 1 | AUPmWhim37Y | 1121 | |
RDV TOUS LES VENDREDI @ LOVE BOAT / TOULOUSE (hiphop & dancehall) | A male singer introduces the DJ lineup with an enthusiastic song. The tempo is medium with a groovy bass line, steady drumming rhythm, keyboard harmony and other percussion hits. The song is enthusiastic and energetic. The audio quality is very poor. | 2009-11-17T02:45:12Z | bengbengprod | RDV TOUS LES VENDREDI @ LOVE BOAT!!! dj skyone & dj akel au mix! ( hiphop hits, dancehall tunes, remixes, rn'b dancefloor, brand new dirty, house rmx ) c'est gratuit pour les miss avant o1h!!! 1o€ + conso! attention get ur swagg on! tenue fashion, glamour de rigueur!!! (contacts & infoline: bengbengprod@live.fr / 06 28 96 64 84 ) | ["Music", "Rhythm and blues", "Hip hop music"] | ["dj", "male vocals", "dj introduction", "party all night", "dance party", "people dancing", "wave your hands", "party music", "party time", "youthful music", "slow dancing", "electronic dance music", "poor audio quality", "male singer", "backup singers", "dj introduction video", "keyboard harmony", "groovy bass line"] | 1 | LvpImXJMryI | 2228 |
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;