musiccaps_details (view)
3 rows where musiccaps_aspects contains "amateur recording" and musiccaps_names contains "Rimshot" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- amateur recording · 3 ✖
- acoustic drums 1
- bad audio quality 1
- dance rhythm 1
- drum solo 1
- drums 1
- drums maestro 1
- echoes 1
- energetic 1
- exciting 1
- exemplary stick work 1
- fast paced 1
- gripping experience 1
- groovy rhythm 1
- impressive playing 1
- instrumental music 1
- live audience 1
- live performance 1
- male voice speaking 1
- medium tempo 1
- medium to uptempo 1
- pulsating experience 1
- retro drum hits 1
- syncopated rhythms 1
video | youtube_link ▼ | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Drums Steve Gadd Cowbell.wmv | The song is an instrumental. The tempo is medium with a maestro percussionist performing a solo drum solo in front of a live audience. The song is exciting and gripping. The audio quality is poor. | 2008-12-16T11:27:34Z | bestdrumvideos | Drums Steve Gadd | ["Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["drum solo", "live performance", "live audience", "gripping experience", "instrumental music", "echoes", "syncopated rhythms", "drums maestro", "impressive playing", "energetic", "medium tempo", "groovy rhythm", "bad audio quality", "amateur recording", "exciting", "pulsating experience", "exemplary stick work", "retro drum hits", "dance rhythm"] | 1 | nrj2zTr7U0o | 4584 | |
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 |
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;