musiccaps_details (view)
4 rows where search matches "guitar", musiccaps_aspects contains "lonely" and musiccaps_aspects contains "sad"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 63 ✖
- lonely · 4 ✖
- sad · 4 ✖
- poignant 3
- acoustic guitar 2
- breakup 2
- emotional 2
- heart break 2
- male singer 2
- melancholic 2
- passionate 2
- sentimental 2
- slow tempo 2
- alternative dance 1
- alternative rock 1
- atmospheric 1
- bitter 1
- blues 1
- blues-rock 1
- blues-rockvigorous electric guitar 1
- breakup song 1
- classic rock 1
- depressed 1
- dream pop 1
- droning keyboard harmony 1
- engaging 1
- enthusiastic 1
- female singing 1
- funk rock 1
- funky bass lines 1
- groovy bass line 1
- groovy electric guitar lead 1
- home recording 1
- home video 1
- hurt 1
- husky voice 1
- incessant 1
- infectious drumming 1
- intense drumming 1
- keyboard accompaniment 1
- lonely sad 1
- longing 1
- love song 1
- male vocalist 1
- medium fast tempo 1
- medium tempo 1
- mellow 1
- movie soundtrack 1
- muffled guitar quality 1
- pop 1
- pop rock 1
- quirky music 1
- regretful 1
- repetitive 1
- rhythmic 1
- rock 1
- room acoustics 1
- soft 1
- sombre 1
- synthesiser arrangement 1
- vigorous electric guitar riff 1
- vocal backup 1
- wistful 1
- youthful 1
musiccaps_names (array) 8 ✖
- Music 4
- Acoustic guitar 1
- Blues 1
- Funk 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
CAKE - Never There (Official HD Video) | A male vocalist sings this quirky Rock melody. The tempo is medium fast with groovy electric guitar harmony, funky, intense bass lines, infectious drumming, keyboard accompaniment and vocal backup. The song is catchy, rhythmic, emotional, incessant, sentimental, melancholic, lonely, romantic , unconventional, quirky and upbeat. This song is classic rock. | 2011-03-18T00:20:30Z | CakeVEVO | ”Never There” by CAKE in HD Listen to CAKE: https://Cake.lnk.to/listenYD Watch more videos by CAKE: https://Cake.lnk.to/listenYD/youtube Subscribe to the official CAKE YouTube channel: https://Cake.lnk.to/subscribeYD Follow CAKE Facebook: https://Cake.lnk.to/followFI Instagram: https://Cake.lnk.to/followII Twitter: https://Cake.lnk.to/followTI Website: https://Cake.lnk.to/followWI Spotify: https://Cake.lnk.to/followSI YouTube: https://Cake.lnk.to/subscribeYD Ask your voice device to play CAKE! Lyrics: Never there You're never there You're never ever, ever, ever there Hey! #CAKE #NeverThere #OfficialHDVideo #HD #Remastered #ProlongingTheMagic #Rock | ["Funk", "Music"] | ["male vocalist", "medium fast tempo", "vocal backup", "funky bass lines", "groovy electric guitar lead", "keyboard accompaniment", "infectious drumming", "passionate", "emotional", "sentimental", "love song", "alternative rock", "funk rock", "alternative dance", "rhythmic", "melancholic", "sad", "lonely", "repetitive", "incessant", "breakup", "heart break", "classic rock", "quirky music", "engaging", "youthful", "enthusiastic"] | 7 | FRZzUh9hcTo | 1642 | |
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 | |
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;