musiccaps_details (view)
2 rows where musiccaps_aspects contains "female vocal", musiccaps_aspects contains "folk dance" and musiccaps_author = 9
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- female vocal · 2 ✖
- folk dance · 2 ✖
- back vocals 1
- claps 1
- doira 1
- electronic drums 1
- folk music 1
- garmon 1
- keyboard 1
- lively 1
- melodic singing 1
- pamiri 1
- percussion 1
- playful 1
- uzbek folk music 1
- vibrant 1
musiccaps_names (array) 3 ✖
- Music 2
- /t/dd00004 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 |
---|---|---|---|---|---|---|---|---|---|---|
Qizlar folklor ahangi, uzbek music | This is an Uzbek folk music piece. There is a female vocalist singing melodically. The main tune is being played by the garmon while the rhythmic background consists of the doors and the clapping of the dancers. There is a vibrant atmosphere in this piece. It could be used as an accompaniment piece for an Uzbek folk dance course. | 2013-06-19T17:57:32Z | Uzbek Youtub | afghanistan, uzbek music,afghan uzbek music, | ["Traditional music", "Music"] | ["uzbek folk music", "female vocal", "melodic singing", "garmon", "doira", "claps", "vibrant", "lively", "folk dance"] | 9 | 5F8zpfwFKl0 | 646 | |
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;