musiccaps_details (view)
2 rows where musiccaps_aspects contains "rhythmic", musiccaps_names contains "Music" and musiccaps_names contains "Percussion"
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- rhythmic · 2 ✖
- african 1
- afrobeat 1
- busy percussion 1
- celebratory 1
- complex 1
- earthy 1
- female lead vocalist 1
- fun 1
- group female vocals 1
- hand percussion 1
- instrumental 1
- mallet percussion 1
- marimba 1
- melodic 1
- no singer 1
- odd meter 1
- organic 1
- percussion 1
- playful 1
musiccaps_names (array) 8 ✖
- Music · 2 ✖
- Percussion · 2 ✖
- Drum 1
- Maraca 1
- Marimba, xylophone 1
- Musical instrument 1
- Singing 1
- Vibraphone 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
WAMALI PERCUSSIONS AUX NUITS MANDINGUES 2012 - SOKO | Rhythmic African afrobeat music that sounds celebratory and fun. Busy hand percussion and mallet percussion play in an odd meter, accompanying group female vocals with a lead female vocalist. Feels organic and earthy. | 2012-03-16T17:53:53Z | Assowamali1 | WAMALI PERCUSSIONS AUX NUITS MANDINGUES 2012 - SOKO DARTAGNAN ( Djembé- ) BEMBA ( Doundoun ) SORY ( Balafon ) ANTOINE (Sanbang) FANTA (Chant,Danse) KARAMOKO ( Kora ) MOHAMED (Djembé ) Special Guest EVELYNE MAMBO ( Chant Danse ) FIFI ( Chant danse ) | ["Singing", "Drum", "Music", "Percussion", "Maraca"] | ["african", "busy percussion", "hand percussion", "afrobeat", "organic", "earthy", "female lead vocalist", "group female vocals", "rhythmic", "odd meter", "mallet percussion", "celebratory", "fun"] | 8 | 6Si3eGkmmy8 | 759 | |
PercaDu Play Octabones | This is an instrumental marimba piece. Two marimbas are being played simultaneously. The performance is a complex one. The atmosphere is playful. Parts of this piece can be used to make a ringtone or to lift samples to use in a beat. | 2008-03-28T10:08:37Z | Adi Morag | This Video was made in Sapir academy, Sederot,Israel, performed by PercaDu. The work is now published. for details: moragadi@gmail.com | ["Music", "Musical instrument", "Marimba, xylophone", "Vibraphone", "Percussion"] | ["no singer", "instrumental", "marimba", "percussion", "rhythmic", "melodic", "playful", "complex"] | 9 | RQMUz0NFx6o | 2700 |
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;