musiccaps_details (view)
3 rows where musiccaps_aspects contains "nostalgic" and musiccaps_aspects contains "soft pop"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- nostalgic · 3 ✖
- sentimental 3
- soft pop · 3 ✖
- emotional 2
- keyboard accompaniment 2
- medium tempo 2
- melancholic 2
- rhythmic acoustic guitar 2
- romantic 2
- subtle bass line 2
- asian music 1
- female singer 1
- female vocalist 1
- first love 1
- flute 1
- foreign language 1
- love song 1
- male singer 1
- mellow 1
- mellow electric guitar 1
- melodic 1
- melodic violin harmony 1
- minimal music 1
- pensive 1
- pleasant 1
- pop 1
- pop hits 1
- romantic pop 1
- slow tempo 1
- soft keyboard harmony 1
- soft lilting flute 1
- soothing 1
- soundtrack 1
- steady drumming 1
- subtle bass lines 1
- vocal emphasis 1
- young love 1
musiccaps_names (array) 6 ✖
- Music 3
- /t/dd00004 1
- Sad music 1
- Singing 1
- Soul music 1
- Tender music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
"ANGEL OF BENGAL" - The Religion of Love, music video | A female vocalist sings this soft melody. The song is slow tempo with a mellow electric guitar harmony, soft keyboard accompaniment , a soft lilting flute melody and subtle bass line. There is no use of percussion. The song is soft, mellow, emotional, nostalgic and sentimental . This song is Soft pop. | 2008-07-09T03:19:08Z | Hassan Ali | Devotional music written, performed, and produced by Jaraneh Nova. Dedicated to our Spiritual Master, Mother Rytasha, The Angel of Bengal. A Razzaque Khan Production. http://thereligionoflove.net ,http://www.chela.net/rytasha ,-- love@chela.net | ["Music", "Sad music"] | ["female singer", "slow tempo", "mellow electric guitar", "soft lilting flute", "keyboard accompaniment", "subtle bass lines", "vocal emphasis", "minimal music", "soft pop", "mellow", "soothing", "emotional", "sentimental", "nostalgic", "melancholic"] | 7 | 9aE33JEIGOg | 1028 | |
Kiss - Because I'm A Girl (Chinese Version) | A female vocalist sings this soft love song in a foreign language. The tempo is medium with a mellifluous violin harmony, keyboard accompaniment, subtle bass, steady drumming and rhythmic acoustic guitar. The song is sweet, youthful, simple, romantic, sentimental, melancholic and pensive. This song is Romantic Pop. | 2007-03-17T01:24:14Z | Joel Lee | Comments and Rating Plz.. | ["Music", "Tender music"] | ["female vocalist", "medium tempo", "foreign language", "romantic pop", "soft pop", "subtle bass line", "asian music", "soundtrack", "melodic violin harmony", "keyboard accompaniment", "flute", "romantic", "love song", "young love", "first love", "sentimental", "nostalgic", "pensive", "melancholic", "rhythmic acoustic guitar"] | 7 | FGoDfNZezh0 | 1632 | |
Arnel Pineda in AMO, 1988, singing "Lights" by Journey | A male vocalist sings this soft melody. The tempo is slow with a mellow keyboard harmony, steady drumming, subtle bass line and acoustic guitar accompaniment. The song is soft, romantic, melodic, emotional , sentimental, melancholic and pleasant. This song is classic Soft Rock. | 2008-03-22T11:10:43Z | ArnelPinedaFan | Audio only. Arnel Pineda with AMO, performing live "Lights" (originally by Journey) in 1998, almost 20 years before he became Journey's lead singer. Photos from Arnel's "journey" accompany the video. NOTE: Sorry I can't approve non-English comments because I don't understand them. | ["Singing", "Music", "Soul music", "/t/dd00004"] | ["male singer", "medium tempo", "soft keyboard harmony", "steady drumming", "subtle bass line", "rhythmic acoustic guitar", "romantic", "pleasant", "soft pop", "pop", "pop hits", "romantic", "sentimental", "emotional", "nostalgic", "melodic"] | 7 | thHSYzhoLo4 | 5057 |
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;