musiccaps_details (view)
4 rows where musiccaps_aspects contains "e-bass", musiccaps_aspects contains "percussion's" and musiccaps_aspects contains "uptempo"
This data as json, CSV (advanced)
musiccaps_aspects (array) 19 ✖
- e-bass · 4 ✖
- percussion's · 4 ✖
- uptempo · 4 ✖
- acoustic drums 1
- amateur recording 1
- brass 1
- female voice singing 1
- higher register 1
- indie-funk 1
- latin 1
- male 1
- male and female backing voices 1
- male backing singers 1
- male voice singing 1
- mid range singer 1
- oriental/pop 1
- plucked oriental string instruments 1
- salsa 1
- strings 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 |
---|---|---|---|---|---|---|---|---|---|---|
Serge Gainsbourg - Psychastenie | This song seems to be experimental. An e-bass is playing a light funky groove along with a clapping sound while other percussion's are adding a rhythm rounding up the rhythm section. A oriental sounding string is playing one single note rhythmically while another oriental and plucked instrument is playing a melody in the higher register. The whole recording sounds a little old but is of good quality. This song may be playing in the kitchen while cooking. | 2009-11-02T11:09:11Z | tuberider1976 | ["Music", "Sitar"] | ["indie-funk", "plucked oriental string instruments", "e-bass", "percussion's", "uptempo"] | 6 | BnkDQXlrIX4 | 1291 | ||
Ana&Efren Teatro Jovellanos Gijon enero 08(bachata y salsa) | This is a classical, uptempo salsa song full of percussive instruments playing the rhythm. An e-bass is playing underlining the percussion. While the brass instruments are playing a catchy melody along with the male backing singers. Then the male higher range singer takes over and responds to the backing vocals. This song may be playing in a salsa bar or latin festival. | 2009-01-23T15:46:23Z | pinina360 | festival de la soliaridad gijon 2008 | ["Music", "Music of Latin America", "Salsa music"] | ["salsa", "percussion's", "e-bass", "brass", "male backing singers", "male", "mid range singer", "uptempo"] | 6 | J4DrdTy52kg | 1967 | |
اغاني وطنية - غزل سلامة - لولا الوطن ما حبيت | This song contains a lot of percussive elements and instruments playing a fast paced rhythm with a simple e-bass underlining the drum hits. Strings are being played along with the melody and adding some extra spice. The female voice is singing along with a lot of female and male backing vocals. The voices are panned to the left and right side of the speakers. This song may be playing at a cheerful event while celebrating. | 2015-09-13T22:49:51Z | monir nassar | اغاني وطنية - غزل سلامة - لولا الوطن ما حبيت لولا الوطن ما حبيت غناء غزل سلامة كلمات والحان وتوزيع بو سيف توزيع موسيقي فادي فحماوي مكس ماسترينج استوديو مايسترو خدمات انتاجية سلامة الشلول أمير شكر خاص محمد صالح ابو حمور عاطف ابو حجر مطعم ريم البوادي فهد الزعبي المخرج: انطون نصار حازم عبيدات مساعد مصور انور المستريح مونتاج منير نصار تصوير واخراج محمد الزعبي | ["Music of Asia", "Music", "Middle Eastern music"] | ["oriental/pop", "strings", "acoustic drums", "e-bass", "percussion's", "female voice singing", "male and female backing voices", "uptempo"] | 6 | aWK9CcvOK9w | 3550 | |
Ruben Blades - Patria | Someone is playing an e-bass along with somebody playing percussion with fast rhythms. A male voice is singing in a higher register. This is an amateur recording and of poor audio-quality. This song may be playing in a live scenario. | 2007-01-16T01:53:44Z | jenilenah | Ruben Blades cantando Patria en la teleton 2006 | ["Music", "Synthetic singing"] | ["latin", "percussion's", "e-bass", "male voice singing", "higher register", "uptempo", "amateur recording"] | 6 | fX8A5Uxc8R0 | 3956 |
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;