musiccaps_details (view)
7 rows where musiccaps_aspects contains "latin" and musiccaps_author = 8
This data as json, CSV (advanced)
| video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
|---|---|---|---|---|---|---|---|---|---|---|
| Taquito Militar | An instrumental jazz piano and vibraphone duo. Peppy and upbeat with a latin tinge. | 2007-09-26T23:19:18Z | Martin Ghersa | Duo De Taquito http://martinghersa.bandcamp.com/ Mariano Mores en duo de piano y vibrafono. Ghersa Schwarcz | ["Music", "Musical instrument", "Keyboard (musical)", "Piano", "Vibraphone"] | ["jazz", "piano", "vibraphone", "duo", "peppy", "latin", "upbeat", "instrumental"] | 8 | R60qQ3ag8y8 | 2668 | |
| ( Rumba ) Parrita & Canelita " Remix " Dj Barajero | Latin music featuring a quick tempo, hand percussion, tambourine, lively hand claps, guiro, a low tuned bass drum, an acoustic guitar solo with a wah effect, flamenco inspired fast acoustic guitar strumming, complex chords and a modern electric bass sound supporting a passionate female singer. | 2011-05-27T11:41:49Z | DJ Barajero | Parrita Canelita Remix Dj Barajero Flamenco Rumba Salsa Reggueton Verano Nuevo 2011 2012 2013 | ["Flamenco", "Music", "Music of Latin America"] | ["latin", "low tuned bass drum", "lively", "electric guitar", "wah", "acoustic guitar solo", "hand percussion", "fast strumming acoustic guitar", "flamenco influence", "tambourine", "guiro", "passionate female singer", "complex chords", "fast beat", "modern electric bass", "hand claps", "quick tempo"] | 8 | YzpzKyzyL0Y | 3331 | |
| Pink-white sponge manicure - Nail Art Tutorial | A Latin club track with a thumping bass and a funky feel. The kick snare pattern is simple and the hi-hat is busy playing steady 16th notes. Distorted electric guitar plays a lead melody along with the autotuned harmonized male background vocals. The lead vocals feature a male and female duo singing in harmony, while synth strings fill in the beat with short chords. | 2010-03-05T11:50:33Z | camysh | This is a very easy to do design. Enjoy! *NO COPYRIGHT INTENDED PLEASE DO NOT REMOVE**I do not own this song: Inna feat. Play & Win - Nobody* http://www.camynails.blogspot.com/ | ["Music", "Zing"] | ["female harmonized vocals", "simple kick/snare pattern", "thumping bass", "clap", "autotuned background vocal harmonies", "distorted electric guitar lead", "latin", "club track 16th note hi-hat", "funk feel", "synth string stabs"] | 8 | eZE0RmJESFU | 3880 | |
| Frankie Ruiz-Puerto Rico | Salsa music featuring heavy percussion including timbale, bongos, guiro among others, a brass section with trumpet and trombone. The music features full band melodies and drum breaks with complex chord progressions and group male vocals. | 2011-10-25T16:14:17Z | MegaSalsero69 | Live! Copyright Disclaimer under section 107 of the copyright act of 1976, allowances is made for fair use purposes. All music related performances remain the sole property of their respective copyright holders. No video clips are for sale, nor do they imply challenge to ownerships. They are intended strictly for educational, and historical purposes, and fall under the "Fair Use" guideline | ["Singing", "Swing music", "Music", "Ska", "Song", "Rock and roll", "Salsa music"] | ["salsa", "latin", "group male vocals", "timbale", "guiro", "bongo", "complex chords", "full band melodies", "brass section", "heavy percussion", "trombone", "trumpet", "male singer", "drum breaks"] | 8 | gsBXngKgy-Q | 4062 | |
| flamenco remix 2013 | Energetic, fun latin salsa music with a fast tempo that includes busy percussion, a brass section, piano, group male vocals. | 2012-12-22T20:33:22Z | ole la gitaneria | ["Afrobeat", "Music of Africa", "Flamenco", "Music"] | ["latin", "busy percussion", "brass section", "piano", "group male vocals", "energetic", "fun", "fast tempo"] | 8 | q9Gh-zh-5Ig | 4758 | ||
| Doble Cencerro (contra-campana) - Bebo Chung | Solo latin percussion music featuring congas, cowbells, and timbales, performing complex rhythms. | 2014-07-19T04:46:37Z | Bebo Chung | Tocando el cencerro del timbal junto con la campana del bongocero, mas conocido como tecnica contracampana, mano derecha campana y mano izquierda cencerro del timbal, es facil, practicarlo despacio, la velocidad llega sola. | ["Cowbell", "Drum", "Rimshot", "Percussion"] | ["solo percussion", "congas", "cowbells", "timbales", "latin", "complex rhythms"] | 8 | rnuGOQ-aSjs | 4903 | |
| 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;