musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic drums", musiccaps_aspects contains "single instrument" and musiccaps_names contains "Snare drum"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Groove Drumming | This is the recording of an acoustic drum solo. The drummer is playing a groovy beat with a lot of different fills. This piece could be sampled and looped to be used in the background of a hip-hop beat. | 2010-08-01T22:38:37Z | Groove Drumming | Thought I'd just go with a groove of my own but later can you guess the famous beat I play at one point? What was the band called or the name of the song? Just having some fun, I hope you enjoy. | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["instrumental", "single instrument", "acoustic drums", "drum solo", "groovy", "beat"] | 9 | n_REM0fSVrA | 4556 | |
Horacio Hernandez: The 113 Solo (Part I) | This is an acoustic drum solo performance. The drummer is playing rapid and complex fills with a heavy use of cowbells. There is a clear latin music influence in this solo. It has an energetic aura. Parts of this performance could be sampled in use for beat-making. | 2013-10-24T22:27:23Z | Pearl Drums | Horacio "el Negro" Hernandez uses the Reference Pure Series and his innovative signature cowbells for The 113 Solo. See Part II at http://youtu.be/RBAnjz2diQQ Pearl's all new Reference Pure proudly builds upon the legacy stared by Pearl's original Reference Series Drums by using the exact shell composition formula, the same number and type of wood plies, and the same targeted task specific bearing edges to create a thin shell, highly resonant, lower mass version of the original. http://pearldrum.com/products/kits/drumsets/reference-pure/ Sold individually, these bells are of carbon steel construction with a black powder coat finish and feature many of the key aspects from the original Horacio Hernandez Signature Cowbells, such as a swiveling Quick Release mount which allows the player to stack multiple bells on a single post without wingnut interference, as well as two playing surfaces, flat and rounded, to accommodate player position and preference. http://pearldrum.com/products/percussion/cowbells/horacio-hernandez-signature/ | ["Cymbal", "Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["instrumental", "single instrument", "acoustic drums", "drum solo", "cowbells", "latin influence", "energetic"] | 9 | rKRI5UcIICI | 4865 |
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;