musiccaps_details (view)
2 rows where musiccaps_aspects contains "arabic music" and musiccaps_aspects contains "world music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 30 ✖
- arabic music · 2 ✖
- medium tempo 2
- world music · 2 ✖
- ambient 1
- arabic song 1
- captivating 1
- charming 1
- engaging 1
- female singer 1
- folk music 1
- foreign language 1
- goblet drum 1
- keyboard harmony 1
- male vocalist 1
- mellifluous 1
- melodious 1
- middle eastern music 1
- mizwiz melody 1
- oud 1
- percussion instrument 1
- pleasant 1
- quantum 1
- refreshing 1
- regional pop 1
- romantic 1
- simple bass lines 1
- steady drumming 1
- tambourine 1
- unique instrument 1
- violins 1
musiccaps_names (array) 4 ✖
- Music 2
- Folk music 1
- Music of Africa 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
cheb anouar loukan ta3arfi ch3al nabrik | A male vocalist sings this enthralling Arabic song. The tempo is medium with mizwiz lead melody , rhythmic oud accompaniment,, goblet drum, tambourine keyboard harmony along with more Arabian percussive instruments. The song is melodic, charming, pleasant, engaging, ambient and soulful. This song is an Arabic Pop song. | 2011-09-30T21:09:25Z | mark knopfler | ["Music of Africa", "Music"] | ["male vocalist", "medium tempo", "arabic song", "violins", "ambient", "engaging", "pleasant", "mellifluous", "world music", "folk music", "refreshing", "romantic", "melodious", "charming", "pleasant", "mizwiz melody", "arabic music", "oud", "quantum", "goblet drum"] | 7 | 5-aS_pyXesM | 622 | ||
Gezuar 2016: Shyhrete Behluli - N'daq nafaka me t'ba lum | A female vocalist sings this captivating melody. The tempo is medium with enthusiastic drumming, soft keyboard harmony, steady bass lines and a middle eastern instrument. The song is rhythmic, catchy, peppy, vivacious and has a dance groove. This song is a Regional Pop song. | 2015-12-08T19:33:06Z | VizioniLibonia | Onair Media - https://smarturl.it/Onair.Media Follow VizioniLibonia on… FB: https://smarturl.it/VizioniLiboniaFB IG: https://smarturl.it/VizioniLiboniaIG Subscribe: https://smarturl.it/VizioniLiboniaSub © & ℗ VizioniLibonia & Onair Media. All Rights Reserved | ["Singing", "Folk music", "Music"] | ["female singer", "medium tempo", "foreign language", "regional pop", "world music", "tambourine", "unique instrument", "captivating", "steady drumming", "percussion instrument", "simple bass lines", "keyboard harmony", "arabic music", "middle eastern music"] | 7 | sZwZ2fOWWSg | 4962 |
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;