musiccaps_details (view)
1 row where musiccaps_author = 3 and youtube_channel = "Sam August"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date), musiccaps_names (array), musiccaps_aspects (array)
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 |
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;