musiccaps_details (view)

1 row where musiccaps_aspects contains "manic tom rolls", musiccaps_names contains "Drum", musiccaps_names contains "Percussion" and musiccaps_names contains "Snare drum"

✎ View and edit SQL

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

CSV options: 

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;