musiccaps_details (view)
1 row where musiccaps_aspects contains "male narrator voice", musiccaps_author = 0 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 |
---|---|---|---|---|---|---|---|---|---|---|
One handed Roll - Shuffle to single stroke 9.17.13 | This audio features a drum practice pad being played. A shuffle beat is played on the practice pad. There are no other instruments in this song. A male voice narrates instructions. This song can be played in an instructional video on the shuffle beat. | 2013-09-18T04:09:01Z | OldSchoolDrummer101 | This video is for Paul who messaged me via my website about the one handed roll. He is wondering how to get away from a shuffle feel to a more even one handed roll. The goal is to get thinking about the one handed roll differently and count it differently. I hope this helps and if anyone has questions please send me a message! Channel--------http://www.youtube.com/OldSchoolDrummer101 FaceBook-----https://www.facebook.com/osd101 . Dear Viewer, This channel exists to express my interests in drums. Tutorials, solos, and restoration projects are the types of videos you will encounter on my channel. Recently my hobby reaches out to restoring vintage drums and buying and trading vintage drum parts. My website has information on how to purchase or sell vintage drum parts. This my hobby, I hope you find it interesting like I do. | ["Wood block", "Percussion"] | ["drum practice pad", "shuffle beat", "no other instruments", "male narrator voice", "no other instruments"] | 0 | D_usHKfOXCw | 1496 |
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;