musiccaps_details (view)
4 rows where musiccaps_aspects contains "calming" and musiccaps_aspects contains "melancholic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- calming · 4 ✖
- melancholic · 4 ✖
- instrumental 3
- mellow 3
- pensive 3
- slow tempo 3
- soothing 3
- enigmatic 2
- ethereal 2
- meditative 2
- peaceful 2
- acoustic guitar 1
- ambient nature sounds 1
- amplified organ 1
- amplified violins 1
- celestial 1
- chimes 1
- chinese instrumental 1
- chinese instruments 1
- downtempo 1
- dreamy 1
- falling rain 1
- female vocal 1
- guzheng harmony 1
- harp 1
- healing 1
- male vocal 1
- melodic piano 1
- pipa accompaniment 1
- poignant 1
- reflective 1
- shaker song 1
- string instruments 1
- viloin harmony 1
- violin harmony 1
- water flowing 1
- wind instrument 1
musiccaps_names (array) 7 ✖
- Music 4
- Background music 2
- A capella 1
- Ambient music 1
- Sad music 1
- Tender music 1
- Theme music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Dragon Music - Sad Moments | This music is a soothing instrumental. The tempo is slow with a beautiful violin symphony, romantic piano accompaniment, harp melody, a wind instrument and shakers. The music is mellifluous, gentle,pensive, nostalgic, poignant, melancholic, romantic, enthralling, enigmatic, dreamy, calming and ethereal. | 2011-06-01T12:35:57Z | DarkLuna x | ["Background music", "Theme music", "Music", "Sad music"] | ["instrumental", "slow tempo", "violin harmony", "melodic piano", "melancholic", "shaker song", "pensive", "poignant", "harp", "wind instrument", "soothing", "mellow", "calming", "enigmatic", "ethereal", "dreamy", "peaceful", "pensive"] | 7 | 3OUNEL8XaR0 | 461 | ||
The Lone Bellow "Slip Slidin' Away" | This is an acoustic ballad that is sung in a melancholic manner by two male vocalists and a female vocalist. There is an acoustic guitar in the background playing a simple tune. The tempo and the general atmosphere of the song is relatively calm. The music could be played at a coffee shop in the background. | 2015-04-27T14:02:56Z | Ron Paris | The Lone Bellow doing a fantastic cover of Paul Simon's "Slip Slidin' Away". Recorded live at Virginia Arts Recording Studio in Charlottesville VA. A special Corner Lounge for 106.1 WCNR. Video by Ron Paris. | ["Music", "A capella"] | ["acoustic guitar", "male vocal", "female vocal", "melancholic", "calming", "downtempo", "mellow"] | 9 | 8r1y_Bz4VfQ | 955 | |
"Infinite Lie" - (Magix Music Maker 17) - Electronic & Ambient Song - By Paranoid Prophet | This music is instrumental. The tempo is slow with atmospheric keyboard, melodic piano, amplified organ and sound of rain falling and water flowing. The music is peaceful, soothing, meditative, ethereal, pensive,reflective, celestial and calming. | 2010-11-24T17:15:27Z | Paranoid Prophet | Made As Always With Magix Music Maker. Except The Drums Loop Created With Fruity Loops. It's An Ambient Song With Pop Rock Parts. Please Subscribe Comment & Rate :) | ["Background music", "Music", "Ambient music"] | ["instrumental", "slow tempo", "amplified organ", "falling rain", "ambient nature sounds", "water flowing", "amplified violins", "mellow", "melancholic", "peaceful", "soothing", "meditative", "pensive", "reflective", "ethereal", "enigmatic", "celestial", "peaceful", "calming"] | 7 | EyO5vB4eqo0 | 1605 | |
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 |
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;