musiccaps_details (view)
2 rows where musiccaps_aspects contains "loud" and musiccaps_aspects contains "thin" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- loud · 2 ✖
- low quality 2
- mono 2
- noisy 2
- thin · 2 ✖
- addictive brass melody 1
- energetic 1
- exotic marimba melody 1
- harsh 1
- jazzy drums 1
- live performance 1
- messy 1
- muddy 1
- muddy bass 1
- muffled male vocal 1
- mumbling crowd noises 1
- piano keys chords 1
- reggae 1
- shimmering cymbals 1
- shimmering hi hats 1
- syncopated snare 1
- tropical 1
- water splashing noise 1
musiccaps_names (array) 4 ✖
- Music 2
- Music of Latin America 1
- Ska 1
- Steelpan 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Raskahuele--LA Sound System | The low quality recording features a live performance of a reggae song that consists of shimmering cymbals, addictive brass melody and muffled male vocal singing over it. It is noisy and in mono, and it sounds thin, harsh, muddy, messy and energetic. | 2008-06-22T17:38:28Z | Geovanni De Leon | LASS | ["Music", "Ska", "Music of Latin America"] | ["low quality", "shimmering cymbals", "noisy", "mono", "addictive brass melody", "muffled male vocal", "live performance", "reggae", "loud", "thin", "harsh", "muddy", "messy", "energetic"] | 4 | GkB_BkyVyPs | 1752 | |
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;