musiccaps_details (view)
3 rows where search matches "guitar", musiccaps_aspects contains "crowd cheering" and musiccaps_names contains "Musical instrument" sorted by youtube_published
This data as json, CSV (advanced)
musiccaps_aspects (array) 33 ✖
- crowd cheering · 3 ✖
- low quality 2
- rock 2
- acoustic guitar 1
- addictive 1
- animated sounds 1
- arpeggiated electric guitar melody 1
- banjo riff 1
- camera sounds 1
- clapping 1
- clicking sound 1
- crowd singing 1
- electric guitar chords 1
- emotional 1
- flat male vocal 1
- funny 1
- groovy bass guitar 1
- guitar string plonk 1
- hooting sound 1
- instrumental 1
- introduction music 1
- kids screaming in joy 1
- live performance 1
- medium fast tempo 1
- noisy 1
- plastic tapping sounds 1
- punchy kick 1
- shimmering hi hats 1
- snappy rimshots 1
- swishing sound 1
- video game 1
- vocalisation 1
- water bubbling 1
musiccaps_names (array) 8 ✖
- Music 3
- Musical instrument · 3 ✖
- Banjo 2
- Guitar 2
- Plucked string instrument 2
- Acoustic guitar 1
- Blues 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published ▼ | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Compact - Fata din vis | The low quality recording features a live performance of a rock song and it consists of flat male vocal singing over arpeggiated electric guitar melody, groovy bass guitar, shimmering hi hats, snappy rimshots and punchy kicks. In the background, there are some crowd singing and crowd cheering noises. It sounds emotional and a bit addictive. | 2008-04-19T14:23:33Z | Horia D | nice love song | ["Blues", "Singing", "Music", "Musical instrument"] | ["low quality", "live performance", "rock", "crowd cheering", "crowd singing", "flat male vocal", "punchy kick", "snappy rimshots", "shimmering hi hats", "arpeggiated electric guitar melody", "groovy bass guitar", "emotional", "addictive"] | 4 | cTJqIkSuf6s | 3710 | |
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 | |
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 |
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;