musiccaps_details (view)
2 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "passionate" and musiccaps_names contains "Steelpan"
This data as json, CSV (advanced)
musiccaps_aspects (array) 25 ✖
- energetic · 2 ✖
- passionate · 2 ✖
- big band 1
- big band hits 1
- brass section harmony 1
- energetic drums 1
- exotic 1
- fast jazz drumming 1
- fast tempo 1
- fats jazz drumming 1
- groovy bass line 1
- instrumental music 1
- jazz band 1
- jazz legends 1
- jazz music 1
- jazz super hits 1
- live performance 1
- low quality 1
- mono 1
- noisy 1
- piano accompaniment 1
- poor audio quality 1
- retro jazz classics 1
- steel drums melody 1
- trumpets playing percussively 1
musiccaps_names (array) 7 ✖
- Music 2
- Steelpan · 2 ✖
- 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 |
---|---|---|---|---|---|---|---|---|---|---|
Chuck Mangione - Sun Shower | The song is an instrumental. The tempo is fast with trumpets playing percussively along with other brass instruments, piano accompaniment, groovy bass line jazz drumming rhythm. The song is energetic and passionate. The song is a retro big band jazz classic with poor audio quality. | 2011-01-29T01:59:44Z | Henry Cooper | From 1971's Together. Sampled by Tonex for "Sonshine" | ["Music", "Steelpan"] | ["instrumental music", "jazz music", "fast jazz drumming", "energetic", "passionate", "retro jazz classics", "jazz super hits", "jazz legends", "big band hits", "trumpets playing percussively", "fast tempo", "piano accompaniment", "fats jazz drumming", "brass section harmony", "groovy bass line", "big band", "poor audio quality", "jazz band"] | 1 | lNg2y6SRZPo | 4392 | |
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;