musiccaps_details (view)

1 row where musiccaps_author = 9, musiccaps_names contains "Drum" and "youtube_published" is on date 2007-08-10

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)

video youtube_link musiccaps_caption youtube_published youtube_channel youtube_description musiccaps_names musiccaps_aspects musiccaps_author youtube_id musiccaps_rowid
Double Stroke Roll - Drum Lessons This is a drum lesson recording. A double stroke roll pattern is being performed on the snare drum of an acoustic drum kit. A metronome click can be heard in the background. 2007-08-10T22:35:02Z Drumeo Learn The Drums Faster, Easier, Better: ► https://www.Drumeo.com/ Faster Hands & Feet (in 10 days) ► https://www.Drumeo.com/faster/ FREE Series: The Drum Rudiment Master Class - http://bit.ly/OMmKh7 . The double stroke roll is an extremely popular rudiment that should be practiced to perfection by anyone serious about playing the drums. Not only is it popular for use within beats and fills, but it is also the foundation for many other important drum rudiments. Watch this video lesson to see Lionel demonstrate it on it's own, then in a beat, and finally in a fill. . Get the sheet music for this lesson online at: - http://www.freedrumlessons.com/drum-lessons/double-stroke-roll.php . Watch more drum lessons at: - http://www.FreeDrumLessons.com - http://www.DrumLessons.com ["Drum", "Drum kit", "Drum roll", "Snare drum", "Bass drum", "Percussion"] ["drum lesson", "acoustic drums", "snare drum", "drumroll", "metronome click"] 9 W_979HkE4EI 3106

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;