musiccaps_details (view)
1 row where musiccaps_aspects contains "drums lesson", musiccaps_aspects contains "instructive speaking", musiccaps_aspects contains "male voice" and musiccaps_names contains "Bass 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 Rolls On The Toms - Free Drum Lessons | This is an acoustic drums lesson recording concerning how to play double stroke rolls on the toms. Initially, there is a rapid drum fill that can be heard. Then, a male voice starts speaking in an instructive manner. | 2014-07-22T18:53:40Z | Drumeo | Learn The Drums Faster, Easier, Better: ► https://www.Drumeo.com/ Faster Hands & Feet (in 10 days) ► https://www.Drumeo.com/faster/ Get a free 30-day trial to Drumeo Edge: - http://drumeo.com/trial Get the sheet music here: - http://www.drumeo.com/blog/double-stroke-rolls-on-the-toms/ In this video, I walk you through how I like to practice double strokes to get maximum speed, power, and control on the toms. If you find the lesson useful, please consider sharing with your drumming friends. | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["lesson recording", "drums lesson", "acoustic drum fill", "male voice", "instructive speaking"] | 9 | PpamaOkNqoI | 2569 |
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;