musiccaps_details (view)
1 row where musiccaps_aspects contains "cover", musiccaps_aspects contains "passionate", musiccaps_aspects contains "soft rock" and musiccaps_names contains "Musical 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;