musiccaps_details (view)
3 rows where musiccaps_aspects contains "poignant", musiccaps_aspects contains "sad", musiccaps_aspects contains "slow tempo" and musiccaps_aspects contains "wistful"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Shawshank Redemption - Brook was here | This music is instrumental. The tempo is slow with a melancholic piano melody with violin harmony and keyboard accompaniment. The music is sad, mellow, grim, sombre, wistful, poignant, pensive, melancholic and reflective. This music is a soundtrack for a movie. | 2011-04-29T20:28:12Z | Opeth Opet | Enjoy | ["New-age music"] | ["instrumental", "melancholic piano", "slow tempo", "grim", "sombre", "movie soundtrack", "wistful", "sad", "pensive", "reflective", "depressed", "lost", "defeated", "violin harmony", "keyboard accompaniment", "poignant"] | 7 | OkcBJawiIHA | 2466 | |
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 | |
harry & eggsy | all i want | A male vocalist sings this sad melody. The tempo is slow with an acoustic guitar accompaniment and a droning keyboard harmony. The song is soft ,mellow, sad, emotional, sentimental, regretful , lonely and poignant. This song is an Alternative Rock/Indie. | 2015-08-20T05:52:36Z | stoleyourmateria | HARTWIN WEEK: Day 5: angst ----------------------------------------------------------------- (PLEASE WATCH IN HD) this is kind of a companion piece to my hartwin "love love love" fanvid. i had a lot of fun editing this. hope you enjoy the angst! :D ----------------------------------------------------------------- • fandom: kingsman • pairing: harry hart & eggsy unwin • song: "all i want" by kodaline ---------------------------------------------------------------- Copyright Disclaimer Under Section 107 of the Copyright Act 1976, allowance is made for "fair use" for purposes such as criticism, comment, news reporting, teaching, scholarship, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing. Non-profit, educational or personal use tips the balance in favor of fair use. | ["Music", "Theremin"] | ["male singer", "slow tempo", "acoustic guitar", "atmospheric", "poignant", "dream pop", "lonely", "pop rock", "longing", "sombre", "breakup song", "passionate", "sad", "wistful", "emotional", "sentimental", "regretful", "wistful", "movie soundtrack", "droning keyboard harmony"] | 7 | gTX4SG70cEY | 4032 |
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;