musiccaps_details (view)
4 rows where musiccaps_aspects contains "instrumental", musiccaps_aspects contains "latin music" and musiccaps_names contains "Music"
This data as json, CSV (advanced)
musiccaps_aspects (array) 46 ✖
- instrumental · 4 ✖
- latin music · 4 ✖
- drums 2
- fast tempo 2
- no voice 2
- saxophones 2
- trombones 2
- trumpets 2
- almost fast tempo 1
- ambient outdoor sounds 1
- bass guitar 1
- bongos accompaniment 1
- caribbean 1
- carrie an 1
- celebratory 1
- chac-chac 1
- congas 1
- distorted music 1
- electric guitar 1
- electronic sound 1
- festive 1
- guiro 1
- guiro accompaniment 1
- hand percussion 1
- happy 1
- inferior audio quality 1
- joyful 1
- latin dance music 1
- latin percussion 1
- latin regional music 1
- live music 1
- live performance 1
- lively acordion 1
- maracas rhythm 1
- percussion dual 1
- piano 1
- rattle like instrument 1
- rhythmic 1
- scraper instrument 1
- shaker 1
- spirited 1
- spirited congas 1
- static 1
- upright bass 1
- vigorous 1
- world music 1
musiccaps_names (array) 8 ✖
- Music · 4 ✖
- Maraca 2
- Salsa music 2
- Accordion 1
- Funk 1
- Music of Latin America 1
- Musical instrument 1
- Swing music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
DR. RING DING - "Latin Goes Ska" | The instrumental music features a medium sized band playing Latin music. The melody is being played in unison by the saxophones, trumpets and trombones in an almost fast tempo. A bass guitar is playing repeating lines in the low register. The drums play a busy rhythm. An electric guitar is playing a chord on the second half of every beat. | 2012-01-16T08:38:37Z | thegroverrecords | Album - DANDIMITE www.moskito-mailorder.com | ["Swing music", "Funk", "Music", "Music of Latin America", "Salsa music"] | ["trumpets", "saxophones", "trombones", "drums", "bass guitar", "electric guitar", "instrumental", "no voice", "latin music", "almost fast tempo"] | 2 | CuUu6L5hhMs | 1412 | |
Cómo aprender a tocar las maracas | This music is a lively instrumental using a maracas. The tempo is fast with a bongos accompaniment . The music is a duel between the two hand percussion. It is lively, vigorous and vibrant. | 2011-06-06T15:51:04Z | Practicopedia | Un instrumento de percusión que se utiliza para acompañar a otros instrumentos | ["Music", "Maraca"] | ["instrumental", "fast tempo", "maracas rhythm", "caribbean", "percussion dual", "hand percussion", "bongos accompaniment", "vigorous", "shaker", "chac-chac", "rattle like instrument", "latin percussion", "latin music", "rhythmic", "carrie an"] | 7 | KoP8T0QqzeM | 2120 | |
LUIS E.MARTINEZ EL CANTOR DE FONSECA | This music is a spirited Latin music instrumental. The tempo is fast with a lively accordion harmony, spirited congas beat and guiro accompaniment. The music is happy, vivacious, upbeat, vigorous, cheerful , celebratory and cheerful with ambient outdoor sounds like wind, people talking, clapping and a lot of static indicating that this is a live performance. The audio quality is inferior and this looks like an amateur home recording. | 2008-06-20T18:46:59Z | ALVARO VILLA FONTALVO | INTERPRETA EL CANTOR DE FONSECA EN COMPAÑIA DE SU AUTOR CARLOS HUERTAS EL CANTOR DE FONSECA- LUIS ENRIQUE INTERPRETA MAGISTRALMENTE SU ACORDEON, ENTRE LOS ASISTENTES ESTABA GABO, FUE EN EL AÑO 1993 EN B/QUILLA | ["Music", "Musical instrument", "Accordion", "Maraca"] | ["instrumental", "fast tempo", "distorted music", "static", "guiro accompaniment", "scraper instrument", "world music", "latin regional music", "latin dance music", "lively acordion", "spirited congas", "guiro", "latin music", "latin dance music", "happy", "spirited", "live performance", "live music", "ambient outdoor sounds", "inferior audio quality", "celebratory", "festive", "joyful"] | 7 | kpsYSXR1wao | 4360 | |
Jerry rivera Para ti | The instrumental latin music features a big band. The trumpets, saxophones and trombones play the same melody but on different pitches. The percussion section includes a drum kit played in the latin style and a pair of congas. A piano accompanies the brass section and blends in with the rest of the band. An electronic sound can be heard playing the same note throughout the music excerpt. | 2007-09-10T07:54:12Z | Donabboy | para ti | ["Music", "Salsa music"] | ["latin music", "trumpets", "trombones", "saxophones", "congas", "piano", "upright bass", "electronic sound", "instrumental", "no voice", "drums"] | 2 | nH_lVl3a3Uw | 4529 |
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;