musiccaps_details (view)
4 rows where musiccaps_aspects contains "melancholic", musiccaps_aspects contains "poignant" and musiccaps_aspects contains "sad"
This data as json, CSV (advanced)
musiccaps_aspects (array) 51 ✖
- melancholic · 4 ✖
- poignant · 4 ✖
- sad · 4 ✖
- slow tempo 4
- emotional 3
- mellow 2
- soft 2
- acoustic guitar 1
- alap 1
- ambient room noises 1
- chanting 1
- chimes 1
- chinese stringed instrument 1
- classical music 1
- classical music influences 1
- contemplative 1
- female singing 1
- female vocalist 1
- folk music 1
- foreign language 1
- harp accompaniment 1
- heart break 1
- heartfelt 1
- home recording 1
- home video 1
- husky voice 1
- indian bowed string instrument 1
- instrumental music 1
- live performance 1
- lonely 1
- lonely sad 1
- lucid vocals 1
- meditative 1
- muffled guitar quality 1
- no percussion instruments 1
- passionate 1
- pensive 1
- piano accompaniment 1
- poor audio quality 1
- pop 1
- quiet audience 1
- raga 1
- relaxing playlist 1
- room acoustics 1
- sarangi 1
- sentimental 1
- sound searching 1
- strings plucked 1
- swar 1
- vocalisation 1
- wistful 1
musiccaps_names (array) 11 ✖
- Music 4
- Acoustic guitar 1
- Carnatic music 1
- Folk music 1
- Mantra 1
- Sad music 1
- Speech 1
- Steel guitar, slide guitar 1
- Strum 1
- Theremin 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
もののけ姫/テルミン×ライアー | The song is an instrumental. The song is slow tempo with a Chinese string instrument playing a lilting melody along with tones of the string instrument being plucked like a harp. The song is emotional and melancholic. The song is a live performance with ambient room noise and generally poor audio quality. | 2011-05-23T15:14:22Z | leierogura | テルミンとアルトライアーのコラボ。 | ["Music", "Theremin"] | ["instrumental music", "chinese stringed instrument", "relaxing playlist", "no percussion instruments", "sound searching", "heartfelt", "folk music", "classical music influences", "poor audio quality", "ambient room noises", "slow tempo", "emotional", "passionate", "sad", "melancholic", "poignant", "strings plucked", "live performance", "quiet audience", "harp accompaniment"] | 1 | 3kSQNjfJnN8 | 495 | |
Kom Leuk Torosab Ke Pel Nov Kbe Oun RHM CD Vol 471 | A female vocalist sings this soft song in a foreign language. The tempo is slow with a soft piano accompaniment and sound of chimes. The vocals are mellow, passionate,emotional, sentimental, nostalgic, melancholic and reflective. This song is a sad classic Pop. | 2013-01-16T04:20:07Z | BayKdang | For more Video go to my Channel Youtube : http://www.youtube.com/subscription_center?add_user=BayKdang | ["Music", "Speech", "Sad music"] | ["female vocalist", "slow tempo", "foreign language", "emotional", "sentimental", "poignant", "heart break", "melancholic", "piano accompaniment", "soft", "mellow", "melancholic", "sad", "chimes"] | 7 | 91AmOKytRUM | 970 | |
Light of Asia - Teaser original music by Divana Ensemble (Film concert) | A male singer sings this pensive melody. The tempo is slow with a Sarangi accompaniment . The instrumentation is minimal with vocal emphasis. The song uses classical Ragas and alaps to form a melody. The song is sad, pensive, regretful, pensive, melancholic, emotional, contemplative, wistful and meditative. This song is an Indian Classical. | 2013-07-17T06:13:03Z | ZamanProduction | a film directed by Franz Osten and Himansu Rai (1925) Film concert produced by Zaman Production Special thanks to British Film Institute, Arte TV, and Théâtre National de Toulouse | ["Carnatic music", "Mantra", "Folk music", "Music"] | ["classical music", "slow tempo", "alap", "raga", "sarangi", "meditative", "contemplative", "wistful", "lucid vocals", "melancholic", "pensive", "emotional", "indian bowed string instrument", "swar", "vocalisation", "chanting", "sad", "poignant"] | 7 | QfM5-WqvquQ | 2635 | |
bathtub - waxahatchee (cover) | A female vocalist sings this soft melody. The tempo is slow with acoustic guitar accompaniment. The guitar sound is muffled. The song is sad,poignant, melancholic, sentimental,emotional and lonely. This song is Pop. | 2013-10-01T02:06:18Z | gabbywade | idk hey blog: http://2003rapvideo.tumblr.com/ instagram: veganclit_ | ["Acoustic guitar", "Music", "Steel guitar, slide guitar", "Strum", "Vocal music"] | ["home video", "home recording", "female singing", "lonely sad", "room acoustics", "muffled guitar quality", "husky voice", "lonely", "sad", "poignant", "acoustic guitar", "slow tempo", "soft", "mellow", "poignant", "melancholic", "pop"] | 7 | mq_b6QKVsuc | 4495 |
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;