musiccaps_details (view)
2 rows where musiccaps_aspects contains "arabic music" and musiccaps_names contains "Rattle (instrument)"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- arabic music · 2 ✖
- arabic dance hits 1
- arabic dance music 1
- arabic folk song 1
- arabic percussion instruments 1
- bad audio quality 1
- classical 1
- desert sands 1
- egyptian oud 1
- folk music 1
- folk music influences 1
- groovy music 1
- hand percussion 1
- hissing tones 1
- inferior audio quality 1
- instrumental 1
- instrumental music 1
- lilting 1
- medium fast 1
- middle eastern cultural music 1
- minimalist 1
- oud melody 1
- passionate 1
- people dancing 1
- percussive bass line 1
- regional musc 1
- rich 1
- singing 1
- static 1
- stringed instrument 1
- tambourine percussions 1
- traditional dance music 1
- traditional music 1
- wind instrument 1
musiccaps_names (array) 3 ✖
- Music 2
- Rattle (instrument) · 2 ✖
- Middle Eastern music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
فهد بن سعيد + هذي مفاتيح حبي + موال + لمين ابشكي غرامك + ياناعم العود انا شاكي هواك | This music is an Arabic instrumental. The tempo is medium fast with a harmonious oud and Arabic hand percussion. The music is lilting, spirited, engaging, pleasant, traditional , middle eastern folk music. | 2014-05-01T19:13:20Z | علوؤش الجابري | مشتركه | ["Music", "Rattle (instrument)", "Middle Eastern music"] | ["instrumental", "medium fast", "arabic music", "minimalist", "traditional music", "egyptian oud", "stringed instrument", "lilting", "rich", "middle eastern cultural music", "regional musc", "folk music", "classical", "static", "inferior audio quality", "oud melody", "hand percussion"] | 7 | OS4YFp3DiEE | 2442 | |
Wahraïniate Cheikha Zalamite | The song is an instrumental. The tempo is medium with a percussive Arabic percussion groove, tambourine percussions, percussive bass line and a ethnic wind instrument playing an enthusiastic solo. The song has folk music influences and reminds us of a desert journey. The song audio quality is very poor. | 2013-03-02T12:47:47Z | WahranRai | Cheikha Zalamite, une belle voix Blues Raï de Saïda (Ouest algérien). Cheikha Zalamite me fait penser à cette grande dame du bédoui algérien Cheikha Djénia (Paix à son âme). Elle nous interprète ... Hanini ou n'hanik / Laisse moi tranquille et je te laisserai tranquille... La région de Saïda (Algérie) est connue par ses grands chanteurs, Chioukhs et cheikhates (Mami, Cheikha Djénia, Cheb Aïssa...). Zalamite est l'arabisation du mot Les allumettes. Hommage à Cheikha Zalamite et aux Chioukhs et Cheikhates de l' Ouest algérien. Wahran Raï / Oran Rai. | ["Music", "Rattle (instrument)"] | ["arabic music", "instrumental music", "people dancing", "folk music influences", "passionate", "traditional dance music", "arabic percussion instruments", "tambourine percussions", "groovy music", "percussive bass line", "hissing tones", "arabic folk song", "arabic dance music", "desert sands", "singing", "people dancing", "arabic dance hits", "wind instrument", "bad audio quality"] | 1 | eXrJL1VUQNE | 3876 |
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;