musiccaps_details (view)
3 rows where musiccaps_aspects contains "breakup song" and musiccaps_aspects contains "sentimental"
This data as json, CSV (advanced)
musiccaps_aspects (array) 54 ✖
- breakup song · 3 ✖
- emotional 3
- sentimental · 3 ✖
- lonely 2
- love song 2
- male singer 2
- acoustic guitar 1
- acoustic pop 1
- atmospheric 1
- auto harp 1
- breakup 1
- country pop 1
- country song 1
- courtship song 1
- desperate for you 1
- despondent 1
- dobro 1
- dream pop 1
- droning keyboard harmony 1
- female singer 1
- folk song 1
- harmonica 1
- keyboard accompaniment 1
- loneliness 1
- longing 1
- madly in love 1
- mameluke in love 1
- medium tempo 1
- mellow 1
- melodious tune 1
- modern love 1
- modern pop hits 1
- movie soundtrack 1
- music covers 1
- original song 1
- passionate 1
- piano accompaniment 1
- poignant 1
- pop rock 1
- regional music 1
- regretful 1
- resonator guitar 1
- sad 1
- sad song 1
- slow tempo 1
- soft 1
- soloist 1
- sombre 1
- steady bass lines 1
- steady drumming 1
- strong bass line 1
- wistful 1
- youtube music artist 1
- youtube music videos 1
musiccaps_names (array) 6 ✖
- Music 2
- Christian music 1
- Electric piano 1
- Keyboard (musical) 1
- Piano 1
- Theremin 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Three Days Grace/ Breaking Benjamin/ Paramore - Mashup Cover by Kevin Staudt | A male singer sings this emotional melody. The song is medium tempo with a piano accompaniment and a strong bass drum kick . The song is emotional and romantic. The song is a home music video . | 2014-06-28T20:20:04Z | Kevin Staudt | Hey everyone, since I haven't uploaded much new stuff lately I wanted to put a few requests (Three Days Grace - Take Me Under / Breaking Benjamin - Dance With The Devil / Paramore - Decode) together in one cover. http//www.facebook.com/kevinstaudtmusic | ["Electric piano", "Keyboard (musical)", "Piano"] | ["male singer", "piano accompaniment", "soloist", "modern love", "loneliness", "breakup song", "mameluke in love", "music covers", "youtube music videos", "youtube music artist", "modern pop hits", "courtship song", "desperate for you", "madly in love", "original song", "acoustic pop", "emotional", "love song", "sentimental", "strong bass line", "keyboard accompaniment"] | 1 | 1OIfQHKnAcw | 265 | |
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 | |
~Good As I Was To You~ (With Lyrics) | A female singer sings this sad Country song. The tempo is medium with a Harmonica harmony, steady bass line, acoustic guitar, auto harp and dobro accompaniment. The song is soft, mellow, sad, poignant, emotional, sentimental and despondent with a melodious tune. This Song is a classic Country Pop. | 2008-09-22T07:04:10Z | VampiressSilvia | Lorrie Morgan's Good As I Was To You With the lyrics | ["Christian music", "Music"] | ["female singer", "medium tempo", "country song", "despondent", "melodious tune", "country pop", "regional music", "folk song", "love song", "sad song", "breakup song", "breakup", "harmonica", "steady drumming", "steady bass lines", "auto harp", "dobro", "resonator guitar", "mellow", "lonely", "soft", "sentimental", "emotional"] | 7 | tUJ_ZniLjhc | 5038 |
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;