musiccaps_details (view)
2 rows where musiccaps_aspects contains "electronic drums", musiccaps_aspects contains "folk dance" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- electronic drums · 2 ✖
- folk dance · 2 ✖
- percussion 2
- arabesque 1
- back vocals 1
- baglama 1
- female vocal 1
- folk music 1
- halay 1
- keyboard 1
- kurdish folk music 1
- lively 1
- pamiri 1
- playful 1
- upbeat 1
- zurna 1
musiccaps_names (array) 3 ✖
- Music 2
- /t/dd00004 1
- Soul music 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 |
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;