musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "passionate" and musiccaps_names contains "Music of Africa"
This data as json, CSV (advanced)
musiccaps_aspects (array) 38 ✖
- energetic · 2 ✖
- passionate · 2 ✖
- boomy bass lines 1
- catchy vocal riff 1
- dance groove 1
- dance hits 1
- digital drum 1
- dj 1
- electronic instruments 1
- enthusiastic 1
- exciting 1
- fast tempo 1
- folk 1
- gasping vocals sounds 1
- insistent 1
- instrumental music 1
- jamaican folk 1
- keyboard accompaniment 1
- keyboard harmony 1
- live session 1
- madly in love sexy 1
- male singer 1
- minimal instruments 1
- party all night 1
- piano accompaniment 1
- raspy vocals 1
- reggae 1
- repetitive rhythm 1
- romantic 1
- steady drumming rhythm 1
- synthesiser arrangements 1
- techno dance music 1
- thumping bas slime 1
- trance music 1
- triangle percussions 1
- upbeat 1
- vibrant 1
- youthful 1
musiccaps_names (array) 6 ✖
- Music 2
- Music of Africa · 2 ✖
- Drum and bass 1
- Electronic dance music 1
- House music 1
- Reggae 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Makossa & Megablast feat. Hubert Tubbs - Coming Home (Skwerl's Throbbing Jet Lag Mix) | The song is an instrumental. The tempo is medium with a strong bass line, steady drumming rhythm, triangle percussion, keyboard accompaniment and a male vocalist making guttural noises. The song is a modern techno pop dance tune. | 2014-04-24T20:48:17Z | Tajak | Artist: Makossa & Megablast feat. Hubert Tubbs (Skwerl remix) Single: Coming Home (2010) Label: G-Stone Recordings http://www.beatport.com/release/coming-home/285482 | ["Music of Africa", "Drum and bass", "House music", "Music", "Electronic dance music"] | ["techno dance music", "gasping vocals sounds", "trance music", "dance hits", "triangle percussions", "instrumental music", "dj", "live session", "thumping bas slime", "keyboard accompaniment", "youthful", "energetic", "exciting", "party all night", "dance groove", "madly in love sexy", "romantic", "passionate", "steady drumming rhythm"] | 1 | IMnh-TIyFuE | 1898 | |
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;