musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "electric guitar licks" and musiccaps_names contains "Afrobeat" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- electric guitar licks · 2 ✖
- electric guitar stabs 1
- flat male vocal 1
- groovy bass 1
- happy 1
- medium tempo 1
- metallic snare 1
- offbeat acoustic rhythm guitar chords 1
- reggae 1
- reggae pop 1
- simple kick 1
- smooth dance 1
- smooth male r&b vocal 1
- tropical 1
- uplifting 1
- wide background harmonizing female vocals 1
- wide tinny percussive elements 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Eek A Mouse - Talking About The Business | The Reggae song features a flat male vocal singing, alongside wide background harmonizing female vocals, over metallic snare, simple kick hits, offbeat acoustic rhythm guitar chords, groovy bass, electric guitar licks and tinny percussive elements widely spread in the stereo image. Sounds happy and uplifting, like something you can listen to while chilling at the beach. | 2009-08-17T08:56:37Z | GJW | album: eeksperience release: 2001 label: Rfo Records | ["Afrobeat", "Music of Africa", "Funk", "Music", "Mouse", "Ska"] | ["reggae", "offbeat acoustic rhythm guitar chords", "wide background harmonizing female vocals", "flat male vocal", "groovy bass", "electric guitar licks", "metallic snare", "wide tinny percussive elements", "happy", "uplifting", "simple kick"] | 4 | R5JRh08zgMo | 2666 | |
Brighter Days Riddim Megamix - prod. by Silly Walks Discotheque | This is a contemporary reggae song. The vocalist has a smooth and silky voice, the song sounds romantic and intimate. We hear electric guitar chord stabs on the off-beats which characterise the reggae pop style. There are also licks on the electric guitar and a simple drum beat suitable for laid-back dancing. The song has a tropical feel. | 2013-11-15T16:41:16Z | Silly Walks Discotheque | Taken from the BRIGHTER DAYS RIDDIM prod. by Silly Walks Discotheque Composed by Silly Walks Discotheque & Jr Blender Programmed, arranged and mixed by Jr Blender Please support the music and buy it f.e. from I Tunes: http://bit.ly/177DTMq www.sillywalksdisco.com www.facebook.com/sillywalksdisco www.twitter.com/sillywalksdisco | ["Afrobeat", "Music", "Reggae"] | ["reggae pop", "smooth male r&b vocal", "medium tempo", "electric guitar licks", "electric guitar stabs", "smooth dance", "tropical"] | 3 | qlklggFvAZs | 4816 |
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;