musiccaps_details (view)
4 rows where musiccaps_aspects contains "acoustic guitar" and musiccaps_aspects contains "poignant" sorted by musiccaps_aspects
This data as json, CSV (advanced)
musiccaps_aspects (array) 50 ✖
- acoustic guitar · 4 ✖
- poignant · 4 ✖
- slow tempo 4
- emotional 3
- mellow 3
- sentimental 3
- soft 3
- lonely 2
- male singer 2
- sad 2
- atmospheric 1
- auto harp 1
- boomy bass lines 1
- breakup song 1
- charming 1
- colourful 1
- dream pop 1
- dreamy 1
- droning keyboard harmony 1
- dulcet 1
- female singing 1
- female vocalisation 1
- home recording 1
- home video 1
- husky voice 1
- instrumental 1
- keyboard accompaniment 1
- keyboard harmony 1
- lonely sad 1
- longing 1
- melancholic 1
- melodic 1
- movie soundtrack 1
- muffled guitar quality 1
- nostalgia 1
- passionate 1
- pop 1
- pop rock 1
- regretful 1
- resonator 1
- romantic 1
- room acoustics 1
- shakers 1
- sombre 1
- steady drumming 1
- tambourine 1
- violin harmony 1
- vocalisation 1
- warm 1
- wistful 1
musiccaps_names (array) 8 ✖
- Music 4
- Acoustic guitar 1
- Blues 1
- Sad music 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
MAYA AND SIR CHIEF'S LOVE STORY PART 2 August 2012 Episodes | This music is instrumental. The tempo is slow with an emphatic violin harmony, keyboard accompaniment and rhythmic acoustic guitar with female vocalisation. The song is romantic, sentimental, emotional, nostalgic, poignant, charming, dreamy and soft. | 2012-12-16T04:10:01Z | yean Sagala | ["Music", "Sad music"] | ["instrumental", "slow tempo", "vocalisation", "female vocalisation", "charming", "dreamy", "poignant", "colourful", "warm", "keyboard accompaniment", "violin harmony", "acoustic guitar", "mellow", "soft", "romantic", "emotional", "sentimental"] | 7 | WNmAlKrAPjQ | 3089 | ||
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 | |
Bob Seger - Like a Rock ( Music Video ) | A male vocalist sings this soft country song. The tempo is slow with a gentle acoustic guitar and resonator rhythm, subtle keyboard, soft drumming, tambourine beats and soft auto harp strains. The vocals are mellow, gentle, sentimental, emotional, poignant, melancholic and nostalgic. This song is a Classic Country song. | 2008-06-12T21:36:18Z | jonny1214 | from Like a Rock 1986 & Greatest Hits 1994 ( Words and music by bob seger ) Stood there boldly Sweating in the sun Felt like a million Felt like number one The height of summer I'd never felt that strong Like a rock I was eighteen Did'nt have a care Working for peanuts Not a dime to spare But I was lean and Solid everywhere Like a rock My hands were steady My eyes were clear and bright My walk had purpose My steps were quick and light And I held firmly To what I felt was right Like a rock Like a rock, I was strong as I could be Like a rock, nothin ever got to me Like a rock, I was something to see Like a rock And I stood arrow straight Unencumbered by the weight Of all these hustlers and their schemes I stood proud, I stood tall High above it all I still believed in my dreams Twenty years now Whered they go? Twenty years I dont know Sit and I wonder sometimes Where theyve gone And sometimes late at night When Im bathed in the firelight The moon comes callin a ghostly white And I recall Recall Like a rock. standin arrow straight Like a rock, chargin from the gate Like a rock, carryin the weight Like a rock Lihe a rock, the sun upon my skin Like a rock, hard against the wind Like a rock, I see myself again Like a rock | ["Blues", "Music"] | ["male singer", "slow tempo", "mellow", "soft", "dulcet", "melodic", "acoustic guitar", "auto harp", "resonator", "tambourine", "shakers", "keyboard harmony", "sentimental", "emotional", "nostalgia", "poignant", "boomy bass lines", "steady drumming", "sentimental"] | 7 | keIvA2wSPZc | 4339 |
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;