musiccaps_details (view)
3 rows where musiccaps_aspects contains "folk dance" and musiccaps_aspects contains "percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 23 ✖
- folk dance · 3 ✖
- percussion · 3 ✖
- electronic drums 2
- lively 2
- accordion 1
- arabesque 1
- back vocals 1
- baglama 1
- bass guitar 1
- female vocal 1
- flute 1
- folk music 1
- halay 1
- instrumental 1
- keyboard 1
- kurdish folk music 1
- no singer 1
- pamiri 1
- playful 1
- punjabi film music 1
- upbeat 1
- vibrant 1
- zurna 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ibrahim Tatlises-New Kurdish Music 2011-Nabini | This is a Kurdish folk music piece. The main melody is first played by the baglama and then by the zurna. The rhythmic background consists of an electronic drum beat and supportive percussive elements. The atmosphere is lively. This piece could be used as an accompaniment piece for a folk dance course such as the halay dance. | 2010-11-08T23:44:21Z | Kurd PRODUZENTT | Kurds Muzik Ibo | ["Music", "Soul music"] | ["arabesque", "kurdish folk music", "baglama", "zurna", "electronic drums", "percussion", "upbeat", "lively", "folk dance", "halay"] | 9 | -cLzki-B06o | 66 | |
World most beautiful girl singing pamiri song 2013 best song ever | This is a Pamiri folk song. The female vocalist is singing melodically accompanied by a choir of both male and female back vocals. A keyboard is playing the main tune while a mixture of loud electronic drums and percussion provide the rhythmic background. This piece has a playful atmosphere. It could be used in a dancing course that involves folk dances of the region. | 2013-07-23T15:56:42Z | Muhammad Ammar Saleem | Caution.!! Only 18+ can watch otherwise you will fall in love..!!! | ["Music", "/t/dd00004"] | ["pamiri", "folk music", "female vocal", "back vocals", "keyboard", "electronic drums", "percussion", "playful", "folk dance"] | 9 | 5qVc9y3TNnY | 697 | |
Channa Sachi Muchi [Full Song] Channa Sachi Muchi | This is a Punjabi film music piece. At first, the melody is being played by the accordion. Then, it is being played by the flute. In the background, a bass guitar is playing. The rhythm is provided by the percussion. The atmosphere is vibrant. This piece could be used as an accompaniment piece for a folk dance course. | 2011-05-17T00:20:26Z | T-Series | Song - Channa Sachi Muchi Film - Channa Sachi Muchi Singer - Miss Pooja Lyricist - Romi Tahli Music Director - Jassi Bros. Artist - Miss Pooja, Goldy Sumal, Jas Dhillon, Rana Ranbir Music On - T-Series | ["Wind instrument, woodwind instrument", "Flute", "Accordion"] | ["punjabi film music", "no singer", "instrumental", "accordion", "flute", "bass guitar", "percussion", "vibrant", "lively", "folk dance"] | 9 | eWSA0xubW7I | 3871 |
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;