musiccaps_details (view)
6 rows where musiccaps_aspects contains "exotic", musiccaps_author = 4 and musiccaps_names contains "Steelpan"
This data as json, CSV (advanced)
musiccaps_aspects (array) 32 ✖
- exotic · 6 ✖
- low quality 6
- noisy 4
- shimmering hi hats 3
- steel drums melody 3
- crowd talking 2
- emotional 2
- energetic 2
- groovy bass 2
- live performance 2
- passionate 2
- "4 on the floor" kick pattern 1
- 4 on the floor kick 1
- applause 1
- audio popping sounds 1
- background percussive instrumental 1
- crowd cheering 1
- energetic drums 1
- fun 1
- happy 1
- joyful 1
- loud steel pans melody 1
- mono 1
- open hats 1
- playback instrumental 1
- punchy kick 1
- punchy snare 1
- reverberant 1
- steel pans melody 1
- syncopated snare 1
- tropical 1
- tropical steel drum melody 1
musiccaps_names (array) 7 ✖
- Music 6
- Steelpan · 6 ✖
- Musical instrument 5
- Percussion 4
- Drum 2
- Drum kit 2
- Orchestra 2
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
CSI Steelband ~ "Empire State of Mind" ~ Alicia Keyes | The low quality recording features a live performance of loud steel pans melody over playback instrumental that consists of shimmering hi hats, open hats and "4 on the floor" kick pattern. There are some crowd talking noises in the background. It sounds exotic and energetic. | 2010-08-02T14:27:22Z | SteeldrumTrust | CSI Steelband plays "Empire State of Mind" by Alicia Keys. Trafalgar Square Blockorama August 2010 | ["Music", "Steelpan"] | ["low quality", "live performance", "loud steel pans melody", "playback instrumental", "shimmering hi hats", "open hats", "4 on the floor kick", "energetic", "crowd talking", "exotic"] | 4 | 0bvPjMQ_WbE | 190 | |
I'm Yours - steel drum reggae cover | The low quality recording features a tropical steel drum melody playing over background percussive instrumental. It is noisy, but it sounds tropical, exotic and emotional. | 2009-12-18T22:38:29Z | Steel Drum Music | Jason Mraz's reggae-ish hit on steel drums in Wellington, FL on 12/10/2009 Yes, the puffy shirt cracks me up still. It's hot and humid in Florida year round, so I have a fan on the floor behind me blowing full blast most of the time. ♫ iTunes - http://bit.ly/aE3djW Amazon - http://bit.ly/cgT7rA Google - http://bit.ly/38mMiPu https://www.SteelDrumMusic.net | ["Music", "Musical instrument", "Steelpan"] | ["low quality", "noisy", "background percussive instrumental", "tropical steel drum melody", "tropical", "exotic", "emotional"] | 4 | 3zIQTDfS4Hk | 524 | |
"Amazing Grace" on the steel pans by the Dover High School Steel Drum Band | The low quality recording features a steel pans melody, shimmering hi hats, syncopated snare and "4 on the floor" kick pattern. It is a bit reverberant as it was played in a concert hall. There are some crowd cheering and applause sounds. It sounds exotic, fun and happy. | 2011-10-15T22:04:45Z | Ann Swinderman | Under the direction of Joan Wenzel, the Dover Steel Drum Band performs this favorite in the Performing Arts Center Kent State University Tuscarawas lobby. | ["Music", "Musical instrument", "Orchestra", "Percussion", "Steelpan"] | ["low quality", "steel pans melody", "reverberant", "shimmering hi hats", "syncopated snare", "\"4 on the floor\" kick pattern", "groovy bass", "crowd cheering", "applause", "exotic", "fun", "happy"] | 4 | 6J3X0whM_-4 | 742 | |
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 | |
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;