musiccaps_details (view)
3 rows where musiccaps_aspects contains "k-pop" and musiccaps_aspects contains "romantic"
This data as json, CSV (advanced)
musiccaps_aspects (array) 52 ✖
- emotional 3
- k-pop · 3 ✖
- love song 3
- romantic · 3 ✖
- korean pop 2
- male vocalist 2
- medium tempo 2
- ambient 1
- atmospheric synthesiser 1
- backup singers 1
- boy band 1
- calm 1
- cheerful positive 1
- chimes 1
- contrast song fade 1
- dulcet 1
- electric guitar strumming 1
- female singer 1
- foreign language 1
- k-pop hips 1
- k-pop hits 1
- keyboard accompaniment 1
- korean song 1
- love me 1
- mellow 1
- mellow guitar 1
- melodic 1
- passionate 1
- percussive bass line 1
- pleasant 1
- pop 1
- pop diva 1
- pop hits 1
- romantic piano 1
- sentimental 1
- slow tempo 1
- soft 1
- soft acoustic guitar accompaniment 1
- soft pop 1
- soft soothing 1
- song fade 1
- steady drumming 1
- steady drumming rhythm 1
- straightforward bass lines 1
- synthesiser arrangements 1
- various percussion hits 1
- vigorous introduction 1
- vocal backup 1
- vocal harmony 1
- world music 1
- young love 1
- youthful 1
musiccaps_names (array) 5 ✖
- Music 3
- Music of Asia 1
- Pop music 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 |
---|---|---|---|---|---|---|---|---|---|---|
BEAST/B2ST - Clenching A Fist Tight | A male vocalist sings this soft Korean Melody. The tempo is medium with a romantic piano accompaniment, steady drumming, simple bass lines, chimes, synthesiser arrangements and male vocal backup. The song is a soft, mellow, romantic, emotional, sentimental, dulcet, melodic love song. This song is a Korean Soft Pop/K-pop song. | 2010-09-17T04:03:08Z | megcapati | BEAST's 3rd Mini Album MASTERMIND. SUPPORT BEAST BUY BUYING THEIR 3RD MINI ALBUM MASTERMIND! :D :D :D ~~ Another awesome ballad. Perfect song to listen to if you want to cry. ~~ CHECK OUT MY OTHER VIDEOS :D Twitter: http://www.twitter.com/meggiewegsss Tumblr: http://www.meggiewegsss.tumblr.com Facebook: http://www.facebook.com/meggiewegsss B2STLYB2UTIES website coming soon~♥ Twitter: http://www.twitter.com/B2STLYB2UTIES Facebook: http://www.facebook.com/pages/B2stlyb2uties/144520828909598 Every 2 weeks is the birth of a new parody made by EMDEE Parodies ^_^v Twitter: http://www.twitter.com/EMDEEparodies YouTube: http://www.youtube.com/user/EMDEEparodies | ["Music", "Pop music", "Soul music"] | ["male vocalist", "medium tempo", "dulcet", "sentimental", "emotional", "love song", "melodic", "world music", "k-pop hips", "youthful", "young love", "soft soothing", "romantic piano", "steady drumming", "straightforward bass lines", "chimes", "atmospheric synthesiser", "boy band", "vocal backup", "ambient", "pop", "soft pop", "romantic", "pleasant", "emotional", "melodic", "foreign language", "korean song", "k-pop"] | 7 | 0F-Z0zF1504 | 138 | |
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 | |
KARA - 「マンマミーア!」Music Video | A female singer sings this cool pop melody. The song is medium with a steady drumming rhythm, percussive bass line, keyboard accompaniment and various percussion hits. The song is modern K-pop. The song is romantic and cheerful. | 2014-08-18T19:00:08Z | KARAJAPANChannel | 遂にベールを脱いだ新生KARAが放つ、超最新ダンスチューン! New Single 2014.08.27 Release!! 「マンマミーア!」 予約はこちらから: http://umusic.ly/kara_umstore 初回封入特典:2014年全国ツアーチケット先行抽選受け付けシリアルナンバー 応募期間:2014年8月26(火)18:00〜2014年9月3(水)23:00 初回限定盤ASG+DVDUMCK-9696 ¥1,886(税抜)+税 <CD> 1. マンマミーア! 2. ソー・グッド 3. マンマミーア!(Instrumental) 4. ソー・グッド(Instrumental) <DVD> マンマミーア!(Music Video Clip) マンマミーア!(Dance Shot Ver.) マンマミーア!(Music Video Clip オフショット) 初回限定盤BSG+フォトブックUMCK-9697 ¥1,600(税抜価格)+税 <CD> 1. マンマミーア! 2. ソー・グッド 3. マンマミーア!(Instrumental) 4. ソー・グッド(Instrumental) <フォトブック> 28Pスペシャルフォトブック 初回限定盤CSG+ボーナストラックUMCK-9698 ¥1,200(税抜価格)+税 <CD> 1. マンマミーア! 2. ソー・グッド 3. マンマミーア!(Instrumental) 4. ソー・グッド(Instrumental) 5. Don’t Hurry (Bonus Track) *初回盤Cが終了次第、通常盤SGのみ(UMCK-5494 ¥1,000+税)に移行します ◆UM JAPAN KARA オフィシャルサイト http://umusic.ly/um_kara | ["Music of Asia", "Music"] | ["k-pop", "korean pop", "percussive bass line", "medium tempo", "backup singers", "vocal harmony", "steady drumming rhythm", "keyboard accompaniment", "various percussion hits", "pop hits", "pop diva", "romantic", "love song", "emotional", "female singer", "cheerful positive", "love me", "electric guitar strumming"] | 1 | EQSv7DIJJtw | 1555 |
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;