musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "guitar accompaniment", musiccaps_aspects contains "instrumental music" and musiccaps_aspects contains "positive"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- guitar accompaniment · 2 ✖
- instrumental music · 2 ✖
- positive · 2 ✖
- a great day 1
- adventure 1
- averts sound quality 1
- building anticipation 1
- documentary soundtrack 1
- electric guitar 1
- electric guitar demo 1
- emotional passionate 1
- energetic 1
- good vibes 1
- groovy rhythm 1
- guitar amplifier 1
- guitar lead 1
- guitar solo artist 1
- home music video 1
- medium tempo 1
- modern pop instrumental 1
- movie soundtrack 1
- music demo 1
- mysterious 1
- new places 1
- no other instrumentation 1
- passionate 1
- pop music 1
- reverb tones 1
- secret agent man 1
- sense of adventure 1
- senseof adventure 1
- slow tempo 1
- soloist 1
- song fade 1
- song introduction 1
- strong bass line 1
- strong drum rhythm 1
- suspense 1
- travel show 1
musiccaps_names (array) 9 ✖
- Music 2
- Bass guitar 1
- Effects unit 1
- Guitar 1
- Musical instrument 1
- Plucked string instrument 1
- Reverberation 1
- Silence 1
- Ukulele 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Walk Across America - Behind the Scenes | The song is an instrumental. The tempo is medium with a guitar accompaniment and leads into a strong drumming rhythm and bass line. The song is exciting and energetic. The song is a movie soundtrack for a travel show or a documentary. | 2010-07-21T22:40:16Z | walkUSA | Here is how we created Guy Walks Across America. You can see our entire route on Google Maps here: http://bit.ly/brNULW Music - "Down River" by The Temper Trap http://www.thetempertrap.com | ["Music", "Ukulele"] | ["instrumental music", "song introduction", "travel show", "new places", "senseof adventure", "a great day", "positive", "good vibes", "pop music", "adventure", "sense of adventure", "building anticipation", "groovy rhythm", "energetic", "passionate", "movie soundtrack", "guitar accompaniment", "strong drum rhythm", "modern pop instrumental", "documentary soundtrack", "medium tempo"] | 1 | cp8t27oT_ww | 3746 | |
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 |
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;