musiccaps_details (view)
2 rows where musiccaps_aspects contains "sombre" and musiccaps_aspects contains "wistful" sorted by youtube_link
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- movie soundtrack 2
- poignant 2
- sad 2
- slow tempo 2
- sombre · 2 ✖
- wistful · 2 ✖
- acoustic guitar 1
- atmospheric 1
- breakup song 1
- defeated 1
- depressed 1
- dream pop 1
- droning keyboard harmony 1
- emotional 1
- grim 1
- instrumental 1
- keyboard accompaniment 1
- lonely 1
- longing 1
- lost 1
- male singer 1
- melancholic piano 1
- passionate 1
- pensive 1
- pop rock 1
- reflective 1
- regretful 1
- sentimental 1
- violin harmony 1
musiccaps_names (array) 3 ✖
- Music 1
- New-age music 1
- Theremin 1
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 | |
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;