musiccaps: musiccaps_details: 7 rows where musiccaps_author = 3 and musiccaps

7 rows where musiccaps_author = 3 and musiccaps_names contains "Salsa music"

descending

youtube_link	musiccaps_caption	youtube_published	youtube_channel	youtube_description	musiccaps_names	musiccaps_aspects	musiccaps_author	youtube_id	musiccaps_rowid
Los Blancos (en vivo)	This is a traditional Latin American song which would be suitable for salsa dancing. There are layers of percussion including bongo drums and snare drums. The pianist plays intricate melodies and the brass section plays vibrant and punchy motifs. It's a live performance with a relatively poor audio quality. There is a male group of singers performing energetically.	2008-07-14T19:10:04Z	juandog2000	en concierto (el Rey del timbal) Leopoldo Blanco en los timbales	["Music", "Musical instrument", "Music of Latin America", "Percussion", "Salsa music"]	["latin american music", "upbeat", "brass instruments", "bongo drums", "piano", "male hispanic vocal group", "salsa dancing", "live performance", "low quality audio"]	3	DAX9uKYlDvw	1449
Ya te olvide - Son Tentación // Mulata Salsa Club	This is a live recording of the outro of a latin american salsa song. There are brass instruments like the saxophone and trumpet. There is a man who speaks in Spanish once the music stops. It was the end section or outro of a song.	2015-05-21T06:59:37Z	Mulata Salsa	https://www.facebook.com/MulataSalsaClub Son Tentación@Ya te olvide MULATA SALSA CLUB	["Singing", "Music", "Speech", "Music of Latin America", "Salsa music"]	["latin american music", "salsa", "spanish", "outro", "brass instruments", "saxophone", "trumpet", "spanish speaking", "live recording", "live performance", "bongo drums", "drum roll", "piano"]	3	FYux89o7Hhk	1649
Celos de Ti - Tony Vega (Adry Salsa )	This is a regional Mexican song, in a contemporary style. The song feels romantic and relaxed. The singer has a charming voice and his voice sits atop guitar arpeggios and a simple bassline.	2009-12-11T05:00:07Z	Adry Monita		["Music", "Middle Eastern music", "Salsa music"]	["mexican regional music", "latin american music", "spanish singer", "acoustic guitar arpeggio", "bass guitar", "romantic spanish singing", "charming vocalist"]	3	Qj4r_MCC0mc	2638
Pop'n music 8 - Miami Salsa - El dia feliz	This is a salsa song with an upbeat and vibrant energy. It contains typical salsa instruments like the conga, the trumpet, and the piano. The percussion is upbeat and involves bongos and congas, and the singer is lively.	2010-03-11T04:44:33Z	Pan	BAILANDO~	["Music", "Music of Latin America", "Salsa music"]	["salsa music", "upbeat", "dance", "fun", "brass instruments", "piano", "bongo", "conga", "claves", "charming female vocalist", "energetic female vocalist"]	3	RneRJ5ZnHlE	2725
SALS@.COMBO - Los Angeles De La Salsa	The song is a latin american dance song suitable for salsa dancing. There are brass instruments, traditional percussion instruments like bongo drums, and the male vocal group sings in a cheery way in Spanish.	2008-03-21T23:05:17Z	LOS DE LA K.Y. ORQUESTA	Audio foto del tema promocional de SALS@.COMBO Yusel Barraza Director General Contacto: 3162660803 - 3102014159 https://www.facebook.com/LOSDELAKYORQUESTA/	["Music", "Salsa music"]	["latin american music", "salsa music", "upbeat", "party", "dance", "spanish", "brass instruments", "traditional percussion instruments", "bongo drums", "latin vocal group"]	3	cBd0yZ27dtA	3687
mezcla de salsa romantica 2012-2013	This song is a salsa song, with various layers of upbeat percussion which are suitable for dancing. There are bongo drums and maracas, played at a medium to high tempo. The vocalist has a dainty voice and sings in almost a high pitched voice in almost a whisper. There are brass instruments, especially trumpet and the song would be suitable for a salsa party.	2013-04-25T05:38:43Z	Dickson Villarroel	para los amantes de la salsa, espero que les guste...	["Music", "Music of Latin America", "Salsa music"]	["salsa music", "latin american music", "dance", "rhythmic latin percussion", "brass instruments", "trumpet", "bongo drums", "maracas", "piano", "dainty female vocal"]	3	gRGiTueWUVI	4029
amo mi soledad - la rebelion	This is a Latin American dance song in the salsa style. We hear layers of upbeat, rhythmic percussion that's suitable for dancing. Maracas, bongos, and a groovy and complex bassline coupled with a melodic instrument make for a vibrant and fun party/dance song.	2010-09-14T00:59:18Z	salsasanta	bajo la dirección de fernando martinez nace en 1986 en medellin, colombia orquesta la rebelión, aqui tenemos su mayor exito en la voz de marco vinicio.	["Music", "Music of Latin America", "Salsa music"]	["latin american music", "spanish singing", "salsa music", "dance", "fiesta", "party", "upbeat", "passionate tenor male vocal", "group male vocalists", "harmonies", "complex upbeat bassline", "maracas", "bongos"]	3	vByuZEzCZJg	5162

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;

musiccaps_details (view)

7 rows where musiccaps_author = 3 and musiccaps_names contains "Salsa music"

Advanced export