musiccaps_details (view)
1 row where musiccaps_aspects contains "muddy bass", musiccaps_aspects contains "noisy", musiccaps_aspects contains "syncopated snare" and musiccaps_author = 4
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 |
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;