musiccaps_details (view)
3 rows where musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "male vocal", musiccaps_aspects contains "percussion" and musiccaps_names contains "Music"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Guinney Pepper ft Chewbacca - Lick Di Chalice | This is a tongue-in-cheek version of a reggae song edited to make it sound like a movie character was featured in it. It has a male vocal that starts singing with a Jamaican accent that turns into gibberish. Clean electric guitar and bass guitar provide the melodic background while the acoustic drums and percussion play a basic reggae beat for the rhythmic background. | 2012-03-08T03:22:22Z | Baidawi | Star Wars 2015. The Force Awakens. Chewbacca. | ["Music", "/t/dd00032"] | ["reggae", "male vocal", "gibberish", "electric guitar", "bass guitar", "acoustic drums", "percussion", "comedic", "parody"] | 9 | 7ZXz3Xa7APs | 859 | |
Adabu Steven - "NANAI" [Official Music Video] | This is a modern sounding Afrobeat music piece. There is a male vocal singing the same line repeatedly vocal with a male back vocal ad-libbing in the background. The electric guitar is playing a mellow tune. A low-to-medium range bass line that can be heard. The rhythm consists of an acoustic drum beat with supporting percussive elements. Brass stabs can be heard every now and then. The atmosphere is groovy. This piece could be played at African nightclubs or dance clubs. | 2016-05-28T06:28:06Z | Adabu Steven | Adabu Steven - "Nanai" (Official Music Video) Music video by ADABU STEVEN performing NANAI Prod: by Njenga Giggz (xtrim record) Dir: by Dangfilms Adabu steven (c) 2016 ADABU THE BEST ENT . https://www.instagram.com/adabusteven/ https://www.facebook.com/Adabu-Steven-276248899191596/?ref=settings https://mobile.twitter.com/adabusteven #adabumusic #houston | ["Blues", "Music", "Dance music"] | ["afrobeat", "modern sound", "male vocal", "repeated theme", "electric guitar", "bass guitar", "acoustic drums", "percussion", "brass stab", "energetic", "groovy", "danceable"] | 9 | Ade0UZnb6dw | 1147 | |
ΔΗΜΟΤΙΚΑ ΤΡΑΓΟΥΔΙΑ ΑΠΟ ΠΑΝΗΓΥΡΙΑ ΣΤΗΝ ΡΟΥΜΕΛΗ 🎤 | This is a Greek folk music piece. There is a male vocalist singing melodically and with a lot of articulation. The clarinet is playing the main theme while there is an electric guitar playing a backing tune. The rhythmic background consists of a percussion line that sounds very much like the toubeleki. There is a vibrant atmosphere. This piece could be playing in the background at a Greek cuisine restaurant or a Greek tavern. | 2011-06-05T18:34:18Z | George Amfilochia | #ΠΑΡΑΔΟΣΙΑΚΑ 00:00 Αυτά τα μαύρα μάτια 1:42 Αυτού ψηλά ματάκια μου 2:40 Άνθισε και πάλι η αμυγδαλιά 6:33 Aν μ' αγαπας να μου το πεις 10:07 Ανάθεμα την ώρα που σε γνώρισα | ["Clarinet", "Music", "Middle Eastern music"] | ["greek folk music", "male vocal", "melodic singing", "clarinet", "electric guitar", "percussion", "toubeleki", "vibrant", "easygoing"] | 9 | jHEBYrI8zHE | 4244 |
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;