musiccaps_details (view)
4 rows where musiccaps_aspects contains "vibrant" and musiccaps_names contains "Middle Eastern music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- vibrant · 4 ✖
- live performance 2
- percussion 2
- upbeat 2
- african music 1
- bongo drums 1
- clapping hands 1
- claps 1
- clarinet 1
- darbuka 1
- eastern sounding 1
- easygoing 1
- electric bass guitar 1
- electric guitar 1
- electric keyboard 1
- fast paced rhythmic singing 1
- gospel 1
- greek folk music 1
- intricate drum pattern 1
- khaliji music 1
- male vocal 1
- medium tempo 1
- mellow groove 1
- melodic singing 1
- old desi music 1
- orchestra 1
- oud 1
- riq 1
- tabla playing 1
- toubeleki 1
- traditional south asian music 1
- trumpets 1
- violin 1
- wooden percussion instrument 1
musiccaps_names (array) 8 ✖
- Middle Eastern music · 4 ✖
- Music 4
- Bowed string instrument 1
- Clarinet 1
- Gospel music 1
- Musical instrument 1
- Plucked string instrument 1
- Traditional music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
FUNNY QAWALI OF SHOKI KHAN | This is a traditional, cultural South Asian song. It is upbeat, vibrant, cheerful. The lead singer sings in a fast paced and rhythmic way, connecting many words within a short span of musical time. The rest of the performers are clapping their hands, playing the tabla. This is a live performance. | 2010-08-04T10:48:03Z | Hussain Akram | ["Music", "Middle Eastern music"] | ["traditional south asian music", "old desi music", "fast paced rhythmic singing", "clapping hands", "live performance", "tabla playing", "upbeat", "vibrant"] | 3 | 0fiOM---7QI | 197 | ||
GHANA GOSPEL MUSIC PROJECT 2008 AKWAABA JUNIOR LTJBM BAND Ayeyie oo! | This is a live performance by an African music group in a gospel style. The drum pattern is intricate and there are other percussive elements like an occasional bongo and a wooden percussion instrument. The melodic elements are the vintage sounding electric piano as well as the vibrant and fun brass melody played on the trumpets. | 2008-09-09T12:42:40Z | livegospelbandghana | SHILOH EVANGELICAL GOSPEL MUSIC ACADEMY presente to the world Afric's No. 1 juvenile live gospel band, playing three fusions. African gospel music revolution fusion, playing high life reggea jazz etc. contact: neelante@journalist.com, tel: (+233) 244 654 400 / 277 338 172 | ["Gospel music", "Music", "Middle Eastern music"] | ["african music", "gospel", "trumpets", "upbeat", "vibrant", "electric bass guitar", "bongo drums", "intricate drum pattern", "wooden percussion instrument", "electric keyboard", "mellow groove", "medium tempo"] | 3 | C0eCERYt4bA | 1317 | |
خالد الملا على كثر | This is a live performance of a Khaliji music piece. There is an orchestra performing the piece. The melody is being played by the oud and the violin. The rhythmic background is composed of various percussive elements such as the riq, the darbuka and performers clapping their hands. The atmosphere is vibrant. This piece could be playing in the background at an Arab cuisine restaurant. | 2012-12-22T12:53:27Z | saaa64 | المطرب خالد الملا حضرميه على كثر | ["Traditional music", "Music", "Musical instrument", "Middle Eastern music", "Plucked string instrument", "Bowed string instrument"] | ["khaliji music", "live performance", "orchestra", "violin", "oud", "percussion", "riq", "darbuka", "claps", "vibrant", "eastern sounding"] | 9 | MHHshnnqyco | 2251 | |
ΔΗΜΟΤΙΚΑ ΤΡΑΓΟΥΔΙΑ ΑΠΟ ΠΑΝΗΓΥΡΙΑ ΣΤΗΝ ΡΟΥΜΕΛΗ 🎤 | This is a Greek folk music piece. There is a male vocalist singing melodically and with a lot of articulation. The clarinet is playing the main theme while there is an electric guitar playing a backing tune. The rhythmic background consists of a percussion line that sounds very much like the toubeleki. There is a vibrant atmosphere. This piece could be playing in the background at a Greek cuisine restaurant or a Greek tavern. | 2011-06-05T18:34:18Z | George Amfilochia | #ΠΑΡΑΔΟΣΙΑΚΑ 00:00 Αυτά τα μαύρα μάτια 1:42 Αυτού ψηλά ματάκια μου 2:40 Άνθισε και πάλι η αμυγδαλιά 6:33 Aν μ' αγαπας να μου το πεις 10:07 Ανάθεμα την ώρα που σε γνώρισα | ["Clarinet", "Music", "Middle Eastern music"] | ["greek folk music", "male vocal", "melodic singing", "clarinet", "electric guitar", "percussion", "toubeleki", "vibrant", "easygoing"] | 9 | jHEBYrI8zHE | 4244 |
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;