musiccaps_details (view)
3 rows where musiccaps_aspects contains "emotional", musiccaps_author = 9 and musiccaps_names contains "Christian music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 28 ✖
- emotional · 3 ✖
- bass guitar 2
- melodic singing 2
- acoustic drums 1
- acoustic guitar 1
- dreamy 1
- easygoing 1
- electric guitar 1
- electronic drums 1
- female vocal 1
- female vocals 1
- harmonic singing 1
- heart-touching 1
- intuitive folk 1
- keyboard 1
- male vocal 1
- male vocals 1
- mellow 1
- neo-folk 1
- piano 1
- pop music 1
- r&b 1
- remix 1
- simple tune 1
- slow tempo 1
- soft rock 1
- soul 1
- strings 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Be Strong ..xX | This is an R&B/soul music piece. There is a whole mix of male and female vocals singing melodically. The tune is being performed by the keyboard while the electric guitar and the bass guitar are playing in the background. There is a slow tempo electronic drum beat in the rhythmic background. The atmosphere is emotional. This piece could be used in the soundtrack of a romance movie, especially during the scenes of resolution. | 2006-10-28T13:51:06Z | xxnicholsonxx | a video made by me for heartbroken girls | ["Christian music", "Music"] | ["r&b", "soul", "remix", "male vocals", "female vocals", "melodic singing", "keyboard", "electric guitar", "bass guitar", "electronic drums", "emotional", "dreamy", "slow tempo"] | 9 | MFxMPOAbUPA | 2250 | |
jealous guy - john lennon | This is a pop/soft rock music piece. There is a male vocalist singing melodically. The main melody is being performed by the piano with the strings' sound holding notes in the background. A solid bass line can be heard. A slow tempo acoustic drum beat is keeping the rhythm. The atmosphere is easygoing. This piece could be used in the soundtrack of a romantic comedy, especially during the scenes where the male protagonist is feeling regret for his actions. | 2008-09-30T05:47:48Z | mexicooRocks | Jealous Guy" is a song written and performed by John Lennon which first appeared on his 1971 album Imagine. It is one of the most commonly covered Lennon songs, with at least ninety-two recorded cover versions by musicians like Donny Hathaway, the Black Crowes, Jeff Tweedy, Peter Criss (of KISS), and Deftones. The most notable of the non-Lennon recordings were by Roxy Music and the Faces. The Roxy Music version was issued as a tribute single in 1981. Elliott Smith's simple acoustic rendering was a frequent part of his live performances, such as his 1998 Washington DC Black Cat show. Lou Reed of the Velvet Underground gave an emotional performance of "Jealous Guy" at the October 2001 Radio City Music Hall New York City show, Come Together: A Night for John Lennon's Words and Music - a tribute to Lennon and the victims of the September 11 attacks. Youssou N'Dour covered the song for Amnesty International's 2007 CD benefit release, Instant Karma: The Amnesty International Campaign to Save Darfur. lyrics: I was dreaming of the past. And my heart was beating fast, I began to lose control, I began to lose control, I didn't mean to hurt you, I'm sorry that I mad you cry, I didn't want to hurt you, I'm just a jealous guy, I was feeling insecure, You night not love me any more, I was shivering inside, I was shivering inside, I was trying to catch your eyes, Thought that you were trying to hide, I was swallowing my pain, I was swallowing my pain. | ["Christian music"] | ["pop music", "soft rock", "male vocal", "melodic singing", "strings", "piano", "bass guitar", "acoustic drums", "easygoing", "emotional"] | 9 | b0dVykd2i6g | 3595 | |
Diane Cluck - Easy to be Around | This is an intuitive folk/neo-folk music piece. There is a female vocalist singing over multiple tracks, one being the minor harmonies of the other. There is an acoustic guitar playing a gentle, simple tune. The atmosphere of this piece is heart-touching. The music could fit very well in the soundtrack of a drama movie or a TV show. | 2011-03-16T21:57:56Z | seexjayx | ["Christian music", "Music"] | ["intuitive folk", "neo-folk", "female vocal", "harmonic singing", "acoustic guitar", "simple tune", "emotional", "heart-touching", "mellow"] | 9 | q7s7C4oNlFo | 4754 |
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;