musiccaps_details (view)
4 rows where musiccaps_aspects contains "energetic", musiccaps_aspects contains "folk" and musiccaps_aspects contains "noisy"
This data as json, CSV (advanced)
musiccaps_aspects (array) 27 ✖
- energetic · 4 ✖
- folk · 4 ✖
- low quality 4
- noisy · 4 ✖
- mono 3
- addictive 2
- live performance 2
- punchy snare 2
- wooden percussions 2
- addictive brass melody 1
- addictive strings melody 1
- crackling 1
- digital synth melody 1
- echoing male chant 1
- energetic drums 1
- exciting 1
- exciting male vocal 1
- flute melody 1
- groovy bass 1
- joyful 1
- passionate 1
- passionate male vocal 1
- punchy kick 1
- simple bass 1
- strings melody 1
- traditional 1
- woodwind melody 1
musiccaps_names (array) 10 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Zdop si Zdup - Dj Vasile | The low quality recording features a live performance of folk songs played by flute, strings and energetic drums. The recording is noisy and in mono, as the audio is crackling and it sounds energetic and kind of addictive thanks to that flute and strings melody. | 2010-10-15T16:42:09Z | Ciprian BT | Zdop si Zdup - Dj Vasile | ["Jazz", "Music"] | ["low quality", "folk", "noisy", "mono", "flute melody", "strings melody", "energetic drums", "crackling", "live performance", "energetic", "addictive"] | 4 | 4mtfOkzOvBI | 606 | |
Gajde cocek 2014 | The low quality recording features a folk song that consists of a digital synth melody played, after which there is an exciting male vocal. It sounds energetic and exciting. The recording is noisy and in mono. | 2014-01-17T07:10:40Z | Nikola Mladenovic | ["Folk music", "Music"] | ["low quality", "mono", "noisy", "exciting male vocal", "digital synth melody", "energetic", "exciting", "folk"] | 4 | T0tyLNN7SKA | 2804 | ||
Azerbaijan Music Wedding in Israel - Issey | The low quality recording features a live performance of a folk song that consists of a passionate male vocal singing over groovy bass, woodwind melody, punchy snare and wooden percussion. It sounds joyful, energetic and the recording is noisy. | 2007-08-09T13:31:14Z | IzzIPiano | Keyboard played by Issey | ["Drum", "Drum kit", "Music", "Musical instrument", "Wedding music", "Music of Latin America"] | ["low quality", "folk", "passionate male vocal", "groovy bass", "woodwind melody", "punchy snare", "energetic", "wooden percussions", "live performance", "joyful", "noisy"] | 4 | fiAcNMpd2vM | 3971 | |
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 |
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;