musiccaps_details (view)
3 rows where musiccaps_aspects contains "live performance", musiccaps_author = 4 and musiccaps_names contains "Steelpan"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- live performance · 3 ✖
- low quality 3
- energetic 2
- exotic 2
- noisy 2
- shimmering hi hats 2
- 4 on the floor kick 1
- big band 1
- bright brass melody 1
- cowbell percussion 1
- crowd talking 1
- energetic drums 1
- fun 1
- groovy double bass melody 1
- happy 1
- loud steel pans melody 1
- mono 1
- open hats 1
- passionate 1
- playback instrumental 1
- punchy snare 1
- soft kick hits 1
- steel drums melody 1
- steel pan melody 1
musiccaps_names (array) 7 ✖
- Music 3
- Steelpan · 3 ✖
- Drum 1
- Drum kit 1
- Musical instrument 1
- Orchestra 1
- Percussion 1
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 | |
Andy Narell: Coffee Street | The low quality recording features a live performance of a big band that consists of shimmering hi hats, steel pan melody, punchy snare, soft kick hits, bright brass melody, groovy double bass melody and cowbell percussion. The recording is a bit noisy and it sounds happy and fun. | 2013-01-22T23:26:57Z | University of North Texas College Concerts | Coffee Street, (1998) by Andy Narell 2:00 Steel Band - Mark Ford, director One O'Clock Lab Band - Steve Weist, director Recorded Live, October 29, 2012 Winspear Hall, College of Music University of North Texas http://music.unt.edu More about UNT Percussion: http://music.unt.edu/pecussion | ["Music", "Steelpan"] | ["low quality", "live performance", "noisy", "big band", "shimmering hi hats", "punchy snare", "soft kick hits", "steel pan melody", "bright brass melody", "groovy double bass melody", "cowbell percussion", "fun", "happy"] | 4 | _fKntnlIYTQ | 3481 | |
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;