musiccaps_details (view)
3 rows where musiccaps_aspects contains "amateur recording", musiccaps_names contains "Drum kit", musiccaps_names contains "Drum roll" and musiccaps_names contains "Percussion"
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 |
---|---|---|---|---|---|---|---|---|---|---|
Cold Pressed (David Hollinden) - Jan Nguyen, percussion - May 2013 | Someone is playing an evolving rhythm on various percussion instruments. This seems to be a professional piece with a lot of dynamics. This song may be playing as a part of an orchestra performance. | 2013-07-06T22:12:28Z | Arts Laureate | Jan Nguyen, percussion, performs in the Gildenhorn Recital Hall at the University of Maryland, College Park, MD on May 7, 2013. | ["Wood block", "Drum", "Drum kit", "Drum roll", "Snare drum", "Bass drum", "Percussion"] | ["amateur recording", "percussions", "tambourine", "kickdrum", "bongos", "toms", "cowbell"] | 6 | Zo9xROGuV3k | 3415 | |
Yamaha PHX Phoenix Drum Set 22/10/12/14/16 - Burled Ash Garnet Fade Gloss | Someone is playing a drum groove on the ride with a lot of fill-ins on toms. This song may be playing during drum practice. | 2013-07-18T20:24:45Z | Memphis Drum Shop | Yamaha PHX Drum Set available from Memphis Drum Shop. Buy it now at http://memphisdrumshop.com/drum-sets/yamaha/ Contact us at sales@memphisdrumshop.com https://www.facebook.com/MemphisDrumShop https://www.facebook.com/myCymbal https://twitter.com/memphisdrumshop Other gear used in this video: • Cymbals (From drummer's L to R): Zildjian 14 1/4" K Custom Hybrid Hi Hat Cymbals, Zildjian 19" K Custom Hybrid Crash Cymbal, Zildjian 21" K Custom Hybrid Ride Cymbal, Zildjian 17" K Custom Hybrid Crash Cymbal • Snare: Yamaha 14x6.5 Sensitive Series Maple Snare Drum | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["amateur recording", "drums", "medium to uptempo"] | 6 | tOb0M2k3deo | 5031 | |
DRUM LESSON: Improving Bass Drum Speed - by Mike Johnston | This audio contains someone playing a fast paced drum groove with a lot of double hits on the kick and tom. The drumming stops and then a male voice starts talking. This may be used for a drum tutorial video. | 2014-04-13T19:41:25Z | Mike Johnston | Click here for more drum lessons: http://goo.gl/Jpuc49 | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Bass drum", "Percussion"] | ["acoustic drums", "amateur recording", "male voice speaking", "fast paced"] | 6 | yMEMzSFbZ2s | 5401 |
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;