musiccaps_details (view)
3 rows where musiccaps_aspects contains "live performance", musiccaps_aspects contains "percussion" and musiccaps_names contains "Traditional music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- live performance · 3 ✖
- percussion · 3 ✖
- vibrant 2
- acoustic drums 1
- arabesque 1
- bass guitar 1
- claps 1
- clarinet 1
- darbuka 1
- drums 1
- eastern sounding 1
- emotional 1
- heart-touching 1
- historical movie music 1
- instrumental 1
- keyboard 1
- khaliji music 1
- lively 1
- lute 1
- medieval music 1
- orchestra 1
- oud 1
- qanun 1
- riq 1
- saz 1
- turkish folk 1
- vielle 1
- violin 1
musiccaps_names (array) 8 ✖
- Music 3
- Traditional music · 3 ✖
- Bowed string instrument 1
- Clarinet 1
- Jazz 1
- Middle Eastern music 1
- Musical instrument 1
- Plucked string instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Hesperion XXI Ancient Music part 2 | This is the live performance of a medieval music piece. The piece is instrumental. The main melody is being played by a vielle while the lute is playing a backing tune. The rhythm is provided by the drums and a chime bell percussion. The atmosphere is lively. This piece could be used in the soundtrack of a historical drama movie or a TV show that takes place during the medieval era. | 2007-08-31T14:06:42Z | TeodorFok | Ancient, Medieval, Church Music, Hesperion XXI | ["Traditional music", "Jazz", "Music"] | ["medieval music", "instrumental", "live performance", "vielle", "lute", "drums", "percussion", "lively", "historical movie music"] | 9 | 7zP5kNyDn88 | 895 | |
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 | |
خالد الملا على كثر | This is a live performance of a Khaliji music piece. There is an orchestra performing the piece. The melody is being played by the oud and the violin. The rhythmic background is composed of various percussive elements such as the riq, the darbuka and performers clapping their hands. The atmosphere is vibrant. This piece could be playing in the background at an Arab cuisine restaurant. | 2012-12-22T12:53:27Z | saaa64 | المطرب خالد الملا حضرميه على كثر | ["Traditional music", "Music", "Musical instrument", "Middle Eastern music", "Plucked string instrument", "Bowed string instrument"] | ["khaliji music", "live performance", "orchestra", "violin", "oud", "percussion", "riq", "darbuka", "claps", "vibrant", "eastern sounding"] | 9 | MHHshnnqyco | 2251 |
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;