musiccaps_details (view)
3 rows where musiccaps_aspects contains "passionate", musiccaps_author = 4 and musiccaps_names contains "Steelpan"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- low quality 3
- passionate · 3 ✖
- exotic 2
- noisy 2
- steel drums melody 2
- addictive 1
- audio popping sounds 1
- emotional 1
- energetic 1
- energetic drums 1
- groovy synth bass 1
- live performance 1
- mono 1
- playback instrumental 1
- punchy "4 on the floor" kick 1
- reverberant 1
- sizzling synths 1
- steel drum solo 1
- syncopated snare 1
- upbeat 1
- urban latin 1
- wide brass melody 1
musiccaps_names (array) 7 ✖
- Music 3
- Musical instrument 3
- Percussion 3
- Steelpan · 3 ✖
- Drum 2
- Drum kit 1
- Orchestra 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Machel Montano - She Ready (Steelpan Version) | The low quality recording features a steel drum solo melody over playback instrumental of urban latin song that consists of groovy synth bass, wide brass melody, sizzling synths, syncopated snare and punchy "4 on the floor" kick pattern. It sounds addictive, passionate and upbeat. The steel drum is reverberant due to the fact that it was recorded in a medium size room. | 2012-11-13T22:17:20Z | Keishaun Julien | Keishaun Julien playing She Say She Ready by Machel Montano on the steel pan (soca 2013) http://www.facebook.com/Keishaun.Julien http://www.twitter.com/keishaunjulien http://www.keishaunjulienmusic.com http://www.instagram.com/KeishaunJulien Special thanks to Precision Productions for making this video possible. http://www.facebook.com/PrecisionProductions Notes http://bit.ly/2ttruTd | ["Drum", "Music", "Musical instrument", "Percussion", "Steelpan"] | ["low quality", "playback instrumental", "urban latin", "groovy synth bass", "punchy \"4 on the floor\" kick", "wide brass melody", "sizzling synths", "syncopated snare", "steel drum solo", "passionate", "addictive", "reverberant", "upbeat"] | 4 | 7WR-hMV2RKs | 852 | |
The Renegades steelband plays Schubert | The low quality recording features a live performance of steel drums. It sounds exotic, passionate and emotional, even though the recording is noisy and has some audio popping sounds. | 2009-01-19T21:04:19Z | seralune | The Renegades steelband Schubert la Folle journée de Nantes en janvier 2008. | ["Music", "Musical instrument", "Percussion", "Steelpan"] | ["low quality", "noisy", "steel drums melody", "exotic", "passionate", "emotional", "audio popping sounds"] | 4 | mwLrABPxvgA | 4502 | |
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;