musiccaps_details (view)
6 rows where musiccaps_aspects contains "cover", musiccaps_aspects contains "emotional", musiccaps_aspects contains "passionate" and musiccaps_names contains "Plucked string instrument"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"September" by Andy Timmons | The low quality recording features a cover of a rock and it consists of passionately played solo acoustic guitar melody over staccato strings melody playing in the background on playback. Even though the recording is noisy, it sounds emotional and passionate. | 2006-04-17T07:15:29Z | aristocrap | A beautiful song by the tone king himself. | ["Guitar", "Music", "Mandolin", "Musical instrument", "Plucked string instrument"] | ["low quality", "staccato strings melody", "passionate solo acoustic guitar melody", "noisy", "cover", "rock", "playback", "emotional", "passionate"] | 4 | 36ToDxW_hns | 441 | |
40 guitar techniques in one solo! | The low quality recording features a cover of a soft rock song and it consists of strummed electric guitar and mellow electric guitar melody played over playback that has groovy bass, reverberant rimshots, shimmering cymbals and sizzling high pitched synth pad. It sounds emotional, funky and passionate. | 2012-05-09T21:21:59Z | gmcguitar | Get the tabs, backings and scales here: http://bit.ly/1fVenNd More Sinisa lessons: http://bit.ly/18qf2o8 Techniques covered in this solo: - hammer on (video part 1) - 5:20 - pull off (video part 1) - 5:20 - alternate picking (video part 2) - 5:48 - strumming (video part 3) - 6:26 - natural harmonics (video part 4) - 6:50 - artificial harmonics (video part 4) - 6:50 - finger picking chords (video part 5) - 7:26 - octave playing (video part 6) - 8:04 - normal legato (video part 7) - 8:41 - strict legato (video part 7) - 8:41 - pre bends (video part 8) - 9:17 - normal bending (video part 8) - 9:17 - micro bending (video part 9) - 9:45 - trills (video part 10) - 10:02 - thumb thang (video part 11) - 10:22 - double stops (video part 12) - 10:41 - vertical vibrato (video part 13) - 11:02 - horizontal vibrato (video part 13) - 11:02 - circular vibrato (video part 13) - 11:02 - wild vibrato (video part 13) - 11:02 - one hand tapping (video part 14) - 11:31 - 2 hand tapping (video part 14) - 11:31 - sweep picking (video part 15) - 12:08 - funk scratching (video part 16) - 12:32 - slapping & popping (video parts 17, 18, 19) - 13:24 , 13:37 , 13:57 - banjo roll (video parts 20, 21) - 14:17 , 14:45 - chicken picking (video part 22) - 15:14 - volume knob/violin effect (video part 23) - 15:45 - tremolo picking (video part 24) - 16:17 - slides (video part 24) - 16:17 - heavy downpicking (video part 25) - 16:58 - palm muting (video part 25) - 16:58 - pinch harmonics (video part 26) - 17:40 - tapped harmonics (video part 27) - 18:05 - switch toggling (video part 27) - 18:05 - Greg Howe Style/glissando vibrato (video part 28) - 18:36 - nut/neck/whammy vibrato (video part 29) - 19:02 - hybrid picking (video part 30) - 19:25 - string skipping (video part 30) - 19:25 - fast picking and mixed techniques (video parts 31-40) - 20:04 + | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["low quality", "playback", "cover", "soft rock", "groovy bass", "strummed electric guitar", "mellow electric guitar melody", "reverberant rimshot", "shimmering cymbals", "sizzling high pitched synth pad", "emotional", "passionate", "funky"] | 4 | 4M_k01zIbVM | 561 | |
Going to California (Led Zeppelin) | The low quality recording features a cover of a rock song and it consists of an arpeggiated acoustic guitar melody over which there is a soft female vocal singing. The recording is noisy, in mono and it sounds emotional, soft and passionate. | 2011-01-17T17:58:17Z | iLoveSHELmusic | I haven't been able to get this song out of my head the last few months, so I decided to play with it a little using my friend Wendy's bright little Fender mando. -Eva Keep in touch with SHEL - http://shelmusic.com Facebook: http://on.fb.me/1X7qCMV Twitter: http://bit.ly/1UinXkS instagram: http://bit.ly/1KnWWb0 iTunes: http://apple.co/1fS1zvB | ["Singing", "Guitar", "Music", "Mandolin", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["low quality", "soft female vocal", "arpeggiated acoustic guitar melody", "noisy", "mono", "passionate", "emotional", "soft", "cover", "rock"] | 4 | 62L5kn1qFeY | 719 | |
Here Comes the Sun: Beatles on the Autoharp: Hal Weeks | The low quality recording features a cover of a rock song and it consists of a passionate male vocal singing over an auto harp melody. It sounds passionate, emotional and mellow, despite the fact that the recording is noisy and in mono. | 2014-09-02T00:08:17Z | Hal Weeks | Hal Weeks teaches autoharp in the Denver Colorado area, and also online via Skype. To purchase Digital Downloads and CD's, go to: http://halweeksmusic.bandcamp.com/ | ["Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["low quality", "mono", "noisy", "passionate male vocal", "auto harp melody", "passionate", "emotional", "mellow", "cover", "rock"] | 4 | ET7yQfaiF_8 | 1561 | |
vicente de montpellier | The low quality recording features a cover of a regional Mexican song and it consists of a passionate male vocalist singing over acoustic rhythm guitar. There are some crowd chattering and asphalt sounds in the background. The recording is noisy, in mono and it sounds passionate and emotional. | 2009-11-09T14:59:52Z | bentana100 | aqui el vicente de montpelier cantando en su barrio monteberou | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Plucked string instrument"] | ["low quality", "mono", "regional mexican", "passionate male vocal", "cover", "noisy", "acoustic rhythm guitar", "crowd chattering", "asphalt sounds", "low quality", "emotional", "passionate"] | 4 | lI8aGjIb8Jg | 4389 | |
Red Hot Chili Peppers "Californication" Bass Cover | The low quality recording features a cover of a rock song played on bass guitar over electric guitar arpeggiated melody played on playback in the background. The recording is noisy, in mono, as it was probably recorded on a phone, and it sounds emotional and passionate. | 2010-10-27T15:02:48Z | CrankUpTheAmps | Facebook page! :D http://www.facebook.com/pages/Laura-Andy/300522706667642 If you're looking for a video to help you tab this song, you may want to keep searching! This isn't a perfect cover, but none of my other ones are either, so why break tradition? ;D I originally recorded this cover in September of 2009, 6 months after I started playing bass! Yes, yes, I know...I played the entire guitar solo part all wrong. The fact that the audio gets a bit off probably doesn't help my case, either. : / If this song didn't exist, there's a good chance that I wouldn't be playing bass today. Yes...it's that cool. When I put this video up before, I ended up getting a lot of comments about how my fingers look so stressed...it's true...but I think I've made a lot of improvement in the year that I've been playing since I recorded this! | ["Bass guitar", "Guitar", "Music", "Musical instrument", "Plucked string instrument", "Inside, small room"] | ["low quality", "noisy", "mono", "playback", "electric guitar arpeggiated melody", "rock", "bass guitar", "cover", "emotional", "passionate"] | 4 | zYsFbF9emtI | 5492 |
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;