musiccaps_details (view)
3 rows where musiccaps_aspects contains "addictive", musiccaps_aspects contains "punchy kick" and musiccaps_aspects contains "wooden percussions"
This data as json, CSV (advanced)
musiccaps_aspects (array) 31 ✖
- addictive · 3 ✖
- low quality 3
- punchy kick · 3 ✖
- wooden percussions · 3 ✖
- energetic 2
- passionate 2
- punchy snare 2
- addictive brass melody 1
- addictive female vocal 1
- addictive strings melody 1
- brass melody 1
- commercial music 1
- distorted 1
- echoing brass melody 1
- echoing male chant 1
- electric guitar melody 1
- folk 1
- funny processed male vocal 1
- groovy bass 1
- harmonizing female vocal 1
- harsh 1
- live performance 1
- messy 1
- mono 1
- noisy 1
- pop 1
- simple bass 1
- snare roll 1
- string melody 1
- traditional 1
- traditional pop 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 |
---|---|---|---|---|---|---|---|---|---|---|
Nivine Nasr - Yo2bosh - Video Clip | The low quality recording features a commercial music that consists of a funny processed male vocal, after which there is a harmonizing female vocal singing over punchy kick, brass melody, wooden percussion and echoing brass melody. It sounds addictive - like every commercial music should sound. | 2010-04-20T13:18:50Z | ArmVisions | Nivine Nasr Yo2bosh نيفين نصر يؤبش | ["Music", "Middle Eastern music", "Speech"] | ["low quality", "pop", "funny processed male vocal", "brass melody", "punchy kick", "wooden percussions", "echoing brass melody", "harmonizing female vocal", "addictive", "commercial music"] | 4 | 3QqVP0odOw4 | 467 | |
Fatima Tuz Zahra Oyshee-De De pal Tule de - Live on RTV MUSIC STATION | The low quality recording features a live performance of a traditional pop song and it consists of an addictive female vocal singing over punchy kick and snare hits, groovy bass, electric guitar melody, strings melody and wooden percussion. There is a short snare roll, right before the bass drops. It sounds messy, a bit harsh, distorted, but also passionate, addictive and energetic. | 2015-11-15T15:01:18Z | Oyshee Express | Singer- Fatima Tuz zahra Oyshee Lyric & Tune: Abdur Rahman Boyati Produced by Khoshru Anchored by Liza Bass Guitar- Sohel Rana Flute: Kamrul Lead Guitar: Roman Keyboard: Nadim Pad: Sakib Percussion: Ujjol | ["Music of Asia", "Music", "Salsa music"] | ["live performance", "low quality", "traditional pop", "addictive female vocal", "punchy snare", "wooden percussions", "snare roll", "groovy bass", "string melody", "electric guitar melody", "punchy kick", "messy", "distorted", "harsh", "passionate", "addictive", "energetic"] | 4 | eISYX9koocM | 3855 | |
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;