musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "vibrant" and musiccaps_names contains "Traditional music" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- vibrant · 2 ✖
- acoustic drums 1
- acoustic guitar 1
- arabesque 1
- bass guitar 1
- clarinet 1
- emotional 1
- fiddle 1
- heart-touching 1
- instrumental 1
- irish folk music 1
- joyful 1
- keyboard 1
- live performance 1
- lively 1
- no singer 1
- percussion 1
- qanun 1
- saz 1
- steady tempo 1
- turkish folk 1
- uilleann pipes 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id ▼ | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hüsnü Klarnet - senin olmaya geldim | This is the live performance of a Turkish folk music piece with arabesque influences. The clarinet is playing the main melody in the lead at a medium-to-high pitch. A secondary melody is playing the qanun in the background. There are supportive elements in the melodic background such as the saz, the keyboard and the bass guitar. The acoustic drums are playing a mellow beat accompanied by rich percussion. There is a vibrant atmosphere in this piece. This could be playing in the background of a Turkish cuisine restaurant or a hookah place. It could also be used in the soundtrack of a Turkish soap opera. | 2008-09-27T11:11:52Z | hsenlendirici | WWW.HUSNUFAN.ORG | ["Clarinet", "Traditional music", "Music"] | ["turkish folk", "arabesque", "clarinet", "qanun", "saz", "keyboard", "bass guitar", "acoustic drums", "percussion", "vibrant", "emotional", "heart-touching", "live performance"] | 9 | BMgYWTTJv3s | 1232 | |
Seán McKeon, Conor McEvoy, John Blake - Traditional Irish Music from LiveTrad.com | This is an Irish folk music piece. There is no singer. The main melody is being played by the uilleann pipes and the fiddle at a high pitch. The acoustic guitar is playing a rapid procession of chords in the background. The atmosphere is lively. This piece could be playing in the background at an Irish pub. It could also be used in the soundtracks of movies and TV shows that have a theme with an Irish influence. | 2012-02-17T12:56:44Z | Livetrad | http://www.livetrad.com Performing a number of reels during a benefit concert for 'Aid Japan for Children', a group working with survivors of the earthquake and tsunami in Japan in 2011. This video was recorded by Martin Moylan at St. Anne's Church on Dawson St., Dublin 2 and we're delighted to add it to the LiveTrad YouTube channel. For more info see 'Aid Japan for Children' on Facebook. | ["Banjo", "Traditional music", "Music", "Bluegrass"] | ["irish folk music", "no singer", "instrumental", "uilleann pipes", "fiddle", "acoustic guitar", "vibrant", "joyful", "lively", "steady tempo"] | 9 | NwA9JSlK_lM | 2378 |
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;