musiccaps_details (view)
1 row where musiccaps_aspects contains "punchy tom" and musiccaps_names contains "Drum kit"
This data as json, CSV (advanced)
musiccaps_aspects (array) 9 ✖
- drums solo 1
- energetic 1
- low quality 1
- mono 1
- noisy 1
- punchy snare 1
- punchy tom · 1 ✖
- repetitive cowbell 1
- tutorial 1
musiccaps_names (array) 7 ✖
- Bass drum 1
- Cowbell 1
- Drum 1
- Drum kit · 1 ✖
- Percussion 1
- Rimshot 1
- Snare drum 1
youtube_published (date) 1 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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;