musiccaps_details (view)
2 rows where musiccaps_aspects contains "foreign language" and musiccaps_aspects contains "muddled audio"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- foreign language · 2 ✖
- muddled audio · 2 ✖
- acordion melody 1
- acoustic guitar accompaniment 1
- bongos 1
- celebratory 1
- cheerful 1
- classic latin songs 1
- congas 1
- emotional 1
- fast tempo 1
- female singer 1
- guiro 1
- happy 1
- latin folk songs 1
- latin music 1
- latin percussions 1
- lively 1
- love song 1
- male backup 1
- male singer 1
- male vocal backup 1
- medium tempo 1
- middle eastern music 1
- muffled audio 1
- oud 1
- passionate 1
- shofar like instrument 1
- simple 1
- spanish music 1
- spirited 1
- steady bass line 1
- steady drumming 1
- world music 1
musiccaps_names (array) 5 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ضياء الصغير - موال + يابن الناس | A male vocalist sings this song in a foreign language. The tempo is fast with rhythmic oud , steady drumming, shofar and strong vocal backup. The audio is muffled and incoherent making it difficult to hear the other instruments used. This song is a Middle Eastern Pop song. | 2010-03-30T15:21:02Z | agany2009 | كلمات غسان جوده - الحان طالب السوداني - ضياء الصغير 2003 تشاهدون ايضا في قنتاتي كوكبة من مغنيين ومطربين العراق واغاني قديمه وحديثه علي العيساوي - حاتم العراقي - اوراس ستار - ضياء حسين - ضياء الصغير - سعدي الحلي - سعدي البغدادي - سعدي البياتي - كاظم الساهر - محمود انور - علي محمود السامر - فرج وهاب - محمد الغزي - سعدون جابر - كاظم مدلل - ضياء الراشد - رعد العربي - رياض كريم - فارس العراقي - احمد عباس - علي الصغير - عادل الموسى - عادل عكله - جلال خورشيد - صباح محمود - صباح اللامي - صلاح عبد الغفور - ياس خضر - حميد منصور - عبد الله البدر - هيثم يوسف - مهند محسن - عبد فلك - علاء سعد - مي ووحيد - وحيد سعد - ناظم سعد - مضر محمد - جلال الحنين - حنين بغدادي - وحيد علي - محمد وسام كتعان وصفي - فلفل الكرخي - ضياء الراشد - سعد كمر - جمال الصغير - محمود مشكور | ["Music", "Middle Eastern music"] | ["fast tempo", "male singer", "foreign language", "muffled audio", "oud", "steady drumming", "shofar like instrument", "middle eastern music", "love song", "passionate", "emotional", "male vocal backup", "passionate", "muddled audio"] | 7 | vVNWjq9byoQ | 5186 | |
LLEGO DICIEMBRE CON SU ALEGRIA | A female vocalist sings this classic Spanish song. The tempo is medium with a lively accordion harmony, guiro , congas and bongos rhythm, steady bass line, and acoustic guitar accompaniment. The music is simple, light, happy, joyful, cheerful, celebratory and spirited with vocal backup.There are sounds of people cheering in the background. This is a Classic Latin Folk Song. | 2012-12-02T02:33:13Z | max pardo | LLEGO DICIEMBRE | ["Christmas music", "Christian music", "Music", "Rattle (instrument)"] | ["female singer", "medium tempo", "cheerful", "happy", "spirited", "celebratory", "simple", "classic latin songs", "lively", "latin folk songs", "latin percussions", "latin music", "spanish music", "guiro", "acordion melody", "foreign language", "world music", "congas", "bongos", "acoustic guitar accompaniment", "steady bass line", "male backup", "muddled audio"] | 7 | wQN7fRaPl2A | 5264 |
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;