musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "percussion" and musiccaps_names contains "Music of Africa" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 26 ✖
- acoustic drums 3
- percussion · 3 ✖
- keyboard 2
- auto-tuned singing 1
- bass 1
- bass guitar 1
- brass 1
- chill 1
- dance 1
- e-bass 1
- e-guitar 1
- easygoing 1
- electric guitar 1
- fast tempo 1
- groovy 1
- haiti dance 1
- keys 1
- male vocal 1
- male vocals 1
- melodic singing 1
- r&b 1
- remix 1
- saxophone 1
- ska 1
- soul 1
- uplifting energy 1
musiccaps_names (array) 7 ✖
- Music 3
- Music of Africa · 3 ✖
- Afrobeat 1
- Reggae 1
- Rhythm and blues 1
- Salsa music 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Habri bo brasa ku mini sound band | This is a Haiti dance music piece. There is a male vocalist singing melodically in the Creole language. The brass, the keyboard and the bass guitar are the melodic elements of this piece. In the rhythmic background, the acoustic drums and percussive elements are playing a latin type beat. The atmosphere of the piece is chill and easygoing. This piece could be played at Caribbean bars and dance clubs. It could also be used as an accompaniment piece for dancing courses. | 2009-04-01T15:45:12Z | 3Kin3kin3 | ["Afrobeat", "Music of Africa", "Music", "Salsa music"] | ["haiti dance", "male vocal", "melodic singing", "brass", "keyboard", "bass guitar", "acoustic drums", "percussion", "chill", "dance", "easygoing"] | 9 | qrY7PW5guxk | 4827 | ||
Revolucionario-Rompope Sound | An acoustic drum is playing along with a bassline giving the song a ska/reggae feeling. The e-guitar strumming on the offbeat supports that feeling while a keyboard is playing a bell-sounding chord. Bongos are setting little accents at the end. A saxophone is playing a melody along. This song may be playing at a festival outside while the sun is shining. | 2014-06-06T00:05:11Z | Zkanker Efrain Lorenzo Bautista | Demo! El facebook de la banda:https://www.facebook.com/bandda.rompoopee | ["Swing music", "Music of Africa", "Music", "Reggae"] | ["ska", "saxophone", "e-guitar", "acoustic drums", "percussion", "keys", "e-bass", "fast tempo", "uplifting energy"] | 6 | -kpR93atgd8 | 79 | |
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 |
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;