musiccaps_details (view)
2 rows where musiccaps_aspects contains "animated sounds" and musiccaps_author = 7 sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- animated sounds · 2 ✖
- vocalisation 2
- acoustic guitar 1
- annoying sounds 1
- banjo riff 1
- camera sounds 1
- clapping 1
- clicking sound 1
- crowd cheering 1
- evil laugh 1
- funny 1
- grunting 1
- guitar string plonk 1
- hooting sound 1
- instrumental 1
- introduction music 1
- kids screaming in joy 1
- kissing sound 1
- loud booming noise 1
- loud drum roll 1
- loud thud 1
- medium fast tempo 1
- metal 1
- no lyrics 1
- no melody 1
- smacking lips 1
- sound of loud chewing 1
- sound of metal 1
- straining 1
- swishing sound 1
- water bubbling 1
musiccaps_names (array) 7 ✖
- Music 2
- Acoustic guitar 1
- Banjo 1
- Crunch 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Man of Constant Sorrow Bluesy Guitar Lesson! | This music is an instrumental with a lot of vocalisation and animated sounds. There are sounds of swishing, water bubbling, guitar string plonking, acoustic guitar riff, camera clicking pictures, kids screaming in glee, cheering and clapping. This music seems to be an introduction to a Show. | 2014-06-16T12:31:33Z | Banjo Ben Clark | Lesson link: https://banjobenclark.com/lessons/man-of-constant-sorrow-guitar - I absolutely LOVE this version on guitar! It would be easy to throw together a bunch of bluesy licks that work over the chords, but it's another thing to play bluesy licks that sing the melody, which is what we do here! Make sure you watch the ~30 minute video that matches these tabs and mp3's! | ["Banjo", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental", "medium fast tempo", "acoustic guitar", "introduction music", "vocalisation", "animated sounds", "banjo riff", "water bubbling", "crowd cheering", "clapping", "kids screaming in joy", "funny", "hooting sound", "clicking sound", "guitar string plonk", "swishing sound", "camera sounds"] | 7 | 7ITwarmdyfI | 824 | |
L is for Lachanophobia - Figaro Pho | This audio clip is just vocalisation. There is a loud drum roll with an evil laughter, sound of metal, followed by grunting and straining noises and then loud, noisy chewing and smacking of lips. | 2012-10-12T18:40:38Z | Mickey Mouse | New phobias arriving daily. Lachanophobia is the fear of vegetables. Dig your trenches deep, there's no time to veg out in the world of Figaro Pho! SUBSCRIBE to get notified when new Disney Shorts videos are posted: http://di.sn/SubscribeDisneyShorts Get more from Disney! Disney YouTube: http://di.sn/SubscribeDisney Like Disney: http://Facebook.com/Disney Follow Disney: http://Twitter.com/Disney Disney Tumblr: http://disney.tumblr.com/ Disney Google+: http://plus.google.com/+Disney/posts Disney Instagram: http://Instagram.com/Disney | ["Music", "Crunch"] | ["animated sounds", "vocalisation", "no melody", "no lyrics", "kissing sound", "evil laugh", "loud drum roll", "annoying sounds", "sound of loud chewing", "smacking lips", "straining", "grunting", "loud thud", "sound of metal", "loud booming noise", "metal"] | 7 | 9ZeoYezrI7Q | 1024 |
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;