musiccaps_details (view)
3 rows where musiccaps_aspects contains "female lead vocalist" and musiccaps_author = 8
This data as json, CSV (advanced)
musiccaps_aspects (array) 37 ✖
- female lead vocalist · 3 ✖
- odd meter 2
- african 1
- afrobeat 1
- busy percussion 1
- celebratory 1
- clapping 1
- complex arrangement 1
- earthy 1
- eastern scale 1
- electric bass 1
- encouraging 1
- female background harmonies 1
- female background shouts 1
- fiery 1
- finger cymbals 1
- flute 1
- full band melodies 1
- fun 1
- gospel 1
- group female vocals 1
- hand percussion 1
- heavy drumkit 1
- mallet percussion 1
- middle eastern 1
- one chord 1
- organ chords 1
- organic 1
- polyrhythms 1
- rhythmic 1
- south asian 1
- syncopated bassline 1
- synthesizer 1
- tambourine 1
- thunderous drums 1
- vamp 1
- women's choir 1
musiccaps_names (array) 7 ✖
- Music 3
- Singing 2
- /t/dd00032 1
- Drum 1
- Gospel music 1
- Maraca 1
- Percussion 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 | |
UBC Youth Choir Singing "Who's On The Lord's Side (Get Up)" 03.21.10-11AM | Encouraging gospel music featuring a women's choir, hand clapping, female background shouting, and a lead female vocalist. The choir is accompanied by a band vamping on one chord with an organist, heavy drumkit, and a syncopated bassline. Would fit in a southern spiritual service. | 2010-04-23T15:34:59Z | BaptistBoi | Youth Choir Singing an Elder Timothy Wright Classic!!! Please enjoy and continue to rate and comment!!! | ["Singing", "Gospel music", "Music"] | ["gospel", "clapping", "female background shouts", "encouraging", "female lead vocalist", "organ chords", "heavy drumkit", "syncopated bassline", "vamp", "women's choir", "one chord"] | 8 | 7fVfG0DrLjI | 872 | |
Anna Vissi - Travma | Full band playing a complex arrangement, possibly south asian or middle eastern. The music features odd meters and polyrhythmic full band melodies played by electric bass guitar, synthesizer, flute, and a female vocalist singing an eastern scale with female background harmonies. The drum ensemble is thunderous and fiery with percussion from finger cymbals and tambourine. | 2009-10-25T08:23:26Z | AnnaVissiVEVO | Music video by Anna Vissi performing Travma. (C) 1997 Sony Music Entertainment (Greece) A.E. | ["Music", "/t/dd00032"] | ["south asian", "middle eastern", "eastern scale", "fiery", "finger cymbals", "odd meter", "electric bass", "polyrhythms", "complex arrangement", "full band melodies", "tambourine", "thunderous drums", "synthesizer", "female lead vocalist", "female background harmonies", "flute"] | 8 | L9j9fCHHPeg | 2155 |
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;