musiccaps_details (view)
3 rows where musiccaps_aspects contains "complex chords" and musiccaps_author = 8
This data as json, CSV (advanced)
musiccaps_aspects (array) 34 ✖
- complex chords · 3 ✖
- guiro 2
- latin 2
- acoustic guitar solo 1
- bongo 1
- brass section 1
- dilla 1
- drum breaks 1
- electric guitar 1
- fast beat 1
- fast strumming acoustic guitar 1
- flamenco influence 1
- full band melodies 1
- group male vocals 1
- hand claps 1
- hand percussion 1
- heavy percussion 1
- jazz piano 1
- lively 1
- low tuned bass drum 1
- male rapper 1
- male singer 1
- modern electric bass 1
- nostalgic 1
- off kilter drum beat 1
- passionate female singer 1
- quick tempo 1
- salsa 1
- tambourine 1
- timbale 1
- trip hop 1
- trombone 1
- trumpet 1
- wah 1
musiccaps_names (array) 11 ✖
- Music 3
- Flamenco 1
- Music of Latin America 1
- Rapping 1
- Rhythm and blues 1
- Rock and roll 1
- Salsa music 1
- Singing 1
- Ska 1
- Song 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 |
---|---|---|---|---|---|---|---|---|---|---|
( 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 | |
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 | |
Velcro & Gas-Lab - Incomprendido (Con Letra y Link) (Inspirada en la de Ismael "Maelo" Rivera) | A nostalgic feeling trip hop song with an off kilter, Dilla inspired drum beat, a jazz piano playing complex chords and a male rapper. | 2013-05-19T17:45:58Z | Hacia Otra Sintonia | Suscríbete a nuestro canal más de 150 canciones de hip hop latino y español con sus respectivas letras. Canserbero, Siete Nueve, Rxnde Akozta, Nk Profeta, Bocafloja, Intifada, Luis Díaz, Apache, Lito Mc Cassidy, Portavoz, La Banda Baston, Velcro, Mustafa Yoda, Tote King, Akapellah, Babalu Machete, Benik Fernandes, E.A.Flow, Lil Supa, Indee Styla, Duo Kie, Omar García, R.e.a.l.i.d.a.d., Hache St, Sr. K.R., Michelle Ricardo, Skool 77, R-Two, Ikol Santiago, Tek-One, Comando 57, Pet Fella (Los Petit Fella), Fabián Villegas, Cyborg AOS y Más... Además, algunos links de descargas directas... Gas-Lab Facebook Oficial y Bandcamp https://www.facebook.com/gaslabmusic http://gas-lab.bandcamp.com/ Velcro Mc Web Site y Facebook Oficial http://www.elsitedevelcro.com/ https://www.facebook.com/elfbdevelcro Link De Descarga http://gas-lab.bandcamp.com/album/velcro-gas-lab-incomprendido Miro una estrella y deja de brillar, toco una flor y se ha de marchitar, Mi trago servido ya al llegar al bar Y hasta me guardan esta boleta cardinal Caleidoscopio que hace que lo va girar Como un millón de imágenes por abrirse y abanicarme Es un fri-ito digo de examinarse que atacan como recalcitrante Y yo me creo que es mi pulso pero en verdad es tu sonrisa que regresa en cada diástole en... De esta culpa que te oculto, pues, insisto que fue linda nuestra catástrofe Porque mi emoción al conocerte fue genuina como quien me rescatara de la rutina Pero a nuestra edad, sabemos bien cómo los sueños se asesinan so cantamos cabizbajos estas notas cuando se avecinan Yo, yo, yo creo que voy, solito a estar cuando me muera. Alalale, ¿por qué no me comprenden a mí? Si yo soy un negrito chévere... Algo mágico que te apuntaste Yo con esta cara de sátiro tarareándote... El clásico: creerme que yo me salvo con ser cándido diciéndote que mis miedos son como elásticos- Por más que estiren ellos vuelven y aprietan; contigo vamos a ver si se aquietan... Yo presintiendo que era injusta esa pregunta Si la clara es que la duda es suficiente respuesta … | ["Music", "Rapping", "Rhythm and blues"] | ["trip hop", "male rapper", "off kilter drum beat", "dilla", "jazz piano", "complex chords", "nostalgic"] | 8 | yRWndZvIAHc | 5410 |
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;