musiccaps_details (view)
1 row where musiccaps_aspects contains "classical", musiccaps_aspects contains "noisy" and musiccaps_aspects contains "plucked arpeggiated zheng melody"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 |
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;