musiccaps_details (view)
3 rows where musiccaps_aspects contains "calm", musiccaps_aspects contains "emotional" and musiccaps_aspects contains "love song"
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- calm · 3 ✖
- emotional · 3 ✖
- love song · 3 ✖
- romantic 2
- acoustic guitar 1
- airy soothing female voice 1
- beautiful 1
- contrast song fade 1
- folk song 1
- foreign language 1
- funky bass line 1
- gentle ballad 1
- gentle female vocal 1
- japanese pop 1
- k-pop 1
- k-pop hits 1
- keyboard harmony 1
- korean pop 1
- male singer 1
- male vocalist 1
- mandolin 1
- medium tempo 1
- mellow 1
- mellow guitar 1
- passionate 1
- piano arpeggio 1
- slow tempo 1
- soft 1
- soft acoustic guitar accompaniment 1
- song fade 1
- soothing 1
- soothing ballad 1
- soulfu 1
- soulful 1
- soulfulromantic 1
- steady drumming 1
- synthesiser arrangements 1
- vigorous introduction 1
- world music 1
musiccaps_names (array) 4 ✖
- Music 3
- Tender music 2
- Folk music 1
- Sad music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Daisy (Hey) Music Video (Eng sub) | This is an emotional Japanese pop ballad. The singer has a light, airy and gentle voice that she uses to sing over the deep and full piano arpeggios. The song has a calming and emotional effect. | 2012-12-17T13:51:26Z | pachamadresita | ✿⊱╮For those we lose and love.. | ["Music", "Sad music"] | ["piano arpeggio", "gentle ballad", "soothing ballad", "calm", "beautiful", "emotional", "love song", "airy soothing female voice", "gentle female vocal", "japanese pop"] | 3 | 2M-CFCo-rkY | 357 | |
Kim Jaejoong MUSIC QUIZ | A male vocalist sings this mellow pop. The tempo is slow in contrast to the enthusiastic introductory bit in this section. The song is soft, mellow, emotional, repetitive, melancholic, nostalgic and passionate with a soft acoustic guitar accompaniment. This could be a song fade. This song is a Korean Pop/K-Pop song. | 2016-03-30T01:17:32Z | JaejoongArabFansC3 | Website: http://jaejoongarabfans.com/ Facebook: https://www.facebook.com/JaejoongArabFans Twitter: https://twitter.com/JaejoongArabFan | ["Music", "Tender music"] | ["male vocalist", "slow tempo", "vigorous introduction", "synthesiser arrangements", "contrast song fade", "soft acoustic guitar accompaniment", "korean pop", "k-pop", "k-pop hits", "mellow guitar", "song fade", "love song", "romantic", "emotional", "passionate", "mellow", "soft", "calm"] | 7 | 4i1aizhCnfg | 596 | |
tsehay yohannes - Old music | A male vocalist sings this lilting melody. The tempo is medium with keyboard harmony, groovy bass line, steady drumming and mandolin harmony. The song is emotional, romantic, soulful, sentimental and soothing. This song is Regional Pop, | 2012-06-02T11:28:06Z | Banchi Avera | This song taking me back to my past ......... | ["Folk music", "Music", "Tender music"] | ["male singer", "medium tempo", "foreign language", "romantic", "soulful", "mandolin", "steady drumming", "soulfulromantic", "soulfu", "soothing", "calm", "soulful", "emotional", "love song", "folk song", "world music", "funky bass line", "keyboard harmony", "acoustic guitar"] | 7 | c9h4p6325Xo | 3684 |
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;