musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "good vibes" and musiccaps_author = 6 sorted by youtube_channel
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- acoustic drums 2
- e-bass 2
- good vibes · 2 ✖
- e-guitar 1
- e-guitars 1
- reggae 1
- rock/pop 1
- slow to medium tempo 1
- steeldrum 1
- uptempo 1
musiccaps_names (array) 3 ✖
- Music 2
- Happy music 1
- Steelpan 1
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 | |
NICE SURF MUSIC | An acoustic drum is played together with an e-bass. They both repeat the same pattern. The ride is panned to the right side of the speakers. Three e-guitars are playing. One is strumming the same chords as the bassline while another one is being strummed with a mute technique playing a reggae rhythm. The third guitar is playing a solo melody on top and is panned to the right side of the speakers. This song may be playing at a bar. | 2007-08-03T21:44:52Z | Nico Afshari | VERY VERY AWESOME SURF MUSIC | ["Music", "Happy music"] | ["rock/pop", "e-guitars", "e-bass", "acoustic drums", "good vibes", "uptempo"] | 6 | IWbe-NSK6Ic | 1914 |
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;