musiccaps_details (view)
1 row where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "post-rock", musiccaps_aspects contains "uptempo" and musiccaps_names contains "Rimshot"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Drum Kit From Hell - Electronic Drums Demo | This audio contains acoustic drums playing a groove with a lot of cymbal hits. An e-bass is holding the groove while a distorted e-guitar is playing a solo in a higher register. In the background you can hear another e-guitar playing something like an arpeggio melody in the mid-range. This song may be playing in the rehearsal band room practicing drumming to a backing song. | 2008-04-30T07:12:11Z | MikeyVPT | These Drums are From Hell!!! Thanks to RET Percussion and Toontrack for offering some awesome products! If you're into Metal, Hard Rock, Speed, Death, Black, Grindcore, or Classic rock, this is the kit for you... it does it all! Thanks for watching, and as always, leave plenty of feedback! And, no, I'm NOT A METAL DRUMMER! Plus, playing "double-bass" with a hi-hat pedal is pretty tough :-) If you're looking for prices, availability, and INFO, please visit the RET Website! They have all the gear, all the support, and all the new items here: www.RETPercussion.com -mikey | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["post-rock", "acoustic drums", "e-guitars", "e-bass", "uptempo", "slightly agressive"] | 6 | yj4xorgrbV4 | 5433 |
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;