musiccaps_details (view)
2 rows where musiccaps_aspects contains "tropical" and musiccaps_names contains "Steelpan" sorted by video
This data as json, CSV (advanced)
musiccaps_aspects (array) 18 ✖
- low quality 2
- noisy 2
- tropical · 2 ✖
- background percussive instrumental 1
- emotional 1
- exotic 1
- exotic marimba melody 1
- jazzy drums 1
- loud 1
- mono 1
- muddy bass 1
- mumbling crowd noises 1
- piano keys chords 1
- shimmering hi hats 1
- syncopated snare 1
- thin 1
- tropical steel drum melody 1
- water splashing noise 1
musiccaps_names (array) 3 ✖
- Music 2
- Steelpan · 2 ✖
- Musical instrument 1
video ▼ | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
I'm Yours - steel drum reggae cover | The low quality recording features a tropical steel drum melody playing over background percussive instrumental. It is noisy, but it sounds tropical, exotic and emotional. | 2009-12-18T22:38:29Z | Steel Drum Music | Jason Mraz's reggae-ish hit on steel drums in Wellington, FL on 12/10/2009 Yes, the puffy shirt cracks me up still. It's hot and humid in Florida year round, so I have a fan on the floor behind me blowing full blast most of the time. ♫ iTunes - http://bit.ly/aE3djW Amazon - http://bit.ly/cgT7rA Google - http://bit.ly/38mMiPu https://www.SteelDrumMusic.net | ["Music", "Musical instrument", "Steelpan"] | ["low quality", "noisy", "background percussive instrumental", "tropical steel drum melody", "tropical", "exotic", "emotional"] | 4 | 3zIQTDfS4Hk | 524 | |
Afternoon by the pool on the Serenade of the Seas | The low quality recording features a tropical song playing over speaker and it consists of jazzy drums, muddy bass and exotic marimba melody. It is mono and noisy, while there are also some crowd mumbling and water splashing noises in the background. It sounds thin and loud, but tropical and exotic - like something you would listen to on a vacation. | 2008-07-06T21:14:48Z | Icewave2007 | Just as the title suggests, this is a video shot by the main pool of Royal Caribbean's Serenade of the Seas. This was taken on our sea day (7 day cruise, this was the only day we didn't have a port call). | ["Music", "Steelpan"] | ["low quality", "tropical", "mono", "noisy", "exotic marimba melody", "jazzy drums", "shimmering hi hats", "syncopated snare", "muddy bass", "piano keys chords", "loud", "thin", "mumbling crowd noises", "water splashing noise"] | 4 | PBqNpMpD76k | 2517 |
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;