musiccaps_details (view)
3 rows where musiccaps_names contains "Guitar", musiccaps_names contains "Harmonic", musiccaps_names contains "Musical instrument" 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 |
---|---|---|---|---|---|---|---|---|---|---|
Modtone Harmonic Tremor Tremolo pedal guitar demo | This audio contains a e-guitar running through a tremolo effect that gets into faster modulation speed. This is an amateur recording and may be used for educational purposes. | 2008-12-04T04:31:00Z | gearmanndude | check out http://www.guitar-emporium.com for all the cool boutique pedals I use and demo...IN STOCK! The Mod Tone MT-HT is a top quality, low budget Tremolo Vibrato pedal. Very versatile and solid. Gibson Les Paul Historic into an Orange Tiny Terror amplifier. Enjoy! | ["Effects unit", "Guitar", "Music", "Musical instrument", "Rock music", "Harmonic", "Plucked string instrument", "Distortion"] | ["amateur recording", "e-guitar", "tremolo effect", "medium to fast tempo"] | 6 | KSFND-AdqZs | 2083 | |
Supper Moment - 幸福之歌 guitar 結他 cover by Eric Lo | This is a cover of an alternative rock music piece. There is an electric guitar with a clean sound and a lot of reverb playing a gentle arpeggio. The atmosphere is dreamy and hazy. This piece could be used in the background of a tutorial video. | 2015-06-07T07:58:15Z | Eric Lo Guitar | My tabs : https://www.mymusicsheet.com/ericmusic1437/23233 Buy all my other tabs :https://www.mymusicsheet.com/ericmusic1437/ Guitar lesson / Buy my tabs / tab arrangement request : https://ericmusic1437.wixsite.com/guitar Homepage: https://ericmusic1437.wixsite.com/guitar My Tabs : https://www.mymusicsheet.com/ericmusic1437 Facebook Fanspage : https://www.facebook.com/ericlomusic Personal Facebook: http://www.facebook.com/ericmusic1437 Youtube: http://www.youtube.com/user/ericmusic1437 Ig: https://www.instagram.com/ericmusic1437/ E-mail: ericmusic1437@gmail.com Wtsapp : 852-98633697 Contact details : Mobile : 852-98633697 ( welcome whatsapp ) E-mail : ericmusic1437@gmail.com | ["Guitar", "Music", "Musical instrument", "Harmonic", "Plucked string instrument", "Inside, small room"] | ["cover", "alternative rock", "electric guitar", "clean sound", "reverb", "gentle playing", "dreamy", "hazy"] | 9 | MS8VU468rKk | 2268 | |
Blues Rhythms - #1 - Guitar Lesson - Corey Congilio | The low quality recording features an electric guitar melody played over a playback that consists of groovy bass, punchy snare and shimmering cymbals. At the end of the loop, there is a flat male vocal talking. It sounds groovy, fun and the recording is noisy and slightly distorted. | 2012-11-21T19:01:01Z | TrueFire | *FULL COURSE NOW AVAILABLE FOR DOWNLOAD w/ TAB, JAMS & MORE: http://tfir.es/50BluesRhythms COREY CONGILIO: http://tfir.es/CoreyC MORE FREE GUITAR LESSONS: http://bit.ly/TrueFire | ["Blues", "Bass guitar", "Guitar", "Music", "Musical instrument", "Rhythm and blues", "Speech", "Harmonic", "Plucked string instrument"] | ["low quality", "electric guitar melody", "groovy bass", "punchy snare", "shimmering cymbals", "groovy", "fun", "happy", "flat male vocal", "distorted", "noisy"] | 4 | NZ2kFIaW05k | 2345 |
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;