musiccaps_details (view)
3 rows where musiccaps_aspects contains "crowd cheering" and musiccaps_names contains "Banjo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- crowd cheering · 3 ✖
- acoustic drums 1
- acoustic guitar 1
- acoustic guitars 1
- amateur recording 1
- animated sounds 1
- banjo riff 1
- camera sounds 1
- clapping 1
- clicking sound 1
- electric guitar chords 1
- funny 1
- guitar string plonk 1
- hooting sound 1
- instrumental 1
- introduction music 1
- kids screaming in joy 1
- low quality 1
- male voice singing 1
- mandolin 1
- medium fast tempo 1
- noisy 1
- plastic tapping sounds 1
- pop/singer-songwriter 1
- rock 1
- swishing sound 1
- uplifting energy 1
- uptempo 1
- video game 1
- vocalisation 1
- water bubbling 1
musiccaps_names (array) 8 ✖
- Banjo · 3 ✖
- Music 3
- Guitar 2
- Musical instrument 2
- Plucked string instrument 2
- Acoustic guitar 1
- Country 1
- Singing 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 | |
posdata te quiero galway girl | Two acoustic guitars being strummed can be heard while a male voice is singing in the mid range. Someone is strumming chords in a higher key alone. In the background you can hear acoustic drums and the crowd is cheering. This song may be playing live in a pub. | 2009-09-12T14:37:30Z | Adri Terroba | galway girl-posdata te quiero DISCLAIMER: NO COPYRIGHT INFRINGEMENT INTENDED. FOR ENTERTAINMENT PURPOSES ONLY | ["Singing", "Banjo", "Country", "Music"] | ["pop/singer-songwriter", "amateur recording", "acoustic guitars", "mandolin", "male voice singing", "acoustic drums", "crowd cheering", "uptempo", "uplifting energy"] | 6 | BhJa0kTUdGY | 1276 | |
Dueling Banjos 100% Guitar Hero 4 FC | The low quality recording features a rock song that consists of electric guitar chords, being played in a video game by plastic guitar, which makes plastic tapping noises. There are also some crowd cheering noises and the recording is very noisy overall. | 2009-09-17T02:54:24Z | GuitarHeroPhenom | We are streaming LIVE Here - http://www.twitch.tv/ghp_tv Follow our Twitch to be notified whenever we stream :D Danny Fcing Dueling Banjos a Guitar Hero DLC on Guitar Hero World Tour. http://www.guitarherophenom.com http://www.g8brand.com http://www.gamergrub.com http://www.dreamgear.net | ["Banjo", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["plastic tapping sounds", "crowd cheering", "low quality", "noisy", "rock", "electric guitar chords", "video game"] | 4 | GuYRF0no7hw | 1761 |
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;