musiccaps_details (view)
2 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "meditation song" and musiccaps_aspects contains "no percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 15 ✖
- instrumental · 2 ✖
- meditation song · 2 ✖
- no percussion · 2 ✖
- slow tempo 2
- ambient background 1
- bass 1
- bells and chimes 1
- chinese fiddle 1
- dreamy song 1
- no other instruments 1
- no voice 1
- no voices 1
- oriental song 1
- relaxing song 1
- synth song 1
musiccaps_names (array) 4 ✖
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 | |
SGPB Sleeping Tune.mpg | This song features a synth playing the main melody. The synth plays a heavenly voice with a pad like backing. There are no other instruments in this song. There is no voice in this song. The mood of this song is relaxing. This song can be played in a meditation center. | 2010-03-06T18:33:49Z | gwwoodworth | Bagpipe concert 3/5/10 | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["synth song", "no other instruments", "no percussion", "no voices", "instrumental", "slow tempo", "relaxing song", "meditation song"] | 0 | w0yHqPxybQE | 5230 |
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;