musiccaps_details (view)
1 row where musiccaps_aspects contains "drum lesson", musiccaps_aspects contains "metronome click" and musiccaps_names contains "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 |
---|---|---|---|---|---|---|---|---|---|---|
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
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;