musiccaps_details (view)
2 rows where musiccaps_aspects contains "female voice", musiccaps_author = 0, musiccaps_names contains "Music" and musiccaps_names contains "Music of Africa"
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 |
---|---|---|---|---|---|---|---|---|---|---|
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;