musiccaps_details (view)
4 rows where musiccaps_aspects contains "mono", musiccaps_names contains "Drum kit" and musiccaps_names contains "Snare 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 |
---|---|---|---|---|---|---|---|---|---|---|
solo de murga..ritmo marcha camion. musica de uruguay. | The low quality recording features a drum solo that consists of punchy snare hits and occasional snare roll, punchy kick and shimmering hi-hats. It sounds energetic and the recording is in mono and noisy. | 2010-09-26T04:48:15Z | Mud Riders Adventure 🇺🇾 | LOS VIDEOS FUERON FILMADOS POR JUAN MANUEL HARAN,098 711012. En el video les muestro algo de lo que he aprendido con nicolas arnicho en sus clases. les recomiendo su dvd global rhythm. | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "noisy", "mono", "uptempo", "drums solo", "punchy snare", "shimmering hi hats", "punchy kick", "snare roll", "energetic"] | 4 | 3Yc7_n6mDsI | 480 | |
Banda Aires Del Pacifico | The low quality recording features a live performance of distant trumpet melody, followed by energetic cymbals, snare roll and manically played metallic percussion. It sounds energetic and loud, while the recording is noisy and in mono, as it was probably recorded with a phone. | 2009-08-19T06:13:20Z | Labazuuka | el pony tocando tarolas jeje ....salsa pss al 100 | ["Drum", "Drum kit", "Drum roll", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "distant trumpet melody", "manic metallic percussions", "energetic cymbals", "snare rolls", "energetic", "loud", "noisy", "mono"] | 4 | 7lV4IvuW2lk | 881 | |
Grandma Drummer | Amazing Skills Like A Pro | The low quality recording features laughing male sounds over sloppy drums that contain energetic crash cymbal hits and toms percussion. It sounds exciting, even though the recording is noisy and in mono, as it was probably recorded with a phone. | 2013-07-19T20:16:48Z | This Is Happening | This drumming grandma is definitely cooler than yours. Instead of knitting and baking pies, she's rocking out on a drum set. Jukin Member Upload - Original Video Seen Here: https://www.youtube.com/watch?v=NRhoHN8x_00 SUBSCRIBE: http://bit.ly/JukinVideo LIKE us on FACEBOOK http://facebook.com/JukinVideo FOLLOW us on TWITTER http://twitter.com/JukinVideo FOLLOW us on INSTAGRAM http://instagram.com/JukinVideo TO LICENSE THIS CLIP: http://bit.ly/132Ic5x | ["Cymbal", "Drum", "Drum kit", "Drum roll", "Hi-hat", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "noisy", "mono", "exciting", "laughing male sounds", "toms percussions", "energetic crash cymbal", "sloppy drums"] | 4 | jR_wBfxgZwE | 4254 | |
DRUM HACK | Cowbell Bass Drum Mount Tips Pt. 1 | The low quality recording features an energetic drums solo that consists of punchy snare, tom and kick hits, alongside repetitive cowbell. There is a flat male vocal talking right before the solo. It sounds like a tutorial. The recording is noisy and in mono. | 2013-02-28T02:22:12Z | rdavidr | Little tip for all you cowbell users out there. Nothing crazy, but it helps It also evens out the rocking and stress on your bass drum hoop Pt. 2 http://youtu.be/ZpgyNjmfShM Subscribe: https://www.youtube.com/subscription_center?add_user=rdavidr Support This Channel: https://www.patreon.com/rdavidr Drum Tips & Tricks: https://youtu.be/kAp5c8E7rv0?list=PL6W6pllXpl2R-lIqEsI_rVGGpER36wQhw DIY Projects: https://youtu.be/XnmTeVf4Op8?list=PL6W6pllXpl2S8UAA6EMZBaTERES1wSgea $20 Drum Set Project: https://youtu.be/hVCkyAp9rVc?list=PL6W6pllXpl2TKXWKNeBKRPhAejIRrKOJY My Second Channel: https://www.youtube.com/channel/UCRQuhIsW57xXHYSdnW7ZOmg Instagram: https://instagram.com/davidraouf/ Soundcloud: https://soundcloud.com/silentdave91 | ["Cowbell", "Drum", "Drum kit", "Rimshot", "Snare drum", "Bass drum", "Percussion"] | ["low quality", "drums solo", "noisy", "mono", "punchy snare", "punchy tom", "repetitive cowbell", "energetic", "tutorial"] | 4 | xiN6XwZNEJo | 5348 |
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;