musiccaps_details (view)
2 rows where musiccaps_aspects contains "chinese fiddle" and musiccaps_aspects contains "slow tempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- chinese fiddle · 2 ✖
- slow tempo · 2 ✖
- ambient background 1
- bass 1
- bells and chimes 1
- dreamy song 1
- flute 1
- high pitched voice 1
- instrumental 1
- male voice 1
- meditation song 1
- no percussion 1
- no voice 1
- oriental folk song 1
- oriental percussion 1
- oriental song 1
- tremulous voice 1
musiccaps_names (array) 4 ✖
- Music 2
- Folk music 1
- Music of Asia 1
- New-age music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chinese New Age Music, 二胡 (Erhu), Madrigal, 严洁敏(Yan Jiemin), | This instrumental song features a Chinese fiddle. The song has an oriental feel. The fiddle is accompanied by a bass playing the root notes of the chords. Another medium pitched instrument plays chords in the background. Bells and chimes are played to add more melody to this song. There is no percussion in this song. There are no voices in this song. This song can be played in a meditation center. | 2010-05-30T12:38:35Z | moonbaby1962 | Composer and musician Yan Jiemin is is an associate professor at China's Central Conservatory of Music. Known globally, she is a highly respected musician performing many genres of music. This production combines traditional Chinese theme and composition with a New Age production style, therefore I refer to this recording as being Chinese New Age Cross-Over Music. I highly recommend listening to any of Yan Jiemin's work. She is amazing. I do not own any content within this video. | ["New-age music", "Music"] | ["chinese fiddle", "oriental song", "no voice", "instrumental", "meditation song", "bells and chimes", "dreamy song", "bass", "no percussion", "ambient background", "slow tempo"] | 0 | 0sPVAP17w2U | 216 | |
Missing from YouTube | This song is an oriental folk song featuring a male voice singing at a high pitch. The voice is tremulous. This is accompanied by the Chinese fiddle playing a melody similar to the main voice. A flute also plays the same melody as the voice. The percussion plays random beats leaving a lot of room in between. This song can be played in an Asian movie where a man is trying to woo a girl in a village. | ["Music of Asia", "Folk music", "Music"] | ["oriental folk song", "male voice", "high pitched voice", "chinese fiddle", "oriental percussion", "flute", "slow tempo", "tremulous voice"] | 0 | 2328 |
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;