musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "electric guitar", musiccaps_aspects contains "groovy", musiccaps_aspects contains "medium tempo" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) >30 ✖
- electric guitar · 2 ✖
- groovy · 2 ✖
- medium tempo · 2 ✖
- 80s feel 1
- acoustic drums 1
- amplified guitar 1
- bass guitar 1
- blues 1
- catchy riff 1
- clear 1
- crisp 1
- crunchy 1
- demonstration 1
- dense 1
- edgy 1
- electric guitar lead 1
- electric guitar lesson 1
- electric guitar solo 1
- electric guitars 1
- empahtic 1
- guitar solo 1
- hard rock 1
- instrumental 1
- jazz 1
- keyboard 1
- learning electric 1
- loud 1
- loud feed back 1
- powerful 1
- resonating 1
- …
musiccaps_names (array) 8 ✖
- Music 2
- Musical instrument · 2 ✖
- Blues 1
- Distortion 1
- Electric guitar 1
- Guitar 1
- Plucked string instrument 1
- Reverberation 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"COLD DUCK TIME" - HARRIS/McCANN | This is an amateur recording of a hard rock piece. An electric guitar solo is being played over a backing track that has a rhythm guitar, a bass guitar, a keyboard and acoustic drums playing in it. The sound resembles an 80s feel. It is a raw recording, so the mix is a bit muddy. | 2010-04-26T20:44:14Z | BGJ | THIS GREAT TUNE GAINED NOTICE ON THE EDDIE HARRIS & LES McCANN "LIVE AT MONTREAUX" L.P. IT'S A FUNKY THANG, AND HAS BEEN COVERED BY EVERYBODY! THE L.P. ALSO FEATURED LES'S "TRY TO MAKE IT REAL, COMPARED TO WHAT?" A FINE SOCIAL COMMENTARY SONG OF THE TIME. VIETNAM WAR, CIVIL RIGHTS, STUDENT PROTESTS ECT. LES IS A DEAR FRIEND, WE TALK FROM TIME TO TIME. HE STILL GIGS, RECORDS, & LECTURES AT COLLEGES ACROSS THE COUNTRY. THANKS FOR LOOKING IN, ALOHA, BEAR P.S. THIS IS DEDICATED TO OUR DEAR FRIEND LES McCANN. LOVE YOU BABY! | ["Blues", "Music", "Musical instrument"] | ["hard rock", "electric guitar", "guitar solo", "bass guitar", "keyboard", "acoustic drums", "groovy", "80s feel", "crunchy", "medium tempo"] | 9 | HWe3TSUcvHc | 1810 | |
The Jim Kelley Reverb amplifier, demo by Pete Thorn | This music is an electric guitar instrumental. The tempo is medium with a smooth electric guitar lead harmony. The music is clear, emphatic, smooth, groovy, youthful, crisp, edgy and dominant. | 2013-03-03T20:58:20Z | Pete Thorn | An in-depth look at the Kelley Reverb head, built by J.S. Technologies Check out Pete Thorn's "Guitar Nerd" album at CDbaby.com and iTunes: http://www.cdbaby.com/cd/petethorn https://itunes.apple.com/us/artist/pete-thorn/id437846702 | ["Reverberation", "Electric guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Distortion"] | ["instrumental", "electric guitars", "medium tempo", "demonstration", "tutorial", "learning electric", "electric guitar lesson", "clear", "loud", "powerful", "empahtic", "amplified guitar", "electric guitar", "stringed instrument", "loud feed back", "blues", "rock", "jazz", "resonating", "reverb", "youthful", "groovy", "catchy riff", "smooth", "electric guitar lead", "electric guitar solo", "dense", "rich", "crisp", "edgy"] | 7 | ouVuF-y8bog | 4664 |
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;