musiccaps_details (view)
2 rows where musiccaps_aspects contains "enigmatic", musiccaps_aspects contains "keyboard harmony" and musiccaps_aspects contains "soothing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 45 ✖
- enigmatic · 2 ✖
- keyboard harmony · 2 ✖
- medium tempo 2
- soothing · 2 ✖
- acoustic guitar 1
- ambient 1
- ambient nature sounds 1
- amplified xylophone 1
- angelic 1
- atmospheric 1
- breeze 1
- calming 1
- celestial 1
- chimes 1
- cymbals 1
- digital drum 1
- dreamy 1
- dulcet 1
- elctronic music 1
- enchanting 1
- ethereal 1
- female vocalist 1
- gentle wind 1
- harp 1
- high notes 1
- instrumental 1
- lullaby 1
- meditative 1
- mellifluous 1
- melodious 1
- mood 1
- mystical 1
- no lyrics 1
- pacifying 1
- pleasant 1
- punchy beat 1
- seagulls 1
- soft 1
- soft bass 1
- soft piano harmony 1
- sound of water 1
- sound of waves 1
- steady drumming 1
- tambourine beats 1
- vocalisation 1
musiccaps_names (array) 4 ✖
- Music 2
- Lullaby 1
- New-age music 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Music Maker 2008 Chillout & Ambient 2 Songs | This song is an instrumental. The tempo is medium with a melodious keyboard harmony, rhythmic guitar accompaniment, punchy drumming, subtle bass line, synth arrangement and tambourine beats. The music is soft, mellow, ambient, pleasant, uplifting, and mellifluous. | 2008-03-10T18:25:25Z | Jonas Bayerlein | magix music maker 2008 | ["Music", "Tender music"] | ["instrumental", "medium tempo", "steady drumming", "acoustic guitar", "keyboard harmony", "soft bass", "digital drum", "cymbals", "ambient", "elctronic music", "tambourine beats", "melodious", "soft", "calming", "soothing", "mood", "atmospheric", "ethereal", "enigmatic", "punchy beat"] | 7 | P240GHf9Eq4 | 2494 | |
VITAS MV - 搖籃曲 / Lullaby (歌迷制作) by Dieforsing | A female vocalist sings this dulcet melody. The tempo is medium with soft piano accompaniment, keyboard harmony, chimes, harp, and xylophone sounds , ambient sounds of nature like the sound of sea gulls, waves, water gently hitting the rocks, breeze along with the mellifluous vocalisation. The song is soothing, calming, meditative, peaceful, mellifluous, celestial, mystical, dreamy and dreamy. This song is a Lullaby. | 2010-06-07T14:12:52Z | Vitas HongKong | 歌曲:Колыбельная 來源:百度Vitas吧 songs by Dieforsing 扣子_China http://blog.sina.com.cn/yaojee http://www.vitas.com.cn http://www.vitas.com.ru | ["New-age music", "Music", "Lullaby"] | ["female vocalist", "medium tempo", "vocalisation", "no lyrics", "breeze", "gentle wind", "dulcet", "meditative", "pleasant", "chimes", "mellifluous", "celestial", "enchanting", "enigmatic", "mystical", "angelic", "sound of waves", "seagulls", "sound of water", "ambient nature sounds", "harp", "amplified xylophone", "soft piano harmony", "high notes", "dreamy", "lullaby", "soothing", "pacifying", "keyboard harmony"] | 7 | Rqv5fu1PCXA | 2727 |
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;