musiccaps_details (view)
2 rows where musiccaps_aspects contains "chinese music" and musiccaps_aspects contains "flute"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- chinese music · 2 ✖
- flute · 2 ✖
- ambient auditorium sounds 1
- asian music 1
- average audio quality 1
- echo 1
- energetic drumming 1
- fast tempo 1
- grasslands 1
- incoherent music 1
- inferior audio quality 1
- instrumental 1
- live performance 1
- live recording 1
- marshlands 1
- people talking 1
- reverb 1
- serene and enchanting melody 1
- synthesiser harmony 1
- tambourine beats 1
- traditional chinese flute 1
- upbeat music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Música antigua tradicional China, representada en flauta | This is a live recording of a musician playing a Chinese flute, otherwise known as a dizi. It is a calming and melodic piece - and you could imagine yourself walking peacefully through marshlands or grasslands. Though the melody is enchanting, the audio quality is average - with a slight fuzzy buzz present in the background. | 2008-06-21T18:41:24Z | chenwudang | El maestro Chen, nuevamente, nos deleita con una melodía en flauta de música tradicional antigua china | ["Wind instrument, woodwind instrument", "Flute"] | ["flute", "traditional chinese flute", "chinese music", "serene and enchanting melody", "grasslands", "marshlands", "live recording", "average audio quality"] | 3 | VlXi2TxMXbc | 3028 | |
Ly cay bong - bieu dien: nhom No.1 | This music is instrumental. The tempo is fast with a melodious harmony with synthesiser arrangements, drumming, tambourine beats and some unidentifiable instruments.The audio quality is inferior with an incoherent audio. The music style is Asian/ Chinese. | 2009-08-24T14:33:37Z | Phuong Hai | ["Music", "Tambourine"] | ["instrumental", "fast tempo", "asian music", "people talking", "energetic drumming", "tambourine beats", "flute", "chinese music", "live performance", "synthesiser harmony", "inferior audio quality", "upbeat music", "ambient auditorium sounds", "echo", "reverb", "incoherent music", "people talking"] | 7 | s2iIZ2WNuKY | 4919 |
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;