musiccaps_details (view)
1 row where musiccaps_aspects contains "aggressive", musiccaps_aspects contains "distorted", musiccaps_aspects contains "noisy" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Ginger Baker´s " visual drum roll" reveiled | The low quality recording features a drums solo that contains manic tom rolls and a ride cymbal one shot at the end. There was an exhale sound once the player finished his performance. The recording is very noisy, in mono and it sounds aggressive and energetic. | 2007-03-12T16:29:16Z | rootheart | VERY EASY, but sounds and looks dramatic: This is an exercise I once learned from "Ginger Baker´s Drumbook", quote "It does not only sound dramatic, but it looks amazing as the right hand is moving around the kit counterclockwise, while the left hand is moving around clockwise"...in fact extremely basic, but played fast once in a song or repeated in a solo it might be extremely impressive.. how to use it is all up t o you.. Triplets: RLR LRL... (R)mounted tom, (L)snare, (R)snare,- (L)mounted tom, (R)floortom, (L)floortom. P.S: Audio and video do not really match, it is just a simple cellphone recording. Posted a long time ago to share the lick with those who didn´t kow it yet, not to impress anyone out there. "Never play to impress the drummer from the other Band". "I no not muffle my drums, I want them to ring"..."I lock the breatherhole with a bold and a nut"" ...Quotes from Ginger Baker´s Drumbook | ["Drum", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "noisy", "drums solo", "manic tom rolls", "distorted", "mono", "exhale", "energetic", "aggressive", "ride cymbal one shot"] | 4 | bJVogLOURmc | 3615 |
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;