musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "uptempo" and musiccaps_names contains "Snare drum" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 10 ✖
- acoustic drums 2
- e-bass 2
- uptempo · 2 ✖
- e-guitar 1
- e-guitars 1
- funk/jazz 1
- post-rock 1
- slightly agressive 1
- tambourine 1
- uplifting energy 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
The Bamboos - The Witch | This audio contains a complex and funky acoustic drum groove along with a repeating bassline. The clean e-guitar is playing along with the bass in the lower register. A tambourine adds flavor to the drums. This song may be playing at a breakdance battle. | 2010-07-15T14:58:01Z | bTunes720 | Bboys and Bgirls enjoy the beat. More beats coming along so please subscribe if you like my videos. Video in HD 720p Sound quality high | ["Cymbal", "Drum", "Drum kit", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["funk/jazz", "tambourine", "acoustic drums", "e-bass", "e-guitar", "uptempo", "uplifting energy"] | 6 | iBh37YAaHMU | 4166 | |
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;