musiccaps_details (view)
3 rows where musiccaps_aspects contains "arpeggio" and musiccaps_names contains "Musical instrument"
This data as json, CSV (advanced)
musiccaps_aspects (array) 24 ✖
- arpeggio · 3 ✖
- acoustic 1
- acoustic guitar 1
- christmas euphoria 1
- dark 1
- easygoing 1
- electric guitar 1
- gentle 1
- guitar cover 1
- high pitch 1
- instrumental 1
- intricate electric guitar playing 1
- live recording 1
- low quality 1
- mellow tune 1
- mysterious 1
- mystical 1
- no singer 1
- noisy 1
- nostalgic 1
- relaxing 1
- rock 1
- sizzling glassy melody 1
- tapping noises 1
musiccaps_names (array) 8 ✖
- Musical instrument · 3 ✖
- Guitar 2
- Music 2
- Plucked string instrument 2
- Acoustic guitar 1
- Glass 1
- Strum 1
- Tapping (guitar technique) 1
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 | |
เธอ - Cocktail || Fingerstyle Guitar Cover by ต้นปาล์ม | This is a guitar cover video. There are no vocals in this piece. The acoustic guitar is playing a mellow tune with the heavy use of arpeggios. The atmosphere is gentle and relaxing. This piece could be used as the opening theme of a teenage drama TV series. It could also be playing in the background at a coffee shop. | 2014-05-06T10:23:45Z | tonpalm guitar | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["guitar cover", "no singer", "instrumental", "acoustic guitar", "arpeggio", "mellow tune", "easygoing", "gentle", "relaxing"] | 9 | XWVGQbfpA0k | 3189 | ||
J. S. Bach - Toccata and Fugue in D minor on the glass harp (музыкальные бокалы) | The low quality recording features a sizzling glassy melody arpeggiated in high pitch register. Sounds mystical and it gives off some euphoric Christmas feelings. There are also some tapping noises, mostly in the left channel of the stereo image. | 2011-02-16T17:16:34Z | GlassDuo - Glass Harp | Johann Sebastian Bach - Toccata and Fugue in D minor played on the glass harp by GlassDuo at the "Festival di Santo Stefano" in Bologna, Italy. GlassDuo have created an exceptional musical instrument from a set of custom made wine glasses. The result is the biggest professional #GlassHarp in the world. This track is on the album "GLASSIFIED" available here: http://shop.glassduo.com Some links about GlassDuo and the #MusicalGlasses: http://GlassDuo.com - official website http://GlassHarp.eu - order your own glass harp http://shop.glassduo.com - buy CD and MP3 https://www.facebook.com/GlassHarp.GlassDuo - Facebook profile https://www.instagram.com/glassharpduo - Instagram profile Donation via PayPal: https://www.paypal.com/donate/?hosted_button_id=NXNGF7WPNT3LL | ["Glass", "Music", "Musical instrument"] | ["low quality", "sizzling glassy melody", "noisy", "high pitch", "arpeggio", "acoustic", "mystical", "nostalgic", "christmas euphoria", "tapping noises"] | 4 | gDm4IphrlYg | 4015 |
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;