musiccaps_details (view)
2 rows where musiccaps_aspects contains "piano accompaniment" and musiccaps_names contains "Music of Africa"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- passionate 2
- piano accompaniment · 2 ✖
- boomy bass lines 1
- catchy vocal riff 1
- dance groove 1
- dance rhythm 1
- digital drum 1
- electronic instruments 1
- emotional 1
- energetic 1
- entertaining 1
- enthusiastic 1
- fast tempo 1
- folk 1
- guiro percussions 1
- guitar rhythm 1
- insistent 1
- jamaican folk 1
- keyboard harmony 1
- latin dance band 1
- latin folk singer 1
- latin percussions 1
- male latin singer 1
- male singer 1
- medium tempo 1
- minimal instruments 1
- people dancing 1
- poor audio quality 1
- raspy vocals 1
- reggae 1
- repetitive rhythm 1
- romantic 1
- soaring vocals 1
- spirited 1
- story telling 1
- synthesiser arrangements 1
- upbeat 1
- vibrant 1
- walking bass line 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
el grillo enamorado | A male singer sings this passionate melody. The song is medium tempo with Latin percussion, guiro percussions, guitar rhythm, piano accompaniment and guitar rhythm. The song is romantic and spirited. The song is a Latin dance song with poor audio quality. | 2008-09-05T17:39:10Z | Piko | el grillo enamorado con imagenes de grillos | ["Music of Africa", "Music", "Ska"] | ["male latin singer", "poor audio quality", "latin percussions", "people dancing", "latin dance band", "dance groove", "emotional", "soaring vocals", "latin folk singer", "walking bass line", "piano accompaniment", "dance rhythm", "entertaining", "romantic", "story telling", "passionate", "spirited", "guiro percussions", "medium tempo", "guitar rhythm"] | 1 | 2cxvYC9QZac | 391 | |
Lee 'Scratch' Perry = Word Sound | A male vocalist sings this spirited song. The tempo is fast with keyboard harmony, piano accompaniment,groovy bass lines, digital drum and synthesiser arrangement. The song is catchy, enjoyable, youthful, energetic and vivacious with recurring and insistent rhythm and a dance groove. This song is a Reggae song. | 2010-06-12T15:29:53Z | mrmsclvr | From Lee Perry 'Smoking' - VPCD1358 - | ["Music of Africa", "Music", "Reggae"] | ["male singer", "fast tempo", "boomy bass lines", "vibrant", "enthusiastic", "energetic", "passionate", "piano accompaniment", "reggae", "folk", "jamaican folk", "catchy vocal riff", "keyboard harmony", "repetitive rhythm", "insistent", "synthesiser arrangements", "raspy vocals", "upbeat", "vibrant", "enthusiastic", "energetic", "minimal instruments", "electronic instruments", "digital drum"] | 7 | sgwvhvkNELc | 4973 |
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;