musiccaps_details (view)
2 rows where musiccaps_aspects contains "congas" and musiccaps_aspects contains "hand percussion" sorted by musiccaps_names
This data as json, CSV (advanced)
musiccaps_aspects (array) 39 ✖
- bongos 2
- congas · 2 ✖
- hand percussion · 2 ✖
- amplified flute 1
- amplified ney 1
- brass section 1
- breezy fresh 1
- bulgarian 1
- busy percussion 1
- catchy 1
- cheery 1
- club music 1
- cowbell 1
- dance music 1
- dance pop 1
- electronic music 1
- female vocalist 1
- groovy 1
- latin 1
- lively male singer 1
- medium fast tempo 1
- middle eastern music 1
- ney 1
- oud 1
- oud rhythm 1
- perky 1
- pleasant 1
- pop folk 1
- punchy 1
- romantic 1
- simple melody 1
- steady drumming 1
- string bass 1
- syncopated bass 1
- synthesiser arrangements 1
- tambourine beats 1
- trombone 1
- tumbao 1
- upbeat 1
musiccaps_names (array) 4 ✖
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names ▼ | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ANDREA (SAHARA) ft Kristali - NA EKS - produced by COSTI 2011 | A female vocalist sings this spirited pop. The tempo is medium fast with percussion accompaniment like congas, bongos and drums , tambourine beats,along with amplified flute like the Ney and rhythmic oud. The music is catchy, youthful, groovy, breezy, romantic, pleasant and spirited. This music is contemporary Folk Pop. | 2011-04-27T13:59:10Z | FORZZA MUSIC | Subscribe to my channel: https://bit.ly/ForzzaMusic Subscribe 👉https://bit.ly/2Siqg8P 🔝🎶 NA EKS - produced by COSTI COSTI Grammy Nominated Producer Billboard Hot💯🇺🇸🇷🇴 producer, songwriter, top-liner, compozitor & artist. FORTZAAAA 🔝🎶 Powered by Doctor Music® 2017 Productions & Booking : drstudio@costi.ro International PR Department : office@doctormusic.ro http://www.facebook.com/DrCosti.TheProducer http://twitter.com/CostiOfficial https://instagram.com/costiofficial/ http://www.soundcloud.com/CostiOfficial Costi (The Music Producer) - the first Romanian producer with a Grammy Nomination (Grammy Awards 2012) All rights reserved. Unauthorized reproduction is a violation of applicable laws. | ["Music of Africa", "Music"] | ["female vocalist", "medium fast tempo", "simple melody", "romantic", "breezy fresh", "pleasant", "groovy", "dance music", "dance pop", "club music", "tambourine beats", "catchy", "punchy", "perky", "amplified flute", "ney", "oud", "electronic music", "pop folk", "bulgarian", "middle eastern music", "hand percussion", "congas", "bongos", "steady drumming", "synthesiser arrangements", "amplified ney", "oud rhythm"] | 7 | tJHFSRTPyew | 5026 | |
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;