musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic drums", musiccaps_names = "["Music", "Steelpan"]" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Sounds of Steel ~ Don't Stop 'til You Get Enough | A lot of people are playing different parts of a funk song on steel-drums. An acoustic drum is playing a faster funk groove together with congas and shakers. This song may be playing outside at a live show. | 2010-08-02T10:55:36Z | SteeldrumTrust | Sounds of Steel play "Don't Stop 'til You Get Enough" by Michael Jackson at the Blockorama in Trafalgar Square August 1st 2010 Video © Steel Drum Trust | ["Music", "Steelpan"] | ["funk", "steeldrums", "acoustic drums", "congas", "shaker", "uptempo", "amateur recording"] | 6 | Db0c4aAwUbY | 1499 | |
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;