musiccaps_details (view)
9 rows where musiccaps_aspects contains "poignant", musiccaps_aspects contains "sad" and musiccaps_author = 7
This data as json, CSV (advanced)
musiccaps_aspects (array) 88 ✖
- poignant · 9 ✖
- sad · 9 ✖
- slow tempo 8
- emotional 6
- pensive 5
- mellow 4
- sentimental 4
- soft 4
- instrumental 3
- lonely 3
- melancholic 3
- movie soundtrack 3
- sombre 3
- wistful 3
- acoustic guitar 2
- blues 2
- depressed 2
- heart break 2
- male singer 2
- meditative 2
- melancholy 2
- piano accompaniment 2
- reflective 2
- alap 1
- ambient 1
- ambient piano 1
- applied guitar 1
- atmospheric 1
- bitter 1
- blues-rock 1
- blues-rockvigorous electric guitar 1
- breakup 1
- breakup song 1
- cello 1
- chanting 1
- chimes 1
- classical music 1
- clear 1
- contemplative 1
- defeated 1
- delicate 1
- dream pop 1
- droning keyboard harmony 1
- drum machine 1
- electric guitar melody 1
- female singing 1
- female vocalist 1
- foreign language 1
- grim 1
- groovy bass line 1
- home recording 1
- home video 1
- hurt 1
- husky voice 1
- indian bowed string instrument 1
- intense drumming 1
- keyboard accompaniment 1
- lonely sad 1
- longing 1
- lost 1
- love song 1
- lucid vocals 1
- male vocalist 1
- medium tempo 1
- melancholic piano 1
- minimalist 1
- movie theme music 1
- muffled guitar quality 1
- nostalgic 1
- passionate 1
- ponderous 1
- pop 1
- pop rock 1
- r&b 1
- raga 1
- regretful 1
- rock 1
- room acoustics 1
- sarangi 1
- smooth jazz 1
- soul 1
- string instrument 1
- swar 1
- synthesiser arrangement 1
- vigorous electric guitar riff 1
- violin 1
- violin harmony 1
- vocalisation 1
musiccaps_names (array) 23 ✖
- Music 7
- Acoustic guitar 1
- Blues 1
- Bowed string instrument 1
- Carnatic music 1
- Cello 1
- Double bass 1
- Electronic tuner 1
- Folk music 1
- Guitar 1
- Inside, small room 1
- Mantra 1
- Musical instrument 1
- New-age music 1
- Plucked string instrument 1
- Sad music 1
- Speech 1
- Steel guitar, slide guitar 1
- Strum 1
- Tender music 1
- Theremin 1
- Violin, fiddle 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 |
---|---|---|---|---|---|---|---|---|---|---|
Joe Bonamassa - "Blues of Desperation" - Official Music Video | A male vocalist sings this emphatic rock. The tempo is medium with vigorous electric guitar, synthesiser arrangement, groovy bass line and intense drumming. The vocals are soft ,sad, lonely, poignant, mellow, and melodic in contrast to the intense instrumentation. This song is Blues-Rock. | 2016-08-01T14:41:20Z | JoeBonamassaTV | ► STREAM JOE NOW: https://jbonamassa.com/streaming/ ► FREE ALBUM DOWNLOAD - http://goo.gl/9oI018 ● Official Tickets ● http://jbonamassa.com/tour-dates/ ● Official Social Links ● https://www.facebook.com/JoeBonamassa https://twitter.com/jbonamassa https://instagram.com/joebonamassa/ https://www.pinterest.com/jbonamassa/ ● Official Merchandise ● http://shop.jbonamassa.com/ | ["Blues", "Music"] | ["male singer", "medium tempo", "sad", "depressed", "heart break", "blues-rock", "vigorous electric guitar riff", "breakup", "hurt", "poignant", "bitter", "lonely", "blues-rockvigorous electric guitar", "synthesiser arrangement", "blues", "rock", "groovy bass line", "intense drumming"] | 7 | 6JJMlY3Go9s | 743 | |
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 | |
ne-yo why does she stay | A male vocalist sings this emotional R&B song. The tempo is slow with a melancholic piano accompaniment with drum machine arrangement. The song is an emotional , soulful, pensive, sentimental,melancholic, romantic love song. This song is a Soul/R&B. | 2008-09-25T21:35:05Z | X-tazi | ne-yo why does she stay from the new album-Year Of The Gentleman | ["Music", "Tender music"] | ["male vocalist", "slow tempo", "soft", "mellow", "minimalist", "smooth jazz", "blues", "sad", "poignant", "ambient piano", "drum machine", "soul", "r&b", "love song", "pensive", "melancholy", "nostalgic", "emotional", "sentimental"] | 7 | C-1i2GlbiIY | 1313 | |
Beaux Arts Trio plays Dvorak "Dumky" Trio, ii | This music is instrumental. The tempo is slow with a melancholic cello harmony, and a piano and violin accompaniment. The music is soft, pensive, melancholic, sentimental, sad, reflective, meditative and delicate. This music is a Violin Instrumental. | 2008-05-09T02:43:46Z | Scott Meek | Live from Herbst Theatre, San Francisco April 20, 2008 Menahem Pressler, piano Daniel Hope, violin Antonio Meneses, cello | ["Cello", "Double bass", "Violin, fiddle", "Bowed string instrument"] | ["instrumental", "slow tempo", "cello", "violin", "sad", "reflective", "delicate", "poignant", "meditative", "reflective", "piano accompaniment", "soft", "mellow", "ambient", "pensive", "ponderous", "sentimental", "emotional"] | 7 | EkmHGd0U8yE | 1585 | |
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 | |
RAMBO: FIRST BLOOD Theme ( 1 of 2 ) Guitar Lesson | This music is instrumental. The tempo is slow with an electric guitar harmony. It is mellow, sad, sentimental,sombre, poignant and emotional. This music is a movie theme melody. | 2010-01-30T17:12:46Z | Guitar Lessons BobbyCrispy | TABS FOR THIS LESSON AVAILABLE ON MY NEW GUITAR LESSON WEBSITE: https://guitarlessonvideoswithtabs.yolasite.com/RAMBO---FIRST-BLOOD.php How to play the theme from the movie Rambo: First Blood. Guitar lesson with step by step method with easy to follow tabs in the video. TABS for this lesson available on my guitar lesson website: http://bobsguitarlessons.yolasite.com/ Part 2 of 2 http://youtu.be/qBD6b3oouaw E-------------9----12------12--11--------------------- B----7--9------------------------------14---9----12--- G---------------------------------------------------------- D---------------------------------------------------------- A---------------------------------------------------------- E---------------------------------------------------------- E------------------------------------------------------------- B----14--12----12----7---9----10-----10--12----7--- G------------------------------------------------------------- D------------------------------------------------------------- A------------------------------------------------------------- E------------------------------------------------------------- E-------------9----12------12--11--------------------- B----7--9------------------------------14---9----12--- G---------------------------------------------------------- D---------------------------------------------------------- A---------------------------------------------------------- E---------------------------------------------------------- E---------------------------------------------------------------- B----9--12---12----7----7----9---10------5--7-----9---- G---------------------------------------------------------------- D---------------------------------------------------------------- A---------------------------------------------------------------- E---------------------------------------------------------------- E--------9---9--------------14--12---9--10---9------------------------- B----9-------------12---------------------------------12----7----5--7--- G---------------------------------… | ["Guitar", "Music", "Musical instrument", "Electronic tuner", "Plucked string instrument", "Inside, small room"] | ["instrumental", "slow tempo", "electric guitar melody", "sombre", "emotional", "pensive", "movie soundtrack", "movie theme music", "clear", "string instrument", "applied guitar", "sad", "melancholy", "poignant", "pensive"] | 7 | jjNxc9Zf9s8 | 4277 | |
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;