musiccaps_details (view)
4 rows where musiccaps_aspects contains "salsa", musiccaps_author = 9 and musiccaps_names contains "Music of Latin America"
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 |
|---|---|---|---|---|---|---|---|---|---|---|
| SALSA NUEVA . "ELLA NO BAILA SOLA" LA ZONA FT EL SANTI RIMANTE | This is a latin dance music piece in the style of salsa. There are male vocals shouting in the lead. There is a crisp synth sound playing the melody with the backing of a piano and a bass guitar. The rhythm is played by the latin percussive elements. There is a sensual atmosphere to this piece. It could be playing in the background at a latin nightclub. | 2013-10-12T16:46:06Z | ADOLFO CT. | SALSA NUEVA 2016 LO MAS NUEVO SALSA SHOKE 2016 LO MAS NUEVO SALSA URBANA 2016 LO MAS NUEVO GRAVADO EN ESTUDIOS INDIRECORDS CALI COLOMBIA. DIRECTOR: GUSTAVO CARDONA SALSATON 2016 LO MAS NUEVO | ["Music", "Music of Latin America", "Salsa music"] | ["latin dance", "salsa", "male vocals", "shouting", "crisp synth", "piano", "bass guitar", "latin percussion", "sensual"] | 9 | K55v5p5DEPE | 2055 | |
| CON EL ( HOMERO ) SALSA VIEJA | This is a Latin salsa dance music piece. There are male vocals singing loudly in the Spanish language. There is a groovy bass line. The rhythmic background is provided by the cowbell strokes. The atmosphere is lively. This piece could be used as an accompaniment piece for a Latin dance course. | 2011-03-28T18:31:20Z | noe montiel | ["Music", "Music of Latin America", "Salsa music"] | ["latin dance music", "salsa", "male vocals", "loud singing", "spanish", "bass guitar", "latin percussion", "cowbell", "lively", "vibrant"] | 9 | LWLLN9INTII | 2196 | ||
| los los adolescente salsa mix | This music is a latin dance piece. There is a trumpet playing a vibrant melody as a lead with latin percussive elements playing a syncopated beat in the background. Then a piano fill is played to connect the previous section to the next one followed with a voice announcement. This piece could be used for latin dance courses and dance themed events at bars. | 2009-03-31T22:27:58Z | jorddy147 | los adolecentes salsa mix je.! wenazoO.. EN ESTA PAGIAN PUEDEN ENCONTRAR MUCHO MAS MUSICA WWW.SULLANARADIO.COM ENTREN XVR LOS REMIX. SALSA MERENGE REGUE.. DEL MOMENTO .!!^^ | ["Music", "Music of Latin America", "Salsa music"] | ["trumpet", "piano", "latin percussion", "rhythm", "piano", "spoken word", "melodic", "salsa", "latin music", "dance", "joyful"] | 9 | P97w3AdePgQ | 2511 | |
| Cristian Gonzalez y Orquesta La Bohemia - Cuanto Daria (Official Music Video) | This is a latin pop music piece with a salsa beat. There is a male vocalist singing melodically in the lead. The melody is being played by an orchestra composed of the trumpet, the piano and the bass guitar. The rhythmic background is provided by a mild acoustic drum beat with heavy use of latin percussive elements. The piece has a sensual atmosphere. This music could go well in a Latin American soap opera soundtrack where there is a hopeless situation for one of the characters. | 2011-07-18T21:24:33Z | Cristian Gonzalez y Orquesta La Bohemia | Disfruta el vídeo oficial del éxito de la salsa romántica "Cuanto Daria" de Cristian Gonzalez y Orquesta La Bohemia, la mejor salsa romántica para bailar gozar y dedicar con amor. 🔔 Activa las notificaciones para mantenerte actualizado con nuevos videos y estrenos! Suscríbete a mi Canal de YouTube: http://Disetti.co/YTCristianGonzalezyOrquestalaBohemia 🎶 Escucha la mejor Playlists de Salsa Romántica y Sensual: http://Disetti.co/SalsaRomanticaySensual ❤️ 🎧 Escucha mi música en tu Plataforma Favorita: http://Disetti.co/CristianGonzalezyOrquestalaBohemia/ Spotify: http://Disetti.co/SpotifyCristianGonzalezyOrquestalaBohemia Apple Music: http://Disetti.co/AppleMusicCristianGonzalezyOrquestalaBohemia Deezer: http://Disetti.co/DeezerCristianGonzalezyOrquestalaBohemia 👉Sígueme en RRSS: https://www.instagram.com/CristianGonzalezyLaBohemia/ https://www.facebook.com/RickyLoveOficial https://www.twitter.com/orqlabohemia Visita: https://www.Disetti.com/ #CuantoDaria #CristianGonzalezyOrquestaLaBohemia #DisettiMusic (C) 2022 Cristian Gonzalez y Orquesta La Bohemia. Todos los derechos reservados | ["Music", "Music of Latin America", "Salsa music"] | ["latin pop music", "salsa", "male vocal", "melodic singing", "trumpet", "acoustic drums", "piano", "bass guitar", "latin percussion", "sensual", "slow tempo"] | 9 | hYy0na5oUzE | 4118 |
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;