musiccaps_details (view)
1 row where musiccaps_aspects contains "noisy", musiccaps_aspects contains "snappy wooden snare hits" and musiccaps_names contains "Wood block"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Triple Paradiddle Exercise - Snare Drum TV | The low quality recording features a tutorial that consists of a flat male vocal talking over snappy wooden snare one shots. The recording is noisy and in mono. | 2011-08-24T04:17:49Z | PatrickMcLaughlin | Free Sheet Music: http://mclaughlindrums.com/88/triple-paradiddle-break-down-exercise Triple Paradiddle Breakdown Exercise - Improve Your Triple Paradiddles In Episode 6 of Snare Drum TV, you'll learn a simple Triple Paradiddle drum exercise that will quickly help you improve your triple paradiddle snare drum rudiments. This exercise follows the same guidelines that the single paradiddle exercise and double paradiddle exercise were based on so it should be relatively easy to learn. Every drummers should know all of the paradiddle drum rudiments so be sure to take the time to learn what a Triple Paradiddle is and then use this exercise to master them! Thanks so much for watching Snare Drum TV! Your support is greatly appreciated and I hope these snare drum exercises are helping you improve your drumming! Make sure you connect with us online to stay up to date with the weekly drum lesson and other news: Snare Drum TV on YouTube: http://www.youtube.com/snaredrumtv Pat McLaughlin on Twitter: https://twitter.com/_PatMcLaughlin_ Pat McLaughlin on Google+ https://plus.google.com/+PatMcLaughlin/posts Cheers! Pat McLaughlin Watch Episode 7: http://youtu.be/pCkrxdVPxpg | ["Wood block", "Percussion"] | ["low quality", "noisy", "mono", "flat male vocal", "snappy wooden snare hits", "tutorial"] | 4 | tWwvTUm9RXs | 5048 |
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;