musiccaps_details (view)
3 rows where musiccaps_aspects contains "latin percussion" and musiccaps_aspects contains "trumpets"
This data as json, CSV (advanced)
musiccaps_aspects (array) 35 ✖
- latin percussion · 3 ✖
- trumpets · 3 ✖
- adrenaline rush 1
- ambient room noise 1
- bass guitar 1
- choir 1
- crowd clapping 1
- cumbia 1
- dance 1
- exercise class 1
- female vocal 1
- female voice 1
- flute 1
- groovy music 1
- guitar accompaniment 1
- gym music 1
- latin 1
- latin dance 1
- latin dance hits 1
- latin dance music 1
- male singer 1
- male vocals 1
- medium tempo 1
- passionate 1
- piano 1
- playful 1
- poor audio quality 1
- seductive singing 1
- spirited 1
- strong bass line 1
- trombones 1
- upright bass 1
- workout playlist 1
- zumba dance hits 1
- zumba music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
ven a mi casa mama ( original ) HQ | This is a cumbia piece. There is a female vocal singing seductively joined by male back vocals singing in the chorus. The trumpet is playing the main melody joined by the piano and the bass guitar in the background. Latin percussion playing a cumbia beat provides the rhythmic background. The atmosphere of the piece is very playful. The ideal setting for this piece can be a latin dance course. | 2011-07-15T21:44:16Z | tecoloves | sonideros | ["Swing music", "Music"] | ["cumbia", "latin", "latin dance", "female vocal", "seductive singing", "male vocals", "choir", "latin percussion", "trumpets", "piano", "bass guitar", "playful", "dance"] | 9 | 7NnvEryyYdo | 840 | |
Franco Formica & Oxana Lebedew - Inka Dance | The music excerpt starts off with a Latin band with instruments such as trombones, trumpets, upright bass, flute and latin percussion instruments. After a few seconds the band stops and a female voice starts to sing a voice that starts in the high register and moves to the low one. Right between these two moments one can hear claps coming from a crowd of people. Towards the ending of the excerpt the voice finishes singing the melody and the band starts again. | 2008-11-05T17:12:24Z | afrobot2007 | 2008 World Super Stars Dance Festival Latin | ["Humming", "Music"] | ["female voice", "crowd clapping", "trombones", "trumpets", "upright bass", "flute", "latin percussion"] | 2 | KrK8Giu9ZUc | 2126 | |
Dale Maraca - ABS in Zumba Dance Class with ART ( Mo Betta ) | A male singer sings this Latin dance tune. The song is medium tempo with trumpets, latin percussions; medium drumming rhythm, keyboard harmony and guitar accompaniment. The song is exciting and groovy. The audio quality is poor and is played for work out exercise. | 2009-12-21T09:41:49Z | 19mobetta06 | Great song for ab work. Pull stomach in and use your hips in circular motion not so much work with the shoulders. www.CardioAssassin.com | ["Music", "Song", "Maraca"] | ["ambient room noise", "poor audio quality", "gym music", "zumba dance hits", "trumpets", "guitar accompaniment", "latin percussion", "strong bass line", "latin dance hits", "workout playlist", "passionate", "spirited", "adrenaline rush", "male singer", "latin dance music", "exercise class", "zumba music", "medium tempo", "groovy music"] | 1 | Sj5MQtqDw8Y | 2783 |
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;