musiccaps_details (view)
2 rows where musiccaps_aspects contains "acoustic guitar" and musiccaps_aspects contains "male voices singing"
This data as json, CSV (advanced)
musiccaps_aspects (array) 14 ✖
- acoustic drums 2
- acoustic guitar · 2 ✖
- male voices singing · 2 ✖
- amateur recording 1
- e-bass 1
- higher pitch 1
- pop 1
- ska cubano 1
- trombone 1
- trumpet 1
- upbeat 1
- upright bass 1
- uptempo 1
- violin 1
musiccaps_names (array) 4 ✖
- Music 2
- Singing 1
- Ska 1
- Soul music 1
video | youtube_link | musiccaps_caption | youtube_published | youtube_channel | youtube_description | musiccaps_names | musiccaps_aspects | musiccaps_author | youtube_id | musiccaps_rowid |
---|---|---|---|---|---|---|---|---|---|---|
Ska Cubano " Chango " at Jazz Cafe London | An acoustic drum is holding the groove together with an upright bass and an acoustic guitar playing rhythmic chords on the backbeat. A trumpet and trombone are playing a melody before the male voice starts to sing being backed up by other male voices singing along. This song may be playing during a live event. | 2012-02-08T15:17:51Z | carlinmalacopa | Ska Cubano at Jazz cafe London, December 2011 | ["Singing", "Music", "Ska"] | ["ska cubano", "upright bass", "acoustic guitar", "acoustic drums", "male voices singing", "trumpet", "trombone", "upbeat", "amateur recording"] | 6 | 5NCUtndrsHg | 658 | |
El Ultimo de la Fila - Dios de la Lluvia | This song contains an acoustic drum playing a simple groove with heat panned to both sides of the speakers. An e-bass is playing along while someone is strumming chords on an acoustic guitar. Two male voices are singing together in harmony. A viola is joining, playing along with the singer's melody. This song may be playing while cooking at home. | 2010-04-06T08:35:27Z | pidopoco | De el CD Como la Cabeza al Sombrero Track Nº1 Dios de la lluvia apiádate de las bestias y de mí. Vino tu llanto a redimir un mundo polvoriento y gris hecho a medida del triste reptil. Seguí la luz y te perdí, desde ese día rezaré para que vuelvas envuelto en tu bruma. Dejé a mi niña, dulce abril, entre aire de fresas y jazmín; se desdibuja en mi memoria la umbría vereda que tantas veces recorrí. Antiguos aromas flotando en el aire, espíritu de la bruma, no volverán. Ríe mi niña flotando en el suelo; Dios de la lluvia, devuélveme al ayer. Maldito el día en que crecí dejando atrás el sueño aquel del dulce mundo en que aprendí el dificil arte de vivir. Entre los campos verdes de abril, lejos del mundo, muy cerca de ti. Dios de la lluvia abrázame y bajo tus nubes volveré a considerar las múltiples formas de besar el aire bañado en tu perfume singular de antiguos aromas flotando en el aire espíritu de la bruma, no volverán. Ríe mi niña flotando entre helechos Dios de la lluvia devuélveme al ayer Dios de la lluvia apiádate de las bestias y de mí, pobre mortal. | ["Music", "Soul music"] | ["pop", "acoustic guitar", "e-bass", "acoustic drums", "violin", "male voices singing", "higher pitch", "uptempo"] | 6 | p9nbp0Oo1U0 | 4689 |
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;