musiccaps_details (view)
3 rows where musiccaps_aspects contains "energetic" and musiccaps_aspects contains "traditional"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- addictive 3
- energetic · 3 ✖
- low quality 3
- traditional · 3 ✖
- noisy 2
- wooden percussions 2
- acoustic guitar melody 1
- addictive brass melody 1
- addictive strings melody 1
- clapping 1
- echoing male chant 1
- exciting background male vocals 1
- flat male vocal 1
- folk 1
- fun 1
- groovy bass 1
- joyful 1
- mono 1
- muffled 1
- passionate 1
- pop 1
- punchy kick 1
- punchy snare 1
- repetitive addictive strings melody 1
- shimmering cymbals 1
- simple bass 1
- upbeat 1
- wide 1
- wooden percussive elements 1
musiccaps_names (array) 7 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
orchestra jamal | The low quality recording features a traditional song that consists of a repetitive and addictive string melody, wooden percussion and shimmering cymbals. It sounds really energetic and addictive - almost like a pop song would. The recording is a bit noisy and the left channel of the stereo image is occasionally muffled. | 2012-09-30T12:52:43Z | jamal chaouad | orchestra jamal.wmv | ["Traditional music", "Music", "Orchestra"] | ["low quality", "traditional", "upbeat", "repetitive addictive strings melody", "wooden percussions", "shimmering cymbals", "energetic", "addictive", "muffled", "noisy"] | 4 | CeaWlENtRio | 1389 | |
Badke: KVS/les ballets C de la B/A.M. Qattan Foundation (c) Zaina Zarour | The low quality recording features a folk song that consists of an echoing male chant over punchy kick and snare hits, wooden percussion, addictive strings and brass melodies and simple bass. It sounds traditional, addictive, passionate and energetic. The recording is noisy and in mono. | 2014-04-25T11:45:31Z | balletsCdelaB | In 2006, KVS, les ballets C de la B and the A.M. Qattan Foundation launched a series of workshops with young Palestinian performing artists. Now, Koen Augustijnen, Rosalba Torres (les ballets C de la B) and Hildegard De Vuyst (KVS) present the dance production Badke, for which they work with ten Palestinian performers, young autodidacts from various disciplines including contemporary dance, hip hop, circus, etc. The term 'badke' is a distortion of 'dabke', a Palestinian folk dance. The performance starts out from the popular variant: the people's social, festive dabke. The performers go on to confront this locally rooted dance with elements from worldwide pop (dance) culture. Badke becomes a quest for a dabke that not only conveys the unique Palestinian desire to 'belong somewhere', but also the wish to be part of a world beyond that. | ["Bagpipes", "Wind instrument, woodwind instrument"] | ["low quality", "mono", "noisy", "folk", "echoing male chant", "punchy snare", "punchy kick", "addictive strings melody", "addictive brass melody", "traditional", "addictive", "passionate", "wooden percussions", "simple bass", "energetic"] | 4 | kMmjr8deHis | 4312 | |
Farhad Shams Qarsak-e Panjsher and Sheen Khaale | The low quality recording features a traditional pop song that consists of a flat male vocal, alongside exciting background vocals, singing over claps, wooden percussive elements, groovy bass and acoustic guitar melody. It sounds energetic, addictive, fun and joyful - like something you would hear at more traditional parties. | 2013-03-18T17:13:05Z | StylezhooDB3o9 | Farhad Shams Qarsak-e Panjsher and Sheen Khaale Farhad Shams Qarsak-e Panjsher and Sheen Khaale | ["Singing", "Folk music", "Music"] | ["low quality", "pop", "traditional", "acoustic guitar melody", "wooden percussive elements", "clapping", "groovy bass", "flat male vocal", "exciting background male vocals", "wide", "energetic", "addictive", "fun", "joyful"] | 4 | qM8F6ECriRc | 4779 |
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;