musiccaps_details (view)
6 rows where musiccaps_aspects contains "electric guitar arpeggio" and musiccaps_author = 3
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| Funny kitty video watch it now! | This song is an alternative rock song which features a male vocalist whispering the lyrics. The guitarist plays arpeggios of the chords while there is a screeching distorted sound in the background. | 2007-09-15T06:27:02Z | Dashron10 | Just letting everyone know i am thinking about making a new vid.. for everyone who said "maaybe you should have picked a shorter song, i decided this time i am going to take the time and individually download pics and place them into the video then delete them making room for more, I believe this time i am going to use Metallica. You got a problem with that keep it to yourself... | ["Psychedelic rock", "Rock music"] | ["alternative rock", "whispering", "electric guitar arpeggio", "sombre", "mysterious"] | 3 | 5CtvEcPtknI | 642 | |
| DPRK Music 1-15 어머니의 노래 | The song feels cinematic and momentous. It's an orchestral piece with string instruments, and then with an electric guitar lick. The emotion is gripping and a little sombre. | 2008-08-25T06:06:02Z | chosunmusiccom | Chosun Music Disc 1 - North Korean Karaoke Song | ["New-age music", "Music"] | ["orchestral music", "cinematic", "string instruments", "emotional", "electric guitar arpeggio", "electric bass guitar playing", "cinematic", "epic"] | 3 | BquHBzP5Ep0 | 1295 | |
| On Your Wedding Day (A Stepdad's Song) | The song features a calm, gentle male vocalist. It feels like a soft pop ballad, with a slight rock influence. There's an electric guitar arpeggio, bongo drums, and a prominent bassline. The song feels like it would be suitable as a loving dedication to someone. | 2013-08-11T02:29:43Z | Joe M | ©Copyright 2012 Joe Manzella All Rights Reserved This song is for Melissa: Happy First Anniversary, Sweetie! - Love Joe On Your Wedding Day (A Stepdad's Song) It wasn't really long ago that you were just a girl. I came into your life by chance and slowly shared your world. Through good times and some bad, still always proud to be your stepdad. And now here on your wedding day, as you dance by my side, I'm so thrilled 'cause I get to be stepfather of the bride. So as I hold your hand, this love for you is from your stepdad. (Bridge) Just call on me anytime, it's no bother Always know you'll be my daughter and I'll be there. Wherever this life shall choose to lead us there's a bond always between us,a tie we share and I'll always care. And so here on your wedding day I'm truly blessed to be your stepdad. | ["Music", "Wedding music"] | ["soft rock ballad", "ballad", "pop ballad", "electric bass guitar bassline", "gentle male vocal", "electric guitar arpeggio", "bongo drums", "relaxing", "mellow"] | 3 | OR_YbeqV5tA | 2439 | |
| Gretsch 6120TM Chet Atkins guitar review | This is a solo electric guitarist playing some blues. It's a twelve bar blues progression that's intricately finger picked. It has a turnaround. | 2009-02-21T03:53:07Z | John Heussenstamm | John reviews the Gretsch guitar 6120TM Chet Atkins hollow body. link: http://www.johnhguitar.com/john-heussenstamm/GuitarReviews.php | ["Electric guitar", "Guitar", "Music", "Musical instrument", "Ukulele", "Plucked string instrument"] | ["electric guitar playing", "country blues guitar playing", "electric guitar arpeggio", "complex guitar playing"] | 3 | aqhhfkXKJ1o | 3577 | |
| 2 Chorus Pedals Comparison ( BOSS / CE-2, tc electronic CORONA ) | This is a repeated chord progression that's arpeggiated on an electric guitar. The guitar signal has a chorus pedal effect applied to it, and so it doesn't sound like a clean tone. The arpeggio itself is mellow yet uplifting. | 2015-10-24T01:56:23Z | yukibeatles | Guitar : RS Guitarworks / Contour Amp : Ceriatone / Overtone Lunchbox Loop : Strymon / TIMELINE Chorus Pedals ・tc electronic / CORONA CHORUS ・BOSS / CE-2 CHORUS (1982, made in Japan) | ["Effects unit", "Guitar", "Music", "Chorus effect"] | ["electric guitar arpeggio", "chord arpeggios", "chorus pedal", "guitar riff", "repeated progression"] | 3 | f1_YKSYgtbI | 3917 | |
| Duane Eddy - The Theme from Peter Gunn Glastonbury 2011 | This is a live blues-rock performance. The saxophone is playing a solo section, and the electric guitar repeats an arpeggio. This song would be suitable in a blues bar. | 2011-07-02T11:14:19Z | MLIN20 | Glastonbury 2011. Duane Eddy on the West Holts Stage playing the theme from Peter Gunn with Richards Hawley and an unknown Saxophonist. | ["Brass instrument", "Saxophone"] | ["blues", "saxophone", "electric guitar arpeggio", "simple blues drum beat", "live recording", "live performance", "repeated riff"] | 3 | hhVFK9tYu84 | 4128 |
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;