musiccaps_details (view)
2 rows where musiccaps_aspects contains "ambient room noises", musiccaps_aspects contains "passionate" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 44 ✖
- ambient room noises · 2 ✖
- passionate · 2 ✖
- average audio quality 1
- bas]d audio quality 1
- country music 1
- cowboys 1
- echoes 1
- electric guitar 1
- emotional 1
- energetic 1
- epic stories 1
- fretboard sounds 1
- groovy 1
- groovy music 1
- guitar band 1
- guitar demo 1
- guitar pick percussions 1
- guitar solo 1
- guitar string tones 1
- guitar technique 1
- guitarist 1
- gunslingers 1
- heroes and villains 1
- home music video 1
- humming noise 1
- instrumental music 1
- legends 1
- live audience 1
- live performance 1
- male talking 1
- mediocre audio quality 1
- online guitar lessons 1
- rhythm guitars 1
- scratching tones 1
- song covers 1
- spirited okay 1
- story tellers 1
- strings scratched with plectrum percussions 1
- strong voice 1
- suspense 1
- tense 1
- the wild west 1
- twang sounds 1
- youtube tutorial 1
musiccaps_names (array) 8 ✖
- Guitar 2
- Music 2
- Musical instrument · 2 ✖
- Plucked string instrument 2
- Acoustic guitar 1
- Bass guitar 1
- Speech 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Funky Voodoo Chile' Riff - Stevie Ray Vaughan version | A male guitarist plays the guitar and speaks about technique in this online video tutorial. The male voice is strong and commanding, along with guitar string twang sounds, clearly demonstrating the technique. The audio quality is mediocre. | 2007-12-20T06:13:22Z | Texas Blues Alley | http://txba.ly/v4Ej - Learn how to play a funky little filler riff that Stevie Ray Vaughan played during his cover of Voodoo Chile' by Jimi Hendrix. | ["Bass guitar", "Guitar", "Acoustic guitar", "Music", "Musical instrument", "Speech", "Plucked string instrument"] | ["guitarist", "male talking", "twang sounds", "mediocre audio quality", "guitar string tones", "guitar technique", "fretboard sounds", "guitar demo", "online guitar lessons", "home music video", "youtube tutorial", "bas]d audio quality", "humming noise", "energetic", "passionate", "spirited okay", "strong voice", "ambient room noises"] | 1 | -5xOcMJpTUk | 13 | |
The Good, the Bad and the Ugly / Reel Matawa by California Guitar Trio & Montreal Guitar Trio | The song is an instrumental. The song is medium tempo with a guitar playing lead and several guitarists playing harmony and accompaniment and a pick scratching guitar strings producing a percussive line. The song is immersive and has a classic country gun fight duel vibe to it. The song has ambient room noises. | 2009-11-19T18:55:29Z | MG3 : Montréal Guitare Trio / Montreal Guitar Trio | Montreal Guitar Trio & California Guitar Trio performed The Good, the Bad and the Ugly by Ennio Morricone followed by the Reel Matawa by Richard Forest at Palais Montcalm in Quebec City, October 23, 2009. | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["guitar band", "guitar solo", "scratching tones", "guitar pick percussions", "song covers", "strings scratched with plectrum percussions", "live performance", "live audience", "ambient room noises", "echoes", "average audio quality", "groovy music", "instrumental music", "country music", "tense", "suspense", "gunslingers", "groovy", "story tellers", "the wild west", "emotional", "passionate", "heroes and villains", "legends", "epic stories", "electric guitar", "rhythm guitars", "cowboys"] | 1 | 3w3fD54bNvU | 521 |
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;