musiccaps_details (view)
3 rows where musiccaps_aspects contains "female singer", musiccaps_aspects contains "love song" and musiccaps_aspects contains "vocal harmony"
This data as json, CSV (advanced)
musiccaps_aspects (array) 48 ✖
- backup singers 3
- female singer · 3 ✖
- love song · 3 ✖
- vocal harmony · 3 ✖
- emotional 2
- groovy bass line 2
- romantic 2
- tambourine percussions 2
- adoration 1
- arabic dance song 1
- arabic percussions 1
- arabic pop song 1
- arabic singer 1
- bad audio quality 1
- belly dancing music 1
- cheerful 1
- cheerful positive 1
- cymbals crashing 1
- disco music 1
- disco romance hits 1
- electric guitar strumming 1
- falsetto 1
- groovy rhythm 1
- guitar rhythm 1
- k-pop 1
- keyboard accompaniment 1
- korean pop 1
- love me 1
- lyrical singing 1
- marry me 1
- medium fast tempo 1
- medium tempo 1
- passionate 1
- percussive bass line 1
- piano accompaniment 1
- poor audio quality 1
- pop diva 1
- pop hits 1
- retro hits 1
- retro pop song 1
- slowing down 1
- song retarding 1
- steady drumming 1
- steady drumming rhythm 1
- string section 1
- together forever 1
- traditional music influences 1
- various percussion hits 1
musiccaps_names (array) 9 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
yongseo arab fan- (عالبال (سميرة سعيد | A female Arabic singer sings this beautiful melody with backup singers in vocal harmony. The song is medium tempo with a string section, Arabic percussion instruments, tambourine percussion, steady drum rhythm, groovy bass line and keyboard accompaniment. The song is romantic and celebratory in nature. The audio quality is very poor. | 2011-09-20T18:50:38Z | yasmin ali | ["Afrobeat", "Music of Africa", "Music of Asia", "Music", "Pop music", "Reggae", "Middle Eastern music", "Music of Latin America", "Soul music"] | ["female singer", "arabic singer", "arabic pop song", "lyrical singing", "poor audio quality", "medium fast tempo", "backup singers", "vocal harmony", "string section", "arabic percussions", "groovy bass line", "arabic dance song", "arabic pop song", "lyrical singing", "traditional music influences", "belly dancing music", "groovy rhythm", "cheerful", "romantic", "love song", "adoration", "tambourine percussions"] | 1 | aOGNUGgTQ8k | 3534 | ||
PACHUCO ROLAS VOL 1 | A female singer sings this passionate melody with backup singers in vocal harmony. The tempo is medium and gradually slows down towards the end. The drumming rhythm is steady and retards to the end with a percussive bass line and keyboard accompaniment. The song is a retro disco or R&B love song. The song has poor audio quality. | 2009-03-23T07:20:30Z | pachucojae | PACHUCO MEMORIES.... | ["Music", "Soul music"] | ["female singer", "disco music", "song retarding", "bad audio quality", "slowing down", "backup singers", "falsetto", "vocal harmony", "steady drumming", "groovy bass line", "piano accompaniment", "guitar rhythm", "tambourine percussions", "cymbals crashing", "retro pop song", "retro hits", "emotional", "love song", "passionate", "together forever", "disco romance hits", "marry me"] | 1 | iS-iTbHndw8 | 4185 |
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;