musiccaps_details (view)
3 rows where musiccaps_author = 8 and musiccaps_names contains "Rhythm and blues"
This data as json, CSV (advanced)
Suggested facets: youtube_published (date)
musiccaps_aspects (array) 22 ✖
- amateur recording 1
- complex chords 1
- cow bell 1
- dilla 1
- flamenco 1
- hip hop 1
- jazz piano 1
- kick drum 1
- male laughing 1
- male rapper 1
- minimal production 1
- nostalgic 1
- nylon string guitar 1
- off kilter drum beat 1
- pitched vocal sample 1
- shaker 1
- sloppy 1
- technically challenging 1
- triangle 1
- trip hop 1
- two acoustic guitars 1
- young male rapper 1
musiccaps_names (array) 8 ✖
- Music 3
- Rhythm and blues · 3 ✖
- Blues 1
- Dance music 1
- Flamenco 1
- Independent music 1
- Jazz 1
- Rapping 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
John Catalano Music : Dean Patton Rumba Flamenco in the States Two Talented Young Guitarist | Amateur recording of two nylon string guitars playing in flamenco style. The playing is technically challenging yet sloppy. | 2007-02-18T02:35:10Z | John Catalano | facebook.com/jphncatalanomusic 717-623-7166 John Catalano Teacher Saturday Classes in Gypsy Rumba at Catalano Music . Flamenca Rumba is lively music and developing in the United States Of America as here shown by the young guitar players. Gypsy Rumba In the 1990s the French group Gypsy Kings of Spanish descent became a popular New Flamenco group by playing Rumba Flamenca (or rumba gitana, Catalan rumba) music. | ["Blues", "Flamenco", "Music", "Independent music", "Rhythm and blues"] | ["amateur recording", "two acoustic guitars", "flamenco", "nylon string guitar", "technically challenging", "sloppy"] | 8 | -_OzT7Xyvok | 64 | |
Oden Park ( Fresh Boyz ) - iSkateBoard ( HOT MUSIC ) | hip hop music featuring a young male rapper over a minimalist beat with only percussion such as cowbell, kick drum, shaker, and triangle. | 2009-06-11T07:28:41Z | Oden Park | iSkateBoard by Oden Park (there's a dance to this song)Yuh mainly jerk to it but dont forget to hit the Skate Board with it! Type iSkateboard dance....Twitter us @OdenPark http://itunes.apple.com/us/album/iskateboard/id425746911?i=425746950 | ["Jazz", "Music", "Rhythm and blues", "Dance music"] | ["hip hop", "cow bell", "kick drum", "young male rapper", "pitched vocal sample", "triangle", "male laughing", "minimal production", "shaker"] | 8 | 2RMOegT2Jn8 | 362 | |
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;