musiccaps_details (view)
2 rows where musiccaps_aspects contains "female voice" and musiccaps_aspects contains "trumpets"
This data as json, CSV (advanced)
musiccaps_aspects (array) 17 ✖
- female voice · 2 ✖
- trumpets · 2 ✖
- bass 1
- congo 1
- cowbell 1
- crowd clapping 1
- dance song 1
- flute 1
- latin percussion 1
- moderate tempo 1
- percussion 1
- piano 1
- salsa song 1
- saxophone 1
- trombone 1
- trombones 1
- upright bass 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 |
---|---|---|---|---|---|---|---|---|---|---|
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 | |
Ain't Nobody (Salsa Version)-Alex Wilson | This salsa song features a female voice singing the main melody. This is accompanied by percussion on a drum kit as well as on a congo. The congo gives this song the salsa feel. The drum kit plays the cowbell and high pitched snare drum to add more of the salsa vibe. The bass plays groovy fills. Trumpets, trombones and saxophones play fills in between lines. They play in harmony. A piano plays jazzy chords in the background. This song can be played in a dance club for a salsa night. | 2010-05-06T09:50:53Z | tsiostini | ["Music", "Music of Latin America", "Salsa music"] | ["salsa song", "female voice", "percussion", "trumpets", "congo", "cowbell", "trombone", "saxophone", "dance song", "bass", "piano", "moderate tempo"] | 0 | gMgN50wSnNc | 4025 |
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;