musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "electric guitar" and musiccaps_names = "["Tapping (guitar technique)", "Guitar", "Musical instrument", "Plucked string instrument"]"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 15 ✖
- electric guitar · 2 ✖
- amateur recording 1
- arpeggio 1
- background song faded out 1
- dark 1
- hammer ons 1
- instructional theme 1
- instrumental song 1
- intricate electric guitar playing 1
- live recording 1
- moderate tempo 1
- mysterious 1
- no other instruments 1
- no voices 1
- rock 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ghost Riders in the Sky: Guitar Cover, The Outlaws, Full Song | Here we have a guitarist playing an intricate rock motif on the electric guitar. We hear some rapid plucking of a melody that sounds dark and mysterious. This is a live recording. | 2009-08-25T03:53:36Z | Sam August | Instagram: @samwaugust Follow for more guitar content Venmo: @Sam-August-1 for tips. Thank you! I lost all my gigs due to the Coronavirus outbreak, so this is much appreciated. Feel free to request songs. "Ghost Riders in the Sky" by the Outlaws. This song is absolutely awesome. Been getting a few requests for this one, and it's been too long since I've put up yet another Outlaws song. Originally written by Stan Jones in 1948, it's been covered by many including Johnny Cash, but no other version comes close to this legendary take on the song by the Florida guitar army. There aren't any tabs out there on this version, certainly the solos at least, so of course I did this all by ear, and it's not exactly right in some spots. Yippee-aye-ooo. Enjoy. | ["Tapping (guitar technique)", "Guitar", "Musical instrument", "Plucked string instrument"] | ["live recording", "electric guitar", "intricate electric guitar playing", "rock", "arpeggio", "dark", "mysterious"] | 3 | DV5mynb77JM | 1484 | |
Beast of Burden - Rolling Stones | This amateur recording features an electric guitar playing hammer ons on the pentatonic scale. There is a backing track that fades away and stops playing. The electric guitar plays a chord and pauses. The guitar then strums one more chord four times. There are no voices in this song. This is an instrumental. | 2009-10-26T06:43:24Z | privettricker | Despite popular belief, not everything Keith did post-1970 was in open G. This one's standard tuning. This is mostly Keith's part with some fills thrown in. | ["Tapping (guitar technique)", "Guitar", "Musical instrument", "Plucked string instrument"] | ["amateur recording", "electric guitar", "background song faded out", "hammer ons", "no other instruments", "no voices", "instrumental song", "moderate tempo", "instructional theme"] | 0 | XzlDa1dzUh4 | 3245 |
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;