musiccaps_details (view)
4 rows where musiccaps_aspects contains "mono" and musiccaps_names contains "Steelpan"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- low quality 4
- mono · 4 ✖
- noisy 3
- energetic 2
- loud 2
- crushed 1
- energetic drums 1
- exotic 1
- exotic marimba melody 1
- harsh 1
- instrumental 1
- jazzy drums 1
- live performance 1
- live prrformance 1
- marimba melody 1
- muddy bass 1
- muffled instrumental 1
- mumbling crowd noises 1
- passionate 1
- piano keys chords 1
- punchy kick 1
- punk 1
- room microphone 1
- screaming female vocal 1
- shimmering hi hats 1
- shimmering shakers 1
- soul 1
- steel drums melody 1
- syncopate snare hits 1
- syncopated snare 1
- thin 1
- tinny metallic percussive elements 1
- tropical 1
- water splashing noise 1
musiccaps_names (array) 7 ✖
- Music 4
- Steelpan · 4 ✖
- Drum 1
- Drum kit 1
- Musical instrument 1
- Orchestra 1
- Percussion 1
youtube_published (date) 4 ✖
- 2007-02-02 1
- 2007-05-31 1
- 2008-02-16 1
- 2008-07-06 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Mentalists/The Good Ship | The low quality recording features a live performance of a punk song that consists of screaming female vocal singing over a muffled instrumental. It sounds energetic, harsh, crushed, loud and the recording is noisy and in mono. | 2007-05-31T20:39:50Z | Allyn Lai | Another tune by The Mentalists | ["Music", "Steelpan"] | ["low quality", "live prrformance", "punk", "screaming female vocal", "loud", "crushed", "noisy", "muffled instrumental", "energetic", "harsh", "mono"] | 4 | Ex18Xwznj60 | 1603 | |
Pan Masters--Stand By Me | The Soul Instrumental features an addictive marimba melody, shimmering shakers, punchy kick hits, syncopated snare and tinny metallic percussive elements. It sounds narrow because it is recorded with one mono room microphone and therefore it is a low quality recording. | 2007-02-02T04:58:56Z | Discojones77 | Pan Masters Steel Orchestra of Washington, DC performs Ben E. King's "Stand By Me" at their 20th Anniversary Concert--April 2005. The arrangement is by Kristen Jones | ["Music", "Steelpan"] | ["soul", "low quality", "instrumental", "marimba melody", "shimmering shakers", "tinny metallic percussive elements", "punchy kick", "syncopate snare hits", "low quality", "mono", "room microphone"] | 4 | OcdrbkDm2LQ | 2452 | |
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 | |
Renegades Steel Orchestra | The low quality recording features a live performance of steel drums, followed by energetic drums in the background. It sounds exotic, passionate, energetic and the recording is noisy and in mono. | 2008-02-16T07:33:29Z | panjumbie | Highest-profile ambassadors for the steel pan music, the Renegades Steel Orchestra from Trinidad & Tobago on European Tour 2007. The Panyard Bern (Switzerland) hosted 3 concerts (10 - 12 July 2007) at http://www.thepanyard.ch These 3 concerts have been sponsored by: pan-jumbie.com, panmusic.ch, panch.ch, funlandserenaders.ch, Richardson Steeldrums, and brewery Feldschlösschen Video production by VJ Peter Krüsi | ["Drum", "Drum kit", "Music", "Musical instrument", "Orchestra", "Percussion", "Steelpan"] | ["low quality", "live performance", "steel drums melody", "energetic drums", "energetic", "exotic", "passionate", "mono", "noisy"] | 4 | x22NHqwKSNE | 5302 |
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;