musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "suspense" and musiccaps_names contains "Plucked string instrument" sorted by youtube_description
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 46 ✖
- electric guitar 2
- instrumental music 2
- suspense · 2 ✖
- ambient room noises 1
- average audio quality 1
- averts sound quality 1
- country music 1
- cowboys 1
- echoes 1
- electric guitar demo 1
- emotional 1
- emotional passionate 1
- epic stories 1
- groovy 1
- groovy music 1
- guitar accompaniment 1
- guitar amplifier 1
- guitar band 1
- guitar lead 1
- guitar pick percussions 1
- guitar solo 1
- guitar solo artist 1
- gunslingers 1
- heroes and villains 1
- home music video 1
- legends 1
- live audience 1
- live performance 1
- music demo 1
- mysterious 1
- no other instrumentation 1
- passionate 1
- positive 1
- reverb tones 1
- rhythm guitars 1
- scratching tones 1
- secret agent man 1
- slow tempo 1
- soloist 1
- song covers 1
- song fade 1
- story tellers 1
- strings scratched with plectrum percussions 1
- strong bass line 1
- tense 1
- the wild west 1
musiccaps_names (array) 9 ✖
- Guitar 2
- Music 2
- Musical instrument 2
- Plucked string instrument · 2 ✖
- Bass guitar 1
- Effects unit 1
- Reverberation 1
- Silence 1
- Strum 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Randall Kirk Hammett Signature Amp | The song is an instrumental. The tempo is slow with an electric guitar playing lead and a strong bass line in a rhythmic manner. The song is strong and mysterious like a secret agent movie theme. The song is recorded at home and has an average sound quality. The song is a music demo. | 2008-07-09T15:06:58Z | Guitar World | Guitar World's gear editor Paul Riario demonstrates the features of the Randall Kirk Hammett Signature Head and Cabinet. For more gear reviews, lessons, interviews and more check out guitarworld.com! (more) | ["Bass guitar", "Reverberation", "Silence", "Effects unit", "Guitar", "Music", "Musical instrument", "Plucked string instrument"] | ["instrumental music", "slow tempo", "electric guitar", "music demo", "song fade", "reverb tones", "guitar lead", "guitar accompaniment", "strong bass line", "electric guitar demo", "guitar amplifier", "suspense", "no other instrumentation", "soloist", "guitar solo artist", "home music video", "averts sound quality", "emotional passionate", "positive", "mysterious", "secret agent man"] | 1 | kKihNQ44dDQ | 4309 | |
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;