musiccaps_details (view)
2 rows where musiccaps_aspects contains "chimes" and musiccaps_names contains "Tender music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 22 ✖
- chimes · 2 ✖
- slow tempo 2
- calming 1
- chinese instrumental 1
- chinese instruments 1
- guzheng 1
- guzheng harmony 1
- healing 1
- instrumental 1
- instrumental song 1
- meditation song 1
- meditative 1
- melancholic 1
- no percussion 1
- no voices 1
- pensive 1
- pipa accompaniment 1
- relaxing music 1
- soothing 1
- string instruments 1
- viloin harmony 1
- zither 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Beautiful China and traditional music | This music is a calm Chinese instrumental melody. The tempo is slow with use of traditional chinese string instruments like the Guzheng and Pipa harmony accompanied with violin symphony and chimes. The music is soft, mellow, melancholic, meditative, dreamy, healing and ethereal. | 2008-02-26T22:59:29Z | baby john | Have a look at our back yard! | ["Music", "Tender music"] | ["instrumental", "slow tempo", "chimes", "melancholic", "string instruments", "pipa accompaniment", "viloin harmony", "calming", "soothing", "meditative", "healing", "pensive", "chinese instruments", "chinese instrumental", "guzheng harmony"] | 7 | KxVbdGPAfjE | 2133 | |
Relaxation Music - Melody of Rain (Bandari) | This meditation song features a guzheng playing the main melody. A kind of zither plays arpeggiated chords in the background. Chimes are played in between lines. This song has a Chinese melody. This song is relaxing. There are no voices in this song. This song can be played in a meditation center. | 2009-11-03T09:08:53Z | Cookie Fried | ["Music", "Tender music"] | ["meditation song", "zither", "guzheng", "chimes", "no percussion", "no voices", "instrumental song", "slow tempo", "relaxing music"] | 0 | agK1OkzW5Yg | 3568 |
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;