musiccaps_details (view)
2 rows where musiccaps_aspects contains "duet", musiccaps_aspects contains "foreign language" and musiccaps_aspects contains "youthful"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- duet · 2 ✖
- energetic 2
- foreign language · 2 ✖
- youthful · 2 ✖
- boomy bass drops 1
- buoyant 1
- contemporary 1
- contemporary folk 1
- cymbals 1
- dance groove 1
- digital drumming 1
- digital drums 1
- disco pop 1
- drum kit 1
- electric guitar lead 1
- electro pop 1
- electronic music 1
- electronic sounds 1
- enthusiastic 1
- female singer 1
- groovy 1
- groovy rhtyhm 1
- male singer 1
- male vocalist 1
- medium fast tempo 1
- mellow vocals 1
- peppy 1
- punchy 1
- punchy music 1
- regional pop 1
- synthesiser arrangement 1
- synthesiser arrangements 1
- upbeat 1
- world music 1
musiccaps_names (array) 5 ✖
- Music 2
- Blues 1
- Rhythm and blues 1
- Ska 1
- Vocal music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ghezaal, Qais Ulfat & Shekeb Osmani - Ashiqi New Music Video 2013 | This song is a spirited duet in foreign language . The tempo is fast with male and female vocals, animated digital drums and synthesiser arrangement . The song is upbeat, catchy, engaging, punchy, buoyant and has a nice dance groove. This music is contemporary Regional Pop. | 2013-12-12T23:20:04Z | Ghezaal Enayat Music | PLEASE DO NOT RE-UPLOAD! *Re-Upload Is Strictly Prohibited* Release Date: Feb. 21, 2013 Song: Ashiqi Artists: Qais Ulfat, Shekeb Osmani & Ghezaal Compose & Music Arrangement: Qais Ulfat & Shekeb Osmani Lyrics: Massood Zarab (مسعود زراب) Recording, Mixing & Mastering: SaaZ Studios Inc. Filmed in Goa, Edited in Bombay by Five River Films (Mintoo) "Ashiqi" © 2013 SaaZ Studios Inc. Lyrics: Saraa paa maihrabaan o naazaneeni Too zaibaa dokhtare Afghan zameeni Too tanhaa hamdam o dildaaram hasti Azeez o dilbar o ghamkhaaram hasti Chi khush dar zindagi ashiq bimaanaim Soroode ashiqi baa ham bikhaanaim Dar jawaani ashiqi bay ikhtiyaar ast Hosh o goshe ashiqaan soye nigaar ast Ashiqi zaibaa tar az fasle bahaar ast Man am dar aasomaan mahtabe tanhaa Man am mowje ke jaan bakhshad ba darya Beeyaa maahe shabe yalda-ye man show Beeyaa mowje dile darya-ye man show Ba misle Qais ashiq sho ke zaibaast Jahaanash khaake paa-ye ishqe Liylaast | ["Blues", "Music", "Rhythm and blues", "Ska"] | ["duet", "female singer", "male singer", "foreign language", "contemporary folk", "punchy", "peppy", "youthful", "dance groove", "disco pop", "buoyant", "punchy", "regional pop", "synthesiser arrangement", "drum kit", "digital drumming", "upbeat", "contemporary", "groovy rhtyhm", "youthful", "energetic", "electronic music", "regional pop", "disco pop", "world music"] | 7 | 7Msk_hkz6zk | 836 | |
Big Mac Chant挑战 – FS Fuying & Sam 流行曲风 | This song is a vocal duet of male singers in a foreign language . The tempo is medium fast with an animated electric guitar melody, boomy bass drops, digital drums and synthesiser arrangements. The music is buoyant, youthful,punchy, groovy and emphatic with mellow vocals. This song is contemporary Pop. | 2016-10-13T01:58:19Z | McDonaldsMalaysia | 快来学唱FS Fuying&Sam版本的Big Mac Chant挑战歌曲,之后到Smule与他们合唱,再将影片上传到Facebook或Instagram,最后到www.mcdonalds.com.my/mybigmacchant报名参加,就有机会赢取高达RM10,000现金奖,以及与他们见面的机会!马上行动! | ["Music", "Vocal music"] | ["male vocalist", "duet", "medium fast tempo", "foreign language", "electric guitar lead", "boomy bass drops", "synthesiser arrangements", "cymbals", "electronic sounds", "digital drums", "youthful", "energetic", "enthusiastic", "groovy", "punchy music", "mellow vocals", "electro pop"] | 7 | XaqVAF-ADWU | 3201 |
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;