musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "classical" and musiccaps_names contains "Strum" sorted by youtube_description
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- classical · 2 ✖
- acoustic guitar melody 1
- amateur recording 1
- ambient music 1
- atmospheric 1
- beautiful 1
- captivating 1
- emotional 1
- euphonious 1
- fast tempo 1
- fingerstile acoustic guitar 1
- gentle 1
- guitar lead 1
- guitar solo 1
- instrumental 1
- live performance 1
- mellow 1
- mesmerising 1
- romantic 1
- slow tempo 1
- string instrument 1
- western classical 1
musiccaps_names (array) 6 ✖
- Guitar 2
- Music 2
- Musical instrument 2
- Plucked string instrument 2
- Strum · 2 ✖
- Acoustic guitar 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description ▼ | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Fur Elise on classical guitar performed by Eddie Blatt | This music is instrumental. The tempo is slow with a melodic acoustic guitar solo. The music is soft, euphonious, dreamy, romantic , warm ,ambient and soothing. This is a Classical acoustic instrumental. | 2007-01-23T06:40:15Z | Eddie Blatt | Eddie Blatt plays Fur Elise on classical guitar live at the Byron Bay Community Centre. | ["Guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["instrumental", "slow tempo", "acoustic guitar melody", "western classical", "classical", "beautiful", "mellow", "euphonious", "captivating", "mesmerising", "guitar solo", "guitar lead", "string instrument", "live performance", "gentle", "emotional", "atmospheric", "ambient music", "romantic"] | 7 | p2sXdmex3xQ | 4683 | |
W. A. Mozart - Rondo alla Turca (Turkish March), solo classical guitar | This audio contains someone playing a classical melody on an acoustic guitar using fingerstyle. This audio is full of reverb. This song may be playing at a talent show. | 2012-02-14T18:40:10Z | Los Angeles Guitar Academy | In Mozart's time, the Ottoman Empire still ruled Turkey (Anatolia). Their military bands, called Janissary bands, were quite popular, even in Europe. Mozart borrowed from their sound and rhythm to produce this work, which became one of the big hits of Mozart's day. Its popularity has rarely waned since then. The final movement of the sonata, Rondo Alla Turca, captures the military bands' brassy sound. In its whirling feel, it can evoke another aspect of Turkish culture which has captivated Westerners--the whirling motion of the Sufi dervishes as they perform their ancient ritual of peace and wholeness, though the Rondo whirls at light speed, in contrast to the gentle movement of the Mevlevi. Arranged and performed by Emre Sabuncuoglu. Copyright © 2012 Los Angeles Guitar Academy Publishing. All rights reserved. 𝄞 Purchase sheet music and tabs: https://onlineguitaracademy.net/classical-guitar-sheet-music 🔔 Subscribe for more great pieces and tutorials: https://www.youtube.com/user/LAGuitarAcademy?sub_confirmation=1 🐢 Slow walkthrough videos available on our online lesson program: https://onlineguitaracademy.net/online-classical-guitar-lessons 🍀 Free trial for online programs: https://onlineguitaracademy.net/register/laga-free-trial https://onlineguitaracademy.net/pricing-comparison ❤️ Love our work? Join our Patreon community and access dozens of patron-only posts and exclusive releases: https://www.patreon.com/LAGuitarAcademy ❤️ Or join our channel: https://www.youtube.com/channel/UC3eQeaR786C8HCGFMqtCUSw/join Recommended videos: ✔️ Complete list of our Mozart arrangements: https://www.youtube.com/playlist?list=PL18tTu-0TnfqPbL8O1OFBXEWx5j1QAdkj ✔️ Spring (the Four Seasons) for solo guitar: https://www.youtube.com/watch?v=fENuHRAPEmA ✔️ Maple Leaf Rag by Scott Joplin on solo guitar: https://www.youtube.com/watch?v=xRjXafdabzc ✔️ Eine kleine Nachtmusik for solo guitar: https://www.youtube.com/watch?v=_fxyXLZ65gw | ["Guitar", "Acoustic guitar", "Music", "Musical instrument", "Strum", "Plucked string instrument"] | ["amateur recording", "classical", "fingerstile acoustic guitar", "fast tempo"] | 6 | 26HLgXWF-Co | 332 |
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;