musiccaps_details (view)
3 rows where musiccaps_aspects contains "moderate tempo", musiccaps_aspects contains "programmed percussion" and musiccaps_names contains "Music of Africa"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- bass 3
- moderate tempo · 3 ✖
- programmed percussion · 3 ✖
- dance song 2
- female voice 2
- autotune voice 1
- caribbean music 1
- dance beat 1
- dance music 1
- happy mood 1
- male backing voices 1
- male voice 1
- male voices 1
- marimba 1
- middle eastern song 1
- reggae feel 1
- synth melody 1
- traditional instruments 1
- tribal fusion song 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Mabermuda-Vuthu Marabenta (mocambique musica) | This song features a male voice singing the main melody. Other male voices sing fills in between lines as backing voices. A repetitive melody is played on the marimba. The percussion is programmed and the focus is on the continuous hi-hat strokes. The bass plays the root notes of the chords. The mood of this song is happy. This song can be played at a dance party. | 2012-07-18T16:56:33Z | DOPEITSDAZ MUSIC | ["Afrobeat", "Music of Africa", "Music"] | ["caribbean music", "dance music", "reggae feel", "programmed percussion", "bass", "male voice", "male backing voices", "marimba", "moderate tempo", "happy mood"] | 0 | G9gsCU85c8k | 1695 | ||
chaba dalila mkalcha 2010 live.wmv | This song features a female voice singing the main melody. This song has a Middle-Eastern feel. The voice is accompanied by percussion playing a dance beat. A synth plays a high pitched melody in between lines. A synth pad plays chords in the background. The bass plays the root notes of the chords. Toward the end, all instruments except the synth pads pause. The voice continues to sing at this time. An autotune effect is used on the voice. This song can be played in a club. | 2010-04-04T14:04:11Z | hamrawiya31 | ["Music of Africa", "Music"] | ["middle eastern song", "female voice", "autotune voice", "synth melody", "programmed percussion", "bass", "moderate tempo", "dance song"] | 0 | OnL-e9X0oEc | 2469 | ||
Eze One Ft.Sherifa Gunu - African Dance (Official Video) | This tribal fusion song features a male voice singing the main melody. This is accompanied by percussion playing a dance beat using traditional tribal percussion instruments. The bass plays the root notes of the chords. At the end of the clip, a female voice sings a line. The theme of the song is an African dance. This song can be played in a club. | 2012-04-28T14:14:23Z | afrofusionify | African dance, truly african culture,blend of Azonto in African fusion.Bringing African music,Culture,and fashion together through music, atilogu dance, atilogwu dance, | ["Afrobeat", "Music of Africa", "Music"] | ["tribal fusion song", "dance song", "male voices", "female voice", "dance beat", "programmed percussion", "bass", "traditional instruments", "moderate tempo"] | 0 | ZLXW4ewrVpQ | 3365 |
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;