musiccaps_details (view)
3 rows where musiccaps_aspects contains "hand percussion", musiccaps_author = 8 and musiccaps_names contains "Singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- hand percussion · 3 ✖
- busy percussion 2
- 90's hip hop 1
- african 1
- afrobeat 1
- bongos 1
- brass section 1
- celebratory 1
- cheery 1
- clap 1
- congas 1
- cowbell 1
- deep bass 1
- doubled vocals 1
- earthy 1
- electric piano 1
- female lead vocalist 1
- fun 1
- gangster rap 1
- group female vocals 1
- latin 1
- lively male singer 1
- mallet percussion 1
- odd meter 1
- organic 1
- rhythmic 1
- serious 1
- string bass 1
- strong male rapper 1
- syncopated bass 1
- synth flute 1
- tambourine 1
- trombone 1
- tumbao 1
- upbeat 1
musiccaps_names (array) 7 ✖
- Singing · 3 ✖
- Drum 1
- Maraca 1
- Music 1
- Music of Latin America 1
- Percussion 1
- Reggae 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 | |
2pac blasphemy lyrics | Serious music in the gangster rap genre that features a strong male rapper with doubled vocals over a 90's hip hop beat. Deep bass drives the beat along with hand percussion, clap, electric piano, synth flute, and tambourine. | 2011-06-04T16:28:07Z | misslyricmaster1 | Thanks to kushclouds602 for requsting this song! More 2pac videos to come so keep checking ;) No copywrite intended, love for all, hatred for none. | ["Singing", "Reggae"] | ["90's hip hop", "gangster rap", "strong male rapper", "doubled vocals", "deep bass", "hand percussion", "clap", "electric piano", "synth flute", "tambourine", "serious"] | 8 | O3Cvn4yXrao | 2395 | |
Frankie Ruiz - Bailando | Cheery, upbeat Latin music featuring a lively male singer, busy percussion including hand percussion like bongos and congas as well as cowbell and more. String bass plays a syncopated tumbao rhythm while a brass section accompanies a trombone. | 2008-02-09T16:00:37Z | jjaime99 | Frankie Ruiz | ["Singing", "Music of Latin America"] | ["latin", "busy percussion", "brass section", "trombone", "lively male singer", "tumbao", "syncopated bass", "hand percussion", "bongos", "congas", "string bass", "cowbell", "upbeat", "cheery"] | 8 | w62KGC7um_Y | 5240 |
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;