musiccaps_details (view)
2 rows where musiccaps_aspects contains "synthesiser arrangement" and musiccaps_names contains "Blues"
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- male singer 2
- synthesiser arrangement · 2 ✖
- bitter 1
- blues 1
- blues-rock 1
- blues-rockvigorous electric guitar 1
- breakup 1
- buoyant 1
- contemporary 1
- contemporary folk 1
- dance groove 1
- depressed 1
- digital drumming 1
- disco pop 1
- drum kit 1
- duet 1
- electronic music 1
- energetic 1
- female singer 1
- foreign language 1
- groovy bass line 1
- groovy rhtyhm 1
- heart break 1
- hurt 1
- intense drumming 1
- lonely 1
- medium tempo 1
- peppy 1
- poignant 1
- punchy 1
- regional pop 1
- rock 1
- sad 1
- upbeat 1
- vigorous electric guitar riff 1
- world music 1
- youthful 1
musiccaps_names (array) 4 ✖
- Blues · 2 ✖
- Music 2
- Rhythm and blues 1
- Ska 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Joe Bonamassa - "Blues of Desperation" - Official Music Video | A male vocalist sings this emphatic rock. The tempo is medium with vigorous electric guitar, synthesiser arrangement, groovy bass line and intense drumming. The vocals are soft ,sad, lonely, poignant, mellow, and melodic in contrast to the intense instrumentation. This song is Blues-Rock. | 2016-08-01T14:41:20Z | JoeBonamassaTV | ► STREAM JOE NOW: https://jbonamassa.com/streaming/ ► FREE ALBUM DOWNLOAD - http://goo.gl/9oI018 ● Official Tickets ● http://jbonamassa.com/tour-dates/ ● Official Social Links ● https://www.facebook.com/JoeBonamassa https://twitter.com/jbonamassa https://instagram.com/joebonamassa/ https://www.pinterest.com/jbonamassa/ ● Official Merchandise ● http://shop.jbonamassa.com/ | ["Blues", "Music"] | ["male singer", "medium tempo", "sad", "depressed", "heart break", "blues-rock", "vigorous electric guitar riff", "breakup", "hurt", "poignant", "bitter", "lonely", "blues-rockvigorous electric guitar", "synthesiser arrangement", "blues", "rock", "groovy bass line", "intense drumming"] | 7 | 6JJMlY3Go9s | 743 | |
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 |
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;