musiccaps_details (view)
1 row where musiccaps_aspects contains "good vibes", musiccaps_aspects contains "slow to medium tempo", musiccaps_names contains "Music" and musiccaps_names contains "Steelpan"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Steel Drum - UB40 Red Red Wine by Dano's Island Sounds | An acoustic drum is playing a straight groove while an e-bass is playing a bassline that reminds of reggae. This feeling gets enhanced by a e-guitar strumming a short rhythmic chord on the offbeat giving the song its typical reggae vibe. On top of that, someone is playing a melody on a steeldrums. This song may be playing at beachbar. | 2014-03-05T08:21:26Z | DanoDrum | Music Video by Dano's Island Sounds Download or stream high quality audio at iTunes or Spotify. Red Red Wine was made popular by UB40, but this classic song was written by Neil Diamond. Song: Red Red Wine Artist: Dano's Island Sounds Genre: Instrumental Rock Reggae Album: Single Released: 4/01/2017 Uploaded: 3/05/2014 Dano Lancelot: tenor steel pan, drums, percussion, guitar & sequencing Craig Erwin: lead guitar iTunes: https://itunes.apple.com/us/album/red-red-wine-single/1223222911 Spotify: https://open.spotify.com/album/54fLmCFswZgnD42zGuhkKh?si=ir0f2drLTNG0m1mGPTHY7g Follow Us On YouTube: https://www.youtube.com/user/b52rockit Instagram: https://www.instagram.com/danosisland... Facebook: https://www.facebook.com/DanosIslandS... Website: http://danosislandsounds.com/ Contact Dano if you would like to use this video or audio in visual media, films, TV series/shows, documentaries, video games, websites or advertising. https://danosislandsounds.com/ © 2014 Hug It Out Productions | ["Music", "Steelpan"] | ["reggae", "steeldrum", "e-bass", "e-guitar", "acoustic drums", "slow to medium tempo", "good vibes"] | 6 | GaNjXwElAUE | 1737 |
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;