musiccaps_details (view)
2 rows where musiccaps_aspects contains "enthusiastic", musiccaps_aspects contains "passionate" and musiccaps_names contains "Reggae"
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- enthusiastic · 2 ✖
- keyboard harmony 2
- male singer 2
- passionate · 2 ✖
- bad audio quality 1
- booming bass line 1
- boomy bass lines 1
- catchy vocal riff 1
- digital drum 1
- electronic instruments 1
- energetic 1
- exciting 1
- experimental music 1
- fast tempo 1
- folk 1
- groovy music 1
- insistent 1
- jamaican folk 1
- latin dance music 1
- medium tempo 1
- minimal instruments 1
- missing harmony section 1
- percussive bass line 1
- percussive rhythm 1
- piano accompaniment 1
- raspy vocals 1
- reggae 1
- repetitive rhythm 1
- romantic 1
- spirited 1
- synthesiser arrangements 1
- upbeat 1
- vibrant 1
musiccaps_names (array) 3 ✖
- Music 2
- Reggae · 2 ✖
- Music of Africa 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
PupaJim Raggamuffin | A male Latin singer sings this cool melody. The song is medium tempo with keyboard accompaniment and steady drumming rhythm and a percussive bass-line with missing harmonies. The song is experimental and has bad audio quality. | 2013-08-23T21:58:26Z | bouby076 | Pupajim - Stand High Smokers Pack (2011) | ["Music", "Reggae"] | ["male singer", "booming bass line", "bad audio quality", "missing harmony section", "experimental music", "medium tempo", "latin dance music", "groovy music", "percussive bass line", "exciting", "enthusiastic", "passionate", "spirited", "romantic", "keyboard harmony", "percussive rhythm"] | 1 | 8wty3wJfmEY | 960 | |
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;