musiccaps_details (view)
2 rows where musiccaps_aspects contains "hand percussion" and musiccaps_aspects contains "odd meter" sorted by youtube_id
This data as json, CSV (advanced)
musiccaps_aspects (array) 20 ✖
- hand percussion · 2 ✖
- odd meter · 2 ✖
- additive rhythm 1
- african 1
- afrobeat 1
- busy percussion 1
- celebratory 1
- earthy 1
- female lead vocalist 1
- fun 1
- group female vocals 1
- hypnotic 1
- male singer 1
- mallet percussion 1
- organic 1
- regular rhythm 1
- rhythmic 1
- trance inducing 1
- violin 1
- violin doubling singer 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 | |
Ekkadi Manusha Janmam? (Annamacharya song) | Hand percussion accompanies a male singer and violin doubling a melody with a constant regular rhythm. Mood is hypnotic and trance inducing. Features additive rhythms and odd meters. | 2007-06-11T23:00:23Z | musiquebox | Prince Rama Varma renders an eloquent Annamacharya composition in the Raaga Revagupti at NGMA Mumbai. He is accompanied on the violin by Shri Madhavan and on the mridangam by Shri Ganesh. | ["Tabla", "Percussion"] | ["hand percussion", "male singer", "regular rhythm", "violin", "violin doubling singer", "hypnotic", "trance inducing", "additive rhythm", "odd meter"] | 8 | w_XFNKSRgKI | 5276 |
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;