musiccaps_details (view)
3 rows where musiccaps_aspects contains "group female vocals"
This data as json, CSV (advanced)
musiccaps_aspects (array) 29 ✖
- group female vocals · 3 ✖
- african 1
- afrobeat 1
- busy percussion 1
- celebratory 1
- cheerful 1
- dance 1
- drum breaks 1
- earthy 1
- electronic drums 1
- female lead vocalist 1
- fun 1
- girl band 1
- go go beat 1
- groovy rhythmic percussion 1
- hand percussion 1
- indian music 1
- live performance 1
- loud bass 1
- low fidelity 1
- mallet percussion 1
- odd meter 1
- organic 1
- pop 1
- rhythmic 1
- sitar 1
- south asian music 1
- surf guitar 1
- tamil music 1
musiccaps_names (array) 8 ✖
- Music 2
- Drum 1
- Folk music 1
- Maraca 1
- Music of Asia 1
- Percussion 1
- Pop music 1
- Singing 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Vamsam - Tamil Serial | Episode 556 | 02/05/2015 | This is a traditional south asian dance song with a cheerful affect. We have a group of female singers singing in unison - a melody that matches with the one being played on the sitar. | 2015-05-02T16:00:00Z | Vision Time Tamil | Will Madan succeed in brainwashing Supriya to get married to him and will Archana be able to stop this marriage in time by arresting Madan for killing Bhoomika? Is Bhoomika really dead or alive?? Keep watching this space for more updates on your favorite serial VAMSAM. Cast: Ramya Krishnan, Sai Kiran, Vijayakumar, Seema, Vadivukkarasi | ["Folk music"] | ["south asian music", "indian music", "tamil music", "dance", "group female vocals", "sitar", "groovy rhythmic percussion", "cheerful"] | 3 | 5aCDam9_Ps4 | 671 | |
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 | |
Girls Aloud - Sound Of The Underground (Party in the Park) | Live performance of a girl band group, featuring surf guitar and a go-go beat that transitions to modern pop production with loud bass and electronic drum breaks. Audio is low fidelity. Would be popular with teenage girls. | 2008-03-02T14:23:52Z | Eva McLaughlin | Girls Aloud performing LIVE Sound Of The Underground at Party in the Park, 2003) Official Websites: http://www.girlsaloud.co.uk http://www.polydor.co.uk Girls Aloud: Nadine Coyle Cheryl Cole Sarah Harding Nicola Roberts Kimberley Walsh | ["Music of Asia", "Music", "Pop music"] | ["girl band", "surf guitar", "go go beat", "loud bass", "pop", "live performance", "low fidelity", "group female vocals", "drum breaks", "electronic drums"] | 8 | vo7BYs1OqbM | 5206 |
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;