musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic", musiccaps_author = 4 and musiccaps_names contains "Steelpan"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- energetic · 3 ✖
- low quality 3
- exotic 2
- live performance 2
- mono 2
- noisy 2
- 4 on the floor kick 1
- crowd talking 1
- crushed 1
- energetic drums 1
- harsh 1
- live prrformance 1
- loud 1
- loud steel pans melody 1
- muffled instrumental 1
- open hats 1
- passionate 1
- playback instrumental 1
- punk 1
- screaming female vocal 1
- shimmering hi hats 1
- steel drums 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 | |
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 | |
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;