musiccaps_details (view)
2 rows where search matches "guitar", musiccaps_aspects contains "acoustic drums" and musiccaps_aspects contains "clarinet" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- acoustic drums · 2 ✖
- bass guitar 2
- clarinet · 2 ✖
- acoustic guitar 1
- albanian pop music 1
- arabesque 1
- easygoing 1
- electric guitat 1
- emotional 1
- heart-touching 1
- keyboard 1
- live performance 1
- lively 1
- male vocals 1
- melodic singing 1
- percussion 1
- qanun 1
- saz 1
- turkish folk 1
- vibrant 1
musiccaps_names (array) 6 ✖
- Clarinet 1
- Music 1
- Pop music 1
- Singing 1
- Swing music 1
- Traditional music 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 | |
Klajdi Haruni - O bo bo (Kenga Magjike 2015) | This is an Albanian pop music piece. There are male vocals singing melodically in the Albanian language. The main theme is being played on the clarinet while there is a melodic backing composed of the acoustic guitar, the electric guitar and the bass guitar. The rhythm is provided by a laid-back acoustic drum beat. The atmosphere is lively. This piece could be used as an opening theme for an Albanian sit-com. | 2015-11-17T17:00:02Z | KlajdiHaruniVEVO | Music video for O bo bo (Kenga Magjike 2015) performed by Klajdi Haruni. Site: http://www.threedots.al Facebook: https://www.facebook.com/klajdiharunithreedots?fref=ts Copyright (C) 2015 Threedots Production. http://vevo.ly/fQQQYu | ["Singing", "Swing music", "Pop music"] | ["albanian pop music", "male vocals", "melodic singing", "clarinet", "acoustic guitar", "electric guitat", "bass guitar", "acoustic drums", "easygoing", "lively"] | 9 | t5fW1-6iXZY | 5004 |
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;