musiccaps_details (view)
2 rows where musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "groovy", musiccaps_aspects contains "percussion" and musiccaps_names contains "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 |
---|---|---|---|---|---|---|---|---|---|---|
LIONEL RICHIE FT. BUSY SIGNAL - ALL NIGHT LONG - DJ GENESIS REMIX (MARS 2014) | This is a remix of an R&B soul piece. There is a male vocal singing in a laid-back manner joined by an auto-tuned male vocal. The keyboard provides the melody with a gentle bass guitar playing in the background. The rhythmic structure is composed of the acoustic drums and the percussion playing a medium tempo beat. The atmosphere of the piece is groovy and there is a feelgood aura to it. This piece could be used in the soundtrack of a sitcom. | 2014-03-26T13:04:56Z | Drahpaa | https://soundcloud.com/dj-genesis https://twitter.com/DJGENESIS1 CREATIVE DJ/PRODUCER/AUDIO ENGINEER/REMIX MASTER/GRAPHIC ARTIST, www.flamesradio.co.uk or 94.4FM, SEND TRACKS TO dj_genesis191@yahoo.com FOR BOOKINGS : dj_genesis191@yahoo.com | ["Music of Africa", "Music", "Rhythm and blues"] | ["r&b", "soul", "remix", "male vocals", "auto-tuned singing", "keyboard", "bass", "acoustic drums", "percussion", "electric guitar", "groovy"] | 9 | 1heMbyumHAo | 299 | |
Adabu Steven - "NANAI" [Official Music Video] | This is a modern sounding Afrobeat music piece. There is a male vocal singing the same line repeatedly vocal with a male back vocal ad-libbing in the background. The electric guitar is playing a mellow tune. A low-to-medium range bass line that can be heard. The rhythm consists of an acoustic drum beat with supporting percussive elements. Brass stabs can be heard every now and then. The atmosphere is groovy. This piece could be played at African nightclubs or dance clubs. | 2016-05-28T06:28:06Z | Adabu Steven | Adabu Steven - "Nanai" (Official Music Video) Music video by ADABU STEVEN performing NANAI Prod: by Njenga Giggz (xtrim record) Dir: by Dangfilms Adabu steven (c) 2016 ADABU THE BEST ENT . https://www.instagram.com/adabusteven/ https://www.facebook.com/Adabu-Steven-276248899191596/?ref=settings https://mobile.twitter.com/adabusteven #adabumusic #houston | ["Blues", "Music", "Dance music"] | ["afrobeat", "modern sound", "male vocal", "repeated theme", "electric guitar", "bass guitar", "acoustic drums", "percussion", "brass stab", "energetic", "groovy", "danceable"] | 9 | Ade0UZnb6dw | 1147 |
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;