musiccaps_details (view)
3 rows where musiccaps_aspects contains "noisy", musiccaps_aspects contains "shimmering hi hats" 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Andy Narell: Coffee Street | The low quality recording features a live performance of a big band that consists of shimmering hi hats, steel pan melody, punchy snare, soft kick hits, bright brass melody, groovy double bass melody and cowbell percussion. The recording is a bit noisy and it sounds happy and fun. | 2013-01-22T23:26:57Z | University of North Texas College Concerts | Coffee Street, (1998) by Andy Narell 2:00 Steel Band - Mark Ford, director One O'Clock Lab Band - Steve Weist, director Recorded Live, October 29, 2012 Winspear Hall, College of Music University of North Texas http://music.unt.edu More about UNT Percussion: http://music.unt.edu/pecussion | ["Music", "Steelpan"] | ["low quality", "live performance", "noisy", "big band", "shimmering hi hats", "punchy snare", "soft kick hits", "steel pan melody", "bright brass melody", "groovy double bass melody", "cowbell percussion", "fun", "happy"] | 4 | _fKntnlIYTQ | 3481 | |
Starlite Steelband playing Yellow Bird | The low quality recording features a steel drums melody played over punchy kick and snare hits, shimmering hi hats and groovy bass. It sounds exotic and joyful. The recording is noisy. | 2008-01-05T21:17:18Z | Richard Gooding | Links Picnic 2007. Starlite Steelband playing Yellow Bird | ["Drum", "Drum kit", "Music", "Musical instrument", "Percussion", "Steelpan"] | ["low quality", "noisy", "crowd talking", "steel drums melody", "punchy snare", "punchy kick", "groovy bass", "shimmering hi hats", "exotic", "joyful"] | 4 | loyHHBilYPM | 4423 |
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;