musiccaps_details (view)
2 rows where musiccaps_aspects contains "female vocal", musiccaps_author = 9 and musiccaps_names contains "Traditional music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 16 ✖
- female vocal · 2 ✖
- autotune singing 1
- claps 1
- doira 1
- ethiopian traditional music 1
- folk dance 1
- garmon 1
- lively 1
- masenqo 1
- melodic singing 1
- mourning 1
- percussion 1
- tribal 1
- uzbek folk music 1
- vibrant 1
- washint 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 | |
New Ethiopian Traditional music 2014 שיר אמהרית מסורתי חדש | This is an Ethiopian traditional music piece. There is a female vocalist singing in a crying-like manner through the use of autotune. There are traditional Ethiopian instruments such as washing and masenqo in the melodic background. The rhythm is being played by the percussion. There is an atmosphere of mourning in this piece. This piece could be used in the soundtrack of an Ethiopian drama movie. | 2014-06-10T20:02:38Z | danny feredo | ["Traditional music", "Music"] | ["ethiopian traditional music", "female vocal", "autotune singing", "washint", "masenqo", "percussion", "mourning", "tribal"] | 9 | Fz-ZNyVKWro | 1681 |
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;