musiccaps_details (view)
4 rows where musiccaps_aspects contains "emotional" and musiccaps_names = "["Music", "Independent music"]"
This data as json, CSV (advanced)
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Chester See - That girl [lyrics] | The low quality recording features a passionate male vocal, alongside harmonizing female vocals, singing over simple bass guitar, punchy snare, soft kick hits, acoustic rhythm guitar, groovy piano melody and shimmering hi-hats. It sounds emotional. | 2010-03-10T17:37:51Z | jerrestorms | Oh tonight I'm feeling fine I'm alone just wasting time No friday movie nights, or romantic candlelight I'm just having conversations With the thoughts in my head All I hear are angels crying Oh won't they just sing instead It would be wrong for me to say Chorus I don't need that girl by my side I don't need that girl in my life I don't want to talk it out Or hold her when she cries I don't want to say she's my kind I don't want to say that she's mine I don't want to tell her that I love her more than life More than life... I love her more than life Honestly, this won't do How is she doing? I tell myself that I'm feeling swell But I know I'm such a fool I can take it as a new beginning But you know I don't feel that way Who will take all this pain away? I know it's wrong for me to say Chorus I don't need that girl by my side I don't need that girl in my life I don't want to talk it out Or hold her when she cries I don't want to say she's my kind I don't want to say that she's mine I don't want to tell her that I love her more than life More than life... I love her more than life... Talk about a sin Was the day I walked Into the other side I would run back in I wouldn't waste no time I know it's wrong for me to say Chorus I don't need that girl by my side I don't need that girl in my life I don't want to talk it out Or hold her when she cries I don't want to say she's my kind I don't want to say that she's mine I don't want to tell her that I love her more than life More than life... I love her more than life | ["Music", "Independent music"] | ["low quality", "groovy piano melody", "acoustic rhythm guitar", "passionate male vocal", "simple bass guitar", "punchy snare", "soft kick hits", "shimmering hi hats", "emotional", "harmonizing female vocal"] | 4 | J8lCxfaiHeo | 1972 | |
Babyshambles - Gang of Gin | The low quality recording features an alternative/indie song that consists of a passionate male vocal singing over groovy bass guitar, wide electric guitar melodies, shimmering cymbals and "4 on the floor" kick pattern. It sounds mellow, easygoing, emotional and passionate. | 2009-01-25T10:38:31Z | ninsajala | Babyshambles Gang of Gin Lyrics: I get around to singing about That gang of gin I'm in Then you'll know most certainly The kind of game I'm in You sound around to swinging about The gang of gin I'm rolling in, oh Then you'll know The kind of state I'm in Who will buy my beautiful roses? Who will buy my beautiful songs? Who will buy my beautiful roses? Who will buy my beautiful songs? Oh in a nutshell Yeah in a nutshell, oh In a nutshell In a nutshell I get around to singing about That gang of gin I'm in Then you'll know The kind of game I'm in She was getting pally with a scally in the alley Giving head for gear She calls a spade a spade Got slit from ear to ear Who will buy my beautiful roses? Who will buy my beautiful songs? Who will buy my beautiful roses? Who will buy my beautiful songs? Well I showed no decorum Span my heart out on the forum Looked like a snapshot Of the most tragic day I'll tell you my story The treachery it bores me Carl and McGee both promised me It would not happen this way Carl is kept sedated The frontman elevated And McGee doing all he can to ruin my band And keep me out the way In this industry of fools Musclemen and ghouls If you're not a puppet or a muppet Then you might as well call it a day-ayay The truth here gets distorted The wall scrapings get snorted I'm welcome back if I give up crack But you gave me my first pipe anyway Can't show no decorum Posts left on the forum Was like a snapshot Of the most tragic day | ["Music", "Independent music"] | ["low quality", "alternative/indie", "passionate male vocal", "wide electric guitars melodies", "groovy bass guitar", "shimmering cymbals", "\"4 on the floor\" kick pattern", "mellow", "easygoing", "emotional", "passionate"] | 4 | XI-tRuDZ6HA | 3172 | |
Missing from YouTube | A male singer sings this rock melody. The tempo is medium with a groovy bass line, guitar rhythm , keyboard accompaniment, and heavy rock drumming with cymbals crashing. The song is energetic and passionate. The song is a retro pop-rock song. | ["Music", "Independent music"] | ["male singer", "classic rock band", "cymbals crashing", "rock band", "emotional", "steady drumming rhythm", "medium tempo", "guitar rhythm", "keyboard accompaniment", "romantic", "emotional", "love song", "energetic", "youthful", "passionate", "retro pop hits", "percussive bass line"] | 1 | 4437 | |||||
ones band-kilau ku(local indie band malaysia) | A male vocalist sings this dulcet, soulful song in a foreign language. The tempo is medium with bass guitar lead and acoustic guitar accompaniment. The song is minimalist instruments with vocal emphasis. It is a soft, emotional, sentimental, mellifluous, soulful, soothing, calming, pleasant , warm and tender Pop. | 2010-06-15T15:54:19Z | faqul23 | layan sja... | ["Music", "Independent music"] | ["male vocalist", "medium tempo", "foreign language", "bass guitar accompaniment", "rhythmic acoustic guitar", "home recording", "static", "melodic", "dulcet", "soulful", "emotional", "sentimental", "minimalist", "soothing", "peaceful", "calming"] | 7 | uZesGREO0eI | 5125 |
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;