musiccaps_details (view)
4 rows where musiccaps_aspects contains "emotional", musiccaps_aspects contains "noisy" and musiccaps_names contains "Traditional music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 21 ✖
- emotional · 4 ✖
- low quality 4
- noisy · 4 ✖
- mono 3
- traditional 3
- passionate 2
- classical 1
- distorted passionate female vocal 1
- folk 1
- joyful 1
- live performance 1
- passionate female vocal 1
- passionate woodwind melody 1
- plucked arpeggiated zheng melody 1
- plucked strings melody 1
- sentimental 1
- soulful 1
- subtle sitar melody 1
- synth lead melody 1
- wooden percussions 1
- wooden percussive elements 1
musiccaps_names (array) 7 ✖
- Music 4
- Traditional music · 4 ✖
- Carnatic music 1
- Clarinet 1
- Musical instrument 1
- Singing 1
- Wind instrument, woodwind instrument 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Raga Bhairavi in Carnatic Music | The low quality recording features a live performance of traditional folk song and it consists of distorted, passionate female vocal singing over subtle sitar melody. The recording is noisy and it sounds emotional and passionate. | 2012-07-07T10:09:57Z | Dr Charulatha Mani | Isai Payanam with Charulatha Mani Raga Bhairavi in Carnatic Music Violin - Anantakrishnan, Mridangam - Arjun Ganesh See "A Raga's Journey - Bewitching Bhairavi" - http://charulathamani.blogspot.in/2012/07/ragas-journey-bewitching-bhairavi.html Comparison of Ragas Bhairavi and Mukhari: http://www.youtube.com/playlist?list=PL0IoH26Ut8bIitglEs2Nzq9aRW8h-9nTt | ["Carnatic music", "Traditional music", "Music"] | ["low quality", "distorted passionate female vocal", "noisy", "live performance", "traditional", "emotional", "subtle sitar melody", "folk"] | 4 | 0a91szM1Ivw | 186 | |
Chinese traditional music by Liu Fang on guzheng 古筝曲 寒鴉戲水 劉芳古箏獨奏 | The low quality recording features a plucked arpeggiated Zheng melody. The recording is in mono and it is noisy and it gives off sentimental vibes. | 2007-03-29T02:54:56Z | phil manage | Guzheng (where "Gu" and "Zheng" stand for "ancient" and "zither" or "harp") is one of the most popular traditional instruments from China. It's beautiful and mellow sounds are very attractive. Pipa soloist Liu Fang also has also an excellent command of guzheng playing, particularly for classical styles, as evidenced in this piece. Performer: Liu Fang (www.liufangmusic.net) Title: "Seagulls playing in water". This is a traditional piece from the Chinese classical repertoire, recorded live at Liu Fang's solo recital in the Theatre de la Ville of Paris on May 8, 2006. The whole piece is about 6 minutes. Musique tradionnelle chinoise pour la cithare guzheng par Liu Fang. (Source: http://www.philmultic.com/liufang/video/guzheng_music.html ) 古筝名曲 《寒鴉戲水》, 劉芳古箏獨奏 | ["Traditional music", "Music"] | ["classical", "low quality", "plucked arpeggiated zheng melody", "noisy", "emotional", "sentimental", "mono"] | 4 | 3EtbIWF_ynU | 450 | |
Kamil - Azerbaycan teraneleri | The low quality recording features a traditional song that consists of a passionate woodwind melody played over wooden percussive elements. It sounds soulful, passionate and emotional, even though the recording is in mono and noisy. | 2008-12-07T05:51:30Z | gunazyayim | Kamil Azerbaycan treraneleri | ["Clarinet", "Traditional music", "Music", "Musical instrument", "Wind instrument, woodwind instrument"] | ["low quality", "traditional", "noisy", "mono", "passionate woodwind melody", "wooden percussive elements", "soulful", "passionate", "emotional"] | 4 | 3w_LsKl-3Pk | 523 | |
Jamilah sa'ad yemen song | The low quality recording features a passionate female vocalist singing over wooden percussion, synth lead melody and plucked strings melody playing in the background. It sounds passionate, emotional, joyful and traditional. | 2009-01-27T15:22:28Z | girhish | Jamilah sa'ad | ["Singing", "Traditional music", "Music"] | ["low quality", "mono", "noisy", "passionate female vocal", "wooden percussions", "synth lead melody", "plucked strings melody", "passionate", "emotional", "joyful", "traditional"] | 4 | gNpzuFPu6q8 | 4027 |
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;