musiccaps_details (view)

3 rows where musiccaps_aspects contains "male voice", musiccaps_names contains "Music of Latin America" and musiccaps_names contains "Salsa music"

✎ View and edit SQL

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
Orq. Bronco - Duena De Mi Cuerpo This Latin pop song features a male voice singing the main melody. The voice sings at a high pitch. This is accompanied by Latin style percussion. A variety of percussion is used including the claves and cowbell. The bass plays a groovy bassline. The piano plays chords with a Latin feel. The brass section plays fills in between lines. This song has a romantic mood. This song can be played in a party for a slow dance. 2010-03-26T03:09:29Z EdwardMulenze gran orquesta venezolana de finales de los 80.. se caracteriza por la finura y la cuerda de sus trombones disfrutenlo... ["Music", "Music of Latin America", "Salsa music"] ["latin pop", "male voice", "slow dance song", "bass", "percussion", "piano", "brass section", "romantic mood", "claves"] 0 92QYLjfo68Q 972
FAMOUS SALSA SONGS TRANSLATED INTO ENGLISH 2 - Rebelion (No le pegue a la negra) Joe Arroyo This salsa song features a male voice. It starts off with the keyboard and bass playing a synchronized melody. The percussion is played only as a rimshot in a grouping of two strokes followed by a group of three strokes. This is followed by a male voice singing one word. The rest of the instruments start playing at a faster tempo. The main melody of the song is played on the trumpet and saxophone. This is accompanied by percussion playing a salsa beat. A keyboard plays chords with a salsa feel. This song can be played at a dance party. 2009-01-30T16:16:08Z yaramaca If you want to learn more about the rhythms in salsa check out my other video "UNDERSTAND AND LEARN SALSA RHYTHMS - excerpt and promo - Learn the rhythms of a salsa band" or got to http://www.aboutsalsamusic.com ============================================ Follow me at twitter for songs of different styles: @FindGoodSongs ============================================ With pictures from Colombia - land of the salsa! A few words or phrases are slightly altered to get the feel of the lyrics in spanish. This translation is not official, just made by fan. Two pictures from a dancefloor is not from Colombia, the rest are, enjogy the beautiful landscapes.. Check out the other translated videos also! ["Music", "Music of Latin America", "Salsa music"] ["salsa song", "keyboard", "bass", "male voice", "trumpets", "percussion", "cowbell", "saxophone", "moderate tempo", "dance song"] 0 F5xnAYHuGlo 1613
Zumba Michelle Marco Island (Da La Vuelta) This low quality audio features a male voice singing the main melody. This is accompanied by percussion playing a simple but fast paced beat. Trumpets are featured in this song playing fills at high pitch. This song can be played in an aerobics workout session where fast movements are required. 2010-09-18T04:28:34Z Michelle Jordan Choreography by Michelle Jordan ["Song", "Music of Latin America", "Salsa music", "Maraca"] ["low quality audio", "fast tempo song", "male voice", "trumpet song", "fast paced percussion", "workout song"] 0 jIoDR_eskaU 4245

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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;